4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_SYSTEM_PARAMS_ALL_V Record Spec
7: TYPE sypv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,delink_yn OKL_SYSTEM_PARAMS.DELINK_YN%TYPE := OKL_API.G_MISS_CHAR
10: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
11: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
12: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: -- OKL_SYSTEM_PARAMS_ALL_V Record Spec
7: TYPE sypv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,delink_yn OKL_SYSTEM_PARAMS.DELINK_YN%TYPE := OKL_API.G_MISS_CHAR
10: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
11: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
12: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
13: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
7: TYPE sypv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,delink_yn OKL_SYSTEM_PARAMS.DELINK_YN%TYPE := OKL_API.G_MISS_CHAR
10: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
11: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
12: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
13: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
14: ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,delink_yn OKL_SYSTEM_PARAMS.DELINK_YN%TYPE := OKL_API.G_MISS_CHAR
10: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
11: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
12: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
13: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
14: ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
16: ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
9: ,delink_yn OKL_SYSTEM_PARAMS.DELINK_YN%TYPE := OKL_API.G_MISS_CHAR
10: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
11: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
12: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
13: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
14: ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
16: ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
17: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
10: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
11: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
12: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
13: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
14: ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
16: ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
17: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
18: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
11: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
12: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
13: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
14: ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
16: ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
17: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
18: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
19: ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
12: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
13: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
14: ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
15: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
16: ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
17: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
18: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
19: ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
20: --SECHAWLA 28-MAR-05 4274575 : Added 3 new columns
15: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
16: ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
17: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
18: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
19: ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
20: --SECHAWLA 28-MAR-05 4274575 : Added 3 new columns
21: ,TAX_UPFRONT_YN OKL_SYSTEM_PARAMS.TAX_UPFRONT_YN%TYPE := OKL_API.G_MISS_CHAR
22: ,TAX_INVOICE_YN OKL_SYSTEM_PARAMS.TAX_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR
23: ,TAX_SCHEDULE_YN OKL_SYSTEM_PARAMS.TAX_SCHEDULE_YN%TYPE := OKL_API.G_MISS_CHAR
17: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
18: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
19: ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
20: --SECHAWLA 28-MAR-05 4274575 : Added 3 new columns
21: ,TAX_UPFRONT_YN OKL_SYSTEM_PARAMS.TAX_UPFRONT_YN%TYPE := OKL_API.G_MISS_CHAR
22: ,TAX_INVOICE_YN OKL_SYSTEM_PARAMS.TAX_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR
23: ,TAX_SCHEDULE_YN OKL_SYSTEM_PARAMS.TAX_SCHEDULE_YN%TYPE := OKL_API.G_MISS_CHAR
24: -- SECHAWLA 07-Jul-05 4274575 : added 1 new column
25: ,TAX_UPFRONT_STY_ID OKL_SYSTEM_PARAMS.TAX_UPFRONT_STY_ID%TYPE := OKL_API.G_MISS_NUM
18: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
19: ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
20: --SECHAWLA 28-MAR-05 4274575 : Added 3 new columns
21: ,TAX_UPFRONT_YN OKL_SYSTEM_PARAMS.TAX_UPFRONT_YN%TYPE := OKL_API.G_MISS_CHAR
22: ,TAX_INVOICE_YN OKL_SYSTEM_PARAMS.TAX_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR
23: ,TAX_SCHEDULE_YN OKL_SYSTEM_PARAMS.TAX_SCHEDULE_YN%TYPE := OKL_API.G_MISS_CHAR
24: -- SECHAWLA 07-Jul-05 4274575 : added 1 new column
25: ,TAX_UPFRONT_STY_ID OKL_SYSTEM_PARAMS.TAX_UPFRONT_STY_ID%TYPE := OKL_API.G_MISS_NUM
26: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: end
19: ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
20: --SECHAWLA 28-MAR-05 4274575 : Added 3 new columns
21: ,TAX_UPFRONT_YN OKL_SYSTEM_PARAMS.TAX_UPFRONT_YN%TYPE := OKL_API.G_MISS_CHAR
22: ,TAX_INVOICE_YN OKL_SYSTEM_PARAMS.TAX_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR
23: ,TAX_SCHEDULE_YN OKL_SYSTEM_PARAMS.TAX_SCHEDULE_YN%TYPE := OKL_API.G_MISS_CHAR
24: -- SECHAWLA 07-Jul-05 4274575 : added 1 new column
25: ,TAX_UPFRONT_STY_ID OKL_SYSTEM_PARAMS.TAX_UPFRONT_STY_ID%TYPE := OKL_API.G_MISS_NUM
26: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: end
27: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
21: ,TAX_UPFRONT_YN OKL_SYSTEM_PARAMS.TAX_UPFRONT_YN%TYPE := OKL_API.G_MISS_CHAR
22: ,TAX_INVOICE_YN OKL_SYSTEM_PARAMS.TAX_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR
23: ,TAX_SCHEDULE_YN OKL_SYSTEM_PARAMS.TAX_SCHEDULE_YN%TYPE := OKL_API.G_MISS_CHAR
24: -- SECHAWLA 07-Jul-05 4274575 : added 1 new column
25: ,TAX_UPFRONT_STY_ID OKL_SYSTEM_PARAMS.TAX_UPFRONT_STY_ID%TYPE := OKL_API.G_MISS_NUM
26: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: end
27: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
28: ,CATEGORY_SET_ID OKL_SYSTEM_PARAMS.CATEGORY_SET_ID%TYPE := OKL_API.G_MISS_NUM
29: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
24: -- SECHAWLA 07-Jul-05 4274575 : added 1 new column
25: ,TAX_UPFRONT_STY_ID OKL_SYSTEM_PARAMS.TAX_UPFRONT_STY_ID%TYPE := OKL_API.G_MISS_NUM
26: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: end
27: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
28: ,CATEGORY_SET_ID OKL_SYSTEM_PARAMS.CATEGORY_SET_ID%TYPE := OKL_API.G_MISS_NUM
29: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
30: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements : begin
31: ,VALIDATION_SET_ID OKL_SYSTEM_PARAMS.VALIDATION_SET_ID%TYPE := OKL_API.G_MISS_NUM
32: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements : end
27: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
28: ,CATEGORY_SET_ID OKL_SYSTEM_PARAMS.CATEGORY_SET_ID%TYPE := OKL_API.G_MISS_NUM
29: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
30: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements : begin
31: ,VALIDATION_SET_ID OKL_SYSTEM_PARAMS.VALIDATION_SET_ID%TYPE := OKL_API.G_MISS_NUM
32: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements : end
33: ,CANCEL_QUOTES_YN OKL_SYSTEM_PARAMS.CANCEL_QUOTES_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4556370
34: ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
35: -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
29: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
30: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements : begin
31: ,VALIDATION_SET_ID OKL_SYSTEM_PARAMS.VALIDATION_SET_ID%TYPE := OKL_API.G_MISS_NUM
32: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements : end
33: ,CANCEL_QUOTES_YN OKL_SYSTEM_PARAMS.CANCEL_QUOTES_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4556370
34: ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
35: -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
36: ,TASK_TEMPLATE_GROUP_ID OKL_SYSTEM_PARAMS.TASK_TEMPLATE_GROUP_ID%type := OKL_API.G_MISS_NUM
37: ,OWNER_TYPE_CODE OKL_SYSTEM_PARAMS.OWNER_TYPE_CODE%type := OKL_API.G_MISS_CHAR
30: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements : begin
31: ,VALIDATION_SET_ID OKL_SYSTEM_PARAMS.VALIDATION_SET_ID%TYPE := OKL_API.G_MISS_NUM
32: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements : end
33: ,CANCEL_QUOTES_YN OKL_SYSTEM_PARAMS.CANCEL_QUOTES_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4556370
34: ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
35: -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
36: ,TASK_TEMPLATE_GROUP_ID OKL_SYSTEM_PARAMS.TASK_TEMPLATE_GROUP_ID%type := OKL_API.G_MISS_NUM
37: ,OWNER_TYPE_CODE OKL_SYSTEM_PARAMS.OWNER_TYPE_CODE%type := OKL_API.G_MISS_CHAR
38: ,OWNER_ID OKL_SYSTEM_PARAMS.OWNER_ID%type := OKL_API.G_MISS_NUM
32: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements : end
33: ,CANCEL_QUOTES_YN OKL_SYSTEM_PARAMS.CANCEL_QUOTES_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4556370
34: ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
35: -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
36: ,TASK_TEMPLATE_GROUP_ID OKL_SYSTEM_PARAMS.TASK_TEMPLATE_GROUP_ID%type := OKL_API.G_MISS_NUM
37: ,OWNER_TYPE_CODE OKL_SYSTEM_PARAMS.OWNER_TYPE_CODE%type := OKL_API.G_MISS_CHAR
38: ,OWNER_ID OKL_SYSTEM_PARAMS.OWNER_ID%type := OKL_API.G_MISS_NUM
39: -- gboomina Bug 5128517 - End
40: -- dcshanmu begin MOAC change for moving three new profiles to System Options
33: ,CANCEL_QUOTES_YN OKL_SYSTEM_PARAMS.CANCEL_QUOTES_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4556370
34: ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
35: -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
36: ,TASK_TEMPLATE_GROUP_ID OKL_SYSTEM_PARAMS.TASK_TEMPLATE_GROUP_ID%type := OKL_API.G_MISS_NUM
37: ,OWNER_TYPE_CODE OKL_SYSTEM_PARAMS.OWNER_TYPE_CODE%type := OKL_API.G_MISS_CHAR
38: ,OWNER_ID OKL_SYSTEM_PARAMS.OWNER_ID%type := OKL_API.G_MISS_NUM
39: -- gboomina Bug 5128517 - End
40: -- dcshanmu begin MOAC change for moving three new profiles to System Options
41: ,ITEM_INV_ORG_ID OKL_SYSTEM_PARAMS.ITEM_INV_ORG_ID%type :=
34: ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
35: -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
36: ,TASK_TEMPLATE_GROUP_ID OKL_SYSTEM_PARAMS.TASK_TEMPLATE_GROUP_ID%type := OKL_API.G_MISS_NUM
37: ,OWNER_TYPE_CODE OKL_SYSTEM_PARAMS.OWNER_TYPE_CODE%type := OKL_API.G_MISS_CHAR
38: ,OWNER_ID OKL_SYSTEM_PARAMS.OWNER_ID%type := OKL_API.G_MISS_NUM
39: -- gboomina Bug 5128517 - End
40: -- dcshanmu begin MOAC change for moving three new profiles to System Options
41: ,ITEM_INV_ORG_ID OKL_SYSTEM_PARAMS.ITEM_INV_ORG_ID%type :=
42: OKL_API.G_MISS_NUM
38: ,OWNER_ID OKL_SYSTEM_PARAMS.OWNER_ID%type := OKL_API.G_MISS_NUM
39: -- gboomina Bug 5128517 - End
40: -- dcshanmu begin MOAC change for moving three new profiles to System Options
41: ,ITEM_INV_ORG_ID OKL_SYSTEM_PARAMS.ITEM_INV_ORG_ID%type :=
42: OKL_API.G_MISS_NUM
43: , RPT_PROD_BOOK_TYPE_CODE OKL_SYSTEM_PARAMS.RPT_PROD_BOOK_TYPE_CODE%type :=
44: OKL_API.G_MISS_CHAR
45: ,ASST_ADD_BOOK_TYPE_CODE OKL_SYSTEM_PARAMS.ASST_ADD_BOOK_TYPE_CODE%type :=
46: OKL_API.G_MISS_CHAR
40: -- dcshanmu begin MOAC change for moving three new profiles to System Options
41: ,ITEM_INV_ORG_ID OKL_SYSTEM_PARAMS.ITEM_INV_ORG_ID%type :=
42: OKL_API.G_MISS_NUM
43: , RPT_PROD_BOOK_TYPE_CODE OKL_SYSTEM_PARAMS.RPT_PROD_BOOK_TYPE_CODE%type :=
44: OKL_API.G_MISS_CHAR
45: ,ASST_ADD_BOOK_TYPE_CODE OKL_SYSTEM_PARAMS.ASST_ADD_BOOK_TYPE_CODE%type :=
46: OKL_API.G_MISS_CHAR
47: ,CCARD_REMITTANCE_ID OKL_SYSTEM_PARAMS.CCARD_REMITTANCE_ID%type := OKL_API.G_MISS_NUM
48: -- dcshanmu end MOAC change for moving three new profiles to System Options
42: OKL_API.G_MISS_NUM
43: , RPT_PROD_BOOK_TYPE_CODE OKL_SYSTEM_PARAMS.RPT_PROD_BOOK_TYPE_CODE%type :=
44: OKL_API.G_MISS_CHAR
45: ,ASST_ADD_BOOK_TYPE_CODE OKL_SYSTEM_PARAMS.ASST_ADD_BOOK_TYPE_CODE%type :=
46: OKL_API.G_MISS_CHAR
47: ,CCARD_REMITTANCE_ID OKL_SYSTEM_PARAMS.CCARD_REMITTANCE_ID%type := OKL_API.G_MISS_NUM
48: -- dcshanmu end MOAC change for moving three new profiles to System Options
49:
50: -- DJANASWA Bug 6653304 begin
43: , RPT_PROD_BOOK_TYPE_CODE OKL_SYSTEM_PARAMS.RPT_PROD_BOOK_TYPE_CODE%type :=
44: OKL_API.G_MISS_CHAR
45: ,ASST_ADD_BOOK_TYPE_CODE OKL_SYSTEM_PARAMS.ASST_ADD_BOOK_TYPE_CODE%type :=
46: OKL_API.G_MISS_CHAR
47: ,CCARD_REMITTANCE_ID OKL_SYSTEM_PARAMS.CCARD_REMITTANCE_ID%type := OKL_API.G_MISS_NUM
48: -- dcshanmu end MOAC change for moving three new profiles to System Options
49:
50: -- DJANASWA Bug 6653304 begin
51: ,CORPORATE_BOOK OKL_SYSTEM_PARAMS.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
47: ,CCARD_REMITTANCE_ID OKL_SYSTEM_PARAMS.CCARD_REMITTANCE_ID%type := OKL_API.G_MISS_NUM
48: -- dcshanmu end MOAC change for moving three new profiles to System Options
49:
50: -- DJANASWA Bug 6653304 begin
51: ,CORPORATE_BOOK OKL_SYSTEM_PARAMS.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
52: ,TAX_BOOK_1 OKL_SYSTEM_PARAMS.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
53: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
54: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
55: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
48: -- dcshanmu end MOAC change for moving three new profiles to System Options
49:
50: -- DJANASWA Bug 6653304 begin
51: ,CORPORATE_BOOK OKL_SYSTEM_PARAMS.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
52: ,TAX_BOOK_1 OKL_SYSTEM_PARAMS.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
53: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
54: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
55: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
56: ,FORMULA_ID OKL_SYSTEM_PARAMS.FORMULA_ID%type := OKL_API.G_MISS_NUM
49:
50: -- DJANASWA Bug 6653304 begin
51: ,CORPORATE_BOOK OKL_SYSTEM_PARAMS.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
52: ,TAX_BOOK_1 OKL_SYSTEM_PARAMS.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
53: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
54: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
55: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
56: ,FORMULA_ID OKL_SYSTEM_PARAMS.FORMULA_ID%type := OKL_API.G_MISS_NUM
57: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
50: -- DJANASWA Bug 6653304 begin
51: ,CORPORATE_BOOK OKL_SYSTEM_PARAMS.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
52: ,TAX_BOOK_1 OKL_SYSTEM_PARAMS.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
53: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
54: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
55: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
56: ,FORMULA_ID OKL_SYSTEM_PARAMS.FORMULA_ID%type := OKL_API.G_MISS_NUM
57: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
58: -- DJANASWA Bug 6653304 end
51: ,CORPORATE_BOOK OKL_SYSTEM_PARAMS.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
52: ,TAX_BOOK_1 OKL_SYSTEM_PARAMS.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
53: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
54: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
55: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
56: ,FORMULA_ID OKL_SYSTEM_PARAMS.FORMULA_ID%type := OKL_API.G_MISS_NUM
57: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
58: -- DJANASWA Bug 6653304 end
59: -- Bug 5568328
52: ,TAX_BOOK_1 OKL_SYSTEM_PARAMS.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
53: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
54: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
55: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
56: ,FORMULA_ID OKL_SYSTEM_PARAMS.FORMULA_ID%type := OKL_API.G_MISS_NUM
57: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
58: -- DJANASWA Bug 6653304 end
59: -- Bug 5568328
60: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
53: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
54: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
55: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
56: ,FORMULA_ID OKL_SYSTEM_PARAMS.FORMULA_ID%type := OKL_API.G_MISS_NUM
57: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
58: -- DJANASWA Bug 6653304 end
59: -- Bug 5568328
60: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
56: ,FORMULA_ID OKL_SYSTEM_PARAMS.FORMULA_ID%type := OKL_API.G_MISS_NUM
57: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
58: -- DJANASWA Bug 6653304 end
59: -- Bug 5568328
60: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
57: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
58: -- DJANASWA Bug 6653304 end
59: -- Bug 5568328
60: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
58: -- DJANASWA Bug 6653304 end
59: -- Bug 5568328
60: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,program_update_date OKL_SYSTEM_PARAMS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
59: -- Bug 5568328
60: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,program_update_date OKL_SYSTEM_PARAMS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,attribute_category OKL_SYSTEM_PARAMS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
60: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,program_update_date OKL_SYSTEM_PARAMS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,attribute_category OKL_SYSTEM_PARAMS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute1 OKL_SYSTEM_PARAMS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
61: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,program_update_date OKL_SYSTEM_PARAMS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,attribute_category OKL_SYSTEM_PARAMS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute1 OKL_SYSTEM_PARAMS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute2 OKL_SYSTEM_PARAMS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
62: ,org_id NUMBER := OKL_API.G_MISS_NUM
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,program_update_date OKL_SYSTEM_PARAMS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,attribute_category OKL_SYSTEM_PARAMS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute1 OKL_SYSTEM_PARAMS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute2 OKL_SYSTEM_PARAMS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute3 OKL_SYSTEM_PARAMS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
63: ,request_id NUMBER := OKL_API.G_MISS_NUM
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,program_update_date OKL_SYSTEM_PARAMS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,attribute_category OKL_SYSTEM_PARAMS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute1 OKL_SYSTEM_PARAMS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute2 OKL_SYSTEM_PARAMS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute3 OKL_SYSTEM_PARAMS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute4 OKL_SYSTEM_PARAMS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
64: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,program_update_date OKL_SYSTEM_PARAMS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,attribute_category OKL_SYSTEM_PARAMS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute1 OKL_SYSTEM_PARAMS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute2 OKL_SYSTEM_PARAMS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute3 OKL_SYSTEM_PARAMS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute4 OKL_SYSTEM_PARAMS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute5 OKL_SYSTEM_PARAMS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
65: ,program_id NUMBER := OKL_API.G_MISS_NUM
66: ,program_update_date OKL_SYSTEM_PARAMS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,attribute_category OKL_SYSTEM_PARAMS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute1 OKL_SYSTEM_PARAMS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute2 OKL_SYSTEM_PARAMS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute3 OKL_SYSTEM_PARAMS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute4 OKL_SYSTEM_PARAMS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute5 OKL_SYSTEM_PARAMS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute6 OKL_SYSTEM_PARAMS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
66: ,program_update_date OKL_SYSTEM_PARAMS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
67: ,attribute_category OKL_SYSTEM_PARAMS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute1 OKL_SYSTEM_PARAMS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute2 OKL_SYSTEM_PARAMS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute3 OKL_SYSTEM_PARAMS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute4 OKL_SYSTEM_PARAMS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute5 OKL_SYSTEM_PARAMS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute6 OKL_SYSTEM_PARAMS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute7 OKL_SYSTEM_PARAMS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
67: ,attribute_category OKL_SYSTEM_PARAMS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute1 OKL_SYSTEM_PARAMS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute2 OKL_SYSTEM_PARAMS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute3 OKL_SYSTEM_PARAMS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute4 OKL_SYSTEM_PARAMS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute5 OKL_SYSTEM_PARAMS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute6 OKL_SYSTEM_PARAMS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute7 OKL_SYSTEM_PARAMS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute8 OKL_SYSTEM_PARAMS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
68: ,attribute1 OKL_SYSTEM_PARAMS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute2 OKL_SYSTEM_PARAMS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute3 OKL_SYSTEM_PARAMS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute4 OKL_SYSTEM_PARAMS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute5 OKL_SYSTEM_PARAMS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute6 OKL_SYSTEM_PARAMS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute7 OKL_SYSTEM_PARAMS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute8 OKL_SYSTEM_PARAMS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute9 OKL_SYSTEM_PARAMS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
69: ,attribute2 OKL_SYSTEM_PARAMS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute3 OKL_SYSTEM_PARAMS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute4 OKL_SYSTEM_PARAMS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute5 OKL_SYSTEM_PARAMS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute6 OKL_SYSTEM_PARAMS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute7 OKL_SYSTEM_PARAMS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute8 OKL_SYSTEM_PARAMS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute9 OKL_SYSTEM_PARAMS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute10 OKL_SYSTEM_PARAMS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
70: ,attribute3 OKL_SYSTEM_PARAMS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute4 OKL_SYSTEM_PARAMS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute5 OKL_SYSTEM_PARAMS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute6 OKL_SYSTEM_PARAMS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute7 OKL_SYSTEM_PARAMS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute8 OKL_SYSTEM_PARAMS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute9 OKL_SYSTEM_PARAMS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute10 OKL_SYSTEM_PARAMS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute11 OKL_SYSTEM_PARAMS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
71: ,attribute4 OKL_SYSTEM_PARAMS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute5 OKL_SYSTEM_PARAMS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute6 OKL_SYSTEM_PARAMS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute7 OKL_SYSTEM_PARAMS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute8 OKL_SYSTEM_PARAMS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute9 OKL_SYSTEM_PARAMS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute10 OKL_SYSTEM_PARAMS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute11 OKL_SYSTEM_PARAMS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute12 OKL_SYSTEM_PARAMS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
72: ,attribute5 OKL_SYSTEM_PARAMS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute6 OKL_SYSTEM_PARAMS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute7 OKL_SYSTEM_PARAMS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute8 OKL_SYSTEM_PARAMS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute9 OKL_SYSTEM_PARAMS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute10 OKL_SYSTEM_PARAMS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute11 OKL_SYSTEM_PARAMS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute12 OKL_SYSTEM_PARAMS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute13 OKL_SYSTEM_PARAMS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
73: ,attribute6 OKL_SYSTEM_PARAMS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute7 OKL_SYSTEM_PARAMS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute8 OKL_SYSTEM_PARAMS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute9 OKL_SYSTEM_PARAMS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute10 OKL_SYSTEM_PARAMS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute11 OKL_SYSTEM_PARAMS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute12 OKL_SYSTEM_PARAMS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute13 OKL_SYSTEM_PARAMS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute14 OKL_SYSTEM_PARAMS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
74: ,attribute7 OKL_SYSTEM_PARAMS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute8 OKL_SYSTEM_PARAMS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute9 OKL_SYSTEM_PARAMS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute10 OKL_SYSTEM_PARAMS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute11 OKL_SYSTEM_PARAMS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute12 OKL_SYSTEM_PARAMS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute13 OKL_SYSTEM_PARAMS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute14 OKL_SYSTEM_PARAMS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute15 OKL_SYSTEM_PARAMS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
75: ,attribute8 OKL_SYSTEM_PARAMS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
76: ,attribute9 OKL_SYSTEM_PARAMS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute10 OKL_SYSTEM_PARAMS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute11 OKL_SYSTEM_PARAMS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute12 OKL_SYSTEM_PARAMS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute13 OKL_SYSTEM_PARAMS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute14 OKL_SYSTEM_PARAMS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute15 OKL_SYSTEM_PARAMS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
83: ,created_by NUMBER := OKL_API.G_MISS_NUM
76: ,attribute9 OKL_SYSTEM_PARAMS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
77: ,attribute10 OKL_SYSTEM_PARAMS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute11 OKL_SYSTEM_PARAMS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute12 OKL_SYSTEM_PARAMS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute13 OKL_SYSTEM_PARAMS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute14 OKL_SYSTEM_PARAMS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute15 OKL_SYSTEM_PARAMS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
83: ,created_by NUMBER := OKL_API.G_MISS_NUM
84: ,creation_date OKL_SYSTEM_PARAMS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
77: ,attribute10 OKL_SYSTEM_PARAMS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
78: ,attribute11 OKL_SYSTEM_PARAMS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute12 OKL_SYSTEM_PARAMS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute13 OKL_SYSTEM_PARAMS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute14 OKL_SYSTEM_PARAMS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute15 OKL_SYSTEM_PARAMS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
83: ,created_by NUMBER := OKL_API.G_MISS_NUM
84: ,creation_date OKL_SYSTEM_PARAMS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
85: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
78: ,attribute11 OKL_SYSTEM_PARAMS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
79: ,attribute12 OKL_SYSTEM_PARAMS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute13 OKL_SYSTEM_PARAMS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute14 OKL_SYSTEM_PARAMS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute15 OKL_SYSTEM_PARAMS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
83: ,created_by NUMBER := OKL_API.G_MISS_NUM
84: ,creation_date OKL_SYSTEM_PARAMS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
85: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
86: ,last_update_date OKL_SYSTEM_PARAMS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
79: ,attribute12 OKL_SYSTEM_PARAMS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
80: ,attribute13 OKL_SYSTEM_PARAMS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute14 OKL_SYSTEM_PARAMS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute15 OKL_SYSTEM_PARAMS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
83: ,created_by NUMBER := OKL_API.G_MISS_NUM
84: ,creation_date OKL_SYSTEM_PARAMS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
85: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
86: ,last_update_date OKL_SYSTEM_PARAMS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
80: ,attribute13 OKL_SYSTEM_PARAMS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
81: ,attribute14 OKL_SYSTEM_PARAMS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute15 OKL_SYSTEM_PARAMS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
83: ,created_by NUMBER := OKL_API.G_MISS_NUM
84: ,creation_date OKL_SYSTEM_PARAMS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
85: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
86: ,last_update_date OKL_SYSTEM_PARAMS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
88: --Bug 7022258-Added new columns by kkorrapo
81: ,attribute14 OKL_SYSTEM_PARAMS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute15 OKL_SYSTEM_PARAMS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
83: ,created_by NUMBER := OKL_API.G_MISS_NUM
84: ,creation_date OKL_SYSTEM_PARAMS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
85: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
86: ,last_update_date OKL_SYSTEM_PARAMS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
88: --Bug 7022258-Added new columns by kkorrapo
89: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute15 OKL_SYSTEM_PARAMS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
83: ,created_by NUMBER := OKL_API.G_MISS_NUM
84: ,creation_date OKL_SYSTEM_PARAMS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
85: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
86: ,last_update_date OKL_SYSTEM_PARAMS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
88: --Bug 7022258-Added new columns by kkorrapo
89: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
90: ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
83: ,created_by NUMBER := OKL_API.G_MISS_NUM
84: ,creation_date OKL_SYSTEM_PARAMS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
85: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
86: ,last_update_date OKL_SYSTEM_PARAMS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
88: --Bug 7022258-Added new columns by kkorrapo
89: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
90: ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
91: ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS.QCKQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
85: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
86: ,last_update_date OKL_SYSTEM_PARAMS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
88: --Bug 7022258-Added new columns by kkorrapo
89: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
90: ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
91: ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS.QCKQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
92: ,lseqte_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
93: --Bug 7022258-Addition end
86: ,last_update_date OKL_SYSTEM_PARAMS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
87: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
88: --Bug 7022258-Added new columns by kkorrapo
89: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
90: ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
91: ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS.QCKQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
92: ,lseqte_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
93: --Bug 7022258-Addition end
94: );
87: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
88: --Bug 7022258-Added new columns by kkorrapo
89: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
90: ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
91: ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS.QCKQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
92: ,lseqte_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
93: --Bug 7022258-Addition end
94: );
95: G_Miss_sypv_rec sypv_rec_type;
88: --Bug 7022258-Added new columns by kkorrapo
89: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
90: ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
91: ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS.QCKQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
92: ,lseqte_seq_prefix_txt OKL_SYSTEM_PARAMS.LSEQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
93: --Bug 7022258-Addition end
94: );
95: G_Miss_sypv_rec sypv_rec_type;
96: TYPE sypv_tbl_type IS TABLE OF sypv_rec_type
96: TYPE sypv_tbl_type IS TABLE OF sypv_rec_type
97: INDEX BY BINARY_INTEGER;
98: -- OKL_SYSTEM_PARAMS_ALL Record Spec
99: TYPE syp_rec_type IS RECORD (
100: id NUMBER := OKL_API.G_MISS_NUM
101: ,delink_yn OKL_SYSTEM_PARAMS_ALL.DELINK_YN%TYPE := OKL_API.G_MISS_CHAR
102: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
103: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS_ALL.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
104: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS_ALL.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
97: INDEX BY BINARY_INTEGER;
98: -- OKL_SYSTEM_PARAMS_ALL Record Spec
99: TYPE syp_rec_type IS RECORD (
100: id NUMBER := OKL_API.G_MISS_NUM
101: ,delink_yn OKL_SYSTEM_PARAMS_ALL.DELINK_YN%TYPE := OKL_API.G_MISS_CHAR
102: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
103: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS_ALL.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
104: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS_ALL.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
105: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS_ALL.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
99: TYPE syp_rec_type IS RECORD (
100: id NUMBER := OKL_API.G_MISS_NUM
101: ,delink_yn OKL_SYSTEM_PARAMS_ALL.DELINK_YN%TYPE := OKL_API.G_MISS_CHAR
102: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
103: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS_ALL.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
104: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS_ALL.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
105: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS_ALL.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
106: ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS_ALL.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
107: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
100: id NUMBER := OKL_API.G_MISS_NUM
101: ,delink_yn OKL_SYSTEM_PARAMS_ALL.DELINK_YN%TYPE := OKL_API.G_MISS_CHAR
102: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
103: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS_ALL.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
104: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS_ALL.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
105: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS_ALL.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
106: ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS_ALL.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
107: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
108: ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
101: ,delink_yn OKL_SYSTEM_PARAMS_ALL.DELINK_YN%TYPE := OKL_API.G_MISS_CHAR
102: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
103: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS_ALL.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
104: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS_ALL.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
105: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS_ALL.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
106: ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS_ALL.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
107: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
108: ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
109: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
102: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : begin
103: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS_ALL.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
104: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS_ALL.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
105: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS_ALL.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
106: ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS_ALL.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
107: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
108: ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
109: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
110: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
103: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS_ALL.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR
104: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS_ALL.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
105: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS_ALL.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
106: ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS_ALL.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
107: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
108: ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
109: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
110: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
111: ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
104: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS_ALL.REMK_ORGANIZATION_ID%TYPE := OKL_API.G_MISS_NUM
105: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS_ALL.REMK_PRICE_LIST_ID%TYPE := OKL_API.G_MISS_NUM
106: ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS_ALL.REMK_PROCESS_CODE%TYPE := OKL_API.G_MISS_CHAR
107: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
108: ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
109: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
110: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
111: ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
112: --28-MAR-05 SECHAWLA 4274575 : Added 3 new columns
107: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM
108: ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_INVOICED_CODE%TYPE := OKL_API.G_MISS_CHAR
109: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
110: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
111: ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
112: --28-MAR-05 SECHAWLA 4274575 : Added 3 new columns
113: ,TAX_UPFRONT_YN OKL_SYSTEM_PARAMS.TAX_UPFRONT_YN%TYPE := OKL_API.G_MISS_CHAR
114: ,TAX_INVOICE_YN OKL_SYSTEM_PARAMS.TAX_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR
115: ,TAX_SCHEDULE_YN OKL_SYSTEM_PARAMS.TAX_SCHEDULE_YN%TYPE := OKL_API.G_MISS_CHAR
109: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end
110: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
111: ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
112: --28-MAR-05 SECHAWLA 4274575 : Added 3 new columns
113: ,TAX_UPFRONT_YN OKL_SYSTEM_PARAMS.TAX_UPFRONT_YN%TYPE := OKL_API.G_MISS_CHAR
114: ,TAX_INVOICE_YN OKL_SYSTEM_PARAMS.TAX_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR
115: ,TAX_SCHEDULE_YN OKL_SYSTEM_PARAMS.TAX_SCHEDULE_YN%TYPE := OKL_API.G_MISS_CHAR
116: --07-Jul-05 SECHAWLA 4274575 : Added 1 new column
117: ,TAX_UPFRONT_STY_ID OKL_SYSTEM_PARAMS.TAX_UPFRONT_STY_ID%TYPE := OKL_API.G_MISS_NUM
110: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin
111: ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
112: --28-MAR-05 SECHAWLA 4274575 : Added 3 new columns
113: ,TAX_UPFRONT_YN OKL_SYSTEM_PARAMS.TAX_UPFRONT_YN%TYPE := OKL_API.G_MISS_CHAR
114: ,TAX_INVOICE_YN OKL_SYSTEM_PARAMS.TAX_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR
115: ,TAX_SCHEDULE_YN OKL_SYSTEM_PARAMS.TAX_SCHEDULE_YN%TYPE := OKL_API.G_MISS_CHAR
116: --07-Jul-05 SECHAWLA 4274575 : Added 1 new column
117: ,TAX_UPFRONT_STY_ID OKL_SYSTEM_PARAMS.TAX_UPFRONT_STY_ID%TYPE := OKL_API.G_MISS_NUM
118: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: end
111: ,LEASE_INV_ORG_YN OKL_SYSTEM_PARAMS.LEASE_INV_ORG_YN%TYPE := OKL_API.G_MISS_CHAR
112: --28-MAR-05 SECHAWLA 4274575 : Added 3 new columns
113: ,TAX_UPFRONT_YN OKL_SYSTEM_PARAMS.TAX_UPFRONT_YN%TYPE := OKL_API.G_MISS_CHAR
114: ,TAX_INVOICE_YN OKL_SYSTEM_PARAMS.TAX_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR
115: ,TAX_SCHEDULE_YN OKL_SYSTEM_PARAMS.TAX_SCHEDULE_YN%TYPE := OKL_API.G_MISS_CHAR
116: --07-Jul-05 SECHAWLA 4274575 : Added 1 new column
117: ,TAX_UPFRONT_STY_ID OKL_SYSTEM_PARAMS.TAX_UPFRONT_STY_ID%TYPE := OKL_API.G_MISS_NUM
118: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: end
119: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
113: ,TAX_UPFRONT_YN OKL_SYSTEM_PARAMS.TAX_UPFRONT_YN%TYPE := OKL_API.G_MISS_CHAR
114: ,TAX_INVOICE_YN OKL_SYSTEM_PARAMS.TAX_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR
115: ,TAX_SCHEDULE_YN OKL_SYSTEM_PARAMS.TAX_SCHEDULE_YN%TYPE := OKL_API.G_MISS_CHAR
116: --07-Jul-05 SECHAWLA 4274575 : Added 1 new column
117: ,TAX_UPFRONT_STY_ID OKL_SYSTEM_PARAMS.TAX_UPFRONT_STY_ID%TYPE := OKL_API.G_MISS_NUM
118: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: end
119: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
120: ,CATEGORY_SET_ID OKL_SYSTEM_PARAMS_ALL.CATEGORY_SET_ID%TYPE := OKL_API.G_MISS_NUM
121: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
116: --07-Jul-05 SECHAWLA 4274575 : Added 1 new column
117: ,TAX_UPFRONT_STY_ID OKL_SYSTEM_PARAMS.TAX_UPFRONT_STY_ID%TYPE := OKL_API.G_MISS_NUM
118: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: end
119: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
120: ,CATEGORY_SET_ID OKL_SYSTEM_PARAMS_ALL.CATEGORY_SET_ID%TYPE := OKL_API.G_MISS_NUM
121: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
122: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
123: ,VALIDATION_SET_ID OKL_SYSTEM_PARAMS.VALIDATION_SET_ID%TYPE := OKL_API.G_MISS_NUM
124: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
119: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : begin
120: ,CATEGORY_SET_ID OKL_SYSTEM_PARAMS_ALL.CATEGORY_SET_ID%TYPE := OKL_API.G_MISS_NUM
121: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
122: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
123: ,VALIDATION_SET_ID OKL_SYSTEM_PARAMS.VALIDATION_SET_ID%TYPE := OKL_API.G_MISS_NUM
124: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
125: ,CANCEL_QUOTES_YN OKL_SYSTEM_PARAMS_ALL.CANCEL_QUOTES_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4556370
126: ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS_ALL.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
127: -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
121: -- asawanka 24-MAY-05 : Added the new column CATEGORY_SET_ID for Pricing Enhancements : end
122: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
123: ,VALIDATION_SET_ID OKL_SYSTEM_PARAMS.VALIDATION_SET_ID%TYPE := OKL_API.G_MISS_NUM
124: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
125: ,CANCEL_QUOTES_YN OKL_SYSTEM_PARAMS_ALL.CANCEL_QUOTES_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4556370
126: ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS_ALL.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
127: -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
128: ,TASK_TEMPLATE_GROUP_ID OKL_SYSTEM_PARAMS.task_template_group_id%type := OKL_API.G_MISS_NUM
129: ,OWNER_TYPE_CODE OKL_SYSTEM_PARAMS.OWNER_TYPE_CODE%type := OKL_API.G_MISS_CHAR
122: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
123: ,VALIDATION_SET_ID OKL_SYSTEM_PARAMS.VALIDATION_SET_ID%TYPE := OKL_API.G_MISS_NUM
124: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
125: ,CANCEL_QUOTES_YN OKL_SYSTEM_PARAMS_ALL.CANCEL_QUOTES_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4556370
126: ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS_ALL.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
127: -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
128: ,TASK_TEMPLATE_GROUP_ID OKL_SYSTEM_PARAMS.task_template_group_id%type := OKL_API.G_MISS_NUM
129: ,OWNER_TYPE_CODE OKL_SYSTEM_PARAMS.OWNER_TYPE_CODE%type := OKL_API.G_MISS_CHAR
130: ,OWNER_ID OKL_SYSTEM_PARAMS.owner_id%type := OKL_API.G_MISS_NUM
124: -- ssdeshpa 2-SEP-05 : Added the new column VALIDATION_SET_ID for Sales Quote Enhancements :
125: ,CANCEL_QUOTES_YN OKL_SYSTEM_PARAMS_ALL.CANCEL_QUOTES_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4556370
126: ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS_ALL.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
127: -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
128: ,TASK_TEMPLATE_GROUP_ID OKL_SYSTEM_PARAMS.task_template_group_id%type := OKL_API.G_MISS_NUM
129: ,OWNER_TYPE_CODE OKL_SYSTEM_PARAMS.OWNER_TYPE_CODE%type := OKL_API.G_MISS_CHAR
130: ,OWNER_ID OKL_SYSTEM_PARAMS.owner_id%type := OKL_API.G_MISS_NUM
131: -- gboomina Bug 5128517 - End
132:
125: ,CANCEL_QUOTES_YN OKL_SYSTEM_PARAMS_ALL.CANCEL_QUOTES_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4556370
126: ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS_ALL.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
127: -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
128: ,TASK_TEMPLATE_GROUP_ID OKL_SYSTEM_PARAMS.task_template_group_id%type := OKL_API.G_MISS_NUM
129: ,OWNER_TYPE_CODE OKL_SYSTEM_PARAMS.OWNER_TYPE_CODE%type := OKL_API.G_MISS_CHAR
130: ,OWNER_ID OKL_SYSTEM_PARAMS.owner_id%type := OKL_API.G_MISS_NUM
131: -- gboomina Bug 5128517 - End
132:
133: -- DJANASWA Bug 6653304 begin
126: ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS_ALL.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094
127: -- gboomina 10-Apr-2005 - Added New Columns for Bug 5128517 - start
128: ,TASK_TEMPLATE_GROUP_ID OKL_SYSTEM_PARAMS.task_template_group_id%type := OKL_API.G_MISS_NUM
129: ,OWNER_TYPE_CODE OKL_SYSTEM_PARAMS.OWNER_TYPE_CODE%type := OKL_API.G_MISS_CHAR
130: ,OWNER_ID OKL_SYSTEM_PARAMS.owner_id%type := OKL_API.G_MISS_NUM
131: -- gboomina Bug 5128517 - End
132:
133: -- DJANASWA Bug 6653304 begin
134: ,CORPORATE_BOOK OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
130: ,OWNER_ID OKL_SYSTEM_PARAMS.owner_id%type := OKL_API.G_MISS_NUM
131: -- gboomina Bug 5128517 - End
132:
133: -- DJANASWA Bug 6653304 begin
134: ,CORPORATE_BOOK OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
135: ,TAX_BOOK_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
136: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
137: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
138: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
131: -- gboomina Bug 5128517 - End
132:
133: -- DJANASWA Bug 6653304 begin
134: ,CORPORATE_BOOK OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
135: ,TAX_BOOK_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
136: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
137: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
138: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
139: ,FORMULA_ID OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type := OKL_API.G_MISS_NUM
132:
133: -- DJANASWA Bug 6653304 begin
134: ,CORPORATE_BOOK OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
135: ,TAX_BOOK_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
136: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
137: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
138: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
139: ,FORMULA_ID OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type := OKL_API.G_MISS_NUM
140: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
133: -- DJANASWA Bug 6653304 begin
134: ,CORPORATE_BOOK OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
135: ,TAX_BOOK_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
136: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
137: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
138: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
139: ,FORMULA_ID OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type := OKL_API.G_MISS_NUM
140: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
141: -- DJANASWA Bug 6653304 end
134: ,CORPORATE_BOOK OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%type := OKL_API.G_MISS_CHAR
135: ,TAX_BOOK_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
136: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
137: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
138: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
139: ,FORMULA_ID OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type := OKL_API.G_MISS_NUM
140: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
141: -- DJANASWA Bug 6653304 end
142: -- Bug 5568328
135: ,TAX_BOOK_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR
136: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
137: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
138: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
139: ,FORMULA_ID OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type := OKL_API.G_MISS_NUM
140: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
141: -- DJANASWA Bug 6653304 end
142: -- Bug 5568328
143: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
136: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR
137: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR
138: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM
139: ,FORMULA_ID OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type := OKL_API.G_MISS_NUM
140: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
141: -- DJANASWA Bug 6653304 end
142: -- Bug 5568328
143: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
144: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
139: ,FORMULA_ID OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type := OKL_API.G_MISS_NUM
140: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
141: -- DJANASWA Bug 6653304 end
142: -- Bug 5568328
143: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
144: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
145: ,org_id NUMBER := OKL_API.G_MISS_NUM
146: ,request_id NUMBER := OKL_API.G_MISS_NUM
147: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
140: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM
141: -- DJANASWA Bug 6653304 end
142: -- Bug 5568328
143: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
144: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
145: ,org_id NUMBER := OKL_API.G_MISS_NUM
146: ,request_id NUMBER := OKL_API.G_MISS_NUM
147: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
148: ,program_id NUMBER := OKL_API.G_MISS_NUM
141: -- DJANASWA Bug 6653304 end
142: -- Bug 5568328
143: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
144: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
145: ,org_id NUMBER := OKL_API.G_MISS_NUM
146: ,request_id NUMBER := OKL_API.G_MISS_NUM
147: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
148: ,program_id NUMBER := OKL_API.G_MISS_NUM
149: ,program_update_date OKL_SYSTEM_PARAMS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
142: -- Bug 5568328
143: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
144: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
145: ,org_id NUMBER := OKL_API.G_MISS_NUM
146: ,request_id NUMBER := OKL_API.G_MISS_NUM
147: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
148: ,program_id NUMBER := OKL_API.G_MISS_NUM
149: ,program_update_date OKL_SYSTEM_PARAMS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,attribute_category OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
143: ,part_trmnt_apply_round_diff okl_system_params.part_trmnt_apply_round_diff%type := okl_api.g_miss_char
144: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
145: ,org_id NUMBER := OKL_API.G_MISS_NUM
146: ,request_id NUMBER := OKL_API.G_MISS_NUM
147: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
148: ,program_id NUMBER := OKL_API.G_MISS_NUM
149: ,program_update_date OKL_SYSTEM_PARAMS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,attribute_category OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
151: ,attribute1 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
144: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
145: ,org_id NUMBER := OKL_API.G_MISS_NUM
146: ,request_id NUMBER := OKL_API.G_MISS_NUM
147: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
148: ,program_id NUMBER := OKL_API.G_MISS_NUM
149: ,program_update_date OKL_SYSTEM_PARAMS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,attribute_category OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
151: ,attribute1 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
152: ,attribute2 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
145: ,org_id NUMBER := OKL_API.G_MISS_NUM
146: ,request_id NUMBER := OKL_API.G_MISS_NUM
147: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
148: ,program_id NUMBER := OKL_API.G_MISS_NUM
149: ,program_update_date OKL_SYSTEM_PARAMS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,attribute_category OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
151: ,attribute1 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
152: ,attribute2 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
153: ,attribute3 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
146: ,request_id NUMBER := OKL_API.G_MISS_NUM
147: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
148: ,program_id NUMBER := OKL_API.G_MISS_NUM
149: ,program_update_date OKL_SYSTEM_PARAMS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,attribute_category OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
151: ,attribute1 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
152: ,attribute2 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
153: ,attribute3 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
154: ,attribute4 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
147: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
148: ,program_id NUMBER := OKL_API.G_MISS_NUM
149: ,program_update_date OKL_SYSTEM_PARAMS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,attribute_category OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
151: ,attribute1 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
152: ,attribute2 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
153: ,attribute3 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
154: ,attribute4 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
155: ,attribute5 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
148: ,program_id NUMBER := OKL_API.G_MISS_NUM
149: ,program_update_date OKL_SYSTEM_PARAMS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,attribute_category OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
151: ,attribute1 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
152: ,attribute2 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
153: ,attribute3 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
154: ,attribute4 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
155: ,attribute5 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
156: ,attribute6 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
149: ,program_update_date OKL_SYSTEM_PARAMS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
150: ,attribute_category OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
151: ,attribute1 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
152: ,attribute2 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
153: ,attribute3 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
154: ,attribute4 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
155: ,attribute5 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
156: ,attribute6 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
157: ,attribute7 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
150: ,attribute_category OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
151: ,attribute1 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
152: ,attribute2 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
153: ,attribute3 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
154: ,attribute4 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
155: ,attribute5 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
156: ,attribute6 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
157: ,attribute7 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
158: ,attribute8 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
151: ,attribute1 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
152: ,attribute2 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
153: ,attribute3 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
154: ,attribute4 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
155: ,attribute5 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
156: ,attribute6 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
157: ,attribute7 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
158: ,attribute8 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
159: ,attribute9 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
152: ,attribute2 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
153: ,attribute3 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
154: ,attribute4 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
155: ,attribute5 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
156: ,attribute6 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
157: ,attribute7 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
158: ,attribute8 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
159: ,attribute9 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
160: ,attribute10 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
153: ,attribute3 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
154: ,attribute4 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
155: ,attribute5 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
156: ,attribute6 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
157: ,attribute7 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
158: ,attribute8 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
159: ,attribute9 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
160: ,attribute10 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
161: ,attribute11 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
154: ,attribute4 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
155: ,attribute5 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
156: ,attribute6 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
157: ,attribute7 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
158: ,attribute8 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
159: ,attribute9 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
160: ,attribute10 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
161: ,attribute11 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
162: ,attribute12 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
155: ,attribute5 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
156: ,attribute6 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
157: ,attribute7 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
158: ,attribute8 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
159: ,attribute9 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
160: ,attribute10 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
161: ,attribute11 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
162: ,attribute12 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
163: ,attribute13 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
156: ,attribute6 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
157: ,attribute7 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
158: ,attribute8 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
159: ,attribute9 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
160: ,attribute10 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
161: ,attribute11 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
162: ,attribute12 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
163: ,attribute13 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
164: ,attribute14 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
157: ,attribute7 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
158: ,attribute8 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
159: ,attribute9 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
160: ,attribute10 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
161: ,attribute11 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
162: ,attribute12 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
163: ,attribute13 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
164: ,attribute14 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
165: ,attribute15 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
158: ,attribute8 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
159: ,attribute9 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
160: ,attribute10 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
161: ,attribute11 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
162: ,attribute12 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
163: ,attribute13 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
164: ,attribute14 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
165: ,attribute15 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
166: ,created_by NUMBER := OKL_API.G_MISS_NUM
159: ,attribute9 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
160: ,attribute10 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
161: ,attribute11 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
162: ,attribute12 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
163: ,attribute13 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
164: ,attribute14 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
165: ,attribute15 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
166: ,created_by NUMBER := OKL_API.G_MISS_NUM
167: ,creation_date OKL_SYSTEM_PARAMS_ALL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
160: ,attribute10 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
161: ,attribute11 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
162: ,attribute12 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
163: ,attribute13 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
164: ,attribute14 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
165: ,attribute15 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
166: ,created_by NUMBER := OKL_API.G_MISS_NUM
167: ,creation_date OKL_SYSTEM_PARAMS_ALL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
168: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
161: ,attribute11 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
162: ,attribute12 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
163: ,attribute13 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
164: ,attribute14 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
165: ,attribute15 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
166: ,created_by NUMBER := OKL_API.G_MISS_NUM
167: ,creation_date OKL_SYSTEM_PARAMS_ALL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
168: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
169: ,last_update_date OKL_SYSTEM_PARAMS_ALL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
162: ,attribute12 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
163: ,attribute13 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
164: ,attribute14 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
165: ,attribute15 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
166: ,created_by NUMBER := OKL_API.G_MISS_NUM
167: ,creation_date OKL_SYSTEM_PARAMS_ALL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
168: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
169: ,last_update_date OKL_SYSTEM_PARAMS_ALL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
170: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
163: ,attribute13 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
164: ,attribute14 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
165: ,attribute15 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
166: ,created_by NUMBER := OKL_API.G_MISS_NUM
167: ,creation_date OKL_SYSTEM_PARAMS_ALL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
168: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
169: ,last_update_date OKL_SYSTEM_PARAMS_ALL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
170: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
171: --added by akrangan on 28/07/2006 since new columns were added to the table as part of moac changes
164: ,attribute14 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
165: ,attribute15 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
166: ,created_by NUMBER := OKL_API.G_MISS_NUM
167: ,creation_date OKL_SYSTEM_PARAMS_ALL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
168: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
169: ,last_update_date OKL_SYSTEM_PARAMS_ALL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
170: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
171: --added by akrangan on 28/07/2006 since new columns were added to the table as part of moac changes
172: ,item_inv_org_id NUMBER := OKL_API.G_MISS_NUM
165: ,attribute15 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
166: ,created_by NUMBER := OKL_API.G_MISS_NUM
167: ,creation_date OKL_SYSTEM_PARAMS_ALL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
168: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
169: ,last_update_date OKL_SYSTEM_PARAMS_ALL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
170: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
171: --added by akrangan on 28/07/2006 since new columns were added to the table as part of moac changes
172: ,item_inv_org_id NUMBER := OKL_API.G_MISS_NUM
173: ,rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
166: ,created_by NUMBER := OKL_API.G_MISS_NUM
167: ,creation_date OKL_SYSTEM_PARAMS_ALL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
168: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
169: ,last_update_date OKL_SYSTEM_PARAMS_ALL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
170: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
171: --added by akrangan on 28/07/2006 since new columns were added to the table as part of moac changes
172: ,item_inv_org_id NUMBER := OKL_API.G_MISS_NUM
173: ,rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
174: ,asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
168: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
169: ,last_update_date OKL_SYSTEM_PARAMS_ALL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
170: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
171: --added by akrangan on 28/07/2006 since new columns were added to the table as part of moac changes
172: ,item_inv_org_id NUMBER := OKL_API.G_MISS_NUM
173: ,rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
174: ,asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
175: ,ccard_remittance_id OKL_SYSTEM_PARAMS_ALL.CCARD_REMITTANCE_ID%TYPE := OKL_API.G_MISS_NUM
176: --Bug 7022258-Added new columns by kkorrapo
169: ,last_update_date OKL_SYSTEM_PARAMS_ALL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
170: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
171: --added by akrangan on 28/07/2006 since new columns were added to the table as part of moac changes
172: ,item_inv_org_id NUMBER := OKL_API.G_MISS_NUM
173: ,rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
174: ,asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
175: ,ccard_remittance_id OKL_SYSTEM_PARAMS_ALL.CCARD_REMITTANCE_ID%TYPE := OKL_API.G_MISS_NUM
176: --Bug 7022258-Added new columns by kkorrapo
177: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
170: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
171: --added by akrangan on 28/07/2006 since new columns were added to the table as part of moac changes
172: ,item_inv_org_id NUMBER := OKL_API.G_MISS_NUM
173: ,rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
174: ,asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
175: ,ccard_remittance_id OKL_SYSTEM_PARAMS_ALL.CCARD_REMITTANCE_ID%TYPE := OKL_API.G_MISS_NUM
176: --Bug 7022258-Added new columns by kkorrapo
177: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
178: ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
171: --added by akrangan on 28/07/2006 since new columns were added to the table as part of moac changes
172: ,item_inv_org_id NUMBER := OKL_API.G_MISS_NUM
173: ,rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
174: ,asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
175: ,ccard_remittance_id OKL_SYSTEM_PARAMS_ALL.CCARD_REMITTANCE_ID%TYPE := OKL_API.G_MISS_NUM
176: --Bug 7022258-Added new columns by kkorrapo
177: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
178: ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
179: ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.QCKQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
173: ,rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
174: ,asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
175: ,ccard_remittance_id OKL_SYSTEM_PARAMS_ALL.CCARD_REMITTANCE_ID%TYPE := OKL_API.G_MISS_NUM
176: --Bug 7022258-Added new columns by kkorrapo
177: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
178: ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
179: ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.QCKQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
180: ,lseqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
181: --Bug 7022258-Addition end
174: ,asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
175: ,ccard_remittance_id OKL_SYSTEM_PARAMS_ALL.CCARD_REMITTANCE_ID%TYPE := OKL_API.G_MISS_NUM
176: --Bug 7022258-Added new columns by kkorrapo
177: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
178: ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
179: ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.QCKQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
180: ,lseqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
181: --Bug 7022258-Addition end
182: );
175: ,ccard_remittance_id OKL_SYSTEM_PARAMS_ALL.CCARD_REMITTANCE_ID%TYPE := OKL_API.G_MISS_NUM
176: --Bug 7022258-Added new columns by kkorrapo
177: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
178: ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
179: ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.QCKQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
180: ,lseqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
181: --Bug 7022258-Addition end
182: );
183: G_MISS_syp_rec syp_rec_type;
176: --Bug 7022258-Added new columns by kkorrapo
177: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEAPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
178: ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEOPP_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
179: ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.QCKQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
180: ,lseqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR
181: --Bug 7022258-Addition end
182: );
183: G_MISS_syp_rec syp_rec_type;
184: TYPE syp_tbl_type IS TABLE OF syp_rec_type
185: INDEX BY BINARY_INTEGER;
186: ---------------------------------------------------------------------------
187: -- GLOBAL MESSAGE CONSTANTS
188: ---------------------------------------------------------------------------
189: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
190: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
191: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
192: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
193: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
186: ---------------------------------------------------------------------------
187: -- GLOBAL MESSAGE CONSTANTS
188: ---------------------------------------------------------------------------
189: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
190: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
191: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
192: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
193: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
194: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
187: -- GLOBAL MESSAGE CONSTANTS
188: ---------------------------------------------------------------------------
189: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
190: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
191: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
192: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
193: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
194: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
195: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
188: ---------------------------------------------------------------------------
189: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
190: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
191: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
192: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
193: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
194: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
195: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
196: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
189: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
190: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
191: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
192: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
193: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
194: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
195: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
196: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
197: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
190: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
191: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
192: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
193: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
194: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
195: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
196: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
197: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
198: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
191: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
192: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
193: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
194: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
195: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
196: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
197: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
198: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
199: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
192: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
193: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
194: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
195: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
196: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
197: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
198: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
199: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
200: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
193: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
194: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
195: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
196: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
197: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
198: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
199: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
200: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
201: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
194: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
195: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
196: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
197: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
198: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
199: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
200: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
201: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
202:
209: ---------------------------------------------------------------------------
210: -- GLOBAL VARIABLES
211: ---------------------------------------------------------------------------
212: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SYP_PVT';
213: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
214: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
215: ---------------------------------------------------------------------------
216: -- Procedures and Functions
217: ---------------------------------------------------------------------------
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
236: p_sypv_tbl IN sypv_tbl_type,
237: x_sypv_tbl OUT NOCOPY sypv_tbl_type,
238: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
239: PROCEDURE insert_row(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2,
242: x_return_status OUT NOCOPY VARCHAR2,
257: x_return_status OUT NOCOPY VARCHAR2,
258: x_msg_count OUT NOCOPY NUMBER,
259: x_msg_data OUT NOCOPY VARCHAR2,
260: p_sypv_tbl IN sypv_tbl_type,
261: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
262: PROCEDURE lock_row(
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2,
265: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
282: x_msg_data OUT NOCOPY VARCHAR2,
283: p_sypv_tbl IN sypv_tbl_type,
284: x_sypv_tbl OUT NOCOPY sypv_tbl_type,
285: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
286: PROCEDURE update_row(
287: p_api_version IN NUMBER,
288: p_init_msg_list IN VARCHAR2,
289: x_return_status OUT NOCOPY VARCHAR2,
304: x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,
307: p_sypv_tbl IN sypv_tbl_type,
308: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
309: PROCEDURE delete_row(
310: p_api_version IN NUMBER,
311: p_init_msg_list IN VARCHAR2,
312: x_return_status OUT NOCOPY VARCHAR2,
326: x_return_status OUT NOCOPY VARCHAR2,
327: x_msg_count OUT NOCOPY NUMBER,
328: x_msg_data OUT NOCOPY VARCHAR2,
329: p_sypv_tbl IN sypv_tbl_type,
330: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
331: PROCEDURE validate_row(
332: p_api_version IN NUMBER,
333: p_init_msg_list IN VARCHAR2,
334: x_return_status OUT NOCOPY VARCHAR2,