3: ---------------------------------------------------------------------------
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,
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,
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,
16: irt_id NUMBER := Okl_Api.G_MISS_NUM,
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,
16: irt_id NUMBER := Okl_Api.G_MISS_NUM,
17: cra_id NUMBER := Okl_Api.G_MISS_NUM,
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,
16: irt_id NUMBER := Okl_Api.G_MISS_NUM,
17: cra_id NUMBER := Okl_Api.G_MISS_NUM,
18: svf_id NUMBER := 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,
16: irt_id NUMBER := Okl_Api.G_MISS_NUM,
17: cra_id NUMBER := Okl_Api.G_MISS_NUM,
18: svf_id NUMBER := Okl_Api.G_MISS_NUM,
19: tap_id NUMBER := Okl_Api.G_MISS_NUM,
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,
16: irt_id NUMBER := Okl_Api.G_MISS_NUM,
17: cra_id NUMBER := Okl_Api.G_MISS_NUM,
18: svf_id NUMBER := Okl_Api.G_MISS_NUM,
19: tap_id NUMBER := Okl_Api.G_MISS_NUM,
20: qte_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,
16: irt_id NUMBER := Okl_Api.G_MISS_NUM,
17: cra_id NUMBER := Okl_Api.G_MISS_NUM,
18: svf_id NUMBER := Okl_Api.G_MISS_NUM,
19: tap_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,
14: khr_id NUMBER := Okl_Api.G_MISS_NUM,
15: irm_id NUMBER := Okl_Api.G_MISS_NUM,
16: irt_id NUMBER := Okl_Api.G_MISS_NUM,
17: cra_id NUMBER := Okl_Api.G_MISS_NUM,
18: svf_id NUMBER := Okl_Api.G_MISS_NUM,
19: tap_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,
15: irm_id NUMBER := Okl_Api.G_MISS_NUM,
16: irt_id NUMBER := Okl_Api.G_MISS_NUM,
17: cra_id NUMBER := Okl_Api.G_MISS_NUM,
18: svf_id NUMBER := Okl_Api.G_MISS_NUM,
19: tap_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
16: irt_id NUMBER := Okl_Api.G_MISS_NUM,
17: cra_id NUMBER := Okl_Api.G_MISS_NUM,
18: svf_id NUMBER := Okl_Api.G_MISS_NUM,
19: tap_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,
17: cra_id NUMBER := Okl_Api.G_MISS_NUM,
18: svf_id NUMBER := Okl_Api.G_MISS_NUM,
19: tap_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
18: svf_id NUMBER := Okl_Api.G_MISS_NUM,
19: tap_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
19: tap_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,
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,
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,
29: amount 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,
29: amount NUMBER := Okl_Api.G_MISS_NUM,
30: object_version_number 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,
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,
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,
33: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
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,
33: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
34: program_id NUMBER := Okl_Api.G_MISS_NUM,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
40: CPY_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,
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,
42: attribute1 OKL_TRX_AR_INVOICES_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
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,
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,
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,
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,
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,
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,
61: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
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
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
63:
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:
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:
65: -- start:30-Jan-07 cklee Billing R12 project
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
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
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,
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
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.
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,
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,
85: --end: 26-02-07 gkhuntet
86: -- end: 30-Jan-07 cklee Billing R12 project
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
91: g_miss_tai_rec tai_rec_type;
92: TYPE tai_tbl_type IS TABLE OF tai_rec_type
93: INDEX BY BINARY_INTEGER;
94: TYPE OklTrxArInvoicesTlRecType IS RECORD (
95: id NUMBER := Okl_Api.G_MISS_NUM,
96: LANGUAGE OKL_TRX_AR_INVOICES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
97: source_lang OKL_TRX_AR_INVOICES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
98: sfwt_flag OKL_TRX_AR_INVOICES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
99: description OKL_TRX_AR_INVOICES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
92: TYPE tai_tbl_type IS TABLE OF tai_rec_type
93: INDEX BY BINARY_INTEGER;
94: TYPE OklTrxArInvoicesTlRecType IS RECORD (
95: id NUMBER := Okl_Api.G_MISS_NUM,
96: LANGUAGE OKL_TRX_AR_INVOICES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
97: source_lang OKL_TRX_AR_INVOICES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
98: sfwt_flag OKL_TRX_AR_INVOICES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
99: description OKL_TRX_AR_INVOICES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
100: created_by NUMBER := Okl_Api.G_MISS_NUM,
93: INDEX BY BINARY_INTEGER;
94: TYPE OklTrxArInvoicesTlRecType IS RECORD (
95: id NUMBER := Okl_Api.G_MISS_NUM,
96: LANGUAGE OKL_TRX_AR_INVOICES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
97: source_lang OKL_TRX_AR_INVOICES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
98: sfwt_flag OKL_TRX_AR_INVOICES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
99: description OKL_TRX_AR_INVOICES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
100: created_by NUMBER := Okl_Api.G_MISS_NUM,
101: creation_date OKL_TRX_AR_INVOICES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
94: TYPE OklTrxArInvoicesTlRecType IS RECORD (
95: id NUMBER := Okl_Api.G_MISS_NUM,
96: LANGUAGE OKL_TRX_AR_INVOICES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
97: source_lang OKL_TRX_AR_INVOICES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
98: sfwt_flag OKL_TRX_AR_INVOICES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
99: description OKL_TRX_AR_INVOICES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
100: created_by NUMBER := Okl_Api.G_MISS_NUM,
101: creation_date OKL_TRX_AR_INVOICES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
102: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
95: id NUMBER := Okl_Api.G_MISS_NUM,
96: LANGUAGE OKL_TRX_AR_INVOICES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
97: source_lang OKL_TRX_AR_INVOICES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
98: sfwt_flag OKL_TRX_AR_INVOICES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
99: description OKL_TRX_AR_INVOICES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
100: created_by NUMBER := Okl_Api.G_MISS_NUM,
101: creation_date OKL_TRX_AR_INVOICES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
102: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
103: last_update_date OKL_TRX_AR_INVOICES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
96: LANGUAGE OKL_TRX_AR_INVOICES_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
97: source_lang OKL_TRX_AR_INVOICES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
98: sfwt_flag OKL_TRX_AR_INVOICES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
99: description OKL_TRX_AR_INVOICES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
100: created_by NUMBER := Okl_Api.G_MISS_NUM,
101: creation_date OKL_TRX_AR_INVOICES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
102: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
103: last_update_date OKL_TRX_AR_INVOICES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
104: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
97: source_lang OKL_TRX_AR_INVOICES_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
98: sfwt_flag OKL_TRX_AR_INVOICES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
99: description OKL_TRX_AR_INVOICES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
100: created_by NUMBER := Okl_Api.G_MISS_NUM,
101: creation_date OKL_TRX_AR_INVOICES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
102: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
103: last_update_date OKL_TRX_AR_INVOICES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
104: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
105: GMissOklTrxArInvoicesTlRec OklTrxArInvoicesTlRecType;
98: sfwt_flag OKL_TRX_AR_INVOICES_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
99: description OKL_TRX_AR_INVOICES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
100: created_by NUMBER := Okl_Api.G_MISS_NUM,
101: creation_date OKL_TRX_AR_INVOICES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
102: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
103: last_update_date OKL_TRX_AR_INVOICES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
104: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
105: GMissOklTrxArInvoicesTlRec OklTrxArInvoicesTlRecType;
106: TYPE OklTrxArInvoicesTlTblType IS TABLE OF OklTrxArInvoicesTlRecType
99: description OKL_TRX_AR_INVOICES_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
100: created_by NUMBER := Okl_Api.G_MISS_NUM,
101: creation_date OKL_TRX_AR_INVOICES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
102: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
103: last_update_date OKL_TRX_AR_INVOICES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
104: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
105: GMissOklTrxArInvoicesTlRec OklTrxArInvoicesTlRecType;
106: TYPE OklTrxArInvoicesTlTblType IS TABLE OF OklTrxArInvoicesTlRecType
107: INDEX BY BINARY_INTEGER;
100: created_by NUMBER := Okl_Api.G_MISS_NUM,
101: creation_date OKL_TRX_AR_INVOICES_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
102: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
103: last_update_date OKL_TRX_AR_INVOICES_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
104: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
105: GMissOklTrxArInvoicesTlRec OklTrxArInvoicesTlRecType;
106: TYPE OklTrxArInvoicesTlTblType IS TABLE OF OklTrxArInvoicesTlRecType
107: INDEX BY BINARY_INTEGER;
108: TYPE taiv_rec_type IS RECORD (
105: GMissOklTrxArInvoicesTlRec OklTrxArInvoicesTlRecType;
106: TYPE OklTrxArInvoicesTlTblType IS TABLE OF OklTrxArInvoicesTlRecType
107: INDEX BY BINARY_INTEGER;
108: TYPE taiv_rec_type IS RECORD (
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,
106: TYPE OklTrxArInvoicesTlTblType IS TABLE OF OklTrxArInvoicesTlRecType
107: INDEX BY BINARY_INTEGER;
108: TYPE taiv_rec_type IS RECORD (
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,
107: INDEX BY BINARY_INTEGER;
108: TYPE taiv_rec_type IS RECORD (
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,
108: TYPE taiv_rec_type IS RECORD (
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,
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,
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,
120: tcn_id NUMBER := Okl_Api.G_MISS_NUM,
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,
120: tcn_id NUMBER := Okl_Api.G_MISS_NUM,
121: tai_id_reverses NUMBER := Okl_Api.G_MISS_NUM,
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,
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,
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,
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,
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,
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
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,
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
118: tap_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,
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,
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,
128: irm_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,
128: irm_id NUMBER := Okl_Api.G_MISS_NUM,
129: irt_id 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,
128: irm_id NUMBER := Okl_Api.G_MISS_NUM,
129: irt_id NUMBER := Okl_Api.G_MISS_NUM,
130: svf_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,
128: irm_id NUMBER := Okl_Api.G_MISS_NUM,
129: irt_id NUMBER := Okl_Api.G_MISS_NUM,
130: svf_id NUMBER := Okl_Api.G_MISS_NUM,
131: amount NUMBER := Okl_Api.G_MISS_NUM,
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,
128: irm_id NUMBER := Okl_Api.G_MISS_NUM,
129: irt_id NUMBER := Okl_Api.G_MISS_NUM,
130: svf_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,
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,
128: irm_id NUMBER := Okl_Api.G_MISS_NUM,
129: irt_id NUMBER := Okl_Api.G_MISS_NUM,
130: svf_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,
126: ibt_id NUMBER := Okl_Api.G_MISS_NUM,
127: ixx_id NUMBER := Okl_Api.G_MISS_NUM,
128: irm_id NUMBER := Okl_Api.G_MISS_NUM,
129: irt_id NUMBER := Okl_Api.G_MISS_NUM,
130: svf_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,
127: ixx_id NUMBER := Okl_Api.G_MISS_NUM,
128: irm_id NUMBER := Okl_Api.G_MISS_NUM,
129: irt_id NUMBER := Okl_Api.G_MISS_NUM,
130: svf_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,
128: irm_id NUMBER := Okl_Api.G_MISS_NUM,
129: irt_id NUMBER := Okl_Api.G_MISS_NUM,
130: svf_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,
129: irt_id NUMBER := Okl_Api.G_MISS_NUM,
130: svf_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,
130: svf_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,
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,
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,
140: attribute1 OKL_TRX_AR_INVOICES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
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,
140: attribute1 OKL_TRX_AR_INVOICES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
141: attribute2 OKL_TRX_AR_INVOICES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
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,
140: attribute1 OKL_TRX_AR_INVOICES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
141: attribute2 OKL_TRX_AR_INVOICES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
142: attribute3 OKL_TRX_AR_INVOICES_V.ATTRIBUTE3%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,
140: attribute1 OKL_TRX_AR_INVOICES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
141: attribute2 OKL_TRX_AR_INVOICES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
142: attribute3 OKL_TRX_AR_INVOICES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
143: attribute4 OKL_TRX_AR_INVOICES_V.ATTRIBUTE4%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,
140: attribute1 OKL_TRX_AR_INVOICES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
141: attribute2 OKL_TRX_AR_INVOICES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
142: attribute3 OKL_TRX_AR_INVOICES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
143: attribute4 OKL_TRX_AR_INVOICES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
144: attribute5 OKL_TRX_AR_INVOICES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
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,
140: attribute1 OKL_TRX_AR_INVOICES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
141: attribute2 OKL_TRX_AR_INVOICES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
142: attribute3 OKL_TRX_AR_INVOICES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
143: attribute4 OKL_TRX_AR_INVOICES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
144: attribute5 OKL_TRX_AR_INVOICES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
145: attribute6 OKL_TRX_AR_INVOICES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
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,
140: attribute1 OKL_TRX_AR_INVOICES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
141: attribute2 OKL_TRX_AR_INVOICES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
142: attribute3 OKL_TRX_AR_INVOICES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
143: attribute4 OKL_TRX_AR_INVOICES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
144: attribute5 OKL_TRX_AR_INVOICES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
145: attribute6 OKL_TRX_AR_INVOICES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
146: attribute7 OKL_TRX_AR_INVOICES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
139: attribute_category OKL_TRX_AR_INVOICES_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
140: attribute1 OKL_TRX_AR_INVOICES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
141: attribute2 OKL_TRX_AR_INVOICES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
142: attribute3 OKL_TRX_AR_INVOICES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
143: attribute4 OKL_TRX_AR_INVOICES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
144: attribute5 OKL_TRX_AR_INVOICES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
145: attribute6 OKL_TRX_AR_INVOICES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
146: attribute7 OKL_TRX_AR_INVOICES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
147: attribute8 OKL_TRX_AR_INVOICES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
140: attribute1 OKL_TRX_AR_INVOICES_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
141: attribute2 OKL_TRX_AR_INVOICES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
142: attribute3 OKL_TRX_AR_INVOICES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
143: attribute4 OKL_TRX_AR_INVOICES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
144: attribute5 OKL_TRX_AR_INVOICES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
145: attribute6 OKL_TRX_AR_INVOICES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
146: attribute7 OKL_TRX_AR_INVOICES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
147: attribute8 OKL_TRX_AR_INVOICES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
148: attribute9 OKL_TRX_AR_INVOICES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
141: attribute2 OKL_TRX_AR_INVOICES_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
142: attribute3 OKL_TRX_AR_INVOICES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
143: attribute4 OKL_TRX_AR_INVOICES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
144: attribute5 OKL_TRX_AR_INVOICES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
145: attribute6 OKL_TRX_AR_INVOICES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
146: attribute7 OKL_TRX_AR_INVOICES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
147: attribute8 OKL_TRX_AR_INVOICES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
148: attribute9 OKL_TRX_AR_INVOICES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
149: attribute10 OKL_TRX_AR_INVOICES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
142: attribute3 OKL_TRX_AR_INVOICES_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
143: attribute4 OKL_TRX_AR_INVOICES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
144: attribute5 OKL_TRX_AR_INVOICES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
145: attribute6 OKL_TRX_AR_INVOICES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
146: attribute7 OKL_TRX_AR_INVOICES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
147: attribute8 OKL_TRX_AR_INVOICES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
148: attribute9 OKL_TRX_AR_INVOICES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
149: attribute10 OKL_TRX_AR_INVOICES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
150: attribute11 OKL_TRX_AR_INVOICES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
143: attribute4 OKL_TRX_AR_INVOICES_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
144: attribute5 OKL_TRX_AR_INVOICES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
145: attribute6 OKL_TRX_AR_INVOICES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
146: attribute7 OKL_TRX_AR_INVOICES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
147: attribute8 OKL_TRX_AR_INVOICES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
148: attribute9 OKL_TRX_AR_INVOICES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
149: attribute10 OKL_TRX_AR_INVOICES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
150: attribute11 OKL_TRX_AR_INVOICES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
151: attribute12 OKL_TRX_AR_INVOICES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
144: attribute5 OKL_TRX_AR_INVOICES_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
145: attribute6 OKL_TRX_AR_INVOICES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
146: attribute7 OKL_TRX_AR_INVOICES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
147: attribute8 OKL_TRX_AR_INVOICES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
148: attribute9 OKL_TRX_AR_INVOICES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
149: attribute10 OKL_TRX_AR_INVOICES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
150: attribute11 OKL_TRX_AR_INVOICES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
151: attribute12 OKL_TRX_AR_INVOICES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
152: attribute13 OKL_TRX_AR_INVOICES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
145: attribute6 OKL_TRX_AR_INVOICES_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
146: attribute7 OKL_TRX_AR_INVOICES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
147: attribute8 OKL_TRX_AR_INVOICES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
148: attribute9 OKL_TRX_AR_INVOICES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
149: attribute10 OKL_TRX_AR_INVOICES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
150: attribute11 OKL_TRX_AR_INVOICES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
151: attribute12 OKL_TRX_AR_INVOICES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
152: attribute13 OKL_TRX_AR_INVOICES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
153: attribute14 OKL_TRX_AR_INVOICES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
146: attribute7 OKL_TRX_AR_INVOICES_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
147: attribute8 OKL_TRX_AR_INVOICES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
148: attribute9 OKL_TRX_AR_INVOICES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
149: attribute10 OKL_TRX_AR_INVOICES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
150: attribute11 OKL_TRX_AR_INVOICES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
151: attribute12 OKL_TRX_AR_INVOICES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
152: attribute13 OKL_TRX_AR_INVOICES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
153: attribute14 OKL_TRX_AR_INVOICES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
154: attribute15 OKL_TRX_AR_INVOICES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
147: attribute8 OKL_TRX_AR_INVOICES_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
148: attribute9 OKL_TRX_AR_INVOICES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
149: attribute10 OKL_TRX_AR_INVOICES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
150: attribute11 OKL_TRX_AR_INVOICES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
151: attribute12 OKL_TRX_AR_INVOICES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
152: attribute13 OKL_TRX_AR_INVOICES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
153: attribute14 OKL_TRX_AR_INVOICES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
154: attribute15 OKL_TRX_AR_INVOICES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
155: date_entered OKL_TRX_AR_INVOICES_V.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
148: attribute9 OKL_TRX_AR_INVOICES_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
149: attribute10 OKL_TRX_AR_INVOICES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
150: attribute11 OKL_TRX_AR_INVOICES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
151: attribute12 OKL_TRX_AR_INVOICES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
152: attribute13 OKL_TRX_AR_INVOICES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
153: attribute14 OKL_TRX_AR_INVOICES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
154: attribute15 OKL_TRX_AR_INVOICES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
155: date_entered OKL_TRX_AR_INVOICES_V.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
156: request_id NUMBER := Okl_Api.G_MISS_NUM,
149: attribute10 OKL_TRX_AR_INVOICES_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
150: attribute11 OKL_TRX_AR_INVOICES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
151: attribute12 OKL_TRX_AR_INVOICES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
152: attribute13 OKL_TRX_AR_INVOICES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
153: attribute14 OKL_TRX_AR_INVOICES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
154: attribute15 OKL_TRX_AR_INVOICES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
155: date_entered OKL_TRX_AR_INVOICES_V.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
156: request_id NUMBER := Okl_Api.G_MISS_NUM,
157: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
150: attribute11 OKL_TRX_AR_INVOICES_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
151: attribute12 OKL_TRX_AR_INVOICES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
152: attribute13 OKL_TRX_AR_INVOICES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
153: attribute14 OKL_TRX_AR_INVOICES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
154: attribute15 OKL_TRX_AR_INVOICES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
155: date_entered OKL_TRX_AR_INVOICES_V.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
156: request_id NUMBER := Okl_Api.G_MISS_NUM,
157: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
158: program_id NUMBER := Okl_Api.G_MISS_NUM,
151: attribute12 OKL_TRX_AR_INVOICES_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
152: attribute13 OKL_TRX_AR_INVOICES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
153: attribute14 OKL_TRX_AR_INVOICES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
154: attribute15 OKL_TRX_AR_INVOICES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
155: date_entered OKL_TRX_AR_INVOICES_V.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
156: request_id NUMBER := Okl_Api.G_MISS_NUM,
157: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
158: program_id NUMBER := Okl_Api.G_MISS_NUM,
159: program_update_date OKL_TRX_AR_INVOICES_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
152: attribute13 OKL_TRX_AR_INVOICES_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
153: attribute14 OKL_TRX_AR_INVOICES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
154: attribute15 OKL_TRX_AR_INVOICES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
155: date_entered OKL_TRX_AR_INVOICES_V.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
156: request_id NUMBER := Okl_Api.G_MISS_NUM,
157: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
158: program_id NUMBER := Okl_Api.G_MISS_NUM,
159: program_update_date OKL_TRX_AR_INVOICES_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
160: org_id NUMBER := Okl_Api.G_MISS_NUM,
153: attribute14 OKL_TRX_AR_INVOICES_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
154: attribute15 OKL_TRX_AR_INVOICES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
155: date_entered OKL_TRX_AR_INVOICES_V.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
156: request_id NUMBER := Okl_Api.G_MISS_NUM,
157: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
158: program_id NUMBER := Okl_Api.G_MISS_NUM,
159: program_update_date OKL_TRX_AR_INVOICES_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
160: org_id NUMBER := Okl_Api.G_MISS_NUM,
161: created_by NUMBER := Okl_Api.G_MISS_NUM,
154: attribute15 OKL_TRX_AR_INVOICES_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
155: date_entered OKL_TRX_AR_INVOICES_V.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
156: request_id NUMBER := Okl_Api.G_MISS_NUM,
157: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
158: program_id NUMBER := Okl_Api.G_MISS_NUM,
159: program_update_date OKL_TRX_AR_INVOICES_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
160: org_id NUMBER := Okl_Api.G_MISS_NUM,
161: created_by NUMBER := Okl_Api.G_MISS_NUM,
162: creation_date OKL_TRX_AR_INVOICES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
155: date_entered OKL_TRX_AR_INVOICES_V.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
156: request_id NUMBER := Okl_Api.G_MISS_NUM,
157: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
158: program_id NUMBER := Okl_Api.G_MISS_NUM,
159: program_update_date OKL_TRX_AR_INVOICES_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
160: org_id NUMBER := Okl_Api.G_MISS_NUM,
161: created_by NUMBER := Okl_Api.G_MISS_NUM,
162: creation_date OKL_TRX_AR_INVOICES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
163: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
156: request_id NUMBER := Okl_Api.G_MISS_NUM,
157: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
158: program_id NUMBER := Okl_Api.G_MISS_NUM,
159: program_update_date OKL_TRX_AR_INVOICES_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
160: org_id NUMBER := Okl_Api.G_MISS_NUM,
161: created_by NUMBER := Okl_Api.G_MISS_NUM,
162: creation_date OKL_TRX_AR_INVOICES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
163: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
164: last_update_date OKL_TRX_AR_INVOICES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
157: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
158: program_id NUMBER := Okl_Api.G_MISS_NUM,
159: program_update_date OKL_TRX_AR_INVOICES_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
160: org_id NUMBER := Okl_Api.G_MISS_NUM,
161: created_by NUMBER := Okl_Api.G_MISS_NUM,
162: creation_date OKL_TRX_AR_INVOICES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
163: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
164: last_update_date OKL_TRX_AR_INVOICES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
165: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
158: program_id NUMBER := Okl_Api.G_MISS_NUM,
159: program_update_date OKL_TRX_AR_INVOICES_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
160: org_id NUMBER := Okl_Api.G_MISS_NUM,
161: created_by NUMBER := Okl_Api.G_MISS_NUM,
162: creation_date OKL_TRX_AR_INVOICES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
163: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
164: last_update_date OKL_TRX_AR_INVOICES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
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
159: program_update_date OKL_TRX_AR_INVOICES_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
160: org_id NUMBER := Okl_Api.G_MISS_NUM,
161: created_by NUMBER := Okl_Api.G_MISS_NUM,
162: creation_date OKL_TRX_AR_INVOICES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
163: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
164: last_update_date OKL_TRX_AR_INVOICES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
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:
160: org_id NUMBER := Okl_Api.G_MISS_NUM,
161: created_by NUMBER := Okl_Api.G_MISS_NUM,
162: creation_date OKL_TRX_AR_INVOICES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
163: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
164: last_update_date OKL_TRX_AR_INVOICES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
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
161: created_by NUMBER := Okl_Api.G_MISS_NUM,
162: creation_date OKL_TRX_AR_INVOICES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
163: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
164: last_update_date OKL_TRX_AR_INVOICES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
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,
162: creation_date OKL_TRX_AR_INVOICES_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
163: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
164: last_update_date OKL_TRX_AR_INVOICES_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
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,
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,
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,
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,
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,
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.
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,
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,
188: --end: 26-02-07 gkhuntet
189: -- end: 30-Jan-07 cklee Billing R12 project
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;
197: INDEX BY BINARY_INTEGER;
198: ---------------------------------------------------------------------------
199: -- GLOBAL MESSAGE CONSTANTS
200: ---------------------------------------------------------------------------
201: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
202: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
203: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
204: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
205: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
198: ---------------------------------------------------------------------------
199: -- GLOBAL MESSAGE CONSTANTS
200: ---------------------------------------------------------------------------
201: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
202: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
203: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
204: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
205: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
206: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
199: -- GLOBAL MESSAGE CONSTANTS
200: ---------------------------------------------------------------------------
201: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
202: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
203: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
204: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
205: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
206: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
207: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
200: ---------------------------------------------------------------------------
201: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
202: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
203: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
204: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
205: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
206: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
207: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
208: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
201: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
202: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
203: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
204: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
205: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
206: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
207: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
208: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
209: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
203: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
204: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
205: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
206: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
207: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
208: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
209: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
210: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
211: ---------------------------------------------------------------------------
204: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
205: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
206: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
207: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
208: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
209: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
210: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
211: ---------------------------------------------------------------------------
212: -- GLOBAL VARIABLES
205: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
206: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
207: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
208: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
209: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
210: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
211: ---------------------------------------------------------------------------
212: -- GLOBAL VARIABLES
213: ---------------------------------------------------------------------------
206: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
207: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
208: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
209: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
210: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
211: ---------------------------------------------------------------------------
212: -- GLOBAL VARIABLES
213: ---------------------------------------------------------------------------
214: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAI_PVT';
211: ---------------------------------------------------------------------------
212: -- GLOBAL VARIABLES
213: ---------------------------------------------------------------------------
214: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAI_PVT';
215: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
216:
217: /******************ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001) ****************/
218: --GLOBAL MESSAGES
219: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
244: PROCEDURE api_copy;
245: PROCEDURE add_language;
246: PROCEDURE insert_row(
247: p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,
252: p_taiv_rec IN taiv_rec_type,
253: x_taiv_rec OUT NOCOPY taiv_rec_type);
254:
255: PROCEDURE insert_row(
256: p_api_version IN NUMBER,
257: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,
261: p_taiv_tbl IN taiv_tbl_type,
262: x_taiv_tbl OUT NOCOPY taiv_tbl_type);
263:
264: PROCEDURE lock_row(
265: p_api_version IN NUMBER,
266: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
267: x_return_status OUT NOCOPY VARCHAR2,
268: x_msg_count OUT NOCOPY NUMBER,
269: x_msg_data OUT NOCOPY VARCHAR2,
270: p_taiv_rec IN taiv_rec_type);
270: p_taiv_rec IN taiv_rec_type);
271:
272: PROCEDURE lock_row(
273: p_api_version IN NUMBER,
274: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: p_taiv_tbl IN taiv_tbl_type);
278: p_taiv_tbl IN taiv_tbl_type);
279:
280: PROCEDURE update_row(
281: p_api_version IN NUMBER,
282: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,
285: x_msg_data OUT NOCOPY VARCHAR2,
286: p_taiv_rec IN taiv_rec_type,
287: x_taiv_rec OUT NOCOPY taiv_rec_type);
288:
289: PROCEDURE update_row(
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
292: x_return_status OUT NOCOPY VARCHAR2,
293: x_msg_count OUT NOCOPY NUMBER,
294: x_msg_data OUT NOCOPY VARCHAR2,
295: p_taiv_tbl IN taiv_tbl_type,
296: x_taiv_tbl OUT NOCOPY taiv_tbl_type);
297:
298: PROCEDURE delete_row(
299: p_api_version IN NUMBER,
300: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
301: x_return_status OUT NOCOPY VARCHAR2,
302: x_msg_count OUT NOCOPY NUMBER,
303: x_msg_data OUT NOCOPY VARCHAR2,
304: p_taiv_rec IN taiv_rec_type);
304: p_taiv_rec IN taiv_rec_type);
305:
306: PROCEDURE delete_row(
307: p_api_version IN NUMBER,
308: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
309: x_return_status OUT NOCOPY VARCHAR2,
310: x_msg_count OUT NOCOPY NUMBER,
311: x_msg_data OUT NOCOPY VARCHAR2,
312: p_taiv_tbl IN taiv_tbl_type);
312: p_taiv_tbl IN taiv_tbl_type);
313:
314: PROCEDURE validate_row(
315: p_api_version IN NUMBER,
316: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
317: x_return_status OUT NOCOPY VARCHAR2,
318: x_msg_count OUT NOCOPY NUMBER,
319: x_msg_data OUT NOCOPY VARCHAR2,
320: p_taiv_rec IN taiv_rec_type);
320: p_taiv_rec IN taiv_rec_type);
321:
322: PROCEDURE validate_row(
323: p_api_version IN NUMBER,
324: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
327: x_msg_data OUT NOCOPY VARCHAR2,
328: p_taiv_tbl IN taiv_tbl_type);