3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE xsi_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: isi_id NUMBER := Okl_Api.G_MISS_NUM,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
11: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE xsi_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: isi_id NUMBER := Okl_Api.G_MISS_NUM,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
11: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
12: trx_date OKL_EXT_SELL_INVS_B.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
5: ---------------------------------------------------------------------------
6: TYPE xsi_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: isi_id NUMBER := Okl_Api.G_MISS_NUM,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
11: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
12: trx_date OKL_EXT_SELL_INVS_B.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: currency_code OKL_EXT_SELL_INVS_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
6: TYPE xsi_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: isi_id NUMBER := Okl_Api.G_MISS_NUM,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
11: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
12: trx_date OKL_EXT_SELL_INVS_B.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: currency_code OKL_EXT_SELL_INVS_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
14: currency_conversion_type OKL_EXT_SELL_INVS_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: isi_id NUMBER := Okl_Api.G_MISS_NUM,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
11: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
12: trx_date OKL_EXT_SELL_INVS_B.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: currency_code OKL_EXT_SELL_INVS_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
14: currency_conversion_type OKL_EXT_SELL_INVS_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
15: currency_conversion_rate OKL_EXT_SELL_INVS_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
8: isi_id NUMBER := Okl_Api.G_MISS_NUM,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
11: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
12: trx_date OKL_EXT_SELL_INVS_B.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: currency_code OKL_EXT_SELL_INVS_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
14: currency_conversion_type OKL_EXT_SELL_INVS_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
15: currency_conversion_rate OKL_EXT_SELL_INVS_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
16: currency_conversion_date OKL_EXT_SELL_INVS_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
9: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
11: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
12: trx_date OKL_EXT_SELL_INVS_B.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: currency_code OKL_EXT_SELL_INVS_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
14: currency_conversion_type OKL_EXT_SELL_INVS_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
15: currency_conversion_rate OKL_EXT_SELL_INVS_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
16: currency_conversion_date OKL_EXT_SELL_INVS_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
17: customer_id NUMBER := Okl_Api.G_MISS_NUM,
10: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
11: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
12: trx_date OKL_EXT_SELL_INVS_B.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: currency_code OKL_EXT_SELL_INVS_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
14: currency_conversion_type OKL_EXT_SELL_INVS_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
15: currency_conversion_rate OKL_EXT_SELL_INVS_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
16: currency_conversion_date OKL_EXT_SELL_INVS_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
17: customer_id NUMBER := Okl_Api.G_MISS_NUM,
18: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
11: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
12: trx_date OKL_EXT_SELL_INVS_B.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: currency_code OKL_EXT_SELL_INVS_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
14: currency_conversion_type OKL_EXT_SELL_INVS_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
15: currency_conversion_rate OKL_EXT_SELL_INVS_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
16: currency_conversion_date OKL_EXT_SELL_INVS_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
17: customer_id NUMBER := Okl_Api.G_MISS_NUM,
18: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
19: term_id NUMBER := Okl_Api.G_MISS_NUM,
12: trx_date OKL_EXT_SELL_INVS_B.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: currency_code OKL_EXT_SELL_INVS_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
14: currency_conversion_type OKL_EXT_SELL_INVS_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
15: currency_conversion_rate OKL_EXT_SELL_INVS_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
16: currency_conversion_date OKL_EXT_SELL_INVS_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
17: customer_id NUMBER := Okl_Api.G_MISS_NUM,
18: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
19: term_id NUMBER := Okl_Api.G_MISS_NUM,
20: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
13: currency_code OKL_EXT_SELL_INVS_B.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
14: currency_conversion_type OKL_EXT_SELL_INVS_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
15: currency_conversion_rate OKL_EXT_SELL_INVS_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
16: currency_conversion_date OKL_EXT_SELL_INVS_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
17: customer_id NUMBER := Okl_Api.G_MISS_NUM,
18: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
19: term_id NUMBER := Okl_Api.G_MISS_NUM,
20: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
21: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
14: currency_conversion_type OKL_EXT_SELL_INVS_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
15: currency_conversion_rate OKL_EXT_SELL_INVS_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
16: currency_conversion_date OKL_EXT_SELL_INVS_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
17: customer_id NUMBER := Okl_Api.G_MISS_NUM,
18: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
19: term_id NUMBER := Okl_Api.G_MISS_NUM,
20: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
21: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
22: request_id NUMBER := Okl_Api.G_MISS_NUM,
15: currency_conversion_rate OKL_EXT_SELL_INVS_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
16: currency_conversion_date OKL_EXT_SELL_INVS_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
17: customer_id NUMBER := Okl_Api.G_MISS_NUM,
18: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
19: term_id NUMBER := Okl_Api.G_MISS_NUM,
20: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
21: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
22: request_id NUMBER := Okl_Api.G_MISS_NUM,
23: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
16: currency_conversion_date OKL_EXT_SELL_INVS_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
17: customer_id NUMBER := Okl_Api.G_MISS_NUM,
18: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
19: term_id NUMBER := Okl_Api.G_MISS_NUM,
20: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
21: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
22: request_id NUMBER := Okl_Api.G_MISS_NUM,
23: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_id NUMBER := Okl_Api.G_MISS_NUM,
17: customer_id NUMBER := Okl_Api.G_MISS_NUM,
18: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
19: term_id NUMBER := Okl_Api.G_MISS_NUM,
20: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
21: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
22: request_id NUMBER := Okl_Api.G_MISS_NUM,
23: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_update_date OKL_EXT_SELL_INVS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
18: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
19: term_id NUMBER := Okl_Api.G_MISS_NUM,
20: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
21: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
22: request_id NUMBER := Okl_Api.G_MISS_NUM,
23: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_update_date OKL_EXT_SELL_INVS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
26: org_id NUMBER := Okl_Api.G_MISS_NUM,
19: term_id NUMBER := Okl_Api.G_MISS_NUM,
20: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
21: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
22: request_id NUMBER := Okl_Api.G_MISS_NUM,
23: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_update_date OKL_EXT_SELL_INVS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
26: org_id NUMBER := Okl_Api.G_MISS_NUM,
27: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
20: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
21: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
22: request_id NUMBER := Okl_Api.G_MISS_NUM,
23: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_update_date OKL_EXT_SELL_INVS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
26: org_id NUMBER := Okl_Api.G_MISS_NUM,
27: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
28: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
21: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
22: request_id NUMBER := Okl_Api.G_MISS_NUM,
23: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_update_date OKL_EXT_SELL_INVS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
26: org_id NUMBER := Okl_Api.G_MISS_NUM,
27: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
28: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
29: TRX_NUMBER OKL_EXT_SELL_INVS_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
22: request_id NUMBER := Okl_Api.G_MISS_NUM,
23: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_update_date OKL_EXT_SELL_INVS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
26: org_id NUMBER := Okl_Api.G_MISS_NUM,
27: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
28: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
29: TRX_NUMBER OKL_EXT_SELL_INVS_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
30: inf_id NUMBER := Okl_Api.G_MISS_NUM,
23: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
24: program_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_update_date OKL_EXT_SELL_INVS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
26: org_id NUMBER := Okl_Api.G_MISS_NUM,
27: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
28: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
29: TRX_NUMBER OKL_EXT_SELL_INVS_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
30: inf_id NUMBER := Okl_Api.G_MISS_NUM,
31: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
24: program_id NUMBER := Okl_Api.G_MISS_NUM,
25: program_update_date OKL_EXT_SELL_INVS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
26: org_id NUMBER := Okl_Api.G_MISS_NUM,
27: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
28: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
29: TRX_NUMBER OKL_EXT_SELL_INVS_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
30: inf_id NUMBER := Okl_Api.G_MISS_NUM,
31: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
32: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
25: program_update_date OKL_EXT_SELL_INVS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
26: org_id NUMBER := Okl_Api.G_MISS_NUM,
27: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
28: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
29: TRX_NUMBER OKL_EXT_SELL_INVS_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
30: inf_id NUMBER := Okl_Api.G_MISS_NUM,
31: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
32: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
33: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
26: org_id NUMBER := Okl_Api.G_MISS_NUM,
27: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
28: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
29: TRX_NUMBER OKL_EXT_SELL_INVS_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
30: inf_id NUMBER := Okl_Api.G_MISS_NUM,
31: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
32: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
33: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
34: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
27: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
28: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
29: TRX_NUMBER OKL_EXT_SELL_INVS_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
30: inf_id NUMBER := Okl_Api.G_MISS_NUM,
31: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
32: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
33: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
34: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
35: attribute_category OKL_EXT_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
28: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
29: TRX_NUMBER OKL_EXT_SELL_INVS_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
30: inf_id NUMBER := Okl_Api.G_MISS_NUM,
31: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
32: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
33: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
34: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
35: attribute_category OKL_EXT_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute1 OKL_EXT_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
29: TRX_NUMBER OKL_EXT_SELL_INVS_B.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
30: inf_id NUMBER := Okl_Api.G_MISS_NUM,
31: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
32: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
33: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
34: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
35: attribute_category OKL_EXT_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute1 OKL_EXT_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute2 OKL_EXT_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
30: inf_id NUMBER := Okl_Api.G_MISS_NUM,
31: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
32: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
33: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
34: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
35: attribute_category OKL_EXT_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute1 OKL_EXT_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute2 OKL_EXT_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute3 OKL_EXT_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
31: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
32: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
33: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
34: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
35: attribute_category OKL_EXT_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute1 OKL_EXT_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute2 OKL_EXT_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute3 OKL_EXT_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute4 OKL_EXT_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
32: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
33: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
34: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
35: attribute_category OKL_EXT_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute1 OKL_EXT_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute2 OKL_EXT_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute3 OKL_EXT_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute4 OKL_EXT_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute5 OKL_EXT_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
33: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
34: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
35: attribute_category OKL_EXT_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute1 OKL_EXT_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute2 OKL_EXT_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute3 OKL_EXT_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute4 OKL_EXT_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute5 OKL_EXT_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute6 OKL_EXT_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
34: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
35: attribute_category OKL_EXT_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute1 OKL_EXT_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute2 OKL_EXT_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute3 OKL_EXT_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute4 OKL_EXT_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute5 OKL_EXT_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute6 OKL_EXT_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute7 OKL_EXT_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
35: attribute_category OKL_EXT_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute1 OKL_EXT_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute2 OKL_EXT_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute3 OKL_EXT_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute4 OKL_EXT_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute5 OKL_EXT_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute6 OKL_EXT_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute7 OKL_EXT_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute8 OKL_EXT_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
36: attribute1 OKL_EXT_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute2 OKL_EXT_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute3 OKL_EXT_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute4 OKL_EXT_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute5 OKL_EXT_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute6 OKL_EXT_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute7 OKL_EXT_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute8 OKL_EXT_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute9 OKL_EXT_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
37: attribute2 OKL_EXT_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute3 OKL_EXT_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute4 OKL_EXT_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute5 OKL_EXT_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute6 OKL_EXT_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute7 OKL_EXT_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute8 OKL_EXT_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute9 OKL_EXT_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute10 OKL_EXT_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
38: attribute3 OKL_EXT_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute4 OKL_EXT_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute5 OKL_EXT_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute6 OKL_EXT_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute7 OKL_EXT_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute8 OKL_EXT_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute9 OKL_EXT_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute10 OKL_EXT_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute11 OKL_EXT_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
39: attribute4 OKL_EXT_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute5 OKL_EXT_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute6 OKL_EXT_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute7 OKL_EXT_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute8 OKL_EXT_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute9 OKL_EXT_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute10 OKL_EXT_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute11 OKL_EXT_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute12 OKL_EXT_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
40: attribute5 OKL_EXT_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute6 OKL_EXT_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute7 OKL_EXT_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute8 OKL_EXT_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute9 OKL_EXT_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute10 OKL_EXT_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute11 OKL_EXT_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute12 OKL_EXT_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute13 OKL_EXT_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
41: attribute6 OKL_EXT_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute7 OKL_EXT_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute8 OKL_EXT_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute9 OKL_EXT_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute10 OKL_EXT_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute11 OKL_EXT_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute12 OKL_EXT_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute13 OKL_EXT_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute14 OKL_EXT_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
42: attribute7 OKL_EXT_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute8 OKL_EXT_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute9 OKL_EXT_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute10 OKL_EXT_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute11 OKL_EXT_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute12 OKL_EXT_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute13 OKL_EXT_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute14 OKL_EXT_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute15 OKL_EXT_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
43: attribute8 OKL_EXT_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
44: attribute9 OKL_EXT_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute10 OKL_EXT_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute11 OKL_EXT_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute12 OKL_EXT_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute13 OKL_EXT_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute14 OKL_EXT_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute15 OKL_EXT_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
51: created_by NUMBER := Okl_Api.G_MISS_NUM,
44: attribute9 OKL_EXT_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
45: attribute10 OKL_EXT_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute11 OKL_EXT_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute12 OKL_EXT_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute13 OKL_EXT_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute14 OKL_EXT_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute15 OKL_EXT_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
51: created_by NUMBER := Okl_Api.G_MISS_NUM,
52: creation_date OKL_EXT_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
45: attribute10 OKL_EXT_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
46: attribute11 OKL_EXT_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute12 OKL_EXT_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute13 OKL_EXT_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute14 OKL_EXT_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute15 OKL_EXT_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
51: created_by NUMBER := Okl_Api.G_MISS_NUM,
52: creation_date OKL_EXT_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
53: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
46: attribute11 OKL_EXT_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
47: attribute12 OKL_EXT_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute13 OKL_EXT_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute14 OKL_EXT_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute15 OKL_EXT_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
51: created_by NUMBER := Okl_Api.G_MISS_NUM,
52: creation_date OKL_EXT_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
53: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
54: last_update_date OKL_EXT_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
47: attribute12 OKL_EXT_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
48: attribute13 OKL_EXT_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute14 OKL_EXT_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute15 OKL_EXT_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
51: created_by NUMBER := Okl_Api.G_MISS_NUM,
52: creation_date OKL_EXT_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
53: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
54: last_update_date OKL_EXT_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
55: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
48: attribute13 OKL_EXT_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute14 OKL_EXT_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute15 OKL_EXT_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
51: created_by NUMBER := Okl_Api.G_MISS_NUM,
52: creation_date OKL_EXT_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
53: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
54: last_update_date OKL_EXT_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
55: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
56: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
49: attribute14 OKL_EXT_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute15 OKL_EXT_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
51: created_by NUMBER := Okl_Api.G_MISS_NUM,
52: creation_date OKL_EXT_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
53: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
54: last_update_date OKL_EXT_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
55: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
56: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
50: attribute15 OKL_EXT_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
51: created_by NUMBER := Okl_Api.G_MISS_NUM,
52: creation_date OKL_EXT_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
53: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
54: last_update_date OKL_EXT_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
55: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
56: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
58: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
51: created_by NUMBER := Okl_Api.G_MISS_NUM,
52: creation_date OKL_EXT_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
53: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
54: last_update_date OKL_EXT_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
55: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
56: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
58: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
59: xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
52: creation_date OKL_EXT_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
53: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
54: last_update_date OKL_EXT_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
55: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
56: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
58: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
59: xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
60: legal_entity_id OKL_EXT_SELL_INVS_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM -- for LE Uptake project 08-11-2006
53: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
54: last_update_date OKL_EXT_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
55: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
56: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
58: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
59: xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
60: legal_entity_id OKL_EXT_SELL_INVS_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM -- for LE Uptake project 08-11-2006
61: );
54: last_update_date OKL_EXT_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
55: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
56: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
58: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
59: xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
60: legal_entity_id OKL_EXT_SELL_INVS_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM -- for LE Uptake project 08-11-2006
61: );
62: g_miss_xsi_rec xsi_rec_type;
55: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
56: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
58: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
59: xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
60: legal_entity_id OKL_EXT_SELL_INVS_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM -- for LE Uptake project 08-11-2006
61: );
62: g_miss_xsi_rec xsi_rec_type;
63: TYPE xsi_tbl_type IS TABLE OF xsi_rec_type
56: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
57: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
58: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
59: xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
60: legal_entity_id OKL_EXT_SELL_INVS_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM -- for LE Uptake project 08-11-2006
61: );
62: g_miss_xsi_rec xsi_rec_type;
63: TYPE xsi_tbl_type IS TABLE OF xsi_rec_type
64: INDEX BY BINARY_INTEGER;
62: g_miss_xsi_rec xsi_rec_type;
63: TYPE xsi_tbl_type IS TABLE OF xsi_rec_type
64: INDEX BY BINARY_INTEGER;
65: TYPE okl_ext_sell_invs_tl_rec_type IS RECORD (
66: id NUMBER := Okl_Api.G_MISS_NUM,
67: LANGUAGE OKL_EXT_SELL_INVS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
68: source_lang OKL_EXT_SELL_INVS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
69: sfwt_flag OKL_EXT_SELL_INVS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
70: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_TL.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
63: TYPE xsi_tbl_type IS TABLE OF xsi_rec_type
64: INDEX BY BINARY_INTEGER;
65: TYPE okl_ext_sell_invs_tl_rec_type IS RECORD (
66: id NUMBER := Okl_Api.G_MISS_NUM,
67: LANGUAGE OKL_EXT_SELL_INVS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
68: source_lang OKL_EXT_SELL_INVS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
69: sfwt_flag OKL_EXT_SELL_INVS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
70: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_TL.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
71: xtrx_format_type OKL_EXT_SELL_INVS_TL.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
64: INDEX BY BINARY_INTEGER;
65: TYPE okl_ext_sell_invs_tl_rec_type IS RECORD (
66: id NUMBER := Okl_Api.G_MISS_NUM,
67: LANGUAGE OKL_EXT_SELL_INVS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
68: source_lang OKL_EXT_SELL_INVS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
69: sfwt_flag OKL_EXT_SELL_INVS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
70: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_TL.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
71: xtrx_format_type OKL_EXT_SELL_INVS_TL.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
72: xtrx_private_label OKL_EXT_SELL_INVS_TL.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
65: TYPE okl_ext_sell_invs_tl_rec_type IS RECORD (
66: id NUMBER := Okl_Api.G_MISS_NUM,
67: LANGUAGE OKL_EXT_SELL_INVS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
68: source_lang OKL_EXT_SELL_INVS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
69: sfwt_flag OKL_EXT_SELL_INVS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
70: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_TL.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
71: xtrx_format_type OKL_EXT_SELL_INVS_TL.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
72: xtrx_private_label OKL_EXT_SELL_INVS_TL.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
73: invoice_message OKL_EXT_SELL_INVS_TL.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
66: id NUMBER := Okl_Api.G_MISS_NUM,
67: LANGUAGE OKL_EXT_SELL_INVS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
68: source_lang OKL_EXT_SELL_INVS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
69: sfwt_flag OKL_EXT_SELL_INVS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
70: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_TL.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
71: xtrx_format_type OKL_EXT_SELL_INVS_TL.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
72: xtrx_private_label OKL_EXT_SELL_INVS_TL.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
73: invoice_message OKL_EXT_SELL_INVS_TL.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
74: description OKL_EXT_SELL_INVS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
67: LANGUAGE OKL_EXT_SELL_INVS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
68: source_lang OKL_EXT_SELL_INVS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
69: sfwt_flag OKL_EXT_SELL_INVS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
70: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_TL.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
71: xtrx_format_type OKL_EXT_SELL_INVS_TL.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
72: xtrx_private_label OKL_EXT_SELL_INVS_TL.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
73: invoice_message OKL_EXT_SELL_INVS_TL.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
74: description OKL_EXT_SELL_INVS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
75: created_by NUMBER := Okl_Api.G_MISS_NUM,
68: source_lang OKL_EXT_SELL_INVS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
69: sfwt_flag OKL_EXT_SELL_INVS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
70: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_TL.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
71: xtrx_format_type OKL_EXT_SELL_INVS_TL.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
72: xtrx_private_label OKL_EXT_SELL_INVS_TL.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
73: invoice_message OKL_EXT_SELL_INVS_TL.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
74: description OKL_EXT_SELL_INVS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
75: created_by NUMBER := Okl_Api.G_MISS_NUM,
76: creation_date OKL_EXT_SELL_INVS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
69: sfwt_flag OKL_EXT_SELL_INVS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
70: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_TL.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
71: xtrx_format_type OKL_EXT_SELL_INVS_TL.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
72: xtrx_private_label OKL_EXT_SELL_INVS_TL.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
73: invoice_message OKL_EXT_SELL_INVS_TL.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
74: description OKL_EXT_SELL_INVS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
75: created_by NUMBER := Okl_Api.G_MISS_NUM,
76: creation_date OKL_EXT_SELL_INVS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
77: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
70: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_TL.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
71: xtrx_format_type OKL_EXT_SELL_INVS_TL.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
72: xtrx_private_label OKL_EXT_SELL_INVS_TL.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
73: invoice_message OKL_EXT_SELL_INVS_TL.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
74: description OKL_EXT_SELL_INVS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
75: created_by NUMBER := Okl_Api.G_MISS_NUM,
76: creation_date OKL_EXT_SELL_INVS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
77: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
78: last_update_date OKL_EXT_SELL_INVS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
71: xtrx_format_type OKL_EXT_SELL_INVS_TL.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
72: xtrx_private_label OKL_EXT_SELL_INVS_TL.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
73: invoice_message OKL_EXT_SELL_INVS_TL.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
74: description OKL_EXT_SELL_INVS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
75: created_by NUMBER := Okl_Api.G_MISS_NUM,
76: creation_date OKL_EXT_SELL_INVS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
77: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
78: last_update_date OKL_EXT_SELL_INVS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
79: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
72: xtrx_private_label OKL_EXT_SELL_INVS_TL.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
73: invoice_message OKL_EXT_SELL_INVS_TL.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
74: description OKL_EXT_SELL_INVS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
75: created_by NUMBER := Okl_Api.G_MISS_NUM,
76: creation_date OKL_EXT_SELL_INVS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
77: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
78: last_update_date OKL_EXT_SELL_INVS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
79: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
80: GMissOklExtSellInvsTlRec okl_ext_sell_invs_tl_rec_type;
73: invoice_message OKL_EXT_SELL_INVS_TL.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
74: description OKL_EXT_SELL_INVS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
75: created_by NUMBER := Okl_Api.G_MISS_NUM,
76: creation_date OKL_EXT_SELL_INVS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
77: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
78: last_update_date OKL_EXT_SELL_INVS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
79: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
80: GMissOklExtSellInvsTlRec okl_ext_sell_invs_tl_rec_type;
81: TYPE okl_ext_sell_invs_tl_tbl_type IS TABLE OF okl_ext_sell_invs_tl_rec_type
74: description OKL_EXT_SELL_INVS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
75: created_by NUMBER := Okl_Api.G_MISS_NUM,
76: creation_date OKL_EXT_SELL_INVS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
77: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
78: last_update_date OKL_EXT_SELL_INVS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
79: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
80: GMissOklExtSellInvsTlRec okl_ext_sell_invs_tl_rec_type;
81: TYPE okl_ext_sell_invs_tl_tbl_type IS TABLE OF okl_ext_sell_invs_tl_rec_type
82: INDEX BY BINARY_INTEGER;
75: created_by NUMBER := Okl_Api.G_MISS_NUM,
76: creation_date OKL_EXT_SELL_INVS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
77: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
78: last_update_date OKL_EXT_SELL_INVS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
79: last_update_login NUMBER := Okl_Api.G_MISS_NUM);
80: GMissOklExtSellInvsTlRec okl_ext_sell_invs_tl_rec_type;
81: TYPE okl_ext_sell_invs_tl_tbl_type IS TABLE OF okl_ext_sell_invs_tl_rec_type
82: INDEX BY BINARY_INTEGER;
83: TYPE xsiv_rec_type IS RECORD (
80: GMissOklExtSellInvsTlRec okl_ext_sell_invs_tl_rec_type;
81: TYPE okl_ext_sell_invs_tl_tbl_type IS TABLE OF okl_ext_sell_invs_tl_rec_type
82: INDEX BY BINARY_INTEGER;
83: TYPE xsiv_rec_type IS RECORD (
84: id NUMBER := Okl_Api.G_MISS_NUM,
85: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
86: sfwt_flag OKL_EXT_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
87: isi_id NUMBER := Okl_Api.G_MISS_NUM,
88: trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
81: TYPE okl_ext_sell_invs_tl_tbl_type IS TABLE OF okl_ext_sell_invs_tl_rec_type
82: INDEX BY BINARY_INTEGER;
83: TYPE xsiv_rec_type IS RECORD (
84: id NUMBER := Okl_Api.G_MISS_NUM,
85: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
86: sfwt_flag OKL_EXT_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
87: isi_id NUMBER := Okl_Api.G_MISS_NUM,
88: trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
89: customer_id NUMBER := Okl_Api.G_MISS_NUM,
82: INDEX BY BINARY_INTEGER;
83: TYPE xsiv_rec_type IS RECORD (
84: id NUMBER := Okl_Api.G_MISS_NUM,
85: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
86: sfwt_flag OKL_EXT_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
87: isi_id NUMBER := Okl_Api.G_MISS_NUM,
88: trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
89: customer_id NUMBER := Okl_Api.G_MISS_NUM,
90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
83: TYPE xsiv_rec_type IS RECORD (
84: id NUMBER := Okl_Api.G_MISS_NUM,
85: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
86: sfwt_flag OKL_EXT_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
87: isi_id NUMBER := Okl_Api.G_MISS_NUM,
88: trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
89: customer_id NUMBER := Okl_Api.G_MISS_NUM,
90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
91: term_id NUMBER := Okl_Api.G_MISS_NUM,
84: id NUMBER := Okl_Api.G_MISS_NUM,
85: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
86: sfwt_flag OKL_EXT_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
87: isi_id NUMBER := Okl_Api.G_MISS_NUM,
88: trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
89: customer_id NUMBER := Okl_Api.G_MISS_NUM,
90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
91: term_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
85: object_version_number NUMBER := Okl_Api.G_MISS_NUM,
86: sfwt_flag OKL_EXT_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
87: isi_id NUMBER := Okl_Api.G_MISS_NUM,
88: trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
89: customer_id NUMBER := Okl_Api.G_MISS_NUM,
90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
91: term_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
86: sfwt_flag OKL_EXT_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
87: isi_id NUMBER := Okl_Api.G_MISS_NUM,
88: trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
89: customer_id NUMBER := Okl_Api.G_MISS_NUM,
90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
91: term_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
87: isi_id NUMBER := Okl_Api.G_MISS_NUM,
88: trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
89: customer_id NUMBER := Okl_Api.G_MISS_NUM,
90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
91: term_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
88: trx_date OKL_EXT_SELL_INVS_V.TRX_DATE%TYPE := Okl_Api.G_MISS_DATE,
89: customer_id NUMBER := Okl_Api.G_MISS_NUM,
90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
91: term_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
89: customer_id NUMBER := Okl_Api.G_MISS_NUM,
90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
91: term_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
90: receipt_method_id NUMBER := Okl_Api.G_MISS_NUM,
91: term_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
91: term_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
92: currency_code OKL_EXT_SELL_INVS_V.CURRENCY_CODE%TYPE := Okl_Api.G_MISS_CHAR,
93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
93: currency_conversion_type OKL_EXT_SELL_INVS_V.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
94: currency_conversion_rate OKL_EXT_SELL_INVS_V.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
95: currency_conversion_date OKL_EXT_SELL_INVS_V.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
96: customer_address_id NUMBER := Okl_Api.G_MISS_NUM,
97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
97: set_of_books_id NUMBER := Okl_Api.G_MISS_NUM,
98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
98: receivables_invoice_id NUMBER := Okl_Api.G_MISS_NUM,
99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
106: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
99: cust_trx_type_id NUMBER := Okl_Api.G_MISS_NUM,
100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
106: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
107: TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
100: invoice_message OKL_EXT_SELL_INVS_V.INVOICE_MESSAGE%TYPE := Okl_Api.G_MISS_CHAR,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
106: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
107: TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
108: inf_id NUMBER := Okl_Api.G_MISS_NUM,
101: description OKL_EXT_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
106: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
107: TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
108: inf_id NUMBER := Okl_Api.G_MISS_NUM,
109: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
102: xtrx_cons_invoice_number OKL_EXT_SELL_INVS_V.XTRX_CONS_INVOICE_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
106: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
107: TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
108: inf_id NUMBER := Okl_Api.G_MISS_NUM,
109: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
110: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
103: xtrx_format_type OKL_EXT_SELL_INVS_V.XTRX_FORMAT_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
106: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
107: TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
108: inf_id NUMBER := Okl_Api.G_MISS_NUM,
109: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
110: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
111: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
104: xtrx_private_label OKL_EXT_SELL_INVS_V.XTRX_PRIVATE_LABEL%TYPE := Okl_Api.G_MISS_CHAR,
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
106: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
107: TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
108: inf_id NUMBER := Okl_Api.G_MISS_NUM,
109: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
110: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
111: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
112: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
105: REFERENCE_LINE_ID NUMBER := Okl_Api.G_MISS_NUM,
106: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
107: TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
108: inf_id NUMBER := Okl_Api.G_MISS_NUM,
109: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
110: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
111: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
112: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
106: CUSTOMER_BANK_ACCOUNT_ID NUMBER := Okl_Api.G_MISS_NUM,
107: TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
108: inf_id NUMBER := Okl_Api.G_MISS_NUM,
109: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
110: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
111: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
112: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
107: TRX_NUMBER OKL_EXT_SELL_INVS_V.TRX_NUMBER%TYPE := Okl_Api.G_MISS_CHAR,
108: inf_id NUMBER := Okl_Api.G_MISS_NUM,
109: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
110: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
111: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
112: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
108: inf_id NUMBER := Okl_Api.G_MISS_NUM,
109: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
110: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
111: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
112: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
109: /* khr_id NUMBER := Okl_Api.G_MISS_NUM, */
110: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
111: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
112: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
110: /* clg_id NUMBER := Okl_Api.G_MISS_NUM, */
111: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
112: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
111: /* cpy_id NUMBER := Okl_Api.G_MISS_NUM, */
112: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
112: /* qte_id NUMBER := Okl_Api.G_MISS_NUM, */
113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
113: attribute_category OKL_EXT_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
114: attribute1 OKL_EXT_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
115: attribute2 OKL_EXT_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
116: attribute3 OKL_EXT_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
117: attribute4 OKL_EXT_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
118: attribute5 OKL_EXT_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
119: attribute6 OKL_EXT_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
120: attribute7 OKL_EXT_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
121: attribute8 OKL_EXT_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,
122: attribute9 OKL_EXT_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,
130: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
123: attribute10 OKL_EXT_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,
130: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
131: program_id NUMBER := Okl_Api.G_MISS_NUM,
124: attribute11 OKL_EXT_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,
130: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
131: program_id NUMBER := Okl_Api.G_MISS_NUM,
132: program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
125: attribute12 OKL_EXT_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,
130: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
131: program_id NUMBER := Okl_Api.G_MISS_NUM,
132: program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
133: org_id NUMBER := Okl_Api.G_MISS_NUM,
126: attribute13 OKL_EXT_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,
130: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
131: program_id NUMBER := Okl_Api.G_MISS_NUM,
132: program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
133: org_id NUMBER := Okl_Api.G_MISS_NUM,
134: created_by NUMBER := Okl_Api.G_MISS_NUM,
127: attribute14 OKL_EXT_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,
130: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
131: program_id NUMBER := Okl_Api.G_MISS_NUM,
132: program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
133: org_id NUMBER := Okl_Api.G_MISS_NUM,
134: created_by NUMBER := Okl_Api.G_MISS_NUM,
135: creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
128: attribute15 OKL_EXT_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,
130: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
131: program_id NUMBER := Okl_Api.G_MISS_NUM,
132: program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
133: org_id NUMBER := Okl_Api.G_MISS_NUM,
134: created_by NUMBER := Okl_Api.G_MISS_NUM,
135: creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
136: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
129: request_id NUMBER := Okl_Api.G_MISS_NUM,
130: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
131: program_id NUMBER := Okl_Api.G_MISS_NUM,
132: program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
133: org_id NUMBER := Okl_Api.G_MISS_NUM,
134: created_by NUMBER := Okl_Api.G_MISS_NUM,
135: creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
136: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
137: last_update_date OKL_EXT_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
130: program_application_id NUMBER := Okl_Api.G_MISS_NUM,
131: program_id NUMBER := Okl_Api.G_MISS_NUM,
132: program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
133: org_id NUMBER := Okl_Api.G_MISS_NUM,
134: created_by NUMBER := Okl_Api.G_MISS_NUM,
135: creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
136: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
137: last_update_date OKL_EXT_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
138: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
131: program_id NUMBER := Okl_Api.G_MISS_NUM,
132: program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
133: org_id NUMBER := Okl_Api.G_MISS_NUM,
134: created_by NUMBER := Okl_Api.G_MISS_NUM,
135: creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
136: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
137: last_update_date OKL_EXT_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
138: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
139: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
132: program_update_date OKL_EXT_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
133: org_id NUMBER := Okl_Api.G_MISS_NUM,
134: created_by NUMBER := Okl_Api.G_MISS_NUM,
135: creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
136: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
137: last_update_date OKL_EXT_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
138: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
139: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
140: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
133: org_id NUMBER := Okl_Api.G_MISS_NUM,
134: created_by NUMBER := Okl_Api.G_MISS_NUM,
135: creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
136: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
137: last_update_date OKL_EXT_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
138: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
139: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
140: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
141: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
134: created_by NUMBER := Okl_Api.G_MISS_NUM,
135: creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
136: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
137: last_update_date OKL_EXT_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
138: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
139: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
140: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
141: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
142: xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
135: creation_date OKL_EXT_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
136: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
137: last_update_date OKL_EXT_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
138: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
139: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
140: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
141: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
142: xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
143: legal_entity_id OKL_EXT_SELL_INVS_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM -- for LE Uptake project 08-11-2006
136: last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
137: last_update_date OKL_EXT_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
138: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
139: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
140: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
141: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
142: xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
143: legal_entity_id OKL_EXT_SELL_INVS_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM -- for LE Uptake project 08-11-2006
144: );
137: last_update_date OKL_EXT_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
138: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
139: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
140: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
141: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
142: xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
143: legal_entity_id OKL_EXT_SELL_INVS_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM -- for LE Uptake project 08-11-2006
144: );
145:
138: last_update_login NUMBER := Okl_Api.G_MISS_NUM,
139: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
140: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
141: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
142: xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
143: legal_entity_id OKL_EXT_SELL_INVS_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM -- for LE Uptake project 08-11-2006
144: );
145:
146: g_miss_xsiv_rec xsiv_rec_type;
139: trx_status_code OKL_EXT_SELL_INVS_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
140: tax_exempt_flag OKL_EXT_SELL_INVS_B.TAX_EXEMPT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
141: tax_exempt_reason_code OKL_EXT_SELL_INVS_B.TAX_EXEMPT_REASON_CODE%TYPE:= Okl_Api.G_MISS_CHAR,
142: xtrx_invoice_pull_yn OKL_EXT_SELL_INVS_B.XTRX_INVOICE_PULL_YN%TYPE := Okl_Api.G_MISS_CHAR,
143: legal_entity_id OKL_EXT_SELL_INVS_B.LEGAL_ENTITY_ID%TYPE := Okl_Api.G_MISS_NUM -- for LE Uptake project 08-11-2006
144: );
145:
146: g_miss_xsiv_rec xsiv_rec_type;
147: TYPE xsiv_tbl_type IS TABLE OF xsiv_rec_type
148: INDEX BY BINARY_INTEGER;
149: ---------------------------------------------------------------------------
150: -- GLOBAL MESSAGE CONSTANTS
151: ---------------------------------------------------------------------------
152: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
153: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
149: ---------------------------------------------------------------------------
150: -- GLOBAL MESSAGE CONSTANTS
151: ---------------------------------------------------------------------------
152: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
153: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
150: -- GLOBAL MESSAGE CONSTANTS
151: ---------------------------------------------------------------------------
152: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
153: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
151: ---------------------------------------------------------------------------
152: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
153: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
152: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
153: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
160: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
153: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
160: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
161: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
154: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
160: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
161: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
162: ---------------------------------------------------------------------------
155: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
160: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
161: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
162: ---------------------------------------------------------------------------
163: -- GLOBAL VARIABLES
156: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
160: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
161: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
162: ---------------------------------------------------------------------------
163: -- GLOBAL VARIABLES
164: ---------------------------------------------------------------------------
157: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
158: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
159: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
160: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
161: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
162: ---------------------------------------------------------------------------
163: -- GLOBAL VARIABLES
164: ---------------------------------------------------------------------------
165: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XSI_PVT';
162: ---------------------------------------------------------------------------
163: -- GLOBAL VARIABLES
164: ---------------------------------------------------------------------------
165: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XSI_PVT';
166: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
167:
168: /******************ADDED AFTER TAPI, Sunil T. Mathew (04/16/2001) ****************/
169: --GLOBAL MESSAGES
170: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
195: PROCEDURE api_copy;
196: PROCEDURE add_language;
197: PROCEDURE insert_row(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_xsiv_rec IN xsiv_rec_type,
204: x_xsiv_rec OUT NOCOPY xsiv_rec_type);
205:
206: PROCEDURE insert_row(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_xsiv_tbl IN xsiv_tbl_type,
213: x_xsiv_tbl OUT NOCOPY xsiv_tbl_type);
214:
215: PROCEDURE lock_row(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_xsiv_rec IN xsiv_rec_type);
221: p_xsiv_rec IN xsiv_rec_type);
222:
223: PROCEDURE lock_row(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_xsiv_tbl IN xsiv_tbl_type);
229: p_xsiv_tbl IN xsiv_tbl_type);
230:
231: PROCEDURE update_row(
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_xsiv_rec IN xsiv_rec_type,
238: x_xsiv_rec OUT NOCOPY xsiv_rec_type);
239:
240: PROCEDURE update_row(
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,
246: p_xsiv_tbl IN xsiv_tbl_type,
247: x_xsiv_tbl OUT NOCOPY xsiv_tbl_type);
248:
249: PROCEDURE delete_row(
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_xsiv_rec IN xsiv_rec_type);
255: p_xsiv_rec IN xsiv_rec_type);
256:
257: PROCEDURE delete_row(
258: p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,
262: x_msg_data OUT NOCOPY VARCHAR2,
263: p_xsiv_tbl IN xsiv_tbl_type);
263: p_xsiv_tbl IN xsiv_tbl_type);
264:
265: PROCEDURE validate_row(
266: p_api_version IN NUMBER,
267: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
268: x_return_status OUT NOCOPY VARCHAR2,
269: x_msg_count OUT NOCOPY NUMBER,
270: x_msg_data OUT NOCOPY VARCHAR2,
271: p_xsiv_rec IN xsiv_rec_type);
271: p_xsiv_rec IN xsiv_rec_type);
272:
273: PROCEDURE validate_row(
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,
279: p_xsiv_tbl IN xsiv_tbl_type);