2: /* $Header: OKLSCINS.pls 120.0 2007/03/13 21:19:10 pjgomes noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_CNSLD_AP_INVS Record Spec
7: TYPE cin_rec_type IS RECORD (
8: cnsld_ap_inv_id NUMBER
9: ,trx_status_code OKL_CNSLD_AP_INVS.TRX_STATUS_CODE%TYPE
10: ,vendor_invoice_number OKL_CNSLD_AP_INVS.VENDOR_INVOICE_NUMBER%TYPE
5: ---------------------------------------------------------------------------
6: -- OKL_CNSLD_AP_INVS Record Spec
7: TYPE cin_rec_type IS RECORD (
8: cnsld_ap_inv_id NUMBER
9: ,trx_status_code OKL_CNSLD_AP_INVS.TRX_STATUS_CODE%TYPE
10: ,vendor_invoice_number OKL_CNSLD_AP_INVS.VENDOR_INVOICE_NUMBER%TYPE
11: ,currency_code OKL_CNSLD_AP_INVS.CURRENCY_CODE%TYPE
12: ,currency_conversion_type OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_TYPE%TYPE
13: ,currency_conversion_rate NUMBER
6: -- OKL_CNSLD_AP_INVS Record Spec
7: TYPE cin_rec_type IS RECORD (
8: cnsld_ap_inv_id NUMBER
9: ,trx_status_code OKL_CNSLD_AP_INVS.TRX_STATUS_CODE%TYPE
10: ,vendor_invoice_number OKL_CNSLD_AP_INVS.VENDOR_INVOICE_NUMBER%TYPE
11: ,currency_code OKL_CNSLD_AP_INVS.CURRENCY_CODE%TYPE
12: ,currency_conversion_type OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_TYPE%TYPE
13: ,currency_conversion_rate NUMBER
14: ,currency_conversion_date OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_DATE%TYPE
7: TYPE cin_rec_type IS RECORD (
8: cnsld_ap_inv_id NUMBER
9: ,trx_status_code OKL_CNSLD_AP_INVS.TRX_STATUS_CODE%TYPE
10: ,vendor_invoice_number OKL_CNSLD_AP_INVS.VENDOR_INVOICE_NUMBER%TYPE
11: ,currency_code OKL_CNSLD_AP_INVS.CURRENCY_CODE%TYPE
12: ,currency_conversion_type OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_TYPE%TYPE
13: ,currency_conversion_rate NUMBER
14: ,currency_conversion_date OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_DATE%TYPE
15: ,payment_method_code OKL_CNSLD_AP_INVS.PAYMENT_METHOD_CODE%TYPE
8: cnsld_ap_inv_id NUMBER
9: ,trx_status_code OKL_CNSLD_AP_INVS.TRX_STATUS_CODE%TYPE
10: ,vendor_invoice_number OKL_CNSLD_AP_INVS.VENDOR_INVOICE_NUMBER%TYPE
11: ,currency_code OKL_CNSLD_AP_INVS.CURRENCY_CODE%TYPE
12: ,currency_conversion_type OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_TYPE%TYPE
13: ,currency_conversion_rate NUMBER
14: ,currency_conversion_date OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_DATE%TYPE
15: ,payment_method_code OKL_CNSLD_AP_INVS.PAYMENT_METHOD_CODE%TYPE
16: ,pay_group_lookup_code OKL_CNSLD_AP_INVS.PAY_GROUP_LOOKUP_CODE%TYPE
10: ,vendor_invoice_number OKL_CNSLD_AP_INVS.VENDOR_INVOICE_NUMBER%TYPE
11: ,currency_code OKL_CNSLD_AP_INVS.CURRENCY_CODE%TYPE
12: ,currency_conversion_type OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_TYPE%TYPE
13: ,currency_conversion_rate NUMBER
14: ,currency_conversion_date OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_DATE%TYPE
15: ,payment_method_code OKL_CNSLD_AP_INVS.PAYMENT_METHOD_CODE%TYPE
16: ,pay_group_lookup_code OKL_CNSLD_AP_INVS.PAY_GROUP_LOOKUP_CODE%TYPE
17: ,invoice_type OKL_CNSLD_AP_INVS.INVOICE_TYPE%TYPE
18: ,set_of_books_id NUMBER
11: ,currency_code OKL_CNSLD_AP_INVS.CURRENCY_CODE%TYPE
12: ,currency_conversion_type OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_TYPE%TYPE
13: ,currency_conversion_rate NUMBER
14: ,currency_conversion_date OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_DATE%TYPE
15: ,payment_method_code OKL_CNSLD_AP_INVS.PAYMENT_METHOD_CODE%TYPE
16: ,pay_group_lookup_code OKL_CNSLD_AP_INVS.PAY_GROUP_LOOKUP_CODE%TYPE
17: ,invoice_type OKL_CNSLD_AP_INVS.INVOICE_TYPE%TYPE
18: ,set_of_books_id NUMBER
19: ,try_id NUMBER
12: ,currency_conversion_type OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_TYPE%TYPE
13: ,currency_conversion_rate NUMBER
14: ,currency_conversion_date OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_DATE%TYPE
15: ,payment_method_code OKL_CNSLD_AP_INVS.PAYMENT_METHOD_CODE%TYPE
16: ,pay_group_lookup_code OKL_CNSLD_AP_INVS.PAY_GROUP_LOOKUP_CODE%TYPE
17: ,invoice_type OKL_CNSLD_AP_INVS.INVOICE_TYPE%TYPE
18: ,set_of_books_id NUMBER
19: ,try_id NUMBER
20: ,ipvs_id NUMBER
13: ,currency_conversion_rate NUMBER
14: ,currency_conversion_date OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_DATE%TYPE
15: ,payment_method_code OKL_CNSLD_AP_INVS.PAYMENT_METHOD_CODE%TYPE
16: ,pay_group_lookup_code OKL_CNSLD_AP_INVS.PAY_GROUP_LOOKUP_CODE%TYPE
17: ,invoice_type OKL_CNSLD_AP_INVS.INVOICE_TYPE%TYPE
18: ,set_of_books_id NUMBER
19: ,try_id NUMBER
20: ,ipvs_id NUMBER
21: ,ippt_id NUMBER
18: ,set_of_books_id NUMBER
19: ,try_id NUMBER
20: ,ipvs_id NUMBER
21: ,ippt_id NUMBER
22: ,date_invoiced OKL_CNSLD_AP_INVS.DATE_INVOICED%TYPE
23: ,amount NUMBER
24: ,invoice_number OKL_CNSLD_AP_INVS.INVOICE_NUMBER%TYPE
25: ,date_gl OKL_CNSLD_AP_INVS.DATE_GL%TYPE
26: ,vendor_id NUMBER
20: ,ipvs_id NUMBER
21: ,ippt_id NUMBER
22: ,date_invoiced OKL_CNSLD_AP_INVS.DATE_INVOICED%TYPE
23: ,amount NUMBER
24: ,invoice_number OKL_CNSLD_AP_INVS.INVOICE_NUMBER%TYPE
25: ,date_gl OKL_CNSLD_AP_INVS.DATE_GL%TYPE
26: ,vendor_id NUMBER
27: ,org_id NUMBER
28: ,legal_entity_id NUMBER
21: ,ippt_id NUMBER
22: ,date_invoiced OKL_CNSLD_AP_INVS.DATE_INVOICED%TYPE
23: ,amount NUMBER
24: ,invoice_number OKL_CNSLD_AP_INVS.INVOICE_NUMBER%TYPE
25: ,date_gl OKL_CNSLD_AP_INVS.DATE_GL%TYPE
26: ,vendor_id NUMBER
27: ,org_id NUMBER
28: ,legal_entity_id NUMBER
29: ,vpa_id NUMBER
27: ,org_id NUMBER
28: ,legal_entity_id NUMBER
29: ,vpa_id NUMBER
30: ,accts_pay_cc_id NUMBER
31: ,fee_charged_yn OKL_CNSLD_AP_INVS.FEE_CHARGED_YN%TYPE
32: ,self_bill_yn OKL_CNSLD_AP_INVS.SELF_BILL_YN%TYPE
33: ,self_bill_inv_num OKL_CNSLD_AP_INVS.SELF_BILL_INV_NUM%TYPE
34: ,match_required_yn OKL_CNSLD_AP_INVS.MATCH_REQUIRED_YN%TYPE
35: ,object_version_number NUMBER
28: ,legal_entity_id NUMBER
29: ,vpa_id NUMBER
30: ,accts_pay_cc_id NUMBER
31: ,fee_charged_yn OKL_CNSLD_AP_INVS.FEE_CHARGED_YN%TYPE
32: ,self_bill_yn OKL_CNSLD_AP_INVS.SELF_BILL_YN%TYPE
33: ,self_bill_inv_num OKL_CNSLD_AP_INVS.SELF_BILL_INV_NUM%TYPE
34: ,match_required_yn OKL_CNSLD_AP_INVS.MATCH_REQUIRED_YN%TYPE
35: ,object_version_number NUMBER
36: ,request_id NUMBER
29: ,vpa_id NUMBER
30: ,accts_pay_cc_id NUMBER
31: ,fee_charged_yn OKL_CNSLD_AP_INVS.FEE_CHARGED_YN%TYPE
32: ,self_bill_yn OKL_CNSLD_AP_INVS.SELF_BILL_YN%TYPE
33: ,self_bill_inv_num OKL_CNSLD_AP_INVS.SELF_BILL_INV_NUM%TYPE
34: ,match_required_yn OKL_CNSLD_AP_INVS.MATCH_REQUIRED_YN%TYPE
35: ,object_version_number NUMBER
36: ,request_id NUMBER
37: ,program_application_id NUMBER
30: ,accts_pay_cc_id NUMBER
31: ,fee_charged_yn OKL_CNSLD_AP_INVS.FEE_CHARGED_YN%TYPE
32: ,self_bill_yn OKL_CNSLD_AP_INVS.SELF_BILL_YN%TYPE
33: ,self_bill_inv_num OKL_CNSLD_AP_INVS.SELF_BILL_INV_NUM%TYPE
34: ,match_required_yn OKL_CNSLD_AP_INVS.MATCH_REQUIRED_YN%TYPE
35: ,object_version_number NUMBER
36: ,request_id NUMBER
37: ,program_application_id NUMBER
38: ,program_id NUMBER
35: ,object_version_number NUMBER
36: ,request_id NUMBER
37: ,program_application_id NUMBER
38: ,program_id NUMBER
39: ,program_update_date OKL_CNSLD_AP_INVS.PROGRAM_UPDATE_DATE%TYPE
40: ,attribute_category OKL_CNSLD_AP_INVS.ATTRIBUTE_CATEGORY%TYPE
41: ,attribute1 OKL_CNSLD_AP_INVS.ATTRIBUTE1%TYPE
42: ,attribute2 OKL_CNSLD_AP_INVS.ATTRIBUTE2%TYPE
43: ,attribute3 OKL_CNSLD_AP_INVS.ATTRIBUTE3%TYPE
36: ,request_id NUMBER
37: ,program_application_id NUMBER
38: ,program_id NUMBER
39: ,program_update_date OKL_CNSLD_AP_INVS.PROGRAM_UPDATE_DATE%TYPE
40: ,attribute_category OKL_CNSLD_AP_INVS.ATTRIBUTE_CATEGORY%TYPE
41: ,attribute1 OKL_CNSLD_AP_INVS.ATTRIBUTE1%TYPE
42: ,attribute2 OKL_CNSLD_AP_INVS.ATTRIBUTE2%TYPE
43: ,attribute3 OKL_CNSLD_AP_INVS.ATTRIBUTE3%TYPE
44: ,attribute4 OKL_CNSLD_AP_INVS.ATTRIBUTE4%TYPE
37: ,program_application_id NUMBER
38: ,program_id NUMBER
39: ,program_update_date OKL_CNSLD_AP_INVS.PROGRAM_UPDATE_DATE%TYPE
40: ,attribute_category OKL_CNSLD_AP_INVS.ATTRIBUTE_CATEGORY%TYPE
41: ,attribute1 OKL_CNSLD_AP_INVS.ATTRIBUTE1%TYPE
42: ,attribute2 OKL_CNSLD_AP_INVS.ATTRIBUTE2%TYPE
43: ,attribute3 OKL_CNSLD_AP_INVS.ATTRIBUTE3%TYPE
44: ,attribute4 OKL_CNSLD_AP_INVS.ATTRIBUTE4%TYPE
45: ,attribute5 OKL_CNSLD_AP_INVS.ATTRIBUTE5%TYPE
38: ,program_id NUMBER
39: ,program_update_date OKL_CNSLD_AP_INVS.PROGRAM_UPDATE_DATE%TYPE
40: ,attribute_category OKL_CNSLD_AP_INVS.ATTRIBUTE_CATEGORY%TYPE
41: ,attribute1 OKL_CNSLD_AP_INVS.ATTRIBUTE1%TYPE
42: ,attribute2 OKL_CNSLD_AP_INVS.ATTRIBUTE2%TYPE
43: ,attribute3 OKL_CNSLD_AP_INVS.ATTRIBUTE3%TYPE
44: ,attribute4 OKL_CNSLD_AP_INVS.ATTRIBUTE4%TYPE
45: ,attribute5 OKL_CNSLD_AP_INVS.ATTRIBUTE5%TYPE
46: ,attribute6 OKL_CNSLD_AP_INVS.ATTRIBUTE6%TYPE
39: ,program_update_date OKL_CNSLD_AP_INVS.PROGRAM_UPDATE_DATE%TYPE
40: ,attribute_category OKL_CNSLD_AP_INVS.ATTRIBUTE_CATEGORY%TYPE
41: ,attribute1 OKL_CNSLD_AP_INVS.ATTRIBUTE1%TYPE
42: ,attribute2 OKL_CNSLD_AP_INVS.ATTRIBUTE2%TYPE
43: ,attribute3 OKL_CNSLD_AP_INVS.ATTRIBUTE3%TYPE
44: ,attribute4 OKL_CNSLD_AP_INVS.ATTRIBUTE4%TYPE
45: ,attribute5 OKL_CNSLD_AP_INVS.ATTRIBUTE5%TYPE
46: ,attribute6 OKL_CNSLD_AP_INVS.ATTRIBUTE6%TYPE
47: ,attribute7 OKL_CNSLD_AP_INVS.ATTRIBUTE7%TYPE
40: ,attribute_category OKL_CNSLD_AP_INVS.ATTRIBUTE_CATEGORY%TYPE
41: ,attribute1 OKL_CNSLD_AP_INVS.ATTRIBUTE1%TYPE
42: ,attribute2 OKL_CNSLD_AP_INVS.ATTRIBUTE2%TYPE
43: ,attribute3 OKL_CNSLD_AP_INVS.ATTRIBUTE3%TYPE
44: ,attribute4 OKL_CNSLD_AP_INVS.ATTRIBUTE4%TYPE
45: ,attribute5 OKL_CNSLD_AP_INVS.ATTRIBUTE5%TYPE
46: ,attribute6 OKL_CNSLD_AP_INVS.ATTRIBUTE6%TYPE
47: ,attribute7 OKL_CNSLD_AP_INVS.ATTRIBUTE7%TYPE
48: ,attribute8 OKL_CNSLD_AP_INVS.ATTRIBUTE8%TYPE
41: ,attribute1 OKL_CNSLD_AP_INVS.ATTRIBUTE1%TYPE
42: ,attribute2 OKL_CNSLD_AP_INVS.ATTRIBUTE2%TYPE
43: ,attribute3 OKL_CNSLD_AP_INVS.ATTRIBUTE3%TYPE
44: ,attribute4 OKL_CNSLD_AP_INVS.ATTRIBUTE4%TYPE
45: ,attribute5 OKL_CNSLD_AP_INVS.ATTRIBUTE5%TYPE
46: ,attribute6 OKL_CNSLD_AP_INVS.ATTRIBUTE6%TYPE
47: ,attribute7 OKL_CNSLD_AP_INVS.ATTRIBUTE7%TYPE
48: ,attribute8 OKL_CNSLD_AP_INVS.ATTRIBUTE8%TYPE
49: ,attribute9 OKL_CNSLD_AP_INVS.ATTRIBUTE9%TYPE
42: ,attribute2 OKL_CNSLD_AP_INVS.ATTRIBUTE2%TYPE
43: ,attribute3 OKL_CNSLD_AP_INVS.ATTRIBUTE3%TYPE
44: ,attribute4 OKL_CNSLD_AP_INVS.ATTRIBUTE4%TYPE
45: ,attribute5 OKL_CNSLD_AP_INVS.ATTRIBUTE5%TYPE
46: ,attribute6 OKL_CNSLD_AP_INVS.ATTRIBUTE6%TYPE
47: ,attribute7 OKL_CNSLD_AP_INVS.ATTRIBUTE7%TYPE
48: ,attribute8 OKL_CNSLD_AP_INVS.ATTRIBUTE8%TYPE
49: ,attribute9 OKL_CNSLD_AP_INVS.ATTRIBUTE9%TYPE
50: ,attribute10 OKL_CNSLD_AP_INVS.ATTRIBUTE10%TYPE
43: ,attribute3 OKL_CNSLD_AP_INVS.ATTRIBUTE3%TYPE
44: ,attribute4 OKL_CNSLD_AP_INVS.ATTRIBUTE4%TYPE
45: ,attribute5 OKL_CNSLD_AP_INVS.ATTRIBUTE5%TYPE
46: ,attribute6 OKL_CNSLD_AP_INVS.ATTRIBUTE6%TYPE
47: ,attribute7 OKL_CNSLD_AP_INVS.ATTRIBUTE7%TYPE
48: ,attribute8 OKL_CNSLD_AP_INVS.ATTRIBUTE8%TYPE
49: ,attribute9 OKL_CNSLD_AP_INVS.ATTRIBUTE9%TYPE
50: ,attribute10 OKL_CNSLD_AP_INVS.ATTRIBUTE10%TYPE
51: ,attribute11 OKL_CNSLD_AP_INVS.ATTRIBUTE11%TYPE
44: ,attribute4 OKL_CNSLD_AP_INVS.ATTRIBUTE4%TYPE
45: ,attribute5 OKL_CNSLD_AP_INVS.ATTRIBUTE5%TYPE
46: ,attribute6 OKL_CNSLD_AP_INVS.ATTRIBUTE6%TYPE
47: ,attribute7 OKL_CNSLD_AP_INVS.ATTRIBUTE7%TYPE
48: ,attribute8 OKL_CNSLD_AP_INVS.ATTRIBUTE8%TYPE
49: ,attribute9 OKL_CNSLD_AP_INVS.ATTRIBUTE9%TYPE
50: ,attribute10 OKL_CNSLD_AP_INVS.ATTRIBUTE10%TYPE
51: ,attribute11 OKL_CNSLD_AP_INVS.ATTRIBUTE11%TYPE
52: ,attribute12 OKL_CNSLD_AP_INVS.ATTRIBUTE12%TYPE
45: ,attribute5 OKL_CNSLD_AP_INVS.ATTRIBUTE5%TYPE
46: ,attribute6 OKL_CNSLD_AP_INVS.ATTRIBUTE6%TYPE
47: ,attribute7 OKL_CNSLD_AP_INVS.ATTRIBUTE7%TYPE
48: ,attribute8 OKL_CNSLD_AP_INVS.ATTRIBUTE8%TYPE
49: ,attribute9 OKL_CNSLD_AP_INVS.ATTRIBUTE9%TYPE
50: ,attribute10 OKL_CNSLD_AP_INVS.ATTRIBUTE10%TYPE
51: ,attribute11 OKL_CNSLD_AP_INVS.ATTRIBUTE11%TYPE
52: ,attribute12 OKL_CNSLD_AP_INVS.ATTRIBUTE12%TYPE
53: ,attribute13 OKL_CNSLD_AP_INVS.ATTRIBUTE13%TYPE
46: ,attribute6 OKL_CNSLD_AP_INVS.ATTRIBUTE6%TYPE
47: ,attribute7 OKL_CNSLD_AP_INVS.ATTRIBUTE7%TYPE
48: ,attribute8 OKL_CNSLD_AP_INVS.ATTRIBUTE8%TYPE
49: ,attribute9 OKL_CNSLD_AP_INVS.ATTRIBUTE9%TYPE
50: ,attribute10 OKL_CNSLD_AP_INVS.ATTRIBUTE10%TYPE
51: ,attribute11 OKL_CNSLD_AP_INVS.ATTRIBUTE11%TYPE
52: ,attribute12 OKL_CNSLD_AP_INVS.ATTRIBUTE12%TYPE
53: ,attribute13 OKL_CNSLD_AP_INVS.ATTRIBUTE13%TYPE
54: ,attribute14 OKL_CNSLD_AP_INVS.ATTRIBUTE14%TYPE
47: ,attribute7 OKL_CNSLD_AP_INVS.ATTRIBUTE7%TYPE
48: ,attribute8 OKL_CNSLD_AP_INVS.ATTRIBUTE8%TYPE
49: ,attribute9 OKL_CNSLD_AP_INVS.ATTRIBUTE9%TYPE
50: ,attribute10 OKL_CNSLD_AP_INVS.ATTRIBUTE10%TYPE
51: ,attribute11 OKL_CNSLD_AP_INVS.ATTRIBUTE11%TYPE
52: ,attribute12 OKL_CNSLD_AP_INVS.ATTRIBUTE12%TYPE
53: ,attribute13 OKL_CNSLD_AP_INVS.ATTRIBUTE13%TYPE
54: ,attribute14 OKL_CNSLD_AP_INVS.ATTRIBUTE14%TYPE
55: ,attribute15 OKL_CNSLD_AP_INVS.ATTRIBUTE15%TYPE
48: ,attribute8 OKL_CNSLD_AP_INVS.ATTRIBUTE8%TYPE
49: ,attribute9 OKL_CNSLD_AP_INVS.ATTRIBUTE9%TYPE
50: ,attribute10 OKL_CNSLD_AP_INVS.ATTRIBUTE10%TYPE
51: ,attribute11 OKL_CNSLD_AP_INVS.ATTRIBUTE11%TYPE
52: ,attribute12 OKL_CNSLD_AP_INVS.ATTRIBUTE12%TYPE
53: ,attribute13 OKL_CNSLD_AP_INVS.ATTRIBUTE13%TYPE
54: ,attribute14 OKL_CNSLD_AP_INVS.ATTRIBUTE14%TYPE
55: ,attribute15 OKL_CNSLD_AP_INVS.ATTRIBUTE15%TYPE
56: ,created_by NUMBER
49: ,attribute9 OKL_CNSLD_AP_INVS.ATTRIBUTE9%TYPE
50: ,attribute10 OKL_CNSLD_AP_INVS.ATTRIBUTE10%TYPE
51: ,attribute11 OKL_CNSLD_AP_INVS.ATTRIBUTE11%TYPE
52: ,attribute12 OKL_CNSLD_AP_INVS.ATTRIBUTE12%TYPE
53: ,attribute13 OKL_CNSLD_AP_INVS.ATTRIBUTE13%TYPE
54: ,attribute14 OKL_CNSLD_AP_INVS.ATTRIBUTE14%TYPE
55: ,attribute15 OKL_CNSLD_AP_INVS.ATTRIBUTE15%TYPE
56: ,created_by NUMBER
57: ,creation_date OKL_CNSLD_AP_INVS.CREATION_DATE%TYPE
50: ,attribute10 OKL_CNSLD_AP_INVS.ATTRIBUTE10%TYPE
51: ,attribute11 OKL_CNSLD_AP_INVS.ATTRIBUTE11%TYPE
52: ,attribute12 OKL_CNSLD_AP_INVS.ATTRIBUTE12%TYPE
53: ,attribute13 OKL_CNSLD_AP_INVS.ATTRIBUTE13%TYPE
54: ,attribute14 OKL_CNSLD_AP_INVS.ATTRIBUTE14%TYPE
55: ,attribute15 OKL_CNSLD_AP_INVS.ATTRIBUTE15%TYPE
56: ,created_by NUMBER
57: ,creation_date OKL_CNSLD_AP_INVS.CREATION_DATE%TYPE
58: ,last_updated_by NUMBER
51: ,attribute11 OKL_CNSLD_AP_INVS.ATTRIBUTE11%TYPE
52: ,attribute12 OKL_CNSLD_AP_INVS.ATTRIBUTE12%TYPE
53: ,attribute13 OKL_CNSLD_AP_INVS.ATTRIBUTE13%TYPE
54: ,attribute14 OKL_CNSLD_AP_INVS.ATTRIBUTE14%TYPE
55: ,attribute15 OKL_CNSLD_AP_INVS.ATTRIBUTE15%TYPE
56: ,created_by NUMBER
57: ,creation_date OKL_CNSLD_AP_INVS.CREATION_DATE%TYPE
58: ,last_updated_by NUMBER
59: ,last_update_date OKL_CNSLD_AP_INVS.LAST_UPDATE_DATE%TYPE
53: ,attribute13 OKL_CNSLD_AP_INVS.ATTRIBUTE13%TYPE
54: ,attribute14 OKL_CNSLD_AP_INVS.ATTRIBUTE14%TYPE
55: ,attribute15 OKL_CNSLD_AP_INVS.ATTRIBUTE15%TYPE
56: ,created_by NUMBER
57: ,creation_date OKL_CNSLD_AP_INVS.CREATION_DATE%TYPE
58: ,last_updated_by NUMBER
59: ,last_update_date OKL_CNSLD_AP_INVS.LAST_UPDATE_DATE%TYPE
60: ,last_update_login NUMBER);
61: G_MISS_cin_rec cin_rec_type;
55: ,attribute15 OKL_CNSLD_AP_INVS.ATTRIBUTE15%TYPE
56: ,created_by NUMBER
57: ,creation_date OKL_CNSLD_AP_INVS.CREATION_DATE%TYPE
58: ,last_updated_by NUMBER
59: ,last_update_date OKL_CNSLD_AP_INVS.LAST_UPDATE_DATE%TYPE
60: ,last_update_login NUMBER);
61: G_MISS_cin_rec cin_rec_type;
62: TYPE cin_tbl_type IS TABLE OF cin_rec_type
63: INDEX BY BINARY_INTEGER;