5: ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
6: P_MRC_SOB_TYPE IN VARCHAR2);
7:
8: TYPE cust_bill_ar_rec IS RECORD(
9: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
10: GDF_RA_CUST_BILL_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_BILL_ATT10%TYPE,
11: GDF_RA_CUST_BILL_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_BILL_ATT12%TYPE,
12: GDF_RA_ADDRESSES_BILL_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT8%TYPE,
13: GDF_RA_ADDRESSES_BILL_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT9%TYPE,
6: P_MRC_SOB_TYPE IN VARCHAR2);
7:
8: TYPE cust_bill_ar_rec IS RECORD(
9: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
10: GDF_RA_CUST_BILL_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_BILL_ATT10%TYPE,
11: GDF_RA_CUST_BILL_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_BILL_ATT12%TYPE,
12: GDF_RA_ADDRESSES_BILL_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT8%TYPE,
13: GDF_RA_ADDRESSES_BILL_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT9%TYPE,
14: BILLING_TP_SITE_NAME zx_rep_trx_detail_t.BILLING_TP_SITE_NAME%TYPE,
7:
8: TYPE cust_bill_ar_rec IS RECORD(
9: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
10: GDF_RA_CUST_BILL_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_BILL_ATT10%TYPE,
11: GDF_RA_CUST_BILL_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_BILL_ATT12%TYPE,
12: GDF_RA_ADDRESSES_BILL_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT8%TYPE,
13: GDF_RA_ADDRESSES_BILL_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT9%TYPE,
14: BILLING_TP_SITE_NAME zx_rep_trx_detail_t.BILLING_TP_SITE_NAME%TYPE,
15: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE);
8: TYPE cust_bill_ar_rec IS RECORD(
9: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
10: GDF_RA_CUST_BILL_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_BILL_ATT10%TYPE,
11: GDF_RA_CUST_BILL_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_BILL_ATT12%TYPE,
12: GDF_RA_ADDRESSES_BILL_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT8%TYPE,
13: GDF_RA_ADDRESSES_BILL_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT9%TYPE,
14: BILLING_TP_SITE_NAME zx_rep_trx_detail_t.BILLING_TP_SITE_NAME%TYPE,
15: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE);
16:
9: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
10: GDF_RA_CUST_BILL_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_BILL_ATT10%TYPE,
11: GDF_RA_CUST_BILL_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_BILL_ATT12%TYPE,
12: GDF_RA_ADDRESSES_BILL_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT8%TYPE,
13: GDF_RA_ADDRESSES_BILL_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT9%TYPE,
14: BILLING_TP_SITE_NAME zx_rep_trx_detail_t.BILLING_TP_SITE_NAME%TYPE,
15: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE);
16:
17:
10: GDF_RA_CUST_BILL_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_BILL_ATT10%TYPE,
11: GDF_RA_CUST_BILL_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_BILL_ATT12%TYPE,
12: GDF_RA_ADDRESSES_BILL_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT8%TYPE,
13: GDF_RA_ADDRESSES_BILL_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT9%TYPE,
14: BILLING_TP_SITE_NAME zx_rep_trx_detail_t.BILLING_TP_SITE_NAME%TYPE,
15: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE);
16:
17:
18: TYPE cust_bill_ar_tbl IS TABLE OF cust_bill_ar_rec
11: GDF_RA_CUST_BILL_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_BILL_ATT12%TYPE,
12: GDF_RA_ADDRESSES_BILL_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT8%TYPE,
13: GDF_RA_ADDRESSES_BILL_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_BILL_ATT9%TYPE,
14: BILLING_TP_SITE_NAME zx_rep_trx_detail_t.BILLING_TP_SITE_NAME%TYPE,
15: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE);
16:
17:
18: TYPE cust_bill_ar_tbl IS TABLE OF cust_bill_ar_rec
19: INDEX BY BINARY_INTEGER;
21: g_cust_bill_ar_tbl cust_bill_ar_tbl;
22:
23:
24: TYPE party_bill_ar_rec IS RECORD(
25: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
26: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
27: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE,
28: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
29: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE,
22:
23:
24: TYPE party_bill_ar_rec IS RECORD(
25: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
26: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
27: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE,
28: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
29: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE,
30: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE);
23:
24: TYPE party_bill_ar_rec IS RECORD(
25: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
26: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
27: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE,
28: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
29: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE,
30: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE);
31:
24: TYPE party_bill_ar_rec IS RECORD(
25: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
26: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
27: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE,
28: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
29: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE,
30: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE);
31:
32:
25: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
26: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
27: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE,
28: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
29: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE,
30: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE);
31:
32:
33: TYPE party_bill_ar_tbl IS TABLE OF party_bill_ar_rec
26: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
27: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE,
28: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
29: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE,
30: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE);
31:
32:
33: TYPE party_bill_ar_tbl IS TABLE OF party_bill_ar_rec
34: INDEX BY BINARY_INTEGER;
36: g_party_bill_ar_tbl party_bill_ar_tbl;
37:
38:
39: TYPE site_bill_ar_rec IS RECORD(
40: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
41: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
42: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
43: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
44: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
37:
38:
39: TYPE site_bill_ar_rec IS RECORD(
40: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
41: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
42: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
43: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
44: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
45: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
38:
39: TYPE site_bill_ar_rec IS RECORD(
40: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
41: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
42: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
43: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
44: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
45: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
46: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
39: TYPE site_bill_ar_rec IS RECORD(
40: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
41: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
42: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
43: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
44: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
45: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
46: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
47: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
40: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
41: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
42: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
43: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
44: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
45: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
46: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
47: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
48: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
41: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
42: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
43: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
44: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
45: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
46: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
47: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
48: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
49: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE);
42: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
43: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
44: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
45: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
46: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
47: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
48: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
49: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE);
50:
43: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
44: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
45: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
46: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
47: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
48: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
49: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE);
50:
51:
44: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
45: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
46: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
47: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
48: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
49: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE);
50:
51:
52: TYPE site_bill_ar_tbl IS TABLE OF site_bill_ar_rec
45: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
46: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
47: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
48: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
49: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE);
50:
51:
52: TYPE site_bill_ar_tbl IS TABLE OF site_bill_ar_rec
53: INDEX BY BINARY_INTEGER;
55: g_site_bill_ar_tbl site_bill_ar_tbl;
56:
57:
58: TYPE cust_ship_ar_rec IS RECORD(
59: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
60: GDF_RA_CUST_SHIP_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT10%TYPE,
61: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
62: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
63: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
56:
57:
58: TYPE cust_ship_ar_rec IS RECORD(
59: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
60: GDF_RA_CUST_SHIP_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT10%TYPE,
61: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
62: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
63: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
64: SHIPPING_TP_SITE_NAME zx_rep_trx_detail_t.SHIPPING_TP_SITE_NAME%TYPE,
57:
58: TYPE cust_ship_ar_rec IS RECORD(
59: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
60: GDF_RA_CUST_SHIP_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT10%TYPE,
61: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
62: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
63: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
64: SHIPPING_TP_SITE_NAME zx_rep_trx_detail_t.SHIPPING_TP_SITE_NAME%TYPE,
65: SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE);
58: TYPE cust_ship_ar_rec IS RECORD(
59: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
60: GDF_RA_CUST_SHIP_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT10%TYPE,
61: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
62: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
63: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
64: SHIPPING_TP_SITE_NAME zx_rep_trx_detail_t.SHIPPING_TP_SITE_NAME%TYPE,
65: SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE);
66:
59: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
60: GDF_RA_CUST_SHIP_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT10%TYPE,
61: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
62: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
63: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
64: SHIPPING_TP_SITE_NAME zx_rep_trx_detail_t.SHIPPING_TP_SITE_NAME%TYPE,
65: SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE);
66:
67:
60: GDF_RA_CUST_SHIP_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT10%TYPE,
61: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
62: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
63: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
64: SHIPPING_TP_SITE_NAME zx_rep_trx_detail_t.SHIPPING_TP_SITE_NAME%TYPE,
65: SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE);
66:
67:
68: TYPE cust_ship_ar_tbl IS TABLE OF cust_ship_ar_rec
61: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
62: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
63: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
64: SHIPPING_TP_SITE_NAME zx_rep_trx_detail_t.SHIPPING_TP_SITE_NAME%TYPE,
65: SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE);
66:
67:
68: TYPE cust_ship_ar_tbl IS TABLE OF cust_ship_ar_rec
69: INDEX BY BINARY_INTEGER;
71: g_cust_ship_ar_tbl cust_ship_ar_tbl;
72:
73:
74: TYPE party_ship_ar_rec IS RECORD(
75: SHIPPING_TP_NAME zx_rep_trx_detail_t.SHIPPING_TP_NAME%TYPE,
76: SHIPPING_TP_NAME_ALT zx_rep_trx_detail_t.SHIPPING_TP_NAME_ALT%TYPE,
77: SHIPPING_TP_SIC_CODE zx_rep_trx_detail_t.SHIPPING_TP_SIC_CODE%TYPE,
78: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
79: SHIPPING_TP_TAXPAYER_ID zx_rep_trx_detail_t.SHIPPING_TP_TAXPAYER_ID%TYPE,
72:
73:
74: TYPE party_ship_ar_rec IS RECORD(
75: SHIPPING_TP_NAME zx_rep_trx_detail_t.SHIPPING_TP_NAME%TYPE,
76: SHIPPING_TP_NAME_ALT zx_rep_trx_detail_t.SHIPPING_TP_NAME_ALT%TYPE,
77: SHIPPING_TP_SIC_CODE zx_rep_trx_detail_t.SHIPPING_TP_SIC_CODE%TYPE,
78: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
79: SHIPPING_TP_TAXPAYER_ID zx_rep_trx_detail_t.SHIPPING_TP_TAXPAYER_ID%TYPE,
80: SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE);
73:
74: TYPE party_ship_ar_rec IS RECORD(
75: SHIPPING_TP_NAME zx_rep_trx_detail_t.SHIPPING_TP_NAME%TYPE,
76: SHIPPING_TP_NAME_ALT zx_rep_trx_detail_t.SHIPPING_TP_NAME_ALT%TYPE,
77: SHIPPING_TP_SIC_CODE zx_rep_trx_detail_t.SHIPPING_TP_SIC_CODE%TYPE,
78: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
79: SHIPPING_TP_TAXPAYER_ID zx_rep_trx_detail_t.SHIPPING_TP_TAXPAYER_ID%TYPE,
80: SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE);
81:
74: TYPE party_ship_ar_rec IS RECORD(
75: SHIPPING_TP_NAME zx_rep_trx_detail_t.SHIPPING_TP_NAME%TYPE,
76: SHIPPING_TP_NAME_ALT zx_rep_trx_detail_t.SHIPPING_TP_NAME_ALT%TYPE,
77: SHIPPING_TP_SIC_CODE zx_rep_trx_detail_t.SHIPPING_TP_SIC_CODE%TYPE,
78: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
79: SHIPPING_TP_TAXPAYER_ID zx_rep_trx_detail_t.SHIPPING_TP_TAXPAYER_ID%TYPE,
80: SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE);
81:
82:
75: SHIPPING_TP_NAME zx_rep_trx_detail_t.SHIPPING_TP_NAME%TYPE,
76: SHIPPING_TP_NAME_ALT zx_rep_trx_detail_t.SHIPPING_TP_NAME_ALT%TYPE,
77: SHIPPING_TP_SIC_CODE zx_rep_trx_detail_t.SHIPPING_TP_SIC_CODE%TYPE,
78: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
79: SHIPPING_TP_TAXPAYER_ID zx_rep_trx_detail_t.SHIPPING_TP_TAXPAYER_ID%TYPE,
80: SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE);
81:
82:
83: TYPE party_ship_ar_tbl IS TABLE OF party_ship_ar_rec
76: SHIPPING_TP_NAME_ALT zx_rep_trx_detail_t.SHIPPING_TP_NAME_ALT%TYPE,
77: SHIPPING_TP_SIC_CODE zx_rep_trx_detail_t.SHIPPING_TP_SIC_CODE%TYPE,
78: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
79: SHIPPING_TP_TAXPAYER_ID zx_rep_trx_detail_t.SHIPPING_TP_TAXPAYER_ID%TYPE,
80: SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE);
81:
82:
83: TYPE party_ship_ar_tbl IS TABLE OF party_ship_ar_rec
84: INDEX BY BINARY_INTEGER;
86: g_party_ship_ar_tbl party_ship_ar_tbl;
87:
88:
89: TYPE site_ship_ar_rec IS RECORD(
90: SHIPPING_TP_CITY zx_rep_trx_detail_t.SHIPPING_TP_CITY%TYPE,
91: SHIPPING_TP_COUNTY zx_rep_trx_detail_t.SHIPPING_TP_COUNTY%TYPE,
92: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
93: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
94: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
87:
88:
89: TYPE site_ship_ar_rec IS RECORD(
90: SHIPPING_TP_CITY zx_rep_trx_detail_t.SHIPPING_TP_CITY%TYPE,
91: SHIPPING_TP_COUNTY zx_rep_trx_detail_t.SHIPPING_TP_COUNTY%TYPE,
92: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
93: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
94: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
95: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
88:
89: TYPE site_ship_ar_rec IS RECORD(
90: SHIPPING_TP_CITY zx_rep_trx_detail_t.SHIPPING_TP_CITY%TYPE,
91: SHIPPING_TP_COUNTY zx_rep_trx_detail_t.SHIPPING_TP_COUNTY%TYPE,
92: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
93: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
94: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
95: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
96: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
89: TYPE site_ship_ar_rec IS RECORD(
90: SHIPPING_TP_CITY zx_rep_trx_detail_t.SHIPPING_TP_CITY%TYPE,
91: SHIPPING_TP_COUNTY zx_rep_trx_detail_t.SHIPPING_TP_COUNTY%TYPE,
92: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
93: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
94: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
95: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
96: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
97: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
90: SHIPPING_TP_CITY zx_rep_trx_detail_t.SHIPPING_TP_CITY%TYPE,
91: SHIPPING_TP_COUNTY zx_rep_trx_detail_t.SHIPPING_TP_COUNTY%TYPE,
92: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
93: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
94: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
95: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
96: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
97: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
98: SHIPPING_TP_COUNTRY zx_rep_trx_detail_t.SHIPPING_TP_COUNTRY%TYPE,
91: SHIPPING_TP_COUNTY zx_rep_trx_detail_t.SHIPPING_TP_COUNTY%TYPE,
92: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
93: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
94: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
95: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
96: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
97: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
98: SHIPPING_TP_COUNTRY zx_rep_trx_detail_t.SHIPPING_TP_COUNTRY%TYPE,
99: SHIPPING_TP_POSTAL_CODE zx_rep_trx_detail_t.SHIPPING_TP_POSTAL_CODE%TYPE);
92: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
93: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
94: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
95: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
96: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
97: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
98: SHIPPING_TP_COUNTRY zx_rep_trx_detail_t.SHIPPING_TP_COUNTRY%TYPE,
99: SHIPPING_TP_POSTAL_CODE zx_rep_trx_detail_t.SHIPPING_TP_POSTAL_CODE%TYPE);
100:
93: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
94: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
95: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
96: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
97: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
98: SHIPPING_TP_COUNTRY zx_rep_trx_detail_t.SHIPPING_TP_COUNTRY%TYPE,
99: SHIPPING_TP_POSTAL_CODE zx_rep_trx_detail_t.SHIPPING_TP_POSTAL_CODE%TYPE);
100:
101:
94: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
95: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
96: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
97: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
98: SHIPPING_TP_COUNTRY zx_rep_trx_detail_t.SHIPPING_TP_COUNTRY%TYPE,
99: SHIPPING_TP_POSTAL_CODE zx_rep_trx_detail_t.SHIPPING_TP_POSTAL_CODE%TYPE);
100:
101:
102: TYPE site_ship_ar_tbl IS TABLE OF site_ship_ar_rec
95: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
96: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
97: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
98: SHIPPING_TP_COUNTRY zx_rep_trx_detail_t.SHIPPING_TP_COUNTRY%TYPE,
99: SHIPPING_TP_POSTAL_CODE zx_rep_trx_detail_t.SHIPPING_TP_POSTAL_CODE%TYPE);
100:
101:
102: TYPE site_ship_ar_tbl IS TABLE OF site_ship_ar_rec
103: INDEX BY BINARY_INTEGER;