3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE tld_rec_type IS RECORD (
7: id NUMBER := Okl_api.G_MISS_NUM,
8: bch_id NUMBER := Okl_api.G_MISS_NUM,
9: bcl_id NUMBER := Okl_api.G_MISS_NUM,
10: bsl_id NUMBER := Okl_api.G_MISS_NUM,
11: bgh_id NUMBER := Okl_api.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE tld_rec_type IS RECORD (
7: id NUMBER := Okl_api.G_MISS_NUM,
8: bch_id NUMBER := Okl_api.G_MISS_NUM,
9: bcl_id NUMBER := Okl_api.G_MISS_NUM,
10: bsl_id NUMBER := Okl_api.G_MISS_NUM,
11: bgh_id NUMBER := Okl_api.G_MISS_NUM,
12: idx_id NUMBER := Okl_api.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE tld_rec_type IS RECORD (
7: id NUMBER := Okl_api.G_MISS_NUM,
8: bch_id NUMBER := Okl_api.G_MISS_NUM,
9: bcl_id NUMBER := Okl_api.G_MISS_NUM,
10: bsl_id NUMBER := Okl_api.G_MISS_NUM,
11: bgh_id NUMBER := Okl_api.G_MISS_NUM,
12: idx_id NUMBER := Okl_api.G_MISS_NUM,
13: sel_id NUMBER := Okl_api.G_MISS_NUM,
6: TYPE tld_rec_type IS RECORD (
7: id NUMBER := Okl_api.G_MISS_NUM,
8: bch_id NUMBER := Okl_api.G_MISS_NUM,
9: bcl_id NUMBER := Okl_api.G_MISS_NUM,
10: bsl_id NUMBER := Okl_api.G_MISS_NUM,
11: bgh_id NUMBER := Okl_api.G_MISS_NUM,
12: idx_id NUMBER := Okl_api.G_MISS_NUM,
13: sel_id NUMBER := Okl_api.G_MISS_NUM,
14: sty_id NUMBER := Okl_api.G_MISS_NUM,
7: id NUMBER := Okl_api.G_MISS_NUM,
8: bch_id NUMBER := Okl_api.G_MISS_NUM,
9: bcl_id NUMBER := Okl_api.G_MISS_NUM,
10: bsl_id NUMBER := Okl_api.G_MISS_NUM,
11: bgh_id NUMBER := Okl_api.G_MISS_NUM,
12: idx_id NUMBER := Okl_api.G_MISS_NUM,
13: sel_id NUMBER := Okl_api.G_MISS_NUM,
14: sty_id NUMBER := Okl_api.G_MISS_NUM,
15: til_id_details NUMBER := Okl_api.G_MISS_NUM,
8: bch_id NUMBER := Okl_api.G_MISS_NUM,
9: bcl_id NUMBER := Okl_api.G_MISS_NUM,
10: bsl_id NUMBER := Okl_api.G_MISS_NUM,
11: bgh_id NUMBER := Okl_api.G_MISS_NUM,
12: idx_id NUMBER := Okl_api.G_MISS_NUM,
13: sel_id NUMBER := Okl_api.G_MISS_NUM,
14: sty_id NUMBER := Okl_api.G_MISS_NUM,
15: til_id_details NUMBER := Okl_api.G_MISS_NUM,
16: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
9: bcl_id NUMBER := Okl_api.G_MISS_NUM,
10: bsl_id NUMBER := Okl_api.G_MISS_NUM,
11: bgh_id NUMBER := Okl_api.G_MISS_NUM,
12: idx_id NUMBER := Okl_api.G_MISS_NUM,
13: sel_id NUMBER := Okl_api.G_MISS_NUM,
14: sty_id NUMBER := Okl_api.G_MISS_NUM,
15: til_id_details NUMBER := Okl_api.G_MISS_NUM,
16: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
17: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
10: bsl_id NUMBER := Okl_api.G_MISS_NUM,
11: bgh_id NUMBER := Okl_api.G_MISS_NUM,
12: idx_id NUMBER := Okl_api.G_MISS_NUM,
13: sel_id NUMBER := Okl_api.G_MISS_NUM,
14: sty_id NUMBER := Okl_api.G_MISS_NUM,
15: til_id_details NUMBER := Okl_api.G_MISS_NUM,
16: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
17: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
18: object_version_number NUMBER := Okl_api.G_MISS_NUM,
11: bgh_id NUMBER := Okl_api.G_MISS_NUM,
12: idx_id NUMBER := Okl_api.G_MISS_NUM,
13: sel_id NUMBER := Okl_api.G_MISS_NUM,
14: sty_id NUMBER := Okl_api.G_MISS_NUM,
15: til_id_details NUMBER := Okl_api.G_MISS_NUM,
16: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
17: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
18: object_version_number NUMBER := Okl_api.G_MISS_NUM,
19: late_charge_yn OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
12: idx_id NUMBER := Okl_api.G_MISS_NUM,
13: sel_id NUMBER := Okl_api.G_MISS_NUM,
14: sty_id NUMBER := Okl_api.G_MISS_NUM,
15: til_id_details NUMBER := Okl_api.G_MISS_NUM,
16: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
17: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
18: object_version_number NUMBER := Okl_api.G_MISS_NUM,
19: late_charge_yn OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
20: date_calculation OKL_TXD_AR_LN_DTLS_B.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
13: sel_id NUMBER := Okl_api.G_MISS_NUM,
14: sty_id NUMBER := Okl_api.G_MISS_NUM,
15: til_id_details NUMBER := Okl_api.G_MISS_NUM,
16: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
17: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
18: object_version_number NUMBER := Okl_api.G_MISS_NUM,
19: late_charge_yn OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
20: date_calculation OKL_TXD_AR_LN_DTLS_B.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
21: fixed_rate_yn OKL_TXD_AR_LN_DTLS_B.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
14: sty_id NUMBER := Okl_api.G_MISS_NUM,
15: til_id_details NUMBER := Okl_api.G_MISS_NUM,
16: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
17: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
18: object_version_number NUMBER := Okl_api.G_MISS_NUM,
19: late_charge_yn OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
20: date_calculation OKL_TXD_AR_LN_DTLS_B.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
21: fixed_rate_yn OKL_TXD_AR_LN_DTLS_B.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
22: amount NUMBER := Okl_api.G_MISS_NUM,
15: til_id_details NUMBER := Okl_api.G_MISS_NUM,
16: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
17: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
18: object_version_number NUMBER := Okl_api.G_MISS_NUM,
19: late_charge_yn OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
20: date_calculation OKL_TXD_AR_LN_DTLS_B.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
21: fixed_rate_yn OKL_TXD_AR_LN_DTLS_B.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
22: amount NUMBER := Okl_api.G_MISS_NUM,
23: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
16: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
17: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
18: object_version_number NUMBER := Okl_api.G_MISS_NUM,
19: late_charge_yn OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
20: date_calculation OKL_TXD_AR_LN_DTLS_B.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
21: fixed_rate_yn OKL_TXD_AR_LN_DTLS_B.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
22: amount NUMBER := Okl_api.G_MISS_NUM,
23: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
24: amount_applied NUMBER := Okl_api.G_MISS_NUM,
17: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
18: object_version_number NUMBER := Okl_api.G_MISS_NUM,
19: late_charge_yn OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
20: date_calculation OKL_TXD_AR_LN_DTLS_B.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
21: fixed_rate_yn OKL_TXD_AR_LN_DTLS_B.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
22: amount NUMBER := Okl_api.G_MISS_NUM,
23: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
24: amount_applied NUMBER := Okl_api.G_MISS_NUM,
25: request_id NUMBER := Okl_api.G_MISS_NUM,
18: object_version_number NUMBER := Okl_api.G_MISS_NUM,
19: late_charge_yn OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
20: date_calculation OKL_TXD_AR_LN_DTLS_B.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
21: fixed_rate_yn OKL_TXD_AR_LN_DTLS_B.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
22: amount NUMBER := Okl_api.G_MISS_NUM,
23: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
24: amount_applied NUMBER := Okl_api.G_MISS_NUM,
25: request_id NUMBER := Okl_api.G_MISS_NUM,
26: program_application_id NUMBER := Okl_api.G_MISS_NUM,
19: late_charge_yn OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
20: date_calculation OKL_TXD_AR_LN_DTLS_B.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
21: fixed_rate_yn OKL_TXD_AR_LN_DTLS_B.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
22: amount NUMBER := Okl_api.G_MISS_NUM,
23: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
24: amount_applied NUMBER := Okl_api.G_MISS_NUM,
25: request_id NUMBER := Okl_api.G_MISS_NUM,
26: program_application_id NUMBER := Okl_api.G_MISS_NUM,
27: program_id NUMBER := Okl_api.G_MISS_NUM,
20: date_calculation OKL_TXD_AR_LN_DTLS_B.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
21: fixed_rate_yn OKL_TXD_AR_LN_DTLS_B.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
22: amount NUMBER := Okl_api.G_MISS_NUM,
23: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
24: amount_applied NUMBER := Okl_api.G_MISS_NUM,
25: request_id NUMBER := Okl_api.G_MISS_NUM,
26: program_application_id NUMBER := Okl_api.G_MISS_NUM,
27: program_id NUMBER := Okl_api.G_MISS_NUM,
28: program_update_date OKL_TXD_AR_LN_DTLS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
21: fixed_rate_yn OKL_TXD_AR_LN_DTLS_B.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
22: amount NUMBER := Okl_api.G_MISS_NUM,
23: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
24: amount_applied NUMBER := Okl_api.G_MISS_NUM,
25: request_id NUMBER := Okl_api.G_MISS_NUM,
26: program_application_id NUMBER := Okl_api.G_MISS_NUM,
27: program_id NUMBER := Okl_api.G_MISS_NUM,
28: program_update_date OKL_TXD_AR_LN_DTLS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
29: org_id NUMBER := Okl_api.G_MISS_NUM,
22: amount NUMBER := Okl_api.G_MISS_NUM,
23: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
24: amount_applied NUMBER := Okl_api.G_MISS_NUM,
25: request_id NUMBER := Okl_api.G_MISS_NUM,
26: program_application_id NUMBER := Okl_api.G_MISS_NUM,
27: program_id NUMBER := Okl_api.G_MISS_NUM,
28: program_update_date OKL_TXD_AR_LN_DTLS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
29: org_id NUMBER := Okl_api.G_MISS_NUM,
30: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
23: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
24: amount_applied NUMBER := Okl_api.G_MISS_NUM,
25: request_id NUMBER := Okl_api.G_MISS_NUM,
26: program_application_id NUMBER := Okl_api.G_MISS_NUM,
27: program_id NUMBER := Okl_api.G_MISS_NUM,
28: program_update_date OKL_TXD_AR_LN_DTLS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
29: org_id NUMBER := Okl_api.G_MISS_NUM,
30: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
31: -- Start changes on remarketing by fmiao on 10/18/04 --
24: amount_applied NUMBER := Okl_api.G_MISS_NUM,
25: request_id NUMBER := Okl_api.G_MISS_NUM,
26: program_application_id NUMBER := Okl_api.G_MISS_NUM,
27: program_id NUMBER := Okl_api.G_MISS_NUM,
28: program_update_date OKL_TXD_AR_LN_DTLS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
29: org_id NUMBER := Okl_api.G_MISS_NUM,
30: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
31: -- Start changes on remarketing by fmiao on 10/18/04 --
32: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
25: request_id NUMBER := Okl_api.G_MISS_NUM,
26: program_application_id NUMBER := Okl_api.G_MISS_NUM,
27: program_id NUMBER := Okl_api.G_MISS_NUM,
28: program_update_date OKL_TXD_AR_LN_DTLS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
29: org_id NUMBER := Okl_api.G_MISS_NUM,
30: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
31: -- Start changes on remarketing by fmiao on 10/18/04 --
32: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
33: -- End changes on remarketing by fmiao on 10/18/04 --
26: program_application_id NUMBER := Okl_api.G_MISS_NUM,
27: program_id NUMBER := Okl_api.G_MISS_NUM,
28: program_update_date OKL_TXD_AR_LN_DTLS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
29: org_id NUMBER := Okl_api.G_MISS_NUM,
30: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
31: -- Start changes on remarketing by fmiao on 10/18/04 --
32: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
33: -- End changes on remarketing by fmiao on 10/18/04 --
34: attribute_category OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
28: program_update_date OKL_TXD_AR_LN_DTLS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
29: org_id NUMBER := Okl_api.G_MISS_NUM,
30: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
31: -- Start changes on remarketing by fmiao on 10/18/04 --
32: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
33: -- End changes on remarketing by fmiao on 10/18/04 --
34: attribute_category OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
35: attribute1 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
36: attribute2 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
30: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
31: -- Start changes on remarketing by fmiao on 10/18/04 --
32: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
33: -- End changes on remarketing by fmiao on 10/18/04 --
34: attribute_category OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
35: attribute1 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
36: attribute2 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
37: attribute3 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
38: attribute4 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
31: -- Start changes on remarketing by fmiao on 10/18/04 --
32: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
33: -- End changes on remarketing by fmiao on 10/18/04 --
34: attribute_category OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
35: attribute1 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
36: attribute2 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
37: attribute3 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
38: attribute4 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
39: attribute5 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
32: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
33: -- End changes on remarketing by fmiao on 10/18/04 --
34: attribute_category OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
35: attribute1 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
36: attribute2 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
37: attribute3 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
38: attribute4 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
39: attribute5 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
40: attribute6 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
33: -- End changes on remarketing by fmiao on 10/18/04 --
34: attribute_category OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
35: attribute1 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
36: attribute2 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
37: attribute3 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
38: attribute4 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
39: attribute5 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
40: attribute6 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
41: attribute7 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
34: attribute_category OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
35: attribute1 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
36: attribute2 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
37: attribute3 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
38: attribute4 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
39: attribute5 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
40: attribute6 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
41: attribute7 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
42: attribute8 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
35: attribute1 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
36: attribute2 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
37: attribute3 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
38: attribute4 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
39: attribute5 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
40: attribute6 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
41: attribute7 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
42: attribute8 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
43: attribute9 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
36: attribute2 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
37: attribute3 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
38: attribute4 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
39: attribute5 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
40: attribute6 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
41: attribute7 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
42: attribute8 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
43: attribute9 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
44: attribute10 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
37: attribute3 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
38: attribute4 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
39: attribute5 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
40: attribute6 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
41: attribute7 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
42: attribute8 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
43: attribute9 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
44: attribute10 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
45: attribute11 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
38: attribute4 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
39: attribute5 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
40: attribute6 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
41: attribute7 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
42: attribute8 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
43: attribute9 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
44: attribute10 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
45: attribute11 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
46: attribute12 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
39: attribute5 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
40: attribute6 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
41: attribute7 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
42: attribute8 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
43: attribute9 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
44: attribute10 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
45: attribute11 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
46: attribute12 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
47: attribute13 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
40: attribute6 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
41: attribute7 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
42: attribute8 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
43: attribute9 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
44: attribute10 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
45: attribute11 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
46: attribute12 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
47: attribute13 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
48: attribute14 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
41: attribute7 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
42: attribute8 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
43: attribute9 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
44: attribute10 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
45: attribute11 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
46: attribute12 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
47: attribute13 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
48: attribute14 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
49: attribute15 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
42: attribute8 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
43: attribute9 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
44: attribute10 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
45: attribute11 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
46: attribute12 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
47: attribute13 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
48: attribute14 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
49: attribute15 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
50: created_by NUMBER := Okl_api.G_MISS_NUM,
43: attribute9 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
44: attribute10 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
45: attribute11 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
46: attribute12 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
47: attribute13 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
48: attribute14 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
49: attribute15 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
50: created_by NUMBER := Okl_api.G_MISS_NUM,
51: creation_date OKL_TXD_AR_LN_DTLS_B.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
44: attribute10 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
45: attribute11 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
46: attribute12 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
47: attribute13 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
48: attribute14 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
49: attribute15 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
50: created_by NUMBER := Okl_api.G_MISS_NUM,
51: creation_date OKL_TXD_AR_LN_DTLS_B.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
52: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
45: attribute11 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
46: attribute12 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
47: attribute13 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
48: attribute14 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
49: attribute15 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
50: created_by NUMBER := Okl_api.G_MISS_NUM,
51: creation_date OKL_TXD_AR_LN_DTLS_B.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
52: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
53: last_update_date OKL_TXD_AR_LN_DTLS_B.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
46: attribute12 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
47: attribute13 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
48: attribute14 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
49: attribute15 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
50: created_by NUMBER := Okl_api.G_MISS_NUM,
51: creation_date OKL_TXD_AR_LN_DTLS_B.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
52: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
53: last_update_date OKL_TXD_AR_LN_DTLS_B.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
54: last_update_login NUMBER := Okl_api.G_MISS_NUM,
47: attribute13 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
48: attribute14 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
49: attribute15 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
50: created_by NUMBER := Okl_api.G_MISS_NUM,
51: creation_date OKL_TXD_AR_LN_DTLS_B.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
52: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
53: last_update_date OKL_TXD_AR_LN_DTLS_B.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
54: last_update_login NUMBER := Okl_api.G_MISS_NUM,
55:
48: attribute14 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
49: attribute15 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
50: created_by NUMBER := Okl_api.G_MISS_NUM,
51: creation_date OKL_TXD_AR_LN_DTLS_B.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
52: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
53: last_update_date OKL_TXD_AR_LN_DTLS_B.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
54: last_update_login NUMBER := Okl_api.G_MISS_NUM,
55:
56: --start: 30-Jan-07 cklee Billing R12 project |
49: attribute15 OKL_TXD_AR_LN_DTLS_B.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
50: created_by NUMBER := Okl_api.G_MISS_NUM,
51: creation_date OKL_TXD_AR_LN_DTLS_B.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
52: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
53: last_update_date OKL_TXD_AR_LN_DTLS_B.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
54: last_update_login NUMBER := Okl_api.G_MISS_NUM,
55:
56: --start: 30-Jan-07 cklee Billing R12 project |
57: TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
50: created_by NUMBER := Okl_api.G_MISS_NUM,
51: creation_date OKL_TXD_AR_LN_DTLS_B.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
52: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
53: last_update_date OKL_TXD_AR_LN_DTLS_B.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
54: last_update_login NUMBER := Okl_api.G_MISS_NUM,
55:
56: --start: 30-Jan-07 cklee Billing R12 project |
57: TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
58: INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_TYPE%TYPE := Okl_api.G_MISS_CHAR,
53: last_update_date OKL_TXD_AR_LN_DTLS_B.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
54: last_update_login NUMBER := Okl_api.G_MISS_NUM,
55:
56: --start: 30-Jan-07 cklee Billing R12 project |
57: TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
58: INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_TYPE%TYPE := Okl_api.G_MISS_CHAR,
59: INVOICE_FORMAT_LINE_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_LINE_TYPE%TYPE := Okl_api.G_MISS_CHAR,
60: LATE_CHARGE_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
61: --start: 26-02-07 gkhuntet Invalid assignment.
54: last_update_login NUMBER := Okl_api.G_MISS_NUM,
55:
56: --start: 30-Jan-07 cklee Billing R12 project |
57: TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
58: INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_TYPE%TYPE := Okl_api.G_MISS_CHAR,
59: INVOICE_FORMAT_LINE_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_LINE_TYPE%TYPE := Okl_api.G_MISS_CHAR,
60: LATE_CHARGE_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
61: --start: 26-02-07 gkhuntet Invalid assignment.
62: LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
55:
56: --start: 30-Jan-07 cklee Billing R12 project |
57: TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
58: INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_TYPE%TYPE := Okl_api.G_MISS_CHAR,
59: INVOICE_FORMAT_LINE_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_LINE_TYPE%TYPE := Okl_api.G_MISS_CHAR,
60: LATE_CHARGE_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
61: --start: 26-02-07 gkhuntet Invalid assignment.
62: LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
63: --end: 26-02-07 gkhuntet
56: --start: 30-Jan-07 cklee Billing R12 project |
57: TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
58: INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_TYPE%TYPE := Okl_api.G_MISS_CHAR,
59: INVOICE_FORMAT_LINE_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_LINE_TYPE%TYPE := Okl_api.G_MISS_CHAR,
60: LATE_CHARGE_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
61: --start: 26-02-07 gkhuntet Invalid assignment.
62: LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
63: --end: 26-02-07 gkhuntet
64: LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
58: INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_TYPE%TYPE := Okl_api.G_MISS_CHAR,
59: INVOICE_FORMAT_LINE_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_LINE_TYPE%TYPE := Okl_api.G_MISS_CHAR,
60: LATE_CHARGE_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
61: --start: 26-02-07 gkhuntet Invalid assignment.
62: LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
63: --end: 26-02-07 gkhuntet
64: LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
65: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
66: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
60: LATE_CHARGE_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
61: --start: 26-02-07 gkhuntet Invalid assignment.
62: LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
63: --end: 26-02-07 gkhuntet
64: LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
65: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
66: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
67: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
68: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
61: --start: 26-02-07 gkhuntet Invalid assignment.
62: LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
63: --end: 26-02-07 gkhuntet
64: LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
65: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
66: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
67: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
68: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
69: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
62: LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
63: --end: 26-02-07 gkhuntet
64: LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
65: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
66: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
67: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
68: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
69: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
70: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
63: --end: 26-02-07 gkhuntet
64: LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
65: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
66: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
67: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
68: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
69: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
70: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
71: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
64: LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
65: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
66: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
67: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
68: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
69: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
70: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
71: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
72: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
65: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
66: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
67: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
68: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
69: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
70: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
71: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
72: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
73: --start: 26-02-07 gkhuntet Invalid assignment.
66: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
67: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
68: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
69: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
70: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
71: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
72: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
73: --start: 26-02-07 gkhuntet Invalid assignment.
74: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
67: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
68: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
69: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
70: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
71: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
72: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
73: --start: 26-02-07 gkhuntet Invalid assignment.
74: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
75: KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
68: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
69: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
70: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
71: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
72: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
73: --start: 26-02-07 gkhuntet Invalid assignment.
74: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
75: KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
76: KLE_ID OKL_TXD_AR_LN_DTLS_B.KLE_ID%TYPE := Okl_api.G_MISS_NUM,
70: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
71: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
72: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
73: --start: 26-02-07 gkhuntet Invalid assignment.
74: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
75: KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
76: KLE_ID OKL_TXD_AR_LN_DTLS_B.KLE_ID%TYPE := Okl_api.G_MISS_NUM,
77: TAX_AMOUNT NUMBER := Okl_api.G_MISS_NUM
78: --end: 26-02-07 gkhuntet
71: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
72: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
73: --start: 26-02-07 gkhuntet Invalid assignment.
74: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
75: KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
76: KLE_ID OKL_TXD_AR_LN_DTLS_B.KLE_ID%TYPE := Okl_api.G_MISS_NUM,
77: TAX_AMOUNT NUMBER := Okl_api.G_MISS_NUM
78: --end: 26-02-07 gkhuntet
79: --end: 30-Jan-07 cklee Billing R12 project |
72: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
73: --start: 26-02-07 gkhuntet Invalid assignment.
74: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
75: KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
76: KLE_ID OKL_TXD_AR_LN_DTLS_B.KLE_ID%TYPE := Okl_api.G_MISS_NUM,
77: TAX_AMOUNT NUMBER := Okl_api.G_MISS_NUM
78: --end: 26-02-07 gkhuntet
79: --end: 30-Jan-07 cklee Billing R12 project |
80:
73: --start: 26-02-07 gkhuntet Invalid assignment.
74: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
75: KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
76: KLE_ID OKL_TXD_AR_LN_DTLS_B.KLE_ID%TYPE := Okl_api.G_MISS_NUM,
77: TAX_AMOUNT NUMBER := Okl_api.G_MISS_NUM
78: --end: 26-02-07 gkhuntet
79: --end: 30-Jan-07 cklee Billing R12 project |
80:
81: );
82: g_miss_tld_rec tld_rec_type;
83: TYPE tld_tbl_type IS TABLE OF tld_rec_type
84: INDEX BY BINARY_INTEGER;
85: TYPE okl_txd_ar_ln_dtls_tl_rec_type IS RECORD (
86: id NUMBER := Okl_api.G_MISS_NUM,
87: LANGUAGE OKL_TXD_AR_LN_DTLS_TL.LANGUAGE%TYPE := Okl_api.G_MISS_CHAR,
88: source_lang OKL_TXD_AR_LN_DTLS_TL.SOURCE_LANG%TYPE := Okl_api.G_MISS_CHAR,
89: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
90: sfwt_flag OKL_TXD_AR_LN_DTLS_TL.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
83: TYPE tld_tbl_type IS TABLE OF tld_rec_type
84: INDEX BY BINARY_INTEGER;
85: TYPE okl_txd_ar_ln_dtls_tl_rec_type IS RECORD (
86: id NUMBER := Okl_api.G_MISS_NUM,
87: LANGUAGE OKL_TXD_AR_LN_DTLS_TL.LANGUAGE%TYPE := Okl_api.G_MISS_CHAR,
88: source_lang OKL_TXD_AR_LN_DTLS_TL.SOURCE_LANG%TYPE := Okl_api.G_MISS_CHAR,
89: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
90: sfwt_flag OKL_TXD_AR_LN_DTLS_TL.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
91: description OKL_TXD_AR_LN_DTLS_TL.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
84: INDEX BY BINARY_INTEGER;
85: TYPE okl_txd_ar_ln_dtls_tl_rec_type IS RECORD (
86: id NUMBER := Okl_api.G_MISS_NUM,
87: LANGUAGE OKL_TXD_AR_LN_DTLS_TL.LANGUAGE%TYPE := Okl_api.G_MISS_CHAR,
88: source_lang OKL_TXD_AR_LN_DTLS_TL.SOURCE_LANG%TYPE := Okl_api.G_MISS_CHAR,
89: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
90: sfwt_flag OKL_TXD_AR_LN_DTLS_TL.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
91: description OKL_TXD_AR_LN_DTLS_TL.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
92: created_by NUMBER := Okl_api.G_MISS_NUM,
85: TYPE okl_txd_ar_ln_dtls_tl_rec_type IS RECORD (
86: id NUMBER := Okl_api.G_MISS_NUM,
87: LANGUAGE OKL_TXD_AR_LN_DTLS_TL.LANGUAGE%TYPE := Okl_api.G_MISS_CHAR,
88: source_lang OKL_TXD_AR_LN_DTLS_TL.SOURCE_LANG%TYPE := Okl_api.G_MISS_CHAR,
89: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
90: sfwt_flag OKL_TXD_AR_LN_DTLS_TL.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
91: description OKL_TXD_AR_LN_DTLS_TL.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
92: created_by NUMBER := Okl_api.G_MISS_NUM,
93: creation_date OKL_TXD_AR_LN_DTLS_TL.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
86: id NUMBER := Okl_api.G_MISS_NUM,
87: LANGUAGE OKL_TXD_AR_LN_DTLS_TL.LANGUAGE%TYPE := Okl_api.G_MISS_CHAR,
88: source_lang OKL_TXD_AR_LN_DTLS_TL.SOURCE_LANG%TYPE := Okl_api.G_MISS_CHAR,
89: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
90: sfwt_flag OKL_TXD_AR_LN_DTLS_TL.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
91: description OKL_TXD_AR_LN_DTLS_TL.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
92: created_by NUMBER := Okl_api.G_MISS_NUM,
93: creation_date OKL_TXD_AR_LN_DTLS_TL.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
94: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
87: LANGUAGE OKL_TXD_AR_LN_DTLS_TL.LANGUAGE%TYPE := Okl_api.G_MISS_CHAR,
88: source_lang OKL_TXD_AR_LN_DTLS_TL.SOURCE_LANG%TYPE := Okl_api.G_MISS_CHAR,
89: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
90: sfwt_flag OKL_TXD_AR_LN_DTLS_TL.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
91: description OKL_TXD_AR_LN_DTLS_TL.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
92: created_by NUMBER := Okl_api.G_MISS_NUM,
93: creation_date OKL_TXD_AR_LN_DTLS_TL.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
94: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
95: last_update_date OKL_TXD_AR_LN_DTLS_TL.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
88: source_lang OKL_TXD_AR_LN_DTLS_TL.SOURCE_LANG%TYPE := Okl_api.G_MISS_CHAR,
89: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
90: sfwt_flag OKL_TXD_AR_LN_DTLS_TL.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
91: description OKL_TXD_AR_LN_DTLS_TL.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
92: created_by NUMBER := Okl_api.G_MISS_NUM,
93: creation_date OKL_TXD_AR_LN_DTLS_TL.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
94: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
95: last_update_date OKL_TXD_AR_LN_DTLS_TL.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
96: last_update_login NUMBER := Okl_api.G_MISS_NUM);
89: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
90: sfwt_flag OKL_TXD_AR_LN_DTLS_TL.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
91: description OKL_TXD_AR_LN_DTLS_TL.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
92: created_by NUMBER := Okl_api.G_MISS_NUM,
93: creation_date OKL_TXD_AR_LN_DTLS_TL.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
94: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
95: last_update_date OKL_TXD_AR_LN_DTLS_TL.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
96: last_update_login NUMBER := Okl_api.G_MISS_NUM);
97: GMissOklTxdArLnDtlsTlRec okl_txd_ar_ln_dtls_tl_rec_type;
90: sfwt_flag OKL_TXD_AR_LN_DTLS_TL.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
91: description OKL_TXD_AR_LN_DTLS_TL.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
92: created_by NUMBER := Okl_api.G_MISS_NUM,
93: creation_date OKL_TXD_AR_LN_DTLS_TL.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
94: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
95: last_update_date OKL_TXD_AR_LN_DTLS_TL.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
96: last_update_login NUMBER := Okl_api.G_MISS_NUM);
97: GMissOklTxdArLnDtlsTlRec okl_txd_ar_ln_dtls_tl_rec_type;
98: TYPE okl_txd_ar_ln_dtls_tl_tbl_type IS TABLE OF okl_txd_ar_ln_dtls_tl_rec_type
91: description OKL_TXD_AR_LN_DTLS_TL.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
92: created_by NUMBER := Okl_api.G_MISS_NUM,
93: creation_date OKL_TXD_AR_LN_DTLS_TL.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
94: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
95: last_update_date OKL_TXD_AR_LN_DTLS_TL.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
96: last_update_login NUMBER := Okl_api.G_MISS_NUM);
97: GMissOklTxdArLnDtlsTlRec okl_txd_ar_ln_dtls_tl_rec_type;
98: TYPE okl_txd_ar_ln_dtls_tl_tbl_type IS TABLE OF okl_txd_ar_ln_dtls_tl_rec_type
99: INDEX BY BINARY_INTEGER;
92: created_by NUMBER := Okl_api.G_MISS_NUM,
93: creation_date OKL_TXD_AR_LN_DTLS_TL.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
94: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
95: last_update_date OKL_TXD_AR_LN_DTLS_TL.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
96: last_update_login NUMBER := Okl_api.G_MISS_NUM);
97: GMissOklTxdArLnDtlsTlRec okl_txd_ar_ln_dtls_tl_rec_type;
98: TYPE okl_txd_ar_ln_dtls_tl_tbl_type IS TABLE OF okl_txd_ar_ln_dtls_tl_rec_type
99: INDEX BY BINARY_INTEGER;
100: TYPE tldv_rec_type IS RECORD (
97: GMissOklTxdArLnDtlsTlRec okl_txd_ar_ln_dtls_tl_rec_type;
98: TYPE okl_txd_ar_ln_dtls_tl_tbl_type IS TABLE OF okl_txd_ar_ln_dtls_tl_rec_type
99: INDEX BY BINARY_INTEGER;
100: TYPE tldv_rec_type IS RECORD (
101: id NUMBER := Okl_api.G_MISS_NUM,
102: object_version_number NUMBER := Okl_api.G_MISS_NUM,
103: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
104: sfwt_flag OKL_TXD_AR_LN_DTLS_V.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
105: bch_id NUMBER := Okl_api.G_MISS_NUM,
98: TYPE okl_txd_ar_ln_dtls_tl_tbl_type IS TABLE OF okl_txd_ar_ln_dtls_tl_rec_type
99: INDEX BY BINARY_INTEGER;
100: TYPE tldv_rec_type IS RECORD (
101: id NUMBER := Okl_api.G_MISS_NUM,
102: object_version_number NUMBER := Okl_api.G_MISS_NUM,
103: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
104: sfwt_flag OKL_TXD_AR_LN_DTLS_V.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
105: bch_id NUMBER := Okl_api.G_MISS_NUM,
106: bgh_id NUMBER := Okl_api.G_MISS_NUM,
99: INDEX BY BINARY_INTEGER;
100: TYPE tldv_rec_type IS RECORD (
101: id NUMBER := Okl_api.G_MISS_NUM,
102: object_version_number NUMBER := Okl_api.G_MISS_NUM,
103: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
104: sfwt_flag OKL_TXD_AR_LN_DTLS_V.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
105: bch_id NUMBER := Okl_api.G_MISS_NUM,
106: bgh_id NUMBER := Okl_api.G_MISS_NUM,
107: idx_id NUMBER := Okl_api.G_MISS_NUM,
100: TYPE tldv_rec_type IS RECORD (
101: id NUMBER := Okl_api.G_MISS_NUM,
102: object_version_number NUMBER := Okl_api.G_MISS_NUM,
103: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
104: sfwt_flag OKL_TXD_AR_LN_DTLS_V.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
105: bch_id NUMBER := Okl_api.G_MISS_NUM,
106: bgh_id NUMBER := Okl_api.G_MISS_NUM,
107: idx_id NUMBER := Okl_api.G_MISS_NUM,
108: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
101: id NUMBER := Okl_api.G_MISS_NUM,
102: object_version_number NUMBER := Okl_api.G_MISS_NUM,
103: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
104: sfwt_flag OKL_TXD_AR_LN_DTLS_V.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
105: bch_id NUMBER := Okl_api.G_MISS_NUM,
106: bgh_id NUMBER := Okl_api.G_MISS_NUM,
107: idx_id NUMBER := Okl_api.G_MISS_NUM,
108: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
109: sty_id NUMBER := Okl_api.G_MISS_NUM,
102: object_version_number NUMBER := Okl_api.G_MISS_NUM,
103: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
104: sfwt_flag OKL_TXD_AR_LN_DTLS_V.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
105: bch_id NUMBER := Okl_api.G_MISS_NUM,
106: bgh_id NUMBER := Okl_api.G_MISS_NUM,
107: idx_id NUMBER := Okl_api.G_MISS_NUM,
108: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
109: sty_id NUMBER := Okl_api.G_MISS_NUM,
110: sel_id NUMBER := Okl_api.G_MISS_NUM,
103: error_message OKL_TXD_AR_LN_DTLS_TL.ERROR_MESSAGE%TYPE := Okl_api.G_MISS_CHAR,
104: sfwt_flag OKL_TXD_AR_LN_DTLS_V.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
105: bch_id NUMBER := Okl_api.G_MISS_NUM,
106: bgh_id NUMBER := Okl_api.G_MISS_NUM,
107: idx_id NUMBER := Okl_api.G_MISS_NUM,
108: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
109: sty_id NUMBER := Okl_api.G_MISS_NUM,
110: sel_id NUMBER := Okl_api.G_MISS_NUM,
111: til_id_details NUMBER := Okl_api.G_MISS_NUM,
104: sfwt_flag OKL_TXD_AR_LN_DTLS_V.SFWT_FLAG%TYPE := Okl_api.G_MISS_CHAR,
105: bch_id NUMBER := Okl_api.G_MISS_NUM,
106: bgh_id NUMBER := Okl_api.G_MISS_NUM,
107: idx_id NUMBER := Okl_api.G_MISS_NUM,
108: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
109: sty_id NUMBER := Okl_api.G_MISS_NUM,
110: sel_id NUMBER := Okl_api.G_MISS_NUM,
111: til_id_details NUMBER := Okl_api.G_MISS_NUM,
112: bcl_id NUMBER := Okl_api.G_MISS_NUM,
105: bch_id NUMBER := Okl_api.G_MISS_NUM,
106: bgh_id NUMBER := Okl_api.G_MISS_NUM,
107: idx_id NUMBER := Okl_api.G_MISS_NUM,
108: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
109: sty_id NUMBER := Okl_api.G_MISS_NUM,
110: sel_id NUMBER := Okl_api.G_MISS_NUM,
111: til_id_details NUMBER := Okl_api.G_MISS_NUM,
112: bcl_id NUMBER := Okl_api.G_MISS_NUM,
113: bsl_id NUMBER := Okl_api.G_MISS_NUM,
106: bgh_id NUMBER := Okl_api.G_MISS_NUM,
107: idx_id NUMBER := Okl_api.G_MISS_NUM,
108: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
109: sty_id NUMBER := Okl_api.G_MISS_NUM,
110: sel_id NUMBER := Okl_api.G_MISS_NUM,
111: til_id_details NUMBER := Okl_api.G_MISS_NUM,
112: bcl_id NUMBER := Okl_api.G_MISS_NUM,
113: bsl_id NUMBER := Okl_api.G_MISS_NUM,
114: amount NUMBER := Okl_api.G_MISS_NUM,
107: idx_id NUMBER := Okl_api.G_MISS_NUM,
108: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
109: sty_id NUMBER := Okl_api.G_MISS_NUM,
110: sel_id NUMBER := Okl_api.G_MISS_NUM,
111: til_id_details NUMBER := Okl_api.G_MISS_NUM,
112: bcl_id NUMBER := Okl_api.G_MISS_NUM,
113: bsl_id NUMBER := Okl_api.G_MISS_NUM,
114: amount NUMBER := Okl_api.G_MISS_NUM,
115: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
108: tld_id_reverses NUMBER := Okl_api.G_MISS_NUM,
109: sty_id NUMBER := Okl_api.G_MISS_NUM,
110: sel_id NUMBER := Okl_api.G_MISS_NUM,
111: til_id_details NUMBER := Okl_api.G_MISS_NUM,
112: bcl_id NUMBER := Okl_api.G_MISS_NUM,
113: bsl_id NUMBER := Okl_api.G_MISS_NUM,
114: amount NUMBER := Okl_api.G_MISS_NUM,
115: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
116: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
109: sty_id NUMBER := Okl_api.G_MISS_NUM,
110: sel_id NUMBER := Okl_api.G_MISS_NUM,
111: til_id_details NUMBER := Okl_api.G_MISS_NUM,
112: bcl_id NUMBER := Okl_api.G_MISS_NUM,
113: bsl_id NUMBER := Okl_api.G_MISS_NUM,
114: amount NUMBER := Okl_api.G_MISS_NUM,
115: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
116: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
117: late_charge_yn OKL_TXD_AR_LN_DTLS_V.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
110: sel_id NUMBER := Okl_api.G_MISS_NUM,
111: til_id_details NUMBER := Okl_api.G_MISS_NUM,
112: bcl_id NUMBER := Okl_api.G_MISS_NUM,
113: bsl_id NUMBER := Okl_api.G_MISS_NUM,
114: amount NUMBER := Okl_api.G_MISS_NUM,
115: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
116: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
117: late_charge_yn OKL_TXD_AR_LN_DTLS_V.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
118: description OKL_TXD_AR_LN_DTLS_V.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
111: til_id_details NUMBER := Okl_api.G_MISS_NUM,
112: bcl_id NUMBER := Okl_api.G_MISS_NUM,
113: bsl_id NUMBER := Okl_api.G_MISS_NUM,
114: amount NUMBER := Okl_api.G_MISS_NUM,
115: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
116: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
117: late_charge_yn OKL_TXD_AR_LN_DTLS_V.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
118: description OKL_TXD_AR_LN_DTLS_V.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
119: amount_applied NUMBER := Okl_api.G_MISS_NUM,
112: bcl_id NUMBER := Okl_api.G_MISS_NUM,
113: bsl_id NUMBER := Okl_api.G_MISS_NUM,
114: amount NUMBER := Okl_api.G_MISS_NUM,
115: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
116: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
117: late_charge_yn OKL_TXD_AR_LN_DTLS_V.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
118: description OKL_TXD_AR_LN_DTLS_V.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
119: amount_applied NUMBER := Okl_api.G_MISS_NUM,
120: date_calculation OKL_TXD_AR_LN_DTLS_V.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
113: bsl_id NUMBER := Okl_api.G_MISS_NUM,
114: amount NUMBER := Okl_api.G_MISS_NUM,
115: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
116: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
117: late_charge_yn OKL_TXD_AR_LN_DTLS_V.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
118: description OKL_TXD_AR_LN_DTLS_V.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
119: amount_applied NUMBER := Okl_api.G_MISS_NUM,
120: date_calculation OKL_TXD_AR_LN_DTLS_V.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
121: fixed_rate_yn OKL_TXD_AR_LN_DTLS_V.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
114: amount NUMBER := Okl_api.G_MISS_NUM,
115: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
116: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
117: late_charge_yn OKL_TXD_AR_LN_DTLS_V.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
118: description OKL_TXD_AR_LN_DTLS_V.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
119: amount_applied NUMBER := Okl_api.G_MISS_NUM,
120: date_calculation OKL_TXD_AR_LN_DTLS_V.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
121: fixed_rate_yn OKL_TXD_AR_LN_DTLS_V.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
122: -- Start changes on remarketing by fmiao on 10/18/04 --
115: line_detail_number NUMBER := Okl_api.G_MISS_NUM,
116: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
117: late_charge_yn OKL_TXD_AR_LN_DTLS_V.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
118: description OKL_TXD_AR_LN_DTLS_V.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
119: amount_applied NUMBER := Okl_api.G_MISS_NUM,
120: date_calculation OKL_TXD_AR_LN_DTLS_V.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
121: fixed_rate_yn OKL_TXD_AR_LN_DTLS_V.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
122: -- Start changes on remarketing by fmiao on 10/18/04 --
123: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
116: receivables_invoice_id NUMBER := Okl_api.G_MISS_NUM,
117: late_charge_yn OKL_TXD_AR_LN_DTLS_V.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
118: description OKL_TXD_AR_LN_DTLS_V.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
119: amount_applied NUMBER := Okl_api.G_MISS_NUM,
120: date_calculation OKL_TXD_AR_LN_DTLS_V.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
121: fixed_rate_yn OKL_TXD_AR_LN_DTLS_V.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
122: -- Start changes on remarketing by fmiao on 10/18/04 --
123: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
124: -- End changes on remarketing by fmiao on 10/18/04 --
117: late_charge_yn OKL_TXD_AR_LN_DTLS_V.LATE_CHARGE_YN%TYPE := Okl_api.G_MISS_CHAR,
118: description OKL_TXD_AR_LN_DTLS_V.DESCRIPTION%TYPE := Okl_api.G_MISS_CHAR,
119: amount_applied NUMBER := Okl_api.G_MISS_NUM,
120: date_calculation OKL_TXD_AR_LN_DTLS_V.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
121: fixed_rate_yn OKL_TXD_AR_LN_DTLS_V.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
122: -- Start changes on remarketing by fmiao on 10/18/04 --
123: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
124: -- End changes on remarketing by fmiao on 10/18/04 --
125: attribute_category OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
119: amount_applied NUMBER := Okl_api.G_MISS_NUM,
120: date_calculation OKL_TXD_AR_LN_DTLS_V.DATE_CALCULATION%TYPE := Okl_api.G_MISS_DATE,
121: fixed_rate_yn OKL_TXD_AR_LN_DTLS_V.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
122: -- Start changes on remarketing by fmiao on 10/18/04 --
123: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
124: -- End changes on remarketing by fmiao on 10/18/04 --
125: attribute_category OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
126: attribute1 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
127: attribute2 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
121: fixed_rate_yn OKL_TXD_AR_LN_DTLS_V.FIXED_RATE_YN%TYPE := Okl_api.G_MISS_CHAR,
122: -- Start changes on remarketing by fmiao on 10/18/04 --
123: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
124: -- End changes on remarketing by fmiao on 10/18/04 --
125: attribute_category OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
126: attribute1 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
127: attribute2 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
128: attribute3 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
129: attribute4 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
122: -- Start changes on remarketing by fmiao on 10/18/04 --
123: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
124: -- End changes on remarketing by fmiao on 10/18/04 --
125: attribute_category OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
126: attribute1 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
127: attribute2 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
128: attribute3 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
129: attribute4 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
130: attribute5 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
123: inventory_item_id NUMBER := Okl_api.G_MISS_NUM,
124: -- End changes on remarketing by fmiao on 10/18/04 --
125: attribute_category OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
126: attribute1 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
127: attribute2 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
128: attribute3 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
129: attribute4 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
130: attribute5 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
131: attribute6 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
124: -- End changes on remarketing by fmiao on 10/18/04 --
125: attribute_category OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
126: attribute1 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
127: attribute2 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
128: attribute3 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
129: attribute4 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
130: attribute5 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
131: attribute6 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
132: attribute7 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
125: attribute_category OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_api.G_MISS_CHAR,
126: attribute1 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
127: attribute2 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
128: attribute3 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
129: attribute4 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
130: attribute5 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
131: attribute6 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
132: attribute7 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
133: attribute8 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
126: attribute1 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE1%TYPE := Okl_api.G_MISS_CHAR,
127: attribute2 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
128: attribute3 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
129: attribute4 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
130: attribute5 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
131: attribute6 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
132: attribute7 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
133: attribute8 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
134: attribute9 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
127: attribute2 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE2%TYPE := Okl_api.G_MISS_CHAR,
128: attribute3 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
129: attribute4 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
130: attribute5 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
131: attribute6 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
132: attribute7 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
133: attribute8 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
134: attribute9 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
135: attribute10 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
128: attribute3 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE3%TYPE := Okl_api.G_MISS_CHAR,
129: attribute4 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
130: attribute5 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
131: attribute6 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
132: attribute7 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
133: attribute8 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
134: attribute9 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
135: attribute10 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
136: attribute11 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
129: attribute4 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE4%TYPE := Okl_api.G_MISS_CHAR,
130: attribute5 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
131: attribute6 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
132: attribute7 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
133: attribute8 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
134: attribute9 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
135: attribute10 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
136: attribute11 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
137: attribute12 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
130: attribute5 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE5%TYPE := Okl_api.G_MISS_CHAR,
131: attribute6 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
132: attribute7 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
133: attribute8 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
134: attribute9 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
135: attribute10 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
136: attribute11 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
137: attribute12 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
138: attribute13 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
131: attribute6 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE6%TYPE := Okl_api.G_MISS_CHAR,
132: attribute7 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
133: attribute8 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
134: attribute9 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
135: attribute10 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
136: attribute11 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
137: attribute12 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
138: attribute13 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
139: attribute14 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
132: attribute7 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE7%TYPE := Okl_api.G_MISS_CHAR,
133: attribute8 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
134: attribute9 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
135: attribute10 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
136: attribute11 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
137: attribute12 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
138: attribute13 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
139: attribute14 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
140: attribute15 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
133: attribute8 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE8%TYPE := Okl_api.G_MISS_CHAR,
134: attribute9 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
135: attribute10 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
136: attribute11 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
137: attribute12 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
138: attribute13 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
139: attribute14 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
140: attribute15 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
141: request_id NUMBER := Okl_api.G_MISS_NUM,
134: attribute9 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE9%TYPE := Okl_api.G_MISS_CHAR,
135: attribute10 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
136: attribute11 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
137: attribute12 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
138: attribute13 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
139: attribute14 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
140: attribute15 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
141: request_id NUMBER := Okl_api.G_MISS_NUM,
142: program_application_id NUMBER := Okl_api.G_MISS_NUM,
135: attribute10 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE10%TYPE := Okl_api.G_MISS_CHAR,
136: attribute11 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
137: attribute12 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
138: attribute13 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
139: attribute14 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
140: attribute15 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
141: request_id NUMBER := Okl_api.G_MISS_NUM,
142: program_application_id NUMBER := Okl_api.G_MISS_NUM,
143: program_id NUMBER := Okl_api.G_MISS_NUM,
136: attribute11 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE11%TYPE := Okl_api.G_MISS_CHAR,
137: attribute12 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
138: attribute13 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
139: attribute14 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
140: attribute15 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
141: request_id NUMBER := Okl_api.G_MISS_NUM,
142: program_application_id NUMBER := Okl_api.G_MISS_NUM,
143: program_id NUMBER := Okl_api.G_MISS_NUM,
144: program_update_date OKL_TXD_AR_LN_DTLS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
137: attribute12 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE12%TYPE := Okl_api.G_MISS_CHAR,
138: attribute13 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
139: attribute14 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
140: attribute15 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
141: request_id NUMBER := Okl_api.G_MISS_NUM,
142: program_application_id NUMBER := Okl_api.G_MISS_NUM,
143: program_id NUMBER := Okl_api.G_MISS_NUM,
144: program_update_date OKL_TXD_AR_LN_DTLS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
145: org_id NUMBER := Okl_api.G_MISS_NUM,
138: attribute13 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE13%TYPE := Okl_api.G_MISS_CHAR,
139: attribute14 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
140: attribute15 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
141: request_id NUMBER := Okl_api.G_MISS_NUM,
142: program_application_id NUMBER := Okl_api.G_MISS_NUM,
143: program_id NUMBER := Okl_api.G_MISS_NUM,
144: program_update_date OKL_TXD_AR_LN_DTLS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
145: org_id NUMBER := Okl_api.G_MISS_NUM,
146: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
139: attribute14 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE14%TYPE := Okl_api.G_MISS_CHAR,
140: attribute15 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
141: request_id NUMBER := Okl_api.G_MISS_NUM,
142: program_application_id NUMBER := Okl_api.G_MISS_NUM,
143: program_id NUMBER := Okl_api.G_MISS_NUM,
144: program_update_date OKL_TXD_AR_LN_DTLS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
145: org_id NUMBER := Okl_api.G_MISS_NUM,
146: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
147: created_by NUMBER := Okl_api.G_MISS_NUM,
140: attribute15 OKL_TXD_AR_LN_DTLS_V.ATTRIBUTE15%TYPE := Okl_api.G_MISS_CHAR,
141: request_id NUMBER := Okl_api.G_MISS_NUM,
142: program_application_id NUMBER := Okl_api.G_MISS_NUM,
143: program_id NUMBER := Okl_api.G_MISS_NUM,
144: program_update_date OKL_TXD_AR_LN_DTLS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
145: org_id NUMBER := Okl_api.G_MISS_NUM,
146: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
147: created_by NUMBER := Okl_api.G_MISS_NUM,
148: creation_date OKL_TXD_AR_LN_DTLS_V.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
141: request_id NUMBER := Okl_api.G_MISS_NUM,
142: program_application_id NUMBER := Okl_api.G_MISS_NUM,
143: program_id NUMBER := Okl_api.G_MISS_NUM,
144: program_update_date OKL_TXD_AR_LN_DTLS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
145: org_id NUMBER := Okl_api.G_MISS_NUM,
146: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
147: created_by NUMBER := Okl_api.G_MISS_NUM,
148: creation_date OKL_TXD_AR_LN_DTLS_V.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
149: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
142: program_application_id NUMBER := Okl_api.G_MISS_NUM,
143: program_id NUMBER := Okl_api.G_MISS_NUM,
144: program_update_date OKL_TXD_AR_LN_DTLS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
145: org_id NUMBER := Okl_api.G_MISS_NUM,
146: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
147: created_by NUMBER := Okl_api.G_MISS_NUM,
148: creation_date OKL_TXD_AR_LN_DTLS_V.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
149: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
150: last_update_date OKL_TXD_AR_LN_DTLS_V.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
143: program_id NUMBER := Okl_api.G_MISS_NUM,
144: program_update_date OKL_TXD_AR_LN_DTLS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
145: org_id NUMBER := Okl_api.G_MISS_NUM,
146: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
147: created_by NUMBER := Okl_api.G_MISS_NUM,
148: creation_date OKL_TXD_AR_LN_DTLS_V.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
149: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
150: last_update_date OKL_TXD_AR_LN_DTLS_V.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
151: last_update_login NUMBER := Okl_api.G_MISS_NUM,
144: program_update_date OKL_TXD_AR_LN_DTLS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
145: org_id NUMBER := Okl_api.G_MISS_NUM,
146: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
147: created_by NUMBER := Okl_api.G_MISS_NUM,
148: creation_date OKL_TXD_AR_LN_DTLS_V.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
149: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
150: last_update_date OKL_TXD_AR_LN_DTLS_V.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
151: last_update_login NUMBER := Okl_api.G_MISS_NUM,
152:
145: org_id NUMBER := Okl_api.G_MISS_NUM,
146: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
147: created_by NUMBER := Okl_api.G_MISS_NUM,
148: creation_date OKL_TXD_AR_LN_DTLS_V.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
149: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
150: last_update_date OKL_TXD_AR_LN_DTLS_V.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
151: last_update_login NUMBER := Okl_api.G_MISS_NUM,
152:
153: --start: 30-Jan-07 cklee Billing R12 project |
146: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
147: created_by NUMBER := Okl_api.G_MISS_NUM,
148: creation_date OKL_TXD_AR_LN_DTLS_V.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
149: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
150: last_update_date OKL_TXD_AR_LN_DTLS_V.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
151: last_update_login NUMBER := Okl_api.G_MISS_NUM,
152:
153: --start: 30-Jan-07 cklee Billing R12 project |
154: TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
147: created_by NUMBER := Okl_api.G_MISS_NUM,
148: creation_date OKL_TXD_AR_LN_DTLS_V.CREATION_DATE%TYPE := Okl_api.G_MISS_DATE,
149: last_updated_by NUMBER := Okl_api.G_MISS_NUM,
150: last_update_date OKL_TXD_AR_LN_DTLS_V.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
151: last_update_login NUMBER := Okl_api.G_MISS_NUM,
152:
153: --start: 30-Jan-07 cklee Billing R12 project |
154: TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
155: INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_TYPE%TYPE := Okl_api.G_MISS_CHAR,
150: last_update_date OKL_TXD_AR_LN_DTLS_V.LAST_UPDATE_DATE%TYPE := Okl_api.G_MISS_DATE,
151: last_update_login NUMBER := Okl_api.G_MISS_NUM,
152:
153: --start: 30-Jan-07 cklee Billing R12 project |
154: TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
155: INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_TYPE%TYPE := Okl_api.G_MISS_CHAR,
156: INVOICE_FORMAT_LINE_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_LINE_TYPE%TYPE := Okl_api.G_MISS_CHAR,
157: LATE_CHARGE_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
158:
151: last_update_login NUMBER := Okl_api.G_MISS_NUM,
152:
153: --start: 30-Jan-07 cklee Billing R12 project |
154: TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
155: INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_TYPE%TYPE := Okl_api.G_MISS_CHAR,
156: INVOICE_FORMAT_LINE_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_LINE_TYPE%TYPE := Okl_api.G_MISS_CHAR,
157: LATE_CHARGE_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
158:
159: --start: 26-02-07 gkhuntet Invalid assignment.
152:
153: --start: 30-Jan-07 cklee Billing R12 project |
154: TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
155: INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_TYPE%TYPE := Okl_api.G_MISS_CHAR,
156: INVOICE_FORMAT_LINE_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_LINE_TYPE%TYPE := Okl_api.G_MISS_CHAR,
157: LATE_CHARGE_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
158:
159: --start: 26-02-07 gkhuntet Invalid assignment.
160: LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
153: --start: 30-Jan-07 cklee Billing R12 project |
154: TXL_AR_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_api.G_MISS_NUM,
155: INVOICE_FORMAT_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_TYPE%TYPE := Okl_api.G_MISS_CHAR,
156: INVOICE_FORMAT_LINE_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_LINE_TYPE%TYPE := Okl_api.G_MISS_CHAR,
157: LATE_CHARGE_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
158:
159: --start: 26-02-07 gkhuntet Invalid assignment.
160: LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
161: --end: 26-02-07 gkhuntet
156: INVOICE_FORMAT_LINE_TYPE OKL_TXD_AR_LN_DTLS_B.INVOICE_FORMAT_LINE_TYPE%TYPE := Okl_api.G_MISS_CHAR,
157: LATE_CHARGE_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
158:
159: --start: 26-02-07 gkhuntet Invalid assignment.
160: LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
161: --end: 26-02-07 gkhuntet
162:
163: LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
164: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
159: --start: 26-02-07 gkhuntet Invalid assignment.
160: LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
161: --end: 26-02-07 gkhuntet
162:
163: LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
164: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
165: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
166: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
167: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
160: LATE_INT_ASSESS_DATE OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASSESS_DATE%TYPE := Okl_api.G_MISS_DATE,
161: --end: 26-02-07 gkhuntet
162:
163: LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
164: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
165: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
166: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
167: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
168: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
161: --end: 26-02-07 gkhuntet
162:
163: LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
164: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
165: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
166: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
167: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
168: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
169: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
162:
163: LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
164: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
165: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
166: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
167: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
168: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
169: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
170: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
163: LATE_CHARGE_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_CHARGE_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
164: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
165: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
166: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
167: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
168: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
169: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
170: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
171: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
164: LATE_INT_ASS_YN OKL_TXD_AR_LN_DTLS_B.LATE_INT_ASS_YN%TYPE := Okl_api.G_MISS_CHAR,
165: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
166: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
167: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
168: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
169: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
170: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
171: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
172: --start: 26-02-07 gkhuntet Invalid assignment.
165: INVESTOR_DISB_STATUS OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_STATUS%TYPE := Okl_api.G_MISS_CHAR,
166: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
167: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
168: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
169: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
170: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
171: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
172: --start: 26-02-07 gkhuntet Invalid assignment.
173: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
166: INVESTOR_DISB_ERR_MG OKL_TXD_AR_LN_DTLS_B.INVESTOR_DISB_ERR_MG%TYPE := Okl_api.G_MISS_CHAR,
167: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
168: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
169: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
170: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
171: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
172: --start: 26-02-07 gkhuntet Invalid assignment.
173: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
174: KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
167: DATE_DISBURSED OKL_TXD_AR_LN_DTLS_B.DATE_DISBURSED%TYPE := Okl_api.G_MISS_DATE,
168: PAY_STATUS_CODE OKL_TXD_AR_LN_DTLS_B.PAY_STATUS_CODE%TYPE := Okl_api.G_MISS_CHAR,
169: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
170: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
171: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
172: --start: 26-02-07 gkhuntet Invalid assignment.
173: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
174: KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
175: KLE_ID OKL_TXD_AR_LN_DTLS_B.KLE_ID%TYPE := Okl_api.G_MISS_NUM,
169: RBK_ORI_INVOICE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
170: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
171: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
172: --start: 26-02-07 gkhuntet Invalid assignment.
173: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
174: KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
175: KLE_ID OKL_TXD_AR_LN_DTLS_B.KLE_ID%TYPE := Okl_api.G_MISS_NUM,
176: TAX_AMOUNT NUMBER := Okl_api.G_MISS_NUM
177: --end: 26-02-07 gkhuntet
170: RBK_ORI_INVOICE_LINE_NUMBER OKL_TXD_AR_LN_DTLS_B.RBK_ORI_INVOICE_LINE_NUMBER%TYPE := Okl_api.G_MISS_CHAR,
171: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
172: --start: 26-02-07 gkhuntet Invalid assignment.
173: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
174: KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
175: KLE_ID OKL_TXD_AR_LN_DTLS_B.KLE_ID%TYPE := Okl_api.G_MISS_NUM,
176: TAX_AMOUNT NUMBER := Okl_api.G_MISS_NUM
177: --end: 26-02-07 gkhuntet
178: --end: 30-Jan-07 cklee Billing R12 project |
171: RBK_ADJUSTMENT_DATE OKL_TXD_AR_LN_DTLS_B.RBK_ADJUSTMENT_DATE%TYPE := Okl_api.G_MISS_DATE,
172: --start: 26-02-07 gkhuntet Invalid assignment.
173: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
174: KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
175: KLE_ID OKL_TXD_AR_LN_DTLS_B.KLE_ID%TYPE := Okl_api.G_MISS_NUM,
176: TAX_AMOUNT NUMBER := Okl_api.G_MISS_NUM
177: --end: 26-02-07 gkhuntet
178: --end: 30-Jan-07 cklee Billing R12 project |
179:
172: --start: 26-02-07 gkhuntet Invalid assignment.
173: --KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_CHAR,
174: KHR_ID OKL_TXD_AR_LN_DTLS_B.KHR_ID%TYPE := Okl_api.G_MISS_NUM,
175: KLE_ID OKL_TXD_AR_LN_DTLS_B.KLE_ID%TYPE := Okl_api.G_MISS_NUM,
176: TAX_AMOUNT NUMBER := Okl_api.G_MISS_NUM
177: --end: 26-02-07 gkhuntet
178: --end: 30-Jan-07 cklee Billing R12 project |
179:
180: );
184: INDEX BY BINARY_INTEGER;
185: ---------------------------------------------------------------------------
186: -- GLOBAL MESSAGE CONSTANTS
187: ---------------------------------------------------------------------------
188: G_FND_APP CONSTANT VARCHAR2(200) := Okl_api.G_FND_APP;
189: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
190: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_DELETED;
191: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_CHANGED;
192: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_RECORD_LOGICALLY_DELETED;
185: ---------------------------------------------------------------------------
186: -- GLOBAL MESSAGE CONSTANTS
187: ---------------------------------------------------------------------------
188: G_FND_APP CONSTANT VARCHAR2(200) := Okl_api.G_FND_APP;
189: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
190: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_DELETED;
191: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_CHANGED;
192: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_RECORD_LOGICALLY_DELETED;
193: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_REQUIRED_VALUE;
186: -- GLOBAL MESSAGE CONSTANTS
187: ---------------------------------------------------------------------------
188: G_FND_APP CONSTANT VARCHAR2(200) := Okl_api.G_FND_APP;
189: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
190: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_DELETED;
191: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_CHANGED;
192: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_RECORD_LOGICALLY_DELETED;
193: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_REQUIRED_VALUE;
194: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_INVALID_VALUE;
187: ---------------------------------------------------------------------------
188: G_FND_APP CONSTANT VARCHAR2(200) := Okl_api.G_FND_APP;
189: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
190: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_DELETED;
191: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_CHANGED;
192: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_RECORD_LOGICALLY_DELETED;
193: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_REQUIRED_VALUE;
194: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_INVALID_VALUE;
195: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_COL_NAME_TOKEN;
188: G_FND_APP CONSTANT VARCHAR2(200) := Okl_api.G_FND_APP;
189: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
190: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_DELETED;
191: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_CHANGED;
192: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_RECORD_LOGICALLY_DELETED;
193: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_REQUIRED_VALUE;
194: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_INVALID_VALUE;
195: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_COL_NAME_TOKEN;
196: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_PARENT_TABLE_TOKEN;
189: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
190: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_DELETED;
191: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_CHANGED;
192: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_RECORD_LOGICALLY_DELETED;
193: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_REQUIRED_VALUE;
194: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_INVALID_VALUE;
195: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_COL_NAME_TOKEN;
196: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_PARENT_TABLE_TOKEN;
197: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_CHILD_TABLE_TOKEN;
190: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_DELETED;
191: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_CHANGED;
192: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_RECORD_LOGICALLY_DELETED;
193: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_REQUIRED_VALUE;
194: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_INVALID_VALUE;
195: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_COL_NAME_TOKEN;
196: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_PARENT_TABLE_TOKEN;
197: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_CHILD_TABLE_TOKEN;
198: ---------------------------------------------------------------------------
191: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_api.G_FORM_RECORD_CHANGED;
192: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_RECORD_LOGICALLY_DELETED;
193: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_REQUIRED_VALUE;
194: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_INVALID_VALUE;
195: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_COL_NAME_TOKEN;
196: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_PARENT_TABLE_TOKEN;
197: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_CHILD_TABLE_TOKEN;
198: ---------------------------------------------------------------------------
199: -- GLOBAL VARIABLES
192: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_api.G_RECORD_LOGICALLY_DELETED;
193: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_REQUIRED_VALUE;
194: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_INVALID_VALUE;
195: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_COL_NAME_TOKEN;
196: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_PARENT_TABLE_TOKEN;
197: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_CHILD_TABLE_TOKEN;
198: ---------------------------------------------------------------------------
199: -- GLOBAL VARIABLES
200: ---------------------------------------------------------------------------
193: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_REQUIRED_VALUE;
194: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_api.G_INVALID_VALUE;
195: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_COL_NAME_TOKEN;
196: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_PARENT_TABLE_TOKEN;
197: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_api.G_CHILD_TABLE_TOKEN;
198: ---------------------------------------------------------------------------
199: -- GLOBAL VARIABLES
200: ---------------------------------------------------------------------------
201: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TLD_PVT';
198: ---------------------------------------------------------------------------
199: -- GLOBAL VARIABLES
200: ---------------------------------------------------------------------------
201: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TLD_PVT';
202: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_api.G_APP_NAME;
203:
204: /******************ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001) ****************/
205: --GLOBAL MESSAGES
206: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
231: PROCEDURE api_copy;
232: PROCEDURE add_language;
233: PROCEDURE insert_row(
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_tldv_rec IN tldv_rec_type,
240: x_tldv_rec OUT NOCOPY tldv_rec_type);
241:
242: PROCEDURE insert_row(
243: p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
248: p_tldv_tbl IN tldv_tbl_type,
249: x_tldv_tbl OUT NOCOPY tldv_tbl_type);
250:
251: PROCEDURE lock_row(
252: p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_tldv_rec IN tldv_rec_type);
257: p_tldv_rec IN tldv_rec_type);
258:
259: PROCEDURE lock_row(
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,
265: p_tldv_tbl IN tldv_tbl_type);
265: p_tldv_tbl IN tldv_tbl_type);
266:
267: PROCEDURE update_row(
268: p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,
273: p_tldv_rec IN tldv_rec_type,
274: x_tldv_rec OUT NOCOPY tldv_rec_type);
275:
276: PROCEDURE update_row(
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_msg_count OUT NOCOPY NUMBER,
281: x_msg_data OUT NOCOPY VARCHAR2,
282: p_tldv_tbl IN tldv_tbl_type,
283: x_tldv_tbl OUT NOCOPY tldv_tbl_type);
284:
285: PROCEDURE delete_row(
286: p_api_version IN NUMBER,
287: p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
291: p_tldv_rec IN tldv_rec_type);
291: p_tldv_rec IN tldv_rec_type);
292:
293: PROCEDURE delete_row(
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: p_tldv_tbl IN tldv_tbl_type);
299: p_tldv_tbl IN tldv_tbl_type);
300:
301: PROCEDURE validate_row(
302: p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
304: x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,
307: p_tldv_rec IN tldv_rec_type);
307: p_tldv_rec IN tldv_rec_type);
308:
309: PROCEDURE validate_row(
310: p_api_version IN NUMBER,
311: p_init_msg_list IN VARCHAR2 DEFAULT Okl_api.G_FALSE,
312: x_return_status OUT NOCOPY VARCHAR2,
313: x_msg_count OUT NOCOPY NUMBER,
314: x_msg_data OUT NOCOPY VARCHAR2,
315: p_tldv_tbl IN tldv_tbl_type);