5: ---------------------------------------------------------------------------
6: -- OKL_ACCT_SOURCES_V Record Spec
7: TYPE asev_rec_type IS RECORD (
8: -- udhenuko Bug#5042061 - Modified - Start
9: -- id NUMBER := Okc_Api.G_MISS_NUM
10: id OKL_ACCT_SOURCES.ID%TYPE := Okc_Api.G_MISS_CHAR
11: -- udhenuko Bug#5042061 - Modified - End
12: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
13: ,source_id NUMBER := Okc_Api.G_MISS_NUM
6: -- OKL_ACCT_SOURCES_V Record Spec
7: TYPE asev_rec_type IS RECORD (
8: -- udhenuko Bug#5042061 - Modified - Start
9: -- id NUMBER := Okc_Api.G_MISS_NUM
10: id OKL_ACCT_SOURCES.ID%TYPE := Okc_Api.G_MISS_CHAR
11: -- udhenuko Bug#5042061 - Modified - End
12: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
13: ,source_id NUMBER := Okc_Api.G_MISS_NUM
14: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
8: -- udhenuko Bug#5042061 - Modified - Start
9: -- id NUMBER := Okc_Api.G_MISS_NUM
10: id OKL_ACCT_SOURCES.ID%TYPE := Okc_Api.G_MISS_CHAR
11: -- udhenuko Bug#5042061 - Modified - End
12: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
13: ,source_id NUMBER := Okc_Api.G_MISS_NUM
14: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
15: ,try_id NUMBER := Okc_Api.G_MISS_NUM
16: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
9: -- id NUMBER := Okc_Api.G_MISS_NUM
10: id OKL_ACCT_SOURCES.ID%TYPE := Okc_Api.G_MISS_CHAR
11: -- udhenuko Bug#5042061 - Modified - End
12: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
13: ,source_id NUMBER := Okc_Api.G_MISS_NUM
14: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
15: ,try_id NUMBER := Okc_Api.G_MISS_NUM
16: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
17: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
10: id OKL_ACCT_SOURCES.ID%TYPE := Okc_Api.G_MISS_CHAR
11: -- udhenuko Bug#5042061 - Modified - End
12: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
13: ,source_id NUMBER := Okc_Api.G_MISS_NUM
14: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
15: ,try_id NUMBER := Okc_Api.G_MISS_NUM
16: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
17: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
18: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
11: -- udhenuko Bug#5042061 - Modified - End
12: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
13: ,source_id NUMBER := Okc_Api.G_MISS_NUM
14: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
15: ,try_id NUMBER := Okc_Api.G_MISS_NUM
16: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
17: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
18: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
19: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
12: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
13: ,source_id NUMBER := Okc_Api.G_MISS_NUM
14: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
15: ,try_id NUMBER := Okc_Api.G_MISS_NUM
16: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
17: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
18: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
19: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
20: ,amount NUMBER := Okc_Api.G_MISS_NUM
13: ,source_id NUMBER := Okc_Api.G_MISS_NUM
14: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
15: ,try_id NUMBER := Okc_Api.G_MISS_NUM
16: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
17: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
18: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
19: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
20: ,amount NUMBER := Okc_Api.G_MISS_NUM
21: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
14: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
15: ,try_id NUMBER := Okc_Api.G_MISS_NUM
16: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
17: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
18: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
19: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
20: ,amount NUMBER := Okc_Api.G_MISS_NUM
21: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
22: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
15: ,try_id NUMBER := Okc_Api.G_MISS_NUM
16: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
17: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
18: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
19: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
20: ,amount NUMBER := Okc_Api.G_MISS_NUM
21: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
22: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
23: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
16: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
17: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
18: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
19: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
20: ,amount NUMBER := Okc_Api.G_MISS_NUM
21: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
22: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
23: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
24: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
17: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
18: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
19: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
20: ,amount NUMBER := Okc_Api.G_MISS_NUM
21: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
22: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
23: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
24: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
25: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
18: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
19: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
20: ,amount NUMBER := Okc_Api.G_MISS_NUM
21: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
22: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
23: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
24: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
25: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
26: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
19: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
20: ,amount NUMBER := Okc_Api.G_MISS_NUM
21: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
22: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
23: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
24: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
25: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
26: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
27: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
20: ,amount NUMBER := Okc_Api.G_MISS_NUM
21: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
22: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
23: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
24: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
25: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
26: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
27: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
28: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
21: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
22: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
23: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
24: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
25: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
26: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
27: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
28: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
29: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
22: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
23: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
24: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
25: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
26: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
27: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
28: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
29: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
30: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
23: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
24: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
25: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
26: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
27: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
28: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
29: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
30: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
31: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
24: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
25: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
26: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
27: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
28: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
29: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
30: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
31: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
32: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
25: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
26: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
27: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
28: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
29: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
30: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
31: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
32: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
33: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
26: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
27: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
28: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
29: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
30: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
31: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
32: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
33: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
34: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
27: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
28: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
29: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
30: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
31: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
32: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
33: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
34: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
35: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
28: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
29: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
30: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
31: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
32: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
33: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
34: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
35: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
36: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
29: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
30: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
31: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
32: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
33: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
34: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
35: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
36: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
37: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
30: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
31: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
32: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
33: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
34: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
35: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
36: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
37: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
38: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
31: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
32: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
33: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
34: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
35: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
36: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
37: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
38: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
39: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
32: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
33: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
34: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
35: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
36: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
37: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
38: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
39: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
40: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
33: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
34: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
35: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
36: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
37: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
38: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
39: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
40: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
41: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
34: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
35: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
36: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
37: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
38: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
39: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
40: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
41: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
42: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
35: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
36: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
37: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
38: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
39: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
40: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
41: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
42: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
43: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
36: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
37: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
38: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
39: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
40: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
41: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
42: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
43: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
44: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
37: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
38: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
39: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
40: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
41: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
42: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
43: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
44: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
45: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
38: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
39: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
40: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
41: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
42: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
43: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
44: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
45: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
46: ,org_id NUMBER := Okc_Api.G_MISS_NUM
39: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
40: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
41: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
42: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
43: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
44: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
45: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
46: ,org_id NUMBER := Okc_Api.G_MISS_NUM
47: ,program_id NUMBER := Okc_Api.G_MISS_NUM
40: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
41: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
42: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
43: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
44: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
45: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
46: ,org_id NUMBER := Okc_Api.G_MISS_NUM
47: ,program_id NUMBER := Okc_Api.G_MISS_NUM
48: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
41: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
42: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
43: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
44: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
45: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
46: ,org_id NUMBER := Okc_Api.G_MISS_NUM
47: ,program_id NUMBER := Okc_Api.G_MISS_NUM
48: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
49: ,request_id NUMBER := Okc_Api.G_MISS_NUM
42: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
43: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
44: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
45: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
46: ,org_id NUMBER := Okc_Api.G_MISS_NUM
47: ,program_id NUMBER := Okc_Api.G_MISS_NUM
48: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
49: ,request_id NUMBER := Okc_Api.G_MISS_NUM
50: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
43: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
44: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
45: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
46: ,org_id NUMBER := Okc_Api.G_MISS_NUM
47: ,program_id NUMBER := Okc_Api.G_MISS_NUM
48: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
49: ,request_id NUMBER := Okc_Api.G_MISS_NUM
50: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
51: ,created_by NUMBER := Okc_Api.G_MISS_NUM
44: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
45: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
46: ,org_id NUMBER := Okc_Api.G_MISS_NUM
47: ,program_id NUMBER := Okc_Api.G_MISS_NUM
48: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
49: ,request_id NUMBER := Okc_Api.G_MISS_NUM
50: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
51: ,created_by NUMBER := Okc_Api.G_MISS_NUM
52: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
45: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
46: ,org_id NUMBER := Okc_Api.G_MISS_NUM
47: ,program_id NUMBER := Okc_Api.G_MISS_NUM
48: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
49: ,request_id NUMBER := Okc_Api.G_MISS_NUM
50: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
51: ,created_by NUMBER := Okc_Api.G_MISS_NUM
52: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
53: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
46: ,org_id NUMBER := Okc_Api.G_MISS_NUM
47: ,program_id NUMBER := Okc_Api.G_MISS_NUM
48: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
49: ,request_id NUMBER := Okc_Api.G_MISS_NUM
50: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
51: ,created_by NUMBER := Okc_Api.G_MISS_NUM
52: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
53: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
54: ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
47: ,program_id NUMBER := Okc_Api.G_MISS_NUM
48: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
49: ,request_id NUMBER := Okc_Api.G_MISS_NUM
50: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
51: ,created_by NUMBER := Okc_Api.G_MISS_NUM
52: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
53: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
54: ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
55: ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
48: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
49: ,request_id NUMBER := Okc_Api.G_MISS_NUM
50: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
51: ,created_by NUMBER := Okc_Api.G_MISS_NUM
52: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
53: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
54: ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
55: ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
56: G_MISS_asev_rec asev_rec_type;
49: ,request_id NUMBER := Okc_Api.G_MISS_NUM
50: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
51: ,created_by NUMBER := Okc_Api.G_MISS_NUM
52: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
53: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
54: ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
55: ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
56: G_MISS_asev_rec asev_rec_type;
57: TYPE asev_tbl_type IS TABLE OF asev_rec_type
50: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
51: ,created_by NUMBER := Okc_Api.G_MISS_NUM
52: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
53: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
54: ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
55: ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
56: G_MISS_asev_rec asev_rec_type;
57: TYPE asev_tbl_type IS TABLE OF asev_rec_type
58: INDEX BY BINARY_INTEGER;
51: ,created_by NUMBER := Okc_Api.G_MISS_NUM
52: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
53: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
54: ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
55: ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
56: G_MISS_asev_rec asev_rec_type;
57: TYPE asev_tbl_type IS TABLE OF asev_rec_type
58: INDEX BY BINARY_INTEGER;
59: -- OKL_ACCT_SOURCES Record Spec
58: INDEX BY BINARY_INTEGER;
59: -- OKL_ACCT_SOURCES Record Spec
60: TYPE ase_rec_type IS RECORD (
61: -- udhenuko Bug#5042061 - Modified - Start
62: -- id NUMBER := Okc_Api.G_MISS_NUM
63: id OKL_ACCT_SOURCES.ID%TYPE := Okc_Api.G_MISS_CHAR
64: -- udhenuko Bug#5042061 - Modified - Start
65: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
66: ,source_id NUMBER := Okc_Api.G_MISS_NUM
59: -- OKL_ACCT_SOURCES Record Spec
60: TYPE ase_rec_type IS RECORD (
61: -- udhenuko Bug#5042061 - Modified - Start
62: -- id NUMBER := Okc_Api.G_MISS_NUM
63: id OKL_ACCT_SOURCES.ID%TYPE := Okc_Api.G_MISS_CHAR
64: -- udhenuko Bug#5042061 - Modified - Start
65: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
66: ,source_id NUMBER := Okc_Api.G_MISS_NUM
67: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
61: -- udhenuko Bug#5042061 - Modified - Start
62: -- id NUMBER := Okc_Api.G_MISS_NUM
63: id OKL_ACCT_SOURCES.ID%TYPE := Okc_Api.G_MISS_CHAR
64: -- udhenuko Bug#5042061 - Modified - Start
65: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
66: ,source_id NUMBER := Okc_Api.G_MISS_NUM
67: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
68: ,try_id NUMBER := Okc_Api.G_MISS_NUM
69: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
62: -- id NUMBER := Okc_Api.G_MISS_NUM
63: id OKL_ACCT_SOURCES.ID%TYPE := Okc_Api.G_MISS_CHAR
64: -- udhenuko Bug#5042061 - Modified - Start
65: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
66: ,source_id NUMBER := Okc_Api.G_MISS_NUM
67: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
68: ,try_id NUMBER := Okc_Api.G_MISS_NUM
69: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
70: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
63: id OKL_ACCT_SOURCES.ID%TYPE := Okc_Api.G_MISS_CHAR
64: -- udhenuko Bug#5042061 - Modified - Start
65: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
66: ,source_id NUMBER := Okc_Api.G_MISS_NUM
67: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
68: ,try_id NUMBER := Okc_Api.G_MISS_NUM
69: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
70: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
71: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
64: -- udhenuko Bug#5042061 - Modified - Start
65: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
66: ,source_id NUMBER := Okc_Api.G_MISS_NUM
67: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
68: ,try_id NUMBER := Okc_Api.G_MISS_NUM
69: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
70: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
71: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
72: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
65: ,source_table OKL_ACCT_SOURCES.SOURCE_TABLE%TYPE := Okc_Api.G_MISS_CHAR
66: ,source_id NUMBER := Okc_Api.G_MISS_NUM
67: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
68: ,try_id NUMBER := Okc_Api.G_MISS_NUM
69: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
70: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
71: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
72: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
73: ,amount NUMBER := Okc_Api.G_MISS_NUM
66: ,source_id NUMBER := Okc_Api.G_MISS_NUM
67: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
68: ,try_id NUMBER := Okc_Api.G_MISS_NUM
69: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
70: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
71: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
72: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
73: ,amount NUMBER := Okc_Api.G_MISS_NUM
74: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
67: ,pdt_id NUMBER := Okc_Api.G_MISS_NUM
68: ,try_id NUMBER := Okc_Api.G_MISS_NUM
69: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
70: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
71: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
72: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
73: ,amount NUMBER := Okc_Api.G_MISS_NUM
74: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
75: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
68: ,try_id NUMBER := Okc_Api.G_MISS_NUM
69: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
70: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
71: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
72: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
73: ,amount NUMBER := Okc_Api.G_MISS_NUM
74: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
75: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
76: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
69: ,sty_id NUMBER := Okc_Api.G_MISS_NUM
70: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
71: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
72: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
73: ,amount NUMBER := Okc_Api.G_MISS_NUM
74: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
75: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
76: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
77: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
70: ,memo_yn OKL_ACCT_SOURCES.MEMO_YN%TYPE := Okc_Api.G_MISS_CHAR
71: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
72: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
73: ,amount NUMBER := Okc_Api.G_MISS_NUM
74: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
75: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
76: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
77: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
78: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
71: ,factor_investor_flag OKL_ACCT_SOURCES.FACTOR_INVESTOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
72: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
73: ,amount NUMBER := Okc_Api.G_MISS_NUM
74: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
75: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
76: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
77: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
78: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
79: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
72: ,factor_investor_code OKL_ACCT_SOURCES.FACTOR_INVESTOR_CODE%TYPE := Okc_Api.G_MISS_CHAR
73: ,amount NUMBER := Okc_Api.G_MISS_NUM
74: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
75: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
76: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
77: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
78: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
79: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
80: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
73: ,amount NUMBER := Okc_Api.G_MISS_NUM
74: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
75: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
76: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
77: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
78: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
79: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
80: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
81: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
74: ,formula_used OKL_ACCT_SOURCES.FORMULA_USED%TYPE := Okc_Api.G_MISS_CHAR
75: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
76: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
77: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
78: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
79: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
80: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
81: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
82: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
75: ,entered_date OKL_ACCT_SOURCES.ENTERED_DATE%TYPE := Okc_Api.G_MISS_DATE
76: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
77: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
78: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
79: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
80: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
81: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
82: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
83: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
76: ,accounting_date OKL_ACCT_SOURCES.ACCOUNTING_DATE%TYPE := Okc_Api.G_MISS_DATE
77: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
78: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
79: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
80: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
81: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
82: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
83: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
84: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
77: ,gl_reversal_flag OKL_ACCT_SOURCES.GL_REVERSAL_FLAG%TYPE := Okc_Api.G_MISS_CHAR
78: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
79: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
80: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
81: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
82: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
83: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
84: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
85: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
78: ,post_to_gl OKL_ACCT_SOURCES.POST_TO_GL%TYPE := Okc_Api.G_MISS_CHAR
79: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
80: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
81: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
82: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
83: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
84: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
85: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
86: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
79: ,currency_code OKL_ACCT_SOURCES.CURRENCY_CODE%TYPE := Okc_Api.G_MISS_CHAR
80: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
81: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
82: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
83: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
84: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
85: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
86: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
87: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
80: ,currency_conversion_type OKL_ACCT_SOURCES.CURRENCY_CONVERSION_TYPE%TYPE := Okc_Api.G_MISS_CHAR
81: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
82: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
83: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
84: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
85: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
86: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
87: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
88: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
81: ,currency_conversion_date OKL_ACCT_SOURCES.CURRENCY_CONVERSION_DATE%TYPE := Okc_Api.G_MISS_DATE
82: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
83: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
84: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
85: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
86: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
87: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
88: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
89: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
82: ,currency_conversion_rate NUMBER := Okc_Api.G_MISS_NUM
83: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
84: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
85: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
86: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
87: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
88: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
89: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
90: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
83: ,khr_id NUMBER := Okc_Api.G_MISS_NUM
84: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
85: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
86: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
87: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
88: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
89: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
90: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
91: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
84: ,kle_id NUMBER := Okc_Api.G_MISS_NUM
85: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
86: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
87: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
88: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
89: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
90: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
91: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
92: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
85: ,pay_vendor_sites_pk OKL_ACCT_SOURCES.PAY_VENDOR_SITES_PK%TYPE := Okc_Api.G_MISS_CHAR
86: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
87: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
88: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
89: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
90: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
91: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
92: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
93: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
86: ,rec_site_uses_pk OKL_ACCT_SOURCES.REC_SITE_USES_PK%TYPE := Okc_Api.G_MISS_CHAR
87: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
88: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
89: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
90: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
91: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
92: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
93: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
94: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
87: ,asset_category_id_pk1 OKL_ACCT_SOURCES.ASSET_CATEGORY_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
88: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
89: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
90: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
91: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
92: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
93: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
94: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
95: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
88: ,asset_book_pk2 OKL_ACCT_SOURCES.ASSET_BOOK_PK2%TYPE := Okc_Api.G_MISS_CHAR
89: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
90: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
91: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
92: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
93: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
94: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
95: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
96: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
89: ,pay_financial_options_pk OKL_ACCT_SOURCES.PAY_FINANCIAL_OPTIONS_PK%TYPE := Okc_Api.G_MISS_CHAR
90: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
91: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
92: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
93: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
94: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
95: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
96: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
97: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
90: ,jtf_sales_reps_pk OKL_ACCT_SOURCES.JTF_SALES_REPS_PK%TYPE := Okc_Api.G_MISS_CHAR
91: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
92: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
93: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
94: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
95: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
96: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
97: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
98: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
91: ,inventory_item_id_pk1 OKL_ACCT_SOURCES.INVENTORY_ITEM_ID_PK1%TYPE := Okc_Api.G_MISS_CHAR
92: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
93: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
94: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
95: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
96: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
97: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
98: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
99: ,org_id NUMBER := Okc_Api.G_MISS_NUM
92: ,inventory_org_id_pk2 OKL_ACCT_SOURCES.INVENTORY_ORG_ID_PK2%TYPE := Okc_Api.G_MISS_CHAR
93: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
94: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
95: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
96: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
97: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
98: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
99: ,org_id NUMBER := Okc_Api.G_MISS_NUM
100: ,program_id NUMBER := Okc_Api.G_MISS_NUM
93: ,rec_trx_types_pk OKL_ACCT_SOURCES.REC_TRX_TYPES_PK%TYPE := Okc_Api.G_MISS_CHAR
94: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
95: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
96: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
97: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
98: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
99: ,org_id NUMBER := Okc_Api.G_MISS_NUM
100: ,program_id NUMBER := Okc_Api.G_MISS_NUM
101: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
94: ,avl_id NUMBER := Okc_Api.G_MISS_NUM
95: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
96: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
97: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
98: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
99: ,org_id NUMBER := Okc_Api.G_MISS_NUM
100: ,program_id NUMBER := Okc_Api.G_MISS_NUM
101: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
102: ,request_id NUMBER := Okc_Api.G_MISS_NUM
95: ,local_product_yn OKL_ACCT_SOURCES.LOCAL_PRODUCT_YN%TYPE := Okc_Api.G_MISS_CHAR
96: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
97: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
98: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
99: ,org_id NUMBER := Okc_Api.G_MISS_NUM
100: ,program_id NUMBER := Okc_Api.G_MISS_NUM
101: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
102: ,request_id NUMBER := Okc_Api.G_MISS_NUM
103: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
96: ,internal_status OKL_ACCT_SOURCES.INTERNAL_STATUS%TYPE := Okc_Api.G_MISS_CHAR
97: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
98: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
99: ,org_id NUMBER := Okc_Api.G_MISS_NUM
100: ,program_id NUMBER := Okc_Api.G_MISS_NUM
101: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
102: ,request_id NUMBER := Okc_Api.G_MISS_NUM
103: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
104: ,created_by NUMBER := Okc_Api.G_MISS_NUM
97: ,custom_status OKL_ACCT_SOURCES.CUSTOM_STATUS%TYPE := Okc_Api.G_MISS_CHAR
98: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
99: ,org_id NUMBER := Okc_Api.G_MISS_NUM
100: ,program_id NUMBER := Okc_Api.G_MISS_NUM
101: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
102: ,request_id NUMBER := Okc_Api.G_MISS_NUM
103: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
104: ,created_by NUMBER := Okc_Api.G_MISS_NUM
105: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
98: ,source_indicator_flag OKL_ACCT_SOURCES.SOURCE_INDICATOR_FLAG%TYPE := Okc_Api.G_MISS_CHAR
99: ,org_id NUMBER := Okc_Api.G_MISS_NUM
100: ,program_id NUMBER := Okc_Api.G_MISS_NUM
101: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
102: ,request_id NUMBER := Okc_Api.G_MISS_NUM
103: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
104: ,created_by NUMBER := Okc_Api.G_MISS_NUM
105: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
106: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
99: ,org_id NUMBER := Okc_Api.G_MISS_NUM
100: ,program_id NUMBER := Okc_Api.G_MISS_NUM
101: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
102: ,request_id NUMBER := Okc_Api.G_MISS_NUM
103: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
104: ,created_by NUMBER := Okc_Api.G_MISS_NUM
105: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
106: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
107: ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
100: ,program_id NUMBER := Okc_Api.G_MISS_NUM
101: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
102: ,request_id NUMBER := Okc_Api.G_MISS_NUM
103: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
104: ,created_by NUMBER := Okc_Api.G_MISS_NUM
105: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
106: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
107: ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
108: ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
101: ,program_application_id NUMBER := Okc_Api.G_MISS_NUM
102: ,request_id NUMBER := Okc_Api.G_MISS_NUM
103: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
104: ,created_by NUMBER := Okc_Api.G_MISS_NUM
105: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
106: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
107: ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
108: ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
109: G_MISS_ase_rec ase_rec_type;
102: ,request_id NUMBER := Okc_Api.G_MISS_NUM
103: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
104: ,created_by NUMBER := Okc_Api.G_MISS_NUM
105: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
106: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
107: ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
108: ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
109: G_MISS_ase_rec ase_rec_type;
110: TYPE ase_tbl_type IS TABLE OF ase_rec_type
103: ,program_update_date OKL_ACCT_SOURCES.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
104: ,created_by NUMBER := Okc_Api.G_MISS_NUM
105: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
106: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
107: ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
108: ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
109: G_MISS_ase_rec ase_rec_type;
110: TYPE ase_tbl_type IS TABLE OF ase_rec_type
111: INDEX BY BINARY_INTEGER;
104: ,created_by NUMBER := Okc_Api.G_MISS_NUM
105: ,creation_date OKL_ACCT_SOURCES.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE
106: ,last_updated_by NUMBER := Okc_Api.G_MISS_NUM
107: ,last_update_date OKL_ACCT_SOURCES.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE
108: ,last_update_login NUMBER := Okc_Api.G_MISS_NUM);
109: G_MISS_ase_rec ase_rec_type;
110: TYPE ase_tbl_type IS TABLE OF ase_rec_type
111: INDEX BY BINARY_INTEGER;
112: ---------------------------------------------------------------------------
111: INDEX BY BINARY_INTEGER;
112: ---------------------------------------------------------------------------
113: -- GLOBAL MESSAGE CONSTANTS
114: ---------------------------------------------------------------------------
115: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
112: ---------------------------------------------------------------------------
113: -- GLOBAL MESSAGE CONSTANTS
114: ---------------------------------------------------------------------------
115: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
113: -- GLOBAL MESSAGE CONSTANTS
114: ---------------------------------------------------------------------------
115: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
114: ---------------------------------------------------------------------------
115: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
115: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
116: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
117: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
125: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
118: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
125: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
126: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
119: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
125: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
126: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
127: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
120: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
121: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
122: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
123: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
124: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
125: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
126: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
127: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
128: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
134: ---------------------------------------------------------------------------
135: -- GLOBAL VARIABLES
136: ---------------------------------------------------------------------------
137: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ASE_PVT';
138: G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
139: ---------------------------------------------------------------------------
140: -- Procedures and Functions
141: ---------------------------------------------------------------------------
142: