|
Package BANINST1.fb_commodity_rules Support subprograms for commodity API (FB_COMMODITY_RULES). |
| Program units |
| p_publish_sync | Procedure to publish the synchronized data. |
| p_register_entity | Registers the attribute value pairs to the message cache. |
| p_validate | validates a commodity record. |
| Constants |
| M_OBJECT_NAME | Object name |
| M_CODE | Commodity code |
| M_EFF_DATE | Commodity effective date |
| M_ACTIVITY_DATE | Commodity activity date |
| M_USER_ID | User ID |
| M_DESC | Commodity description |
| M_UOMS_CODE | Commodity unit of measure code |
| M_TERM_DATE | Commodity termination date |
| M_COMM_CODE_PRED | Commodity code predecessor |
| M_AMST_IND | Fixed asset indicator |
| M_TGRP_CODE | Tax group code |
| M_TAX_OVERRIDE_IND | Tax override indicator |
| M_STOCK_IND | Store item indicator |
| M_ONORDER_QTY | Commodity on order quantity |
| M_RESERVED_QTY | Commodity reserved quantity |
| M_NOT_INVOICED_QTY | Not invoiced quantity |
| M_TOTAL_VALUE_AMT | Total value amount |
| M_EST_LIFE_YEARS | Estimated life in years |
M_OBJECT_NAME
M_OBJECT_NAME CONSTANT VARCHAR2(9) := 'COMMODITY';
Object name
M_CODE
M_CODE CONSTANT VARCHAR2(12) := 'FTVCOMM_CODE';
Commodity code
M_EFF_DATE
M_EFF_DATE CONSTANT VARCHAR2(16) := 'FTVCOMM_EFF_DATE';
Commodity effective date
M_ACTIVITY_DATE
M_ACTIVITY_DATE CONSTANT VARCHAR2(21) := 'FTVCOMM_ACTIVITY_DATE';
Commodity activity date
M_USER_ID
M_USER_ID CONSTANT VARCHAR2(15) := 'FTVCOMM_USER_ID';
User ID
M_DESC
M_DESC CONSTANT VARCHAR2(12) := 'FTVCOMM_DESC';
Commodity description
M_UOMS_CODE
M_UOMS_CODE CONSTANT VARCHAR2(17) := 'FTVCOMM_UOMS_CODE';
Commodity unit of measure code
M_TERM_DATE
M_TERM_DATE CONSTANT VARCHAR2(17) := 'FTVCOMM_TERM_DATE';
Commodity termination date
M_COMM_CODE_PRED
M_COMM_CODE_PRED CONSTANT VARCHAR2(22) := 'FTVCOMM_COMM_CODE_PRED';
Commodity code predecessor
M_AMST_IND
M_AMST_IND CONSTANT VARCHAR2(16) := 'FTVCOMM_AMST_IND';
Fixed asset indicator
M_TGRP_CODE
M_TGRP_CODE CONSTANT VARCHAR2(17) := 'FTVCOMM_TGRP_CODE';
Tax group code
M_TAX_OVERRIDE_IND
M_TAX_OVERRIDE_IND CONSTANT VARCHAR2(23) := 'FTVCOMM_TAX_OVERIDE_IND';
Tax override indicator
M_STOCK_IND
M_STOCK_IND CONSTANT VARCHAR2(17) := 'FTVCOMM_STOCK_IND';
Store item indicator
M_ONORDER_QTY
M_ONORDER_QTY CONSTANT VARCHAR2(19) := 'FTVCOMM_ONORDER_QTY';
Commodity on order quantity
M_RESERVED_QTY
M_RESERVED_QTY CONSTANT VARCHAR2(20) := 'FTVCOMM_RESERVED_QTY';
Commodity reserved quantity
M_NOT_INVOICED_QTY
M_NOT_INVOICED_QTY CONSTANT VARCHAR2(24) := 'FTVCOMM_NOT_INVOICED_QTY';
Not invoiced quantity
M_TOTAL_VALUE_AMT
M_TOTAL_VALUE_AMT CONSTANT VARCHAR2(23) := 'FTVCOMM_TOTAL_VALUE_AMT';
Total value amount
M_EST_LIFE_YEARS
M_EST_LIFE_YEARS CONSTANT VARCHAR2(22) := 'FTVCOMM_EST_LIFE_YEARS';
Estimated life in years
p_publish_sync
Procedure p_publish_sync(p_operation_type VARCHAR2,
p_code FTVCOMM.FTVCOMM_CODE%TYPE,
p_eff_date FTVCOMM.FTVCOMM_EFF_DATE%TYPE,
p_desc FTVCOMM.FTVCOMM_DESC%TYPE,
p_uoms_code FTVCOMM.FTVCOMM_UOMS_CODE%TYPE,
p_term_date FTVCOMM.FTVCOMM_TERM_DATE%TYPE,
p_tgrp_code FTVCOMM.FTVCOMM_TGRP_CODE%TYPE)
Procedure to publish the synchronized data.
| Parameters |
| p_operation_type |
The operation type. Valida values are INSERT, UPDATE and DELETE. VARCHAR2 Required. | |
| p_code |
The commodity code. VARCHAR2(10) Required. | |
| p_eff_date |
The effective date of the commodity. Date Required. | |
| p_desc |
Commodity description. VARCHAR2(50) Required. | |
| p_uoms_code |
Unit of measure code. VARCHAR2(3) Required. | |
| p_term_date |
Commodity termination date. Date Required. | |
| p_tgrp_code |
Tax group code. VARCHAR2(4) Required. |
p_register_entity
Procedure p_register_entity(p_operation_type NUMBER,
p_code FTVCOMM.FTVCOMM_CODE%TYPE,
p_eff_date FTVCOMM.FTVCOMM_EFF_DATE%TYPE default null,
p_activity_date FTVCOMM.FTVCOMM_ACTIVITY_DATE%TYPE DEFAULT NULL,
p_user_id FTVCOMM.FTVCOMM_USER_ID%TYPE DEFAULT NULL,
p_desc FTVCOMM.FTVCOMM_DESC%TYPE default null,
p_uoms_code FTVCOMM.FTVCOMM_UOMS_CODE%TYPE default null,
p_term_date FTVCOMM.FTVCOMM_TERM_DATE%TYPE default null,
p_comm_code_pred FTVCOMM.FTVCOMM_COMM_CODE_PRED%TYPE DEFAULT NULL,
p_amst_ind FTVCOMM.FTVCOMM_AMST_IND%TYPE DEFAULT NULL,
p_tgrp_code FTVCOMM.FTVCOMM_TGRP_CODE%TYPE default null,
p_tax_override_ind FTVCOMM.FTVCOMM_TAX_OVERRIDE_IND%TYPE DEFAULT NULL,
p_stock_ind FTVCOMM.FTVCOMM_STOCK_IND%TYPE DEFAULT NULL,
p_onorder_qty FTVCOMM.FTVCOMM_ONORDER_QTY%TYPE DEFAULT NULL,
p_reserved_qty FTVCOMM.FTVCOMM_RESERVED_QTY%TYPE DEFAULT NULL,
p_invoiced_qty FTVCOMM.FTVCOMM_NOT_INVOICED_QTY%TYPE DEFAULT NULL,
p_value_amt FTVCOMM.FTVCOMM_TOTAL_VALUE_AMT%TYPE DEFAULT NULL,
p_est_life_years FTVCOMM.FTVCOMM_EST_LIFE_YEARS%TYPE DEFAULT NULL)
Registers the attribute value pairs to the message cache.
| Parameters |
| p_code |
The commodity code. VARCHAR2(10) Required. | |
| p_eff_date |
The effective date of the commodity. Date. | |
| p_activity_date |
Activity date. Date. | |
| p_user_id |
The user ID. VARCHAR2(30). | |
| p_desc |
Commodity description. VARCHAR2(50). | |
| p_uoms_code |
Unit of measure code. VARCHAR2(3). | |
| p_term_date |
Commodity termination date. Date. | |
| p_comm_code_pred |
Commodity code Predesessor. VARCHAR2(10). | |
| p_amst_ind |
Fixed asset indicator. VARCHAR2(1). | |
| p_tgrp_code |
Tax group code. VARCHAR2(4). | |
| p_tax_override_ind |
Tax override indicator. VARCHAR2(1). | |
| p_stock_ind |
Stock indicator. VARCHAR2(1). | |
| p_onorder_qty |
On order quantity. NUMBER(17,2). | |
| p_reserved_qty |
Reserved quantity. NUMBER(17,2). | |
| p_invoiced_qty |
Not invoiced quantity. NUMBER(17,2). | |
| p_value_amt |
Total value amount. NUMBER(17,2). | |
| p_est_life_years |
Estimated life in years. NUMBER(4). |
p_validate
Procedure p_validate(p_code FTVCOMM.FTVCOMM_CODE%TYPE,
p_desc FTVCOMM.FTVCOMM_DESC%TYPE,
p_uoms_code FTVCOMM.FTVCOMM_UOMS_CODE%TYPE)
validates a commodity record.
| Parameters |
| p_code |
The commodity code. VARCHAR2(10) Required. | |
| p_desc |
Commodity description. VARCHAR2(50) Required. | |
| p_uoms_code |
Unit of measure code. VARCHAR2(3) Required. |