4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE tai_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: currency_code OKL_TRX_AR_INVOICES_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
9: currency_conversion_type OKL_TRX_AR_INVOICES_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
10: currency_conversion_rate OKL_TRX_AR_INVOICES_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
11: currency_conversion_date OKL_TRX_AR_INVOICES_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
12: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE tai_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: currency_code OKL_TRX_AR_INVOICES_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
9: currency_conversion_type OKL_TRX_AR_INVOICES_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
10: currency_conversion_rate OKL_TRX_AR_INVOICES_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
11: currency_conversion_date OKL_TRX_AR_INVOICES_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
12: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
13: ixx_id NUMBER := Okl_Api.G_MISS_NUM,
6: TYPE tai_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: currency_code OKL_TRX_AR_INVOICES_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
9: currency_conversion_type OKL_TRX_AR_INVOICES_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
10: currency_conversion_rate OKL_TRX_AR_INVOICES_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
11: currency_conversion_date OKL_TRX_AR_INVOICES_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
12: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
13: ixx_id NUMBER := Okl_Api.G_MISS_NUM,
14: khr_id NUMBER := Okl_Api.G_MISS_NUM,
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: currency_code OKL_TRX_AR_INVOICES_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
9: currency_conversion_type OKL_TRX_AR_INVOICES_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
10: currency_conversion_rate OKL_TRX_AR_INVOICES_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
11: currency_conversion_date OKL_TRX_AR_INVOICES_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
12: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
13: ixx_id NUMBER := Okl_Api.G_MISS_NUM,
14: khr_id NUMBER := Okl_Api.G_MISS_NUM,
15: irm_id NUMBER := Okl_Api.G_MISS_NUM,
20: qte_id NUMBER := Okl_Api.G_MISS_NUM,
21: tcn_id NUMBER := Okl_Api.G_MISS_NUM,
22: tai_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
23: ipy_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
24: trx_status_code OKL_TRX_AR_INVOICES_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
25: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
26: try_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
27: date_entered OKL_TRX_AR_INVOICES_B.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
28: date_invoiced OKL_TRX_AR_INVOICES_B.DATE_INVOICED%TYPE := Okl_Api.G_MISS_DATE,
23: ipy_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
24: trx_status_code OKL_TRX_AR_INVOICES_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
25: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
26: try_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
27: date_entered OKL_TRX_AR_INVOICES_B.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
28: date_invoiced OKL_TRX_AR_INVOICES_B.DATE_INVOICED%TYPE := Okl_Api.G_MISS_DATE,
29: amount NUMBER := Okl_Api.G_MISS_NUM,
30: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
31: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
24: trx_status_code OKL_TRX_AR_INVOICES_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
25: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
26: try_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
27: date_entered OKL_TRX_AR_INVOICES_B.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
28: date_invoiced OKL_TRX_AR_INVOICES_B.DATE_INVOICED%TYPE := Okl_Api.G_MISS_DATE,
29: amount NUMBER := Okl_Api.G_MISS_NUM,
30: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
31: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
32: request_id NUMBER := Okl_Api.G_MISS_NUM,
31: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
32: request_id NUMBER := Okl_Api.G_MISS_NUM,
33: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
34: program_id NUMBER := Okl_Api.G_MISS_NUM,
35: program_update_date OKL_TRX_AR_INVOICES_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
36: org_id NUMBER := Okl_Api.G_MISS_NUM,
37: TRX_NUMBER OKL_TRX_AR_INVOICES_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
38: CLG_ID NUMBER := Okl_Api.G_MISS_NUM,
39: POX_ID NUMBER := Okl_Api.G_MISS_NUM,
33: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
34: program_id NUMBER := Okl_Api.G_MISS_NUM,
35: program_update_date OKL_TRX_AR_INVOICES_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
36: org_id NUMBER := Okl_Api.G_MISS_NUM,
37: TRX_NUMBER OKL_TRX_AR_INVOICES_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
38: CLG_ID NUMBER := Okl_Api.G_MISS_NUM,
39: POX_ID NUMBER := Okl_Api.G_MISS_NUM,
40: CPY_ID NUMBER := Okl_Api.G_MISS_NUM,
41: attribute_category OKL_TRX_AR_INVOICES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
37: TRX_NUMBER OKL_TRX_AR_INVOICES_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
38: CLG_ID NUMBER := Okl_Api.G_MISS_NUM,
39: POX_ID NUMBER := Okl_Api.G_MISS_NUM,
40: CPY_ID NUMBER := Okl_Api.G_MISS_NUM,
41: attribute_category OKL_TRX_AR_INVOICES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute1 OKL_TRX_AR_INVOICES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TRX_AR_INVOICES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TRX_AR_INVOICES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TRX_AR_INVOICES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
38: CLG_ID NUMBER := Okl_Api.G_MISS_NUM,
39: POX_ID NUMBER := Okl_Api.G_MISS_NUM,
40: CPY_ID NUMBER := Okl_Api.G_MISS_NUM,
41: attribute_category OKL_TRX_AR_INVOICES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute1 OKL_TRX_AR_INVOICES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TRX_AR_INVOICES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TRX_AR_INVOICES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TRX_AR_INVOICES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TRX_AR_INVOICES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
39: POX_ID NUMBER := Okl_Api.G_MISS_NUM,
40: CPY_ID NUMBER := Okl_Api.G_MISS_NUM,
41: attribute_category OKL_TRX_AR_INVOICES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute1 OKL_TRX_AR_INVOICES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TRX_AR_INVOICES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TRX_AR_INVOICES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TRX_AR_INVOICES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TRX_AR_INVOICES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TRX_AR_INVOICES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
40: CPY_ID NUMBER := Okl_Api.G_MISS_NUM,
41: attribute_category OKL_TRX_AR_INVOICES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute1 OKL_TRX_AR_INVOICES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TRX_AR_INVOICES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TRX_AR_INVOICES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TRX_AR_INVOICES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TRX_AR_INVOICES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TRX_AR_INVOICES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TRX_AR_INVOICES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute_category OKL_TRX_AR_INVOICES_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute1 OKL_TRX_AR_INVOICES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TRX_AR_INVOICES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TRX_AR_INVOICES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TRX_AR_INVOICES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TRX_AR_INVOICES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TRX_AR_INVOICES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TRX_AR_INVOICES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TRX_AR_INVOICES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute1 OKL_TRX_AR_INVOICES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TRX_AR_INVOICES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TRX_AR_INVOICES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TRX_AR_INVOICES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TRX_AR_INVOICES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TRX_AR_INVOICES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TRX_AR_INVOICES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TRX_AR_INVOICES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TRX_AR_INVOICES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute2 OKL_TRX_AR_INVOICES_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TRX_AR_INVOICES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TRX_AR_INVOICES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TRX_AR_INVOICES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TRX_AR_INVOICES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TRX_AR_INVOICES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TRX_AR_INVOICES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TRX_AR_INVOICES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TRX_AR_INVOICES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute3 OKL_TRX_AR_INVOICES_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TRX_AR_INVOICES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TRX_AR_INVOICES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TRX_AR_INVOICES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TRX_AR_INVOICES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TRX_AR_INVOICES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TRX_AR_INVOICES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TRX_AR_INVOICES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TRX_AR_INVOICES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute4 OKL_TRX_AR_INVOICES_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TRX_AR_INVOICES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TRX_AR_INVOICES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TRX_AR_INVOICES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TRX_AR_INVOICES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TRX_AR_INVOICES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TRX_AR_INVOICES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TRX_AR_INVOICES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TRX_AR_INVOICES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute5 OKL_TRX_AR_INVOICES_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TRX_AR_INVOICES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TRX_AR_INVOICES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TRX_AR_INVOICES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TRX_AR_INVOICES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TRX_AR_INVOICES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TRX_AR_INVOICES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TRX_AR_INVOICES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TRX_AR_INVOICES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute6 OKL_TRX_AR_INVOICES_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TRX_AR_INVOICES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TRX_AR_INVOICES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TRX_AR_INVOICES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TRX_AR_INVOICES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TRX_AR_INVOICES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TRX_AR_INVOICES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TRX_AR_INVOICES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TRX_AR_INVOICES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute7 OKL_TRX_AR_INVOICES_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TRX_AR_INVOICES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TRX_AR_INVOICES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TRX_AR_INVOICES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TRX_AR_INVOICES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TRX_AR_INVOICES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TRX_AR_INVOICES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TRX_AR_INVOICES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TRX_AR_INVOICES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute8 OKL_TRX_AR_INVOICES_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute9 OKL_TRX_AR_INVOICES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TRX_AR_INVOICES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TRX_AR_INVOICES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TRX_AR_INVOICES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TRX_AR_INVOICES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TRX_AR_INVOICES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TRX_AR_INVOICES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
50: attribute9 OKL_TRX_AR_INVOICES_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
51: attribute10 OKL_TRX_AR_INVOICES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TRX_AR_INVOICES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TRX_AR_INVOICES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TRX_AR_INVOICES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TRX_AR_INVOICES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TRX_AR_INVOICES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
58: creation_date OKL_TRX_AR_INVOICES_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
51: attribute10 OKL_TRX_AR_INVOICES_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
52: attribute11 OKL_TRX_AR_INVOICES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TRX_AR_INVOICES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TRX_AR_INVOICES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TRX_AR_INVOICES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TRX_AR_INVOICES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
58: creation_date OKL_TRX_AR_INVOICES_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
52: attribute11 OKL_TRX_AR_INVOICES_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
53: attribute12 OKL_TRX_AR_INVOICES_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
54: attribute13 OKL_TRX_AR_INVOICES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TRX_AR_INVOICES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TRX_AR_INVOICES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
58: creation_date OKL_TRX_AR_INVOICES_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
60: last_update_date OKL_TRX_AR_INVOICES_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
54: attribute13 OKL_TRX_AR_INVOICES_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
55: attribute14 OKL_TRX_AR_INVOICES_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
56: attribute15 OKL_TRX_AR_INVOICES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
58: creation_date OKL_TRX_AR_INVOICES_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
60: last_update_date OKL_TRX_AR_INVOICES_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
62: legal_entity_id OKL_TRX_AR_INVOICES_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM, -- for LE Uptake project 08-11-2006
56: attribute15 OKL_TRX_AR_INVOICES_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
57: created_by NUMBER := Okl_Api.G_MISS_NUM,
58: creation_date OKL_TRX_AR_INVOICES_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
60: last_update_date OKL_TRX_AR_INVOICES_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
62: legal_entity_id OKL_TRX_AR_INVOICES_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM, -- for LE Uptake project 08-11-2006
63:
64:
58: creation_date OKL_TRX_AR_INVOICES_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
59: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
60: last_update_date OKL_TRX_AR_INVOICES_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
61: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
62: legal_entity_id OKL_TRX_AR_INVOICES_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM, -- for LE Uptake project 08-11-2006
63:
64:
65: -- start:30-Jan-07 cklee Billing R12 project
66: Investor_Agreement_Number OKL_TRX_AR_INVOICES_B.Investor_Agreement_Number%TYPE := Okl_Api.G_MISS_CHAR,
62: legal_entity_id OKL_TRX_AR_INVOICES_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM, -- for LE Uptake project 08-11-2006
63:
64:
65: -- start:30-Jan-07 cklee Billing R12 project
66: Investor_Agreement_Number OKL_TRX_AR_INVOICES_B.Investor_Agreement_Number%TYPE := Okl_Api.G_MISS_CHAR,
67: Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
68: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
69: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
70: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
63:
64:
65: -- start:30-Jan-07 cklee Billing R12 project
66: Investor_Agreement_Number OKL_TRX_AR_INVOICES_B.Investor_Agreement_Number%TYPE := Okl_Api.G_MISS_CHAR,
67: Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
68: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
69: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
70: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
71: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
64:
65: -- start:30-Jan-07 cklee Billing R12 project
66: Investor_Agreement_Number OKL_TRX_AR_INVOICES_B.Investor_Agreement_Number%TYPE := Okl_Api.G_MISS_CHAR,
67: Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
68: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
69: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
70: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
71: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
72: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
65: -- start:30-Jan-07 cklee Billing R12 project
66: Investor_Agreement_Number OKL_TRX_AR_INVOICES_B.Investor_Agreement_Number%TYPE := Okl_Api.G_MISS_CHAR,
67: Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
68: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
69: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
70: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
71: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
72: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
73: ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
66: Investor_Agreement_Number OKL_TRX_AR_INVOICES_B.Investor_Agreement_Number%TYPE := Okl_Api.G_MISS_CHAR,
67: Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
68: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
69: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
70: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
71: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
72: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
73: ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
74: RECEIVABLES_INVOICE_ID OKL_TRX_AR_INVOICES_B.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
67: Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
68: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
69: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
70: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
71: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
72: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
73: ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
74: RECEIVABLES_INVOICE_ID OKL_TRX_AR_INVOICES_B.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
75: --start: 26-02-07 gkhuntet Insufficient assignment.
68: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
69: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
70: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
71: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
72: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
73: ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
74: RECEIVABLES_INVOICE_ID OKL_TRX_AR_INVOICES_B.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
75: --start: 26-02-07 gkhuntet Insufficient assignment.
76: CUST_TRX_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
69: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
70: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
71: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
72: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
73: ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
74: RECEIVABLES_INVOICE_ID OKL_TRX_AR_INVOICES_B.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
75: --start: 26-02-07 gkhuntet Insufficient assignment.
76: CUST_TRX_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
77: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
70: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
71: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
72: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
73: ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
74: RECEIVABLES_INVOICE_ID OKL_TRX_AR_INVOICES_B.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
75: --start: 26-02-07 gkhuntet Insufficient assignment.
76: CUST_TRX_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
77: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
78: --end: 26-02-07 gkhuntet
75: --start: 26-02-07 gkhuntet Insufficient assignment.
76: CUST_TRX_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
77: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
78: --end: 26-02-07 gkhuntet
79: TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
80: TAX_EXEMPT_REASON_CODE OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_REASON_CODE%TYPE := Okl_Api.G_MISS_CHAR,
81: --start: 26-02-07 gkhuntet Insufficient assignment.
82: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
83:
76: CUST_TRX_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
77: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
78: --end: 26-02-07 gkhuntet
79: TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
80: TAX_EXEMPT_REASON_CODE OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_REASON_CODE%TYPE := Okl_Api.G_MISS_CHAR,
81: --start: 26-02-07 gkhuntet Insufficient assignment.
82: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
83:
84: PRIVATE_LABEL OKL_TRX_AR_INVOICES_B.PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
80: TAX_EXEMPT_REASON_CODE OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_REASON_CODE%TYPE := Okl_Api.G_MISS_CHAR,
81: --start: 26-02-07 gkhuntet Insufficient assignment.
82: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
83:
84: PRIVATE_LABEL OKL_TRX_AR_INVOICES_B.PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
85: --end: 26-02-07 gkhuntet
86: -- end: 30-Jan-07 cklee Billing R12 project
87: --gkhuntet start 02-Nov-07
88: TRANSACTION_DATE OKL_TRX_AR_INVOICES_B.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE
84: PRIVATE_LABEL OKL_TRX_AR_INVOICES_B.PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
85: --end: 26-02-07 gkhuntet
86: -- end: 30-Jan-07 cklee Billing R12 project
87: --gkhuntet start 02-Nov-07
88: TRANSACTION_DATE OKL_TRX_AR_INVOICES_B.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE
89: --gkhuntet end 02-Nov-07
90: );
91: g_miss_tai_rec tai_rec_type;
92: TYPE tai_tbl_type IS TABLE OF tai_rec_type
109: id NUMBER := Okl_Api.G_MISS_NUM,
110: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
111: sfwt_flag OKL_TRX_AR_INVOICES_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
112: currency_code OKL_TRX_AR_INVOICES_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
113: currency_conversion_type OKL_TRX_AR_INVOICES_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
114: currency_conversion_rate OKL_TRX_AR_INVOICES_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
115: currency_conversion_date OKL_TRX_AR_INVOICES_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
116: khr_id NUMBER := Okl_Api.G_MISS_NUM,
117: cra_id NUMBER := Okl_Api.G_MISS_NUM,
110: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
111: sfwt_flag OKL_TRX_AR_INVOICES_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
112: currency_code OKL_TRX_AR_INVOICES_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
113: currency_conversion_type OKL_TRX_AR_INVOICES_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
114: currency_conversion_rate OKL_TRX_AR_INVOICES_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
115: currency_conversion_date OKL_TRX_AR_INVOICES_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
116: khr_id NUMBER := Okl_Api.G_MISS_NUM,
117: cra_id NUMBER := Okl_Api.G_MISS_NUM,
118: tap_id NUMBER := Okl_Api.G_MISS_NUM,
111: sfwt_flag OKL_TRX_AR_INVOICES_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
112: currency_code OKL_TRX_AR_INVOICES_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
113: currency_conversion_type OKL_TRX_AR_INVOICES_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
114: currency_conversion_rate OKL_TRX_AR_INVOICES_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
115: currency_conversion_date OKL_TRX_AR_INVOICES_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
116: khr_id NUMBER := Okl_Api.G_MISS_NUM,
117: cra_id NUMBER := Okl_Api.G_MISS_NUM,
118: tap_id NUMBER := Okl_Api.G_MISS_NUM,
119: qte_id NUMBER := Okl_Api.G_MISS_NUM,
119: qte_id NUMBER := Okl_Api.G_MISS_NUM,
120: tcn_id NUMBER := Okl_Api.G_MISS_NUM,
121: tai_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
122: ipy_id NUMBER := Okl_Api.G_MISS_NUM,
123: trx_status_code OKL_TRX_AR_INVOICES_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
124: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
125: try_id NUMBER := Okl_Api.G_MISS_NUM, --Added after postgen changes
126: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
127: ixx_id NUMBER := Okl_Api.G_MISS_NUM,
131: amount NUMBER := Okl_Api.G_MISS_NUM,
132: date_invoiced OKL_TRX_AR_INVOICES_V.DATE_INVOICED%TYPE := Okl_Api.G_MISS_DATE,
133: amount_applied NUMBER := Okl_Api.G_MISS_NUM,
134: description OKL_TRX_AR_INVOICES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
135: TRX_NUMBER OKL_TRX_AR_INVOICES_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
136: CLG_ID NUMBER := Okl_Api.G_MISS_NUM,
137: POX_ID NUMBER := Okl_Api.G_MISS_NUM,
138: CPY_ID NUMBER := Okl_Api.G_MISS_NUM,
139: attribute_category OKL_TRX_AR_INVOICES_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
165: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
166: legal_entity_id OKL_TRX_AR_INVOICES_V.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM, -- for LE Uptake project 08-11-2006
167:
168: -- start:30-Jan-07 cklee Billing R12 project
169: Investor_Agreement_Number OKL_TRX_AR_INVOICES_B.Investor_Agreement_Number%TYPE := Okl_Api.G_MISS_CHAR,
170: Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
171: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
172: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
173: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
166: legal_entity_id OKL_TRX_AR_INVOICES_V.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM, -- for LE Uptake project 08-11-2006
167:
168: -- start:30-Jan-07 cklee Billing R12 project
169: Investor_Agreement_Number OKL_TRX_AR_INVOICES_B.Investor_Agreement_Number%TYPE := Okl_Api.G_MISS_CHAR,
170: Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
171: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
172: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
173: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
174: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
167:
168: -- start:30-Jan-07 cklee Billing R12 project
169: Investor_Agreement_Number OKL_TRX_AR_INVOICES_B.Investor_Agreement_Number%TYPE := Okl_Api.G_MISS_CHAR,
170: Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
171: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
172: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
173: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
174: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
175: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
168: -- start:30-Jan-07 cklee Billing R12 project
169: Investor_Agreement_Number OKL_TRX_AR_INVOICES_B.Investor_Agreement_Number%TYPE := Okl_Api.G_MISS_CHAR,
170: Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
171: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
172: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
173: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
174: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
175: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
176: ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
169: Investor_Agreement_Number OKL_TRX_AR_INVOICES_B.Investor_Agreement_Number%TYPE := Okl_Api.G_MISS_CHAR,
170: Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
171: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
172: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
173: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
174: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
175: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
176: ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
177: RECEIVABLES_INVOICE_ID OKL_TRX_AR_INVOICES_B.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
170: Investor_Name OKL_TRX_AR_INVOICES_B.Investor_Name%TYPE := Okl_Api.G_MISS_CHAR,
171: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
172: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
173: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
174: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
175: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
176: ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
177: RECEIVABLES_INVOICE_ID OKL_TRX_AR_INVOICES_B.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
178: --start: 26-02-07 gkhuntet Insufficient assignment.
171: OKL_SOURCE_BILLING_TRX OKL_TRX_AR_INVOICES_B.OKL_SOURCE_BILLING_TRX%TYPE := Okl_Api.G_MISS_CHAR,
172: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
173: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
174: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
175: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
176: ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
177: RECEIVABLES_INVOICE_ID OKL_TRX_AR_INVOICES_B.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
178: --start: 26-02-07 gkhuntet Insufficient assignment.
179: CUST_TRX_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
172: INF_ID OKL_TRX_AR_INVOICES_B.INF_ID%TYPE := Okl_Api.G_MISS_NUM,
173: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
174: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
175: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
176: ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
177: RECEIVABLES_INVOICE_ID OKL_TRX_AR_INVOICES_B.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
178: --start: 26-02-07 gkhuntet Insufficient assignment.
179: CUST_TRX_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
180: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
173: INVOICE_PULL_YN OKL_TRX_AR_INVOICES_B.INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
174: DUE_DATE OKL_TRX_AR_INVOICES_B.DUE_DATE%TYPE := Okl_Api.G_MISS_DATE,
175: CONSOLIDATED_INVOICE_NUMBER OKL_TRX_AR_INVOICES_B.CONSOLIDATED_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
176: ISI_ID OKL_TRX_AR_INVOICES_B.ISI_ID%TYPE := Okl_Api.G_MISS_NUM,
177: RECEIVABLES_INVOICE_ID OKL_TRX_AR_INVOICES_B.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
178: --start: 26-02-07 gkhuntet Insufficient assignment.
179: CUST_TRX_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
180: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
181: --end: 26-02-07 gkhuntet OKL_TRX_AR_INVOICES_B.CUSTOMER_BANK_ACCOUNT_ID%TYPE := Okl_Api.G_MISS_NUM,
177: RECEIVABLES_INVOICE_ID OKL_TRX_AR_INVOICES_B.RECEIVABLES_INVOICE_ID%TYPE := Okl_Api.G_MISS_NUM,
178: --start: 26-02-07 gkhuntet Insufficient assignment.
179: CUST_TRX_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
180: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
181: --end: 26-02-07 gkhuntet OKL_TRX_AR_INVOICES_B.CUSTOMER_BANK_ACCOUNT_ID%TYPE := Okl_Api.G_MISS_NUM,
182: TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
183: TAX_EXEMPT_REASON_CODE OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_REASON_CODE%TYPE := Okl_Api.G_MISS_CHAR,
184: --start: 26-02-07 gkhuntet Insufficient assignment.
185: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
178: --start: 26-02-07 gkhuntet Insufficient assignment.
179: CUST_TRX_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
180: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
181: --end: 26-02-07 gkhuntet OKL_TRX_AR_INVOICES_B.CUSTOMER_BANK_ACCOUNT_ID%TYPE := Okl_Api.G_MISS_NUM,
182: TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
183: TAX_EXEMPT_REASON_CODE OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_REASON_CODE%TYPE := Okl_Api.G_MISS_CHAR,
184: --start: 26-02-07 gkhuntet Insufficient assignment.
185: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
186: --end: 26-02-07 gkhuntet
179: CUST_TRX_TYPE_ID NUMBER := Okl_Api.G_MISS_NUM,
180: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
181: --end: 26-02-07 gkhuntet OKL_TRX_AR_INVOICES_B.CUSTOMER_BANK_ACCOUNT_ID%TYPE := Okl_Api.G_MISS_NUM,
182: TAX_EXEMPT_FLAG OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
183: TAX_EXEMPT_REASON_CODE OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_REASON_CODE%TYPE := Okl_Api.G_MISS_CHAR,
184: --start: 26-02-07 gkhuntet Insufficient assignment.
185: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
186: --end: 26-02-07 gkhuntet
187: PRIVATE_LABEL OKL_TRX_AR_INVOICES_B.PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
183: TAX_EXEMPT_REASON_CODE OKL_TRX_AR_INVOICES_B.TAX_EXEMPT_REASON_CODE%TYPE := Okl_Api.G_MISS_CHAR,
184: --start: 26-02-07 gkhuntet Insufficient assignment.
185: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
186: --end: 26-02-07 gkhuntet
187: PRIVATE_LABEL OKL_TRX_AR_INVOICES_B.PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
188: --end: 26-02-07 gkhuntet
189: -- end: 30-Jan-07 cklee Billing R12 project
190: --gkhuntet start 02-Nov-07
191: TRANSACTION_DATE OKL_TRX_AR_INVOICES_B.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE
187: PRIVATE_LABEL OKL_TRX_AR_INVOICES_B.PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
188: --end: 26-02-07 gkhuntet
189: -- end: 30-Jan-07 cklee Billing R12 project
190: --gkhuntet start 02-Nov-07
191: TRANSACTION_DATE OKL_TRX_AR_INVOICES_B.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE
192: --gkhuntet end 02-Nov-07
193: );
194:
195: g_miss_taiv_rec taiv_rec_type;