eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SYP_PVT dependencies on OKL_SYSTEM_PARAMS_ALL

Line 6: -- OKL_SYSTEM_PARAMS_ALL_V Record Spec

2: /* $Header: OKLSSYPS.pls 120.21.12010000.3 2008/11/13 13:59:58 kkorrapo ship $ */
3: ---------------------------------------------------------------------------
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

Line 98: -- OKL_SYSTEM_PARAMS_ALL Record Spec

94: );
95: G_Miss_sypv_rec 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

Line 101: ,delink_yn OKL_SYSTEM_PARAMS_ALL.DELINK_YN%TYPE := OKL_API.G_MISS_CHAR

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

Line 103: ,REMK_SUBINVENTORY OKL_SYSTEM_PARAMS_ALL.REMK_SUBINVENTORY%TYPE := OKL_API.G_MISS_CHAR

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

Line 104: ,REMK_ORGANIZATION_ID OKL_SYSTEM_PARAMS_ALL.REMK_ORGANIZATION_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

Line 105: ,REMK_PRICE_LIST_ID OKL_SYSTEM_PARAMS_ALL.REMK_PRICE_LIST_ID%TYPE := 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
109: -- SECHAWLA 28-SEP-04 3924244: Added the following new columns : end

Line 106: ,REMK_PROCESS_CODE OKL_SYSTEM_PARAMS_ALL.REMK_PROCESS_CODE%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
110: -- PAGARG 24-JAN-05 4044659: Added the new column LEASE_INV_ORG_YN: begin

Line 107: ,REMK_ITEM_TEMPLATE_ID OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_TEMPLATE_ID%TYPE := OKL_API.G_MISS_NUM

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

Line 108: ,REMK_ITEM_INVOICED_CODE OKL_SYSTEM_PARAMS_ALL.REMK_ITEM_INVOICED_CODE%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

Line 120: ,CATEGORY_SET_ID OKL_SYSTEM_PARAMS_ALL.CATEGORY_SET_ID%TYPE := OKL_API.G_MISS_NUM

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 :

Line 125: ,CANCEL_QUOTES_YN OKL_SYSTEM_PARAMS_ALL.CANCEL_QUOTES_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4556370

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

Line 126: ,CHK_ACCRUAL_PREVIOUS_MNTH_YN OKL_SYSTEM_PARAMS_ALL.CHK_ACCRUAL_PREVIOUS_MNTH_YN%TYPE := OKL_API.G_MISS_CHAR --RMUNJULU 4769094

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

Line 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

Line 135: ,TAX_BOOK_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type := OKL_API.G_MISS_CHAR

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

Line 136: ,TAX_BOOK_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type := OKL_API.G_MISS_CHAR

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

Line 137: ,DEPRECIATE_YN OKL_SYSTEM_PARAMS_ALL.DEPRECIATE_YN%type := OKL_API.G_MISS_CHAR

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

Line 138: ,FA_LOCATION_ID OKL_SYSTEM_PARAMS_ALL.FA_LOCATION_ID%type := OKL_API.G_MISS_NUM

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

Line 139: ,FORMULA_ID OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type := OKL_API.G_MISS_NUM

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

Line 140: ,ASSET_KEY_ID OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type := OKL_API.G_MISS_NUM

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

Line 149: ,program_update_date OKL_SYSTEM_PARAMS_ALL.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 150: ,attribute_category OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE_CATEGORY%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

Line 151: ,attribute1 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE1%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

Line 152: ,attribute2 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE2%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

Line 153: ,attribute3 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE3%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

Line 154: ,attribute4 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE4%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

Line 155: ,attribute5 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE5%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

Line 156: ,attribute6 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE6%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

Line 157: ,attribute7 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE7%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

Line 158: ,attribute8 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE8%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

Line 159: ,attribute9 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE9%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

Line 160: ,attribute10 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE10%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

Line 161: ,attribute11 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE11%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

Line 162: ,attribute12 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE12%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

Line 163: ,attribute13 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE13%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
167: ,creation_date OKL_SYSTEM_PARAMS_ALL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 164: ,attribute14 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE14%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
168: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 165: ,attribute15 OKL_SYSTEM_PARAMS_ALL.ATTRIBUTE15%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
169: ,last_update_date OKL_SYSTEM_PARAMS_ALL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 167: ,creation_date OKL_SYSTEM_PARAMS_ALL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 169: ,last_update_date OKL_SYSTEM_PARAMS_ALL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 173: ,rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR

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

Line 174: ,asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%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

Line 175: ,ccard_remittance_id OKL_SYSTEM_PARAMS_ALL.CCARD_REMITTANCE_ID%TYPE := 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
179: ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.QCKQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR

Line 177: ,lseapp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEAPP_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

Line 178: ,lseopp_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEOPP_SEQ_PREFIX_TXT%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
182: );

Line 179: ,qckqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.QCKQTE_SEQ_PREFIX_TXT%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: );
183: G_MISS_syp_rec syp_rec_type;

Line 180: ,lseqte_seq_prefix_txt OKL_SYSTEM_PARAMS_ALL.LSEQTE_SEQ_PREFIX_TXT%TYPE := OKL_API.G_MISS_CHAR

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