3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE til_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: inv_receiv_line_code OKL_TXL_AR_INV_LNS_B.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
9: tai_id NUMBER := Okl_Api.G_MISS_NUM,
10: kle_id NUMBER := Okl_Api.G_MISS_NUM,
11: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE til_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: inv_receiv_line_code OKL_TXL_AR_INV_LNS_B.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
9: tai_id NUMBER := Okl_Api.G_MISS_NUM,
10: kle_id NUMBER := Okl_Api.G_MISS_NUM,
11: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
12: sty_id NUMBER := Okl_Api.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE til_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: inv_receiv_line_code OKL_TXL_AR_INV_LNS_B.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
9: tai_id NUMBER := Okl_Api.G_MISS_NUM,
10: kle_id NUMBER := Okl_Api.G_MISS_NUM,
11: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
12: sty_id NUMBER := Okl_Api.G_MISS_NUM,
13: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
6: TYPE til_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: inv_receiv_line_code OKL_TXL_AR_INV_LNS_B.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
9: tai_id NUMBER := Okl_Api.G_MISS_NUM,
10: kle_id NUMBER := Okl_Api.G_MISS_NUM,
11: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
12: sty_id NUMBER := Okl_Api.G_MISS_NUM,
13: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
14: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: inv_receiv_line_code OKL_TXL_AR_INV_LNS_B.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
9: tai_id NUMBER := Okl_Api.G_MISS_NUM,
10: kle_id NUMBER := Okl_Api.G_MISS_NUM,
11: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
12: sty_id NUMBER := Okl_Api.G_MISS_NUM,
13: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
14: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
15: line_number NUMBER := Okl_Api.G_MISS_NUM,
8: inv_receiv_line_code OKL_TXL_AR_INV_LNS_B.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
9: tai_id NUMBER := Okl_Api.G_MISS_NUM,
10: kle_id NUMBER := Okl_Api.G_MISS_NUM,
11: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
12: sty_id NUMBER := Okl_Api.G_MISS_NUM,
13: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
14: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
15: line_number NUMBER := Okl_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
9: tai_id NUMBER := Okl_Api.G_MISS_NUM,
10: kle_id NUMBER := Okl_Api.G_MISS_NUM,
11: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
12: sty_id NUMBER := Okl_Api.G_MISS_NUM,
13: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
14: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
15: line_number NUMBER := Okl_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
17: amount NUMBER := Okl_Api.G_MISS_NUM,
10: kle_id NUMBER := Okl_Api.G_MISS_NUM,
11: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
12: sty_id NUMBER := Okl_Api.G_MISS_NUM,
13: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
14: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
15: line_number NUMBER := Okl_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
17: amount NUMBER := Okl_Api.G_MISS_NUM,
18: quantity NUMBER := Okl_Api.G_MISS_NUM,
11: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
12: sty_id NUMBER := Okl_Api.G_MISS_NUM,
13: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
14: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
15: line_number NUMBER := Okl_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
17: amount NUMBER := Okl_Api.G_MISS_NUM,
18: quantity NUMBER := Okl_Api.G_MISS_NUM,
19: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
12: sty_id NUMBER := Okl_Api.G_MISS_NUM,
13: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
14: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
15: line_number NUMBER := Okl_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
17: amount NUMBER := Okl_Api.G_MISS_NUM,
18: quantity NUMBER := Okl_Api.G_MISS_NUM,
19: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
20: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
13: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
14: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
15: line_number NUMBER := Okl_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
17: amount NUMBER := Okl_Api.G_MISS_NUM,
18: quantity NUMBER := Okl_Api.G_MISS_NUM,
19: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
20: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
21: date_bill_period_start OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
14: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
15: line_number NUMBER := Okl_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
17: amount NUMBER := Okl_Api.G_MISS_NUM,
18: quantity NUMBER := Okl_Api.G_MISS_NUM,
19: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
20: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
21: date_bill_period_start OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
22: date_bill_period_end OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
15: line_number NUMBER := Okl_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
17: amount NUMBER := Okl_Api.G_MISS_NUM,
18: quantity NUMBER := Okl_Api.G_MISS_NUM,
19: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
20: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
21: date_bill_period_start OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
22: date_bill_period_end OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
23: request_id NUMBER := Okl_Api.G_MISS_NUM,
16: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
17: amount NUMBER := Okl_Api.G_MISS_NUM,
18: quantity NUMBER := Okl_Api.G_MISS_NUM,
19: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
20: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
21: date_bill_period_start OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
22: date_bill_period_end OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
23: request_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
17: amount NUMBER := Okl_Api.G_MISS_NUM,
18: quantity NUMBER := Okl_Api.G_MISS_NUM,
19: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
20: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
21: date_bill_period_start OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
22: date_bill_period_end OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
23: request_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_id NUMBER := Okl_Api.G_MISS_NUM,
18: quantity NUMBER := Okl_Api.G_MISS_NUM,
19: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
20: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
21: date_bill_period_start OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
22: date_bill_period_end OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
23: request_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_id NUMBER := Okl_Api.G_MISS_NUM,
26: program_update_date OKL_TXL_AR_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
19: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
20: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
21: date_bill_period_start OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
22: date_bill_period_end OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
23: request_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_id NUMBER := Okl_Api.G_MISS_NUM,
26: program_update_date OKL_TXL_AR_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
27: org_id NUMBER := Okl_Api.G_MISS_NUM,
20: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
21: date_bill_period_start OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
22: date_bill_period_end OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
23: request_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_id NUMBER := Okl_Api.G_MISS_NUM,
26: program_update_date OKL_TXL_AR_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
27: org_id NUMBER := Okl_Api.G_MISS_NUM,
28: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
21: date_bill_period_start OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
22: date_bill_period_end OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
23: request_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_id NUMBER := Okl_Api.G_MISS_NUM,
26: program_update_date OKL_TXL_AR_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
27: org_id NUMBER := Okl_Api.G_MISS_NUM,
28: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
29: isl_id NUMBER := Okl_Api.G_MISS_NUM,
22: date_bill_period_end OKL_TXL_AR_INV_LNS_B.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
23: request_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_id NUMBER := Okl_Api.G_MISS_NUM,
26: program_update_date OKL_TXL_AR_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
27: org_id NUMBER := Okl_Api.G_MISS_NUM,
28: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
29: isl_id NUMBER := Okl_Api.G_MISS_NUM,
30: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
23: request_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_id NUMBER := Okl_Api.G_MISS_NUM,
26: program_update_date OKL_TXL_AR_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
27: org_id NUMBER := Okl_Api.G_MISS_NUM,
28: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
29: isl_id NUMBER := Okl_Api.G_MISS_NUM,
30: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
31: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
24: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_id NUMBER := Okl_Api.G_MISS_NUM,
26: program_update_date OKL_TXL_AR_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
27: org_id NUMBER := Okl_Api.G_MISS_NUM,
28: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
29: isl_id NUMBER := Okl_Api.G_MISS_NUM,
30: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
31: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
32: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
25: program_id NUMBER := Okl_Api.G_MISS_NUM,
26: program_update_date OKL_TXL_AR_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
27: org_id NUMBER := Okl_Api.G_MISS_NUM,
28: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
29: isl_id NUMBER := Okl_Api.G_MISS_NUM,
30: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
31: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
32: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
33: -- Start changes on remarketing by fmiao on 10/18/04 --
26: program_update_date OKL_TXL_AR_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
27: org_id NUMBER := Okl_Api.G_MISS_NUM,
28: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
29: isl_id NUMBER := Okl_Api.G_MISS_NUM,
30: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
31: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
32: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
33: -- Start changes on remarketing by fmiao on 10/18/04 --
34: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
27: org_id NUMBER := Okl_Api.G_MISS_NUM,
28: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
29: isl_id NUMBER := Okl_Api.G_MISS_NUM,
30: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
31: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
32: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
33: -- Start changes on remarketing by fmiao on 10/18/04 --
34: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
35: -- End changes on remarketing by fmiao on 10/18/04 --
28: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
29: isl_id NUMBER := Okl_Api.G_MISS_NUM,
30: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
31: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
32: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
33: -- Start changes on remarketing by fmiao on 10/18/04 --
34: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
35: -- End changes on remarketing by fmiao on 10/18/04 --
36: qte_line_id NUMBER := Okl_Api.G_MISS_NUM,
30: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
31: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
32: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
33: -- Start changes on remarketing by fmiao on 10/18/04 --
34: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
35: -- End changes on remarketing by fmiao on 10/18/04 --
36: qte_line_id NUMBER := Okl_Api.G_MISS_NUM,
37: txs_trx_id NUMBER := Okl_Api.G_MISS_NUM,
38: -- Start Bug 4673593
32: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
33: -- Start changes on remarketing by fmiao on 10/18/04 --
34: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
35: -- End changes on remarketing by fmiao on 10/18/04 --
36: qte_line_id NUMBER := Okl_Api.G_MISS_NUM,
37: txs_trx_id NUMBER := Okl_Api.G_MISS_NUM,
38: -- Start Bug 4673593
39: bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
40: -- End Bug 4673593
33: -- Start changes on remarketing by fmiao on 10/18/04 --
34: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
35: -- End changes on remarketing by fmiao on 10/18/04 --
36: qte_line_id NUMBER := Okl_Api.G_MISS_NUM,
37: txs_trx_id NUMBER := Okl_Api.G_MISS_NUM,
38: -- Start Bug 4673593
39: bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
40: -- End Bug 4673593
41: attribute_category OKL_TXL_AR_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
35: -- End changes on remarketing by fmiao on 10/18/04 --
36: qte_line_id NUMBER := Okl_Api.G_MISS_NUM,
37: txs_trx_id NUMBER := Okl_Api.G_MISS_NUM,
38: -- Start Bug 4673593
39: bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
40: -- End Bug 4673593
41: attribute_category OKL_TXL_AR_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute1 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
37: txs_trx_id NUMBER := Okl_Api.G_MISS_NUM,
38: -- Start Bug 4673593
39: bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
40: -- End Bug 4673593
41: attribute_category OKL_TXL_AR_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute1 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
38: -- Start Bug 4673593
39: bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
40: -- End Bug 4673593
41: attribute_category OKL_TXL_AR_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute1 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
39: bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
40: -- End Bug 4673593
41: attribute_category OKL_TXL_AR_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute1 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
40: -- End Bug 4673593
41: attribute_category OKL_TXL_AR_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute1 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute_category OKL_TXL_AR_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute1 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute1 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
50: attribute9 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
58: creation_date OKL_TXL_AR_INV_LNS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
51: attribute10 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
58: creation_date OKL_TXL_AR_INV_LNS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
52: attribute11 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
58: creation_date OKL_TXL_AR_INV_LNS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
60: last_update_date OKL_TXL_AR_INV_LNS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
53: attribute12 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
58: creation_date OKL_TXL_AR_INV_LNS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
60: last_update_date OKL_TXL_AR_INV_LNS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
54: attribute13 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
58: creation_date OKL_TXL_AR_INV_LNS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
60: last_update_date OKL_TXL_AR_INV_LNS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
62:
55: attribute14 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
58: creation_date OKL_TXL_AR_INV_LNS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
60: last_update_date OKL_TXL_AR_INV_LNS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
62:
63: -- start: 30-Jan-07 cklee Billing R12 project |
56: attribute15 OKL_TXL_AR_INV_LNS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
58: creation_date OKL_TXL_AR_INV_LNS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
60: last_update_date OKL_TXL_AR_INV_LNS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
62:
63: -- start: 30-Jan-07 cklee Billing R12 project |
64: TXL_AR_LINE_NUMBER OKL_TXL_AR_INV_LNS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_Api.G_MISS_NUM,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
58: creation_date OKL_TXL_AR_INV_LNS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
60: last_update_date OKL_TXL_AR_INV_LNS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
62:
63: -- start: 30-Jan-07 cklee Billing R12 project |
64: TXL_AR_LINE_NUMBER OKL_TXL_AR_INV_LNS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_Api.G_MISS_NUM,
65: TXS_TRX_LINE_ID OKL_TXL_AR_INV_LNS_B.TXS_TRX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM ,
60: last_update_date OKL_TXL_AR_INV_LNS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
62:
63: -- start: 30-Jan-07 cklee Billing R12 project |
64: TXL_AR_LINE_NUMBER OKL_TXL_AR_INV_LNS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_Api.G_MISS_NUM,
65: TXS_TRX_LINE_ID OKL_TXL_AR_INV_LNS_B.TXS_TRX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM ,
66: -- end: 30-Jan-07 cklee Billing R12 project |
67: TAX_LINE_ID OKL_TXL_AR_INV_LNS_B.TAX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM --14-May-08 sechawla 6619311
68: );
61: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
62:
63: -- start: 30-Jan-07 cklee Billing R12 project |
64: TXL_AR_LINE_NUMBER OKL_TXL_AR_INV_LNS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_Api.G_MISS_NUM,
65: TXS_TRX_LINE_ID OKL_TXL_AR_INV_LNS_B.TXS_TRX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM ,
66: -- end: 30-Jan-07 cklee Billing R12 project |
67: TAX_LINE_ID OKL_TXL_AR_INV_LNS_B.TAX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM --14-May-08 sechawla 6619311
68: );
69:
63: -- start: 30-Jan-07 cklee Billing R12 project |
64: TXL_AR_LINE_NUMBER OKL_TXL_AR_INV_LNS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_Api.G_MISS_NUM,
65: TXS_TRX_LINE_ID OKL_TXL_AR_INV_LNS_B.TXS_TRX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM ,
66: -- end: 30-Jan-07 cklee Billing R12 project |
67: TAX_LINE_ID OKL_TXL_AR_INV_LNS_B.TAX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM --14-May-08 sechawla 6619311
68: );
69:
70: g_miss_til_rec til_rec_type;
71: TYPE til_tbl_type IS TABLE OF til_rec_type
70: g_miss_til_rec til_rec_type;
71: TYPE til_tbl_type IS TABLE OF til_rec_type
72: INDEX BY BINARY_INTEGER;
73: TYPE okl_txl_ar_inv_lns_tl_rec_type IS RECORD (
74: id NUMBER := Okl_Api.G_MISS_NUM,
75: LANGUAGE OKL_TXL_AR_INV_LNS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
76: source_lang OKL_TXL_AR_INV_LNS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
77: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
78: sfwt_flag OKL_TXL_AR_INV_LNS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
71: TYPE til_tbl_type IS TABLE OF til_rec_type
72: INDEX BY BINARY_INTEGER;
73: TYPE okl_txl_ar_inv_lns_tl_rec_type IS RECORD (
74: id NUMBER := Okl_Api.G_MISS_NUM,
75: LANGUAGE OKL_TXL_AR_INV_LNS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
76: source_lang OKL_TXL_AR_INV_LNS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
77: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
78: sfwt_flag OKL_TXL_AR_INV_LNS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
79: description OKL_TXL_AR_INV_LNS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
72: INDEX BY BINARY_INTEGER;
73: TYPE okl_txl_ar_inv_lns_tl_rec_type IS RECORD (
74: id NUMBER := Okl_Api.G_MISS_NUM,
75: LANGUAGE OKL_TXL_AR_INV_LNS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
76: source_lang OKL_TXL_AR_INV_LNS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
77: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
78: sfwt_flag OKL_TXL_AR_INV_LNS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
79: description OKL_TXL_AR_INV_LNS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
80: created_by NUMBER := Okl_Api.G_MISS_NUM,
73: TYPE okl_txl_ar_inv_lns_tl_rec_type IS RECORD (
74: id NUMBER := Okl_Api.G_MISS_NUM,
75: LANGUAGE OKL_TXL_AR_INV_LNS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
76: source_lang OKL_TXL_AR_INV_LNS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
77: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
78: sfwt_flag OKL_TXL_AR_INV_LNS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
79: description OKL_TXL_AR_INV_LNS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
80: created_by NUMBER := Okl_Api.G_MISS_NUM,
81: creation_date OKL_TXL_AR_INV_LNS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
74: id NUMBER := Okl_Api.G_MISS_NUM,
75: LANGUAGE OKL_TXL_AR_INV_LNS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
76: source_lang OKL_TXL_AR_INV_LNS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
77: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
78: sfwt_flag OKL_TXL_AR_INV_LNS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
79: description OKL_TXL_AR_INV_LNS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
80: created_by NUMBER := Okl_Api.G_MISS_NUM,
81: creation_date OKL_TXL_AR_INV_LNS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
82: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
75: LANGUAGE OKL_TXL_AR_INV_LNS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
76: source_lang OKL_TXL_AR_INV_LNS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
77: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
78: sfwt_flag OKL_TXL_AR_INV_LNS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
79: description OKL_TXL_AR_INV_LNS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
80: created_by NUMBER := Okl_Api.G_MISS_NUM,
81: creation_date OKL_TXL_AR_INV_LNS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
82: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
83: last_update_date OKL_TXL_AR_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
76: source_lang OKL_TXL_AR_INV_LNS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
77: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
78: sfwt_flag OKL_TXL_AR_INV_LNS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
79: description OKL_TXL_AR_INV_LNS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
80: created_by NUMBER := Okl_Api.G_MISS_NUM,
81: creation_date OKL_TXL_AR_INV_LNS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
82: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
83: last_update_date OKL_TXL_AR_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
84: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
77: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
78: sfwt_flag OKL_TXL_AR_INV_LNS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
79: description OKL_TXL_AR_INV_LNS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
80: created_by NUMBER := Okl_Api.G_MISS_NUM,
81: creation_date OKL_TXL_AR_INV_LNS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
82: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
83: last_update_date OKL_TXL_AR_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
84: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
85: GMissOklTxlArInvLnsTlRec okl_txl_ar_inv_lns_tl_rec_type;
78: sfwt_flag OKL_TXL_AR_INV_LNS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
79: description OKL_TXL_AR_INV_LNS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
80: created_by NUMBER := Okl_Api.G_MISS_NUM,
81: creation_date OKL_TXL_AR_INV_LNS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
82: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
83: last_update_date OKL_TXL_AR_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
84: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
85: GMissOklTxlArInvLnsTlRec okl_txl_ar_inv_lns_tl_rec_type;
86: TYPE okl_txl_ar_inv_lns_tl_tbl_type IS TABLE OF okl_txl_ar_inv_lns_tl_rec_type
79: description OKL_TXL_AR_INV_LNS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
80: created_by NUMBER := Okl_Api.G_MISS_NUM,
81: creation_date OKL_TXL_AR_INV_LNS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
82: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
83: last_update_date OKL_TXL_AR_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
84: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
85: GMissOklTxlArInvLnsTlRec okl_txl_ar_inv_lns_tl_rec_type;
86: TYPE okl_txl_ar_inv_lns_tl_tbl_type IS TABLE OF okl_txl_ar_inv_lns_tl_rec_type
87: INDEX BY BINARY_INTEGER;
80: created_by NUMBER := Okl_Api.G_MISS_NUM,
81: creation_date OKL_TXL_AR_INV_LNS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
82: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
83: last_update_date OKL_TXL_AR_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
84: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
85: GMissOklTxlArInvLnsTlRec okl_txl_ar_inv_lns_tl_rec_type;
86: TYPE okl_txl_ar_inv_lns_tl_tbl_type IS TABLE OF okl_txl_ar_inv_lns_tl_rec_type
87: INDEX BY BINARY_INTEGER;
88: TYPE tilv_rec_type IS RECORD (
85: GMissOklTxlArInvLnsTlRec okl_txl_ar_inv_lns_tl_rec_type;
86: TYPE okl_txl_ar_inv_lns_tl_tbl_type IS TABLE OF okl_txl_ar_inv_lns_tl_rec_type
87: INDEX BY BINARY_INTEGER;
88: TYPE tilv_rec_type IS RECORD (
89: id NUMBER := Okl_Api.G_MISS_NUM,
90: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
91: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
92: sfwt_flag OKL_TXL_AR_INV_LNS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
93: kle_id NUMBER := Okl_Api.G_MISS_NUM,
86: TYPE okl_txl_ar_inv_lns_tl_tbl_type IS TABLE OF okl_txl_ar_inv_lns_tl_rec_type
87: INDEX BY BINARY_INTEGER;
88: TYPE tilv_rec_type IS RECORD (
89: id NUMBER := Okl_Api.G_MISS_NUM,
90: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
91: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
92: sfwt_flag OKL_TXL_AR_INV_LNS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
93: kle_id NUMBER := Okl_Api.G_MISS_NUM,
94: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
87: INDEX BY BINARY_INTEGER;
88: TYPE tilv_rec_type IS RECORD (
89: id NUMBER := Okl_Api.G_MISS_NUM,
90: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
91: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
92: sfwt_flag OKL_TXL_AR_INV_LNS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
93: kle_id NUMBER := Okl_Api.G_MISS_NUM,
94: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
95: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
88: TYPE tilv_rec_type IS RECORD (
89: id NUMBER := Okl_Api.G_MISS_NUM,
90: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
91: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
92: sfwt_flag OKL_TXL_AR_INV_LNS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
93: kle_id NUMBER := Okl_Api.G_MISS_NUM,
94: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
95: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
96: inv_receiv_line_code OKL_TXL_AR_INV_LNS_V.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
89: id NUMBER := Okl_Api.G_MISS_NUM,
90: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
91: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
92: sfwt_flag OKL_TXL_AR_INV_LNS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
93: kle_id NUMBER := Okl_Api.G_MISS_NUM,
94: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
95: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
96: inv_receiv_line_code OKL_TXL_AR_INV_LNS_V.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
97: sty_id NUMBER := Okl_Api.G_MISS_NUM,
90: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
91: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
92: sfwt_flag OKL_TXL_AR_INV_LNS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
93: kle_id NUMBER := Okl_Api.G_MISS_NUM,
94: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
95: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
96: inv_receiv_line_code OKL_TXL_AR_INV_LNS_V.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
97: sty_id NUMBER := Okl_Api.G_MISS_NUM,
98: tai_id NUMBER := Okl_Api.G_MISS_NUM,
91: ERROR_MESSAGE OKL_TXL_AR_INV_LNS_TL.ERROR_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
92: sfwt_flag OKL_TXL_AR_INV_LNS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
93: kle_id NUMBER := Okl_Api.G_MISS_NUM,
94: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
95: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
96: inv_receiv_line_code OKL_TXL_AR_INV_LNS_V.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
97: sty_id NUMBER := Okl_Api.G_MISS_NUM,
98: tai_id NUMBER := Okl_Api.G_MISS_NUM,
99: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
92: sfwt_flag OKL_TXL_AR_INV_LNS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
93: kle_id NUMBER := Okl_Api.G_MISS_NUM,
94: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
95: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
96: inv_receiv_line_code OKL_TXL_AR_INV_LNS_V.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
97: sty_id NUMBER := Okl_Api.G_MISS_NUM,
98: tai_id NUMBER := Okl_Api.G_MISS_NUM,
99: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
100: amount NUMBER := Okl_Api.G_MISS_NUM,
93: kle_id NUMBER := Okl_Api.G_MISS_NUM,
94: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
95: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
96: inv_receiv_line_code OKL_TXL_AR_INV_LNS_V.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
97: sty_id NUMBER := Okl_Api.G_MISS_NUM,
98: tai_id NUMBER := Okl_Api.G_MISS_NUM,
99: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
100: amount NUMBER := Okl_Api.G_MISS_NUM,
101: line_number NUMBER := Okl_Api.G_MISS_NUM,
94: tpl_id NUMBER := Okl_Api.G_MISS_NUM,
95: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
96: inv_receiv_line_code OKL_TXL_AR_INV_LNS_V.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
97: sty_id NUMBER := Okl_Api.G_MISS_NUM,
98: tai_id NUMBER := Okl_Api.G_MISS_NUM,
99: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
100: amount NUMBER := Okl_Api.G_MISS_NUM,
101: line_number NUMBER := Okl_Api.G_MISS_NUM,
102: quantity NUMBER := Okl_Api.G_MISS_NUM,
95: til_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
96: inv_receiv_line_code OKL_TXL_AR_INV_LNS_V.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
97: sty_id NUMBER := Okl_Api.G_MISS_NUM,
98: tai_id NUMBER := Okl_Api.G_MISS_NUM,
99: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
100: amount NUMBER := Okl_Api.G_MISS_NUM,
101: line_number NUMBER := Okl_Api.G_MISS_NUM,
102: quantity NUMBER := Okl_Api.G_MISS_NUM,
103: description OKL_TXL_AR_INV_LNS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
96: inv_receiv_line_code OKL_TXL_AR_INV_LNS_V.INV_RECEIV_LINE_CODE%TYPE := Okl_Api.G_MISS_CHAR,
97: sty_id NUMBER := Okl_Api.G_MISS_NUM,
98: tai_id NUMBER := Okl_Api.G_MISS_NUM,
99: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
100: amount NUMBER := Okl_Api.G_MISS_NUM,
101: line_number NUMBER := Okl_Api.G_MISS_NUM,
102: quantity NUMBER := Okl_Api.G_MISS_NUM,
103: description OKL_TXL_AR_INV_LNS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
104: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
97: sty_id NUMBER := Okl_Api.G_MISS_NUM,
98: tai_id NUMBER := Okl_Api.G_MISS_NUM,
99: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
100: amount NUMBER := Okl_Api.G_MISS_NUM,
101: line_number NUMBER := Okl_Api.G_MISS_NUM,
102: quantity NUMBER := Okl_Api.G_MISS_NUM,
103: description OKL_TXL_AR_INV_LNS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
104: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
105: date_bill_period_start OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
98: tai_id NUMBER := Okl_Api.G_MISS_NUM,
99: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
100: amount NUMBER := Okl_Api.G_MISS_NUM,
101: line_number NUMBER := Okl_Api.G_MISS_NUM,
102: quantity NUMBER := Okl_Api.G_MISS_NUM,
103: description OKL_TXL_AR_INV_LNS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
104: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
105: date_bill_period_start OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
106: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
99: acn_id_cost NUMBER := Okl_Api.G_MISS_NUM,
100: amount NUMBER := Okl_Api.G_MISS_NUM,
101: line_number NUMBER := Okl_Api.G_MISS_NUM,
102: quantity NUMBER := Okl_Api.G_MISS_NUM,
103: description OKL_TXL_AR_INV_LNS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
104: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
105: date_bill_period_start OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
106: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
107: date_bill_period_end OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
100: amount NUMBER := Okl_Api.G_MISS_NUM,
101: line_number NUMBER := Okl_Api.G_MISS_NUM,
102: quantity NUMBER := Okl_Api.G_MISS_NUM,
103: description OKL_TXL_AR_INV_LNS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
104: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
105: date_bill_period_start OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
106: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
107: date_bill_period_end OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
108: isl_id NUMBER := Okl_Api.G_MISS_NUM,
101: line_number NUMBER := Okl_Api.G_MISS_NUM,
102: quantity NUMBER := Okl_Api.G_MISS_NUM,
103: description OKL_TXL_AR_INV_LNS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
104: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
105: date_bill_period_start OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
106: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
107: date_bill_period_end OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
108: isl_id NUMBER := Okl_Api.G_MISS_NUM,
109: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
102: quantity NUMBER := Okl_Api.G_MISS_NUM,
103: description OKL_TXL_AR_INV_LNS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
104: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
105: date_bill_period_start OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
106: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
107: date_bill_period_end OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
108: isl_id NUMBER := Okl_Api.G_MISS_NUM,
109: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
110: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
103: description OKL_TXL_AR_INV_LNS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
104: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
105: date_bill_period_start OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
106: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
107: date_bill_period_end OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
108: isl_id NUMBER := Okl_Api.G_MISS_NUM,
109: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
110: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
111: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
104: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
105: date_bill_period_start OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
106: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
107: date_bill_period_end OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
108: isl_id NUMBER := Okl_Api.G_MISS_NUM,
109: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
110: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
111: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
112: -- Start changes on remarketing by fmiao on 10/18/04 --
105: date_bill_period_start OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_START%TYPE := Okl_Api.G_MISS_DATE,
106: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
107: date_bill_period_end OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
108: isl_id NUMBER := Okl_Api.G_MISS_NUM,
109: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
110: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
111: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
112: -- Start changes on remarketing by fmiao on 10/18/04 --
113: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
106: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
107: date_bill_period_end OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
108: isl_id NUMBER := Okl_Api.G_MISS_NUM,
109: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
110: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
111: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
112: -- Start changes on remarketing by fmiao on 10/18/04 --
113: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
114: -- End changes on remarketing by fmiao on 10/18/04 --
107: date_bill_period_end OKL_TXL_AR_INV_LNS_V.DATE_BILL_PERIOD_END%TYPE := Okl_Api.G_MISS_DATE,
108: isl_id NUMBER := Okl_Api.G_MISS_NUM,
109: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
110: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
111: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
112: -- Start changes on remarketing by fmiao on 10/18/04 --
113: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
114: -- End changes on remarketing by fmiao on 10/18/04 --
115: qte_line_id NUMBER := Okl_Api.G_MISS_NUM,
109: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
110: LATE_CHARGE_REC_ID NUMBER := Okl_Api.G_MISS_NUM,
111: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
112: -- Start changes on remarketing by fmiao on 10/18/04 --
113: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
114: -- End changes on remarketing by fmiao on 10/18/04 --
115: qte_line_id NUMBER := Okl_Api.G_MISS_NUM,
116: txs_trx_id NUMBER := Okl_Api.G_MISS_NUM,
117: -- Start Bug 4594310
111: CLL_ID NUMBER := Okl_Api.G_MISS_NUM,
112: -- Start changes on remarketing by fmiao on 10/18/04 --
113: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
114: -- End changes on remarketing by fmiao on 10/18/04 --
115: qte_line_id NUMBER := Okl_Api.G_MISS_NUM,
116: txs_trx_id NUMBER := Okl_Api.G_MISS_NUM,
117: -- Start Bug 4594310
118: bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
119: -- End Bug 4594310
112: -- Start changes on remarketing by fmiao on 10/18/04 --
113: inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
114: -- End changes on remarketing by fmiao on 10/18/04 --
115: qte_line_id NUMBER := Okl_Api.G_MISS_NUM,
116: txs_trx_id NUMBER := Okl_Api.G_MISS_NUM,
117: -- Start Bug 4594310
118: bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
119: -- End Bug 4594310
120: attribute_category OKL_TXL_AR_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: -- End changes on remarketing by fmiao on 10/18/04 --
115: qte_line_id NUMBER := Okl_Api.G_MISS_NUM,
116: txs_trx_id NUMBER := Okl_Api.G_MISS_NUM,
117: -- Start Bug 4594310
118: bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
119: -- End Bug 4594310
120: attribute_category OKL_TXL_AR_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute1 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute2 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: txs_trx_id NUMBER := Okl_Api.G_MISS_NUM,
117: -- Start Bug 4594310
118: bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
119: -- End Bug 4594310
120: attribute_category OKL_TXL_AR_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute1 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute2 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute3 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute4 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
117: -- Start Bug 4594310
118: bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
119: -- End Bug 4594310
120: attribute_category OKL_TXL_AR_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute1 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute2 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute3 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute4 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute5 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
118: bank_acct_id NUMBER := Okl_Api.G_MISS_NUM,
119: -- End Bug 4594310
120: attribute_category OKL_TXL_AR_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute1 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute2 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute3 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute4 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute5 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute6 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
119: -- End Bug 4594310
120: attribute_category OKL_TXL_AR_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute1 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute2 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute3 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute4 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute5 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute6 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute7 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute_category OKL_TXL_AR_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute1 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute2 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute3 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute4 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute5 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute6 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute7 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute8 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute1 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute2 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute3 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute4 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute5 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute6 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute7 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute8 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
129: attribute9 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute2 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute3 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute4 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute5 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute6 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute7 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute8 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
129: attribute9 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
130: attribute10 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute3 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute4 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute5 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute6 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute7 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute8 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
129: attribute9 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
130: attribute10 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
131: attribute11 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute4 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute5 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute6 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute7 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute8 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
129: attribute9 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
130: attribute10 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
131: attribute11 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
132: attribute12 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute5 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute6 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute7 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute8 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
129: attribute9 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
130: attribute10 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
131: attribute11 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
132: attribute12 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
133: attribute13 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute6 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute7 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute8 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
129: attribute9 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
130: attribute10 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
131: attribute11 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
132: attribute12 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
133: attribute13 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
134: attribute14 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute7 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute8 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
129: attribute9 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
130: attribute10 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
131: attribute11 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
132: attribute12 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
133: attribute13 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
134: attribute14 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
135: attribute15 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute8 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
129: attribute9 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
130: attribute10 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
131: attribute11 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
132: attribute12 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
133: attribute13 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
134: attribute14 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
135: attribute15 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
136: request_id NUMBER := Okl_Api.G_MISS_NUM,
129: attribute9 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
130: attribute10 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
131: attribute11 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
132: attribute12 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
133: attribute13 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
134: attribute14 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
135: attribute15 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
136: request_id NUMBER := Okl_Api.G_MISS_NUM,
137: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
130: attribute10 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
131: attribute11 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
132: attribute12 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
133: attribute13 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
134: attribute14 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
135: attribute15 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
136: request_id NUMBER := Okl_Api.G_MISS_NUM,
137: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
138: program_id NUMBER := Okl_Api.G_MISS_NUM,
131: attribute11 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
132: attribute12 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
133: attribute13 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
134: attribute14 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
135: attribute15 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
136: request_id NUMBER := Okl_Api.G_MISS_NUM,
137: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
138: program_id NUMBER := Okl_Api.G_MISS_NUM,
139: program_update_date OKL_TXL_AR_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
132: attribute12 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
133: attribute13 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
134: attribute14 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
135: attribute15 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
136: request_id NUMBER := Okl_Api.G_MISS_NUM,
137: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
138: program_id NUMBER := Okl_Api.G_MISS_NUM,
139: program_update_date OKL_TXL_AR_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
140: org_id NUMBER := Okl_Api.G_MISS_NUM,
133: attribute13 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
134: attribute14 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
135: attribute15 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
136: request_id NUMBER := Okl_Api.G_MISS_NUM,
137: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
138: program_id NUMBER := Okl_Api.G_MISS_NUM,
139: program_update_date OKL_TXL_AR_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
140: org_id NUMBER := Okl_Api.G_MISS_NUM,
141: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
134: attribute14 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
135: attribute15 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
136: request_id NUMBER := Okl_Api.G_MISS_NUM,
137: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
138: program_id NUMBER := Okl_Api.G_MISS_NUM,
139: program_update_date OKL_TXL_AR_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
140: org_id NUMBER := Okl_Api.G_MISS_NUM,
141: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
142: created_by NUMBER := Okl_Api.G_MISS_NUM,
135: attribute15 OKL_TXL_AR_INV_LNS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
136: request_id NUMBER := Okl_Api.G_MISS_NUM,
137: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
138: program_id NUMBER := Okl_Api.G_MISS_NUM,
139: program_update_date OKL_TXL_AR_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
140: org_id NUMBER := Okl_Api.G_MISS_NUM,
141: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
142: created_by NUMBER := Okl_Api.G_MISS_NUM,
143: creation_date OKL_TXL_AR_INV_LNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
136: request_id NUMBER := Okl_Api.G_MISS_NUM,
137: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
138: program_id NUMBER := Okl_Api.G_MISS_NUM,
139: program_update_date OKL_TXL_AR_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
140: org_id NUMBER := Okl_Api.G_MISS_NUM,
141: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
142: created_by NUMBER := Okl_Api.G_MISS_NUM,
143: creation_date OKL_TXL_AR_INV_LNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
144: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
137: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
138: program_id NUMBER := Okl_Api.G_MISS_NUM,
139: program_update_date OKL_TXL_AR_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
140: org_id NUMBER := Okl_Api.G_MISS_NUM,
141: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
142: created_by NUMBER := Okl_Api.G_MISS_NUM,
143: creation_date OKL_TXL_AR_INV_LNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
144: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
145: last_update_date OKL_TXL_AR_INV_LNS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
138: program_id NUMBER := Okl_Api.G_MISS_NUM,
139: program_update_date OKL_TXL_AR_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
140: org_id NUMBER := Okl_Api.G_MISS_NUM,
141: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
142: created_by NUMBER := Okl_Api.G_MISS_NUM,
143: creation_date OKL_TXL_AR_INV_LNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
144: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
145: last_update_date OKL_TXL_AR_INV_LNS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
146: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
139: program_update_date OKL_TXL_AR_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
140: org_id NUMBER := Okl_Api.G_MISS_NUM,
141: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
142: created_by NUMBER := Okl_Api.G_MISS_NUM,
143: creation_date OKL_TXL_AR_INV_LNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
144: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
145: last_update_date OKL_TXL_AR_INV_LNS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
146: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
147:
140: org_id NUMBER := Okl_Api.G_MISS_NUM,
141: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
142: created_by NUMBER := Okl_Api.G_MISS_NUM,
143: creation_date OKL_TXL_AR_INV_LNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
144: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
145: last_update_date OKL_TXL_AR_INV_LNS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
146: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
147:
148: -- start: 30-Jan-07 cklee Billing R12 project |
141: inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
142: created_by NUMBER := Okl_Api.G_MISS_NUM,
143: creation_date OKL_TXL_AR_INV_LNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
144: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
145: last_update_date OKL_TXL_AR_INV_LNS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
146: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
147:
148: -- start: 30-Jan-07 cklee Billing R12 project |
149: TXL_AR_LINE_NUMBER OKL_TXL_AR_INV_LNS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_Api.G_MISS_NUM,
142: created_by NUMBER := Okl_Api.G_MISS_NUM,
143: creation_date OKL_TXL_AR_INV_LNS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
144: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
145: last_update_date OKL_TXL_AR_INV_LNS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
146: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
147:
148: -- start: 30-Jan-07 cklee Billing R12 project |
149: TXL_AR_LINE_NUMBER OKL_TXL_AR_INV_LNS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_Api.G_MISS_NUM,
150: TXS_TRX_LINE_ID OKL_TXL_AR_INV_LNS_B.TXS_TRX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM,
145: last_update_date OKL_TXL_AR_INV_LNS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
146: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
147:
148: -- start: 30-Jan-07 cklee Billing R12 project |
149: TXL_AR_LINE_NUMBER OKL_TXL_AR_INV_LNS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_Api.G_MISS_NUM,
150: TXS_TRX_LINE_ID OKL_TXL_AR_INV_LNS_B.TXS_TRX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM,
151: -- end: 30-Jan-07 cklee Billing R12 project
152: TAX_LINE_ID OKL_TXL_AR_INV_LNS_B.TAX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM --14-May-08 sechawla 6619311 |
153: );
146: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
147:
148: -- start: 30-Jan-07 cklee Billing R12 project |
149: TXL_AR_LINE_NUMBER OKL_TXL_AR_INV_LNS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_Api.G_MISS_NUM,
150: TXS_TRX_LINE_ID OKL_TXL_AR_INV_LNS_B.TXS_TRX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM,
151: -- end: 30-Jan-07 cklee Billing R12 project
152: TAX_LINE_ID OKL_TXL_AR_INV_LNS_B.TAX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM --14-May-08 sechawla 6619311 |
153: );
154: g_miss_tilv_rec tilv_rec_type;
148: -- start: 30-Jan-07 cklee Billing R12 project |
149: TXL_AR_LINE_NUMBER OKL_TXL_AR_INV_LNS_B.TXL_AR_LINE_NUMBER%TYPE := Okl_Api.G_MISS_NUM,
150: TXS_TRX_LINE_ID OKL_TXL_AR_INV_LNS_B.TXS_TRX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM,
151: -- end: 30-Jan-07 cklee Billing R12 project
152: TAX_LINE_ID OKL_TXL_AR_INV_LNS_B.TAX_LINE_ID%TYPE := Okl_Api.G_MISS_NUM --14-May-08 sechawla 6619311 |
153: );
154: g_miss_tilv_rec tilv_rec_type;
155: TYPE tilv_tbl_type IS TABLE OF tilv_rec_type
156: INDEX BY BINARY_INTEGER;
156: INDEX BY BINARY_INTEGER;
157: ---------------------------------------------------------------------------
158: -- GLOBAL MESSAGE CONSTANTS
159: ---------------------------------------------------------------------------
160: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
161: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
162: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
163: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
164: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
157: ---------------------------------------------------------------------------
158: -- GLOBAL MESSAGE CONSTANTS
159: ---------------------------------------------------------------------------
160: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
161: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
162: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
163: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
164: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
165: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
158: -- GLOBAL MESSAGE CONSTANTS
159: ---------------------------------------------------------------------------
160: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
161: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
162: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
163: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
164: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
165: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
166: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
159: ---------------------------------------------------------------------------
160: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
161: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
162: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
163: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
164: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
165: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
166: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
167: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
160: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
161: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
162: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
163: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
164: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
165: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
166: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
167: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
168: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
161: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
162: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
163: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
164: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
165: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
166: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
167: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
168: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
169: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
162: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
163: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
164: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
165: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
166: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
167: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
168: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
169: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
170: ---------------------------------------------------------------------------
163: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
164: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
165: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
166: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
167: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
168: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
169: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
170: ---------------------------------------------------------------------------
171: -- GLOBAL VARIABLES
164: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
165: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
166: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
167: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
168: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
169: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
170: ---------------------------------------------------------------------------
171: -- GLOBAL VARIABLES
172: ---------------------------------------------------------------------------
165: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
166: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
167: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
168: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
169: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
170: ---------------------------------------------------------------------------
171: -- GLOBAL VARIABLES
172: ---------------------------------------------------------------------------
173: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TIL_PVT';
170: ---------------------------------------------------------------------------
171: -- GLOBAL VARIABLES
172: ---------------------------------------------------------------------------
173: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TIL_PVT';
174: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
175:
176: /******************ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001) ****************/
177: --GLOBAL MESSAGES
178: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
203: PROCEDURE api_copy;
204: PROCEDURE add_language;
205: PROCEDURE insert_row(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_tilv_rec IN tilv_rec_type,
212: x_tilv_rec OUT NOCOPY tilv_rec_type);
213:
214: PROCEDURE insert_row(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_tilv_tbl IN tilv_tbl_type,
221: x_tilv_tbl OUT NOCOPY tilv_tbl_type);
222:
223: PROCEDURE lock_row(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_tilv_rec IN tilv_rec_type);
229: p_tilv_rec IN tilv_rec_type);
230:
231: PROCEDURE lock_row(
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_tilv_tbl IN tilv_tbl_type);
237: p_tilv_tbl IN tilv_tbl_type);
238:
239: PROCEDURE update_row(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_tilv_rec IN tilv_rec_type,
246: x_tilv_rec OUT NOCOPY tilv_rec_type);
247:
248: PROCEDURE update_row(
249: p_api_version IN NUMBER,
250: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_tilv_tbl IN tilv_tbl_type,
255: x_tilv_tbl OUT NOCOPY tilv_tbl_type);
256:
257: PROCEDURE delete_row(
258: p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,
262: x_msg_data OUT NOCOPY VARCHAR2,
263: p_tilv_rec IN tilv_rec_type);
263: p_tilv_rec IN tilv_rec_type);
264:
265: PROCEDURE delete_row(
266: p_api_version IN NUMBER,
267: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
268: x_return_status OUT NOCOPY VARCHAR2,
269: x_msg_count OUT NOCOPY NUMBER,
270: x_msg_data OUT NOCOPY VARCHAR2,
271: p_tilv_tbl IN tilv_tbl_type);
271: p_tilv_tbl IN tilv_tbl_type);
272:
273: PROCEDURE validate_row(
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,
279: p_tilv_rec IN tilv_rec_type);
279: p_tilv_rec IN tilv_rec_type);
280:
281: PROCEDURE validate_row(
282: p_api_version IN NUMBER,
283: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
284: x_return_status OUT NOCOPY VARCHAR2,
285: x_msg_count OUT NOCOPY NUMBER,
286: x_msg_data OUT NOCOPY VARCHAR2,
287: p_tilv_tbl IN tilv_tbl_type);