5: ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
6: );
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: );
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: BILL_TO_PARTY_ID zx_rep_trx_detail_t.BILL_TO_PARTY_ID%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: BILL_TO_PARTY_ID zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE,
16: BILL_TO_PARTY_SITE_ID zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE
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: BILL_TO_PARTY_ID zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE,
16: BILL_TO_PARTY_SITE_ID zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE
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: BILL_TO_PARTY_ID zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE,
16: BILL_TO_PARTY_SITE_ID zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE
17: );
18:
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: BILL_TO_PARTY_ID zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE,
16: BILL_TO_PARTY_SITE_ID zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE
17: );
18:
19:
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: BILL_TO_PARTY_ID zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE,
16: BILL_TO_PARTY_SITE_ID zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE
17: );
18:
19:
20: TYPE cust_bill_ar_tbl IS TABLE OF cust_bill_ar_rec
23: g_cust_bill_ar_tbl cust_bill_ar_tbl;
24:
25:
26: TYPE party_bill_ar_rec IS RECORD(
27: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
28: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
29: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE,
30: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
31: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE
24:
25:
26: TYPE party_bill_ar_rec IS RECORD(
27: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
28: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
29: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE,
30: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
31: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE
32: -- BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE
25:
26: TYPE party_bill_ar_rec IS RECORD(
27: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
28: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
29: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE,
30: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
31: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE
32: -- BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE
33: );
26: TYPE party_bill_ar_rec IS RECORD(
27: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
28: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
29: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE,
30: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
31: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE
32: -- BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE
33: );
34:
27: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
28: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
29: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE,
30: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
31: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE
32: -- BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE
33: );
34:
35:
28: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
29: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE,
30: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
31: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE
32: -- BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE
33: );
34:
35:
36: TYPE party_bill_ar_tbl IS TABLE OF party_bill_ar_rec
39: g_party_bill_ar_tbl party_bill_ar_tbl;
40:
41:
42: TYPE site_bill_ar_rec IS RECORD(
43: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
44: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
45: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
46: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
47: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
40:
41:
42: TYPE site_bill_ar_rec IS RECORD(
43: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
44: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
45: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
46: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
47: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
48: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
41:
42: TYPE site_bill_ar_rec IS RECORD(
43: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
44: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
45: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
46: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
47: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
48: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
49: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
42: TYPE site_bill_ar_rec IS RECORD(
43: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
44: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
45: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
46: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
47: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
48: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
49: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
50: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
43: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
44: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
45: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
46: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
47: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
48: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
49: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
50: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
51: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
44: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
45: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
46: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
47: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
48: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
49: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
50: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
51: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
52: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE);
45: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
46: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
47: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
48: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
49: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
50: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
51: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
52: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE);
53:
46: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
47: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
48: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
49: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
50: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
51: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
52: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE);
53:
54:
47: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
48: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
49: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
50: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
51: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
52: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE);
53:
54:
55: TYPE site_bill_ar_tbl IS TABLE OF site_bill_ar_rec
48: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
49: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
50: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
51: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
52: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE);
53:
54:
55: TYPE site_bill_ar_tbl IS TABLE OF site_bill_ar_rec
56: INDEX BY BINARY_INTEGER;
58: g_site_bill_ar_tbl site_bill_ar_tbl;
59:
60:
61: TYPE cust_ship_ar_rec IS RECORD(
62: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
63: GDF_RA_CUST_SHIP_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT10%TYPE,
64: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
65: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
66: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
59:
60:
61: TYPE cust_ship_ar_rec IS RECORD(
62: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
63: GDF_RA_CUST_SHIP_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT10%TYPE,
64: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
65: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
66: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
67: SHIPPING_TP_SITE_NAME zx_rep_trx_detail_t.SHIPPING_TP_SITE_NAME%TYPE,
60:
61: TYPE cust_ship_ar_rec IS RECORD(
62: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
63: GDF_RA_CUST_SHIP_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT10%TYPE,
64: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
65: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
66: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
67: SHIPPING_TP_SITE_NAME zx_rep_trx_detail_t.SHIPPING_TP_SITE_NAME%TYPE,
68: SHIP_TO_PARTY_ID zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE,
61: TYPE cust_ship_ar_rec IS RECORD(
62: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
63: GDF_RA_CUST_SHIP_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT10%TYPE,
64: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
65: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
66: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
67: SHIPPING_TP_SITE_NAME zx_rep_trx_detail_t.SHIPPING_TP_SITE_NAME%TYPE,
68: SHIP_TO_PARTY_ID zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE,
69: SHIP_TO_PARTY_SITE_ID zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE
62: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
63: GDF_RA_CUST_SHIP_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT10%TYPE,
64: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
65: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
66: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
67: SHIPPING_TP_SITE_NAME zx_rep_trx_detail_t.SHIPPING_TP_SITE_NAME%TYPE,
68: SHIP_TO_PARTY_ID zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE,
69: SHIP_TO_PARTY_SITE_ID zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE
70: );
63: GDF_RA_CUST_SHIP_ATT10 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT10%TYPE,
64: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
65: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
66: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
67: SHIPPING_TP_SITE_NAME zx_rep_trx_detail_t.SHIPPING_TP_SITE_NAME%TYPE,
68: SHIP_TO_PARTY_ID zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE,
69: SHIP_TO_PARTY_SITE_ID zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE
70: );
71:
64: GDF_RA_CUST_SHIP_ATT12 zx_rep_trx_detail_t.GDF_RA_CUST_SHIP_ATT12%TYPE,
65: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
66: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
67: SHIPPING_TP_SITE_NAME zx_rep_trx_detail_t.SHIPPING_TP_SITE_NAME%TYPE,
68: SHIP_TO_PARTY_ID zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE,
69: SHIP_TO_PARTY_SITE_ID zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE
70: );
71:
72:
65: GDF_RA_ADDRESSES_SHIP_ATT8 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE,
66: GDF_RA_ADDRESSES_SHIP_ATT9 zx_rep_trx_detail_t.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE,
67: SHIPPING_TP_SITE_NAME zx_rep_trx_detail_t.SHIPPING_TP_SITE_NAME%TYPE,
68: SHIP_TO_PARTY_ID zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE,
69: SHIP_TO_PARTY_SITE_ID zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE
70: );
71:
72:
73: TYPE cust_ship_ar_tbl IS TABLE OF cust_ship_ar_rec
76: g_cust_ship_ar_tbl cust_ship_ar_tbl;
77:
78:
79: TYPE party_ship_ar_rec IS RECORD(
80: SHIPPING_TP_NAME zx_rep_trx_detail_t.SHIPPING_TP_NAME%TYPE,
81: SHIPPING_TP_NAME_ALT zx_rep_trx_detail_t.SHIPPING_TP_NAME_ALT%TYPE,
82: SHIPPING_TP_SIC_CODE zx_rep_trx_detail_t.SHIPPING_TP_SIC_CODE%TYPE,
83: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
84: SHIPPING_TP_TAXPAYER_ID zx_rep_trx_detail_t.SHIPPING_TP_TAXPAYER_ID%TYPE
77:
78:
79: TYPE party_ship_ar_rec IS RECORD(
80: SHIPPING_TP_NAME zx_rep_trx_detail_t.SHIPPING_TP_NAME%TYPE,
81: SHIPPING_TP_NAME_ALT zx_rep_trx_detail_t.SHIPPING_TP_NAME_ALT%TYPE,
82: SHIPPING_TP_SIC_CODE zx_rep_trx_detail_t.SHIPPING_TP_SIC_CODE%TYPE,
83: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
84: SHIPPING_TP_TAXPAYER_ID zx_rep_trx_detail_t.SHIPPING_TP_TAXPAYER_ID%TYPE
85: -- SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE
78:
79: TYPE party_ship_ar_rec IS RECORD(
80: SHIPPING_TP_NAME zx_rep_trx_detail_t.SHIPPING_TP_NAME%TYPE,
81: SHIPPING_TP_NAME_ALT zx_rep_trx_detail_t.SHIPPING_TP_NAME_ALT%TYPE,
82: SHIPPING_TP_SIC_CODE zx_rep_trx_detail_t.SHIPPING_TP_SIC_CODE%TYPE,
83: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
84: SHIPPING_TP_TAXPAYER_ID zx_rep_trx_detail_t.SHIPPING_TP_TAXPAYER_ID%TYPE
85: -- SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE
86: );
79: TYPE party_ship_ar_rec IS RECORD(
80: SHIPPING_TP_NAME zx_rep_trx_detail_t.SHIPPING_TP_NAME%TYPE,
81: SHIPPING_TP_NAME_ALT zx_rep_trx_detail_t.SHIPPING_TP_NAME_ALT%TYPE,
82: SHIPPING_TP_SIC_CODE zx_rep_trx_detail_t.SHIPPING_TP_SIC_CODE%TYPE,
83: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
84: SHIPPING_TP_TAXPAYER_ID zx_rep_trx_detail_t.SHIPPING_TP_TAXPAYER_ID%TYPE
85: -- SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE
86: );
87:
80: SHIPPING_TP_NAME zx_rep_trx_detail_t.SHIPPING_TP_NAME%TYPE,
81: SHIPPING_TP_NAME_ALT zx_rep_trx_detail_t.SHIPPING_TP_NAME_ALT%TYPE,
82: SHIPPING_TP_SIC_CODE zx_rep_trx_detail_t.SHIPPING_TP_SIC_CODE%TYPE,
83: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
84: SHIPPING_TP_TAXPAYER_ID zx_rep_trx_detail_t.SHIPPING_TP_TAXPAYER_ID%TYPE
85: -- SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE
86: );
87:
88:
81: SHIPPING_TP_NAME_ALT zx_rep_trx_detail_t.SHIPPING_TP_NAME_ALT%TYPE,
82: SHIPPING_TP_SIC_CODE zx_rep_trx_detail_t.SHIPPING_TP_SIC_CODE%TYPE,
83: SHIPPING_TP_NUMBER zx_rep_trx_detail_t.SHIPPING_TP_NUMBER%TYPE,
84: SHIPPING_TP_TAXPAYER_ID zx_rep_trx_detail_t.SHIPPING_TP_TAXPAYER_ID%TYPE
85: -- SHIPPING_TP_TAX_REG_NUM zx_rep_trx_detail_t.SHIPPING_TP_TAX_REG_NUM%TYPE
86: );
87:
88:
89: TYPE party_ship_ar_tbl IS TABLE OF party_ship_ar_rec
92: g_party_ship_ar_tbl party_ship_ar_tbl;
93:
94:
95: TYPE site_ship_ar_rec IS RECORD(
96: SHIPPING_TP_CITY zx_rep_trx_detail_t.SHIPPING_TP_CITY%TYPE,
97: SHIPPING_TP_COUNTY zx_rep_trx_detail_t.SHIPPING_TP_COUNTY%TYPE,
98: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
99: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
100: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
93:
94:
95: TYPE site_ship_ar_rec IS RECORD(
96: SHIPPING_TP_CITY zx_rep_trx_detail_t.SHIPPING_TP_CITY%TYPE,
97: SHIPPING_TP_COUNTY zx_rep_trx_detail_t.SHIPPING_TP_COUNTY%TYPE,
98: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
99: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
100: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
101: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
94:
95: TYPE site_ship_ar_rec IS RECORD(
96: SHIPPING_TP_CITY zx_rep_trx_detail_t.SHIPPING_TP_CITY%TYPE,
97: SHIPPING_TP_COUNTY zx_rep_trx_detail_t.SHIPPING_TP_COUNTY%TYPE,
98: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
99: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
100: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
101: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
102: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
95: TYPE site_ship_ar_rec IS RECORD(
96: SHIPPING_TP_CITY zx_rep_trx_detail_t.SHIPPING_TP_CITY%TYPE,
97: SHIPPING_TP_COUNTY zx_rep_trx_detail_t.SHIPPING_TP_COUNTY%TYPE,
98: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
99: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
100: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
101: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
102: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
103: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
96: SHIPPING_TP_CITY zx_rep_trx_detail_t.SHIPPING_TP_CITY%TYPE,
97: SHIPPING_TP_COUNTY zx_rep_trx_detail_t.SHIPPING_TP_COUNTY%TYPE,
98: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
99: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
100: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
101: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
102: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
103: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
104: SHIPPING_TP_COUNTRY zx_rep_trx_detail_t.SHIPPING_TP_COUNTRY%TYPE,
97: SHIPPING_TP_COUNTY zx_rep_trx_detail_t.SHIPPING_TP_COUNTY%TYPE,
98: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
99: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
100: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
101: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
102: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
103: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
104: SHIPPING_TP_COUNTRY zx_rep_trx_detail_t.SHIPPING_TP_COUNTRY%TYPE,
105: SHIPPING_TP_POSTAL_CODE zx_rep_trx_detail_t.SHIPPING_TP_POSTAL_CODE%TYPE);
98: SHIPPING_TP_STATE zx_rep_trx_detail_t.SHIPPING_TP_STATE%TYPE,
99: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
100: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
101: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
102: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
103: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
104: SHIPPING_TP_COUNTRY zx_rep_trx_detail_t.SHIPPING_TP_COUNTRY%TYPE,
105: SHIPPING_TP_POSTAL_CODE zx_rep_trx_detail_t.SHIPPING_TP_POSTAL_CODE%TYPE);
106:
99: SHIPPING_TP_PROVINCE zx_rep_trx_detail_t.SHIPPING_TP_PROVINCE%TYPE,
100: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
101: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
102: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
103: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
104: SHIPPING_TP_COUNTRY zx_rep_trx_detail_t.SHIPPING_TP_COUNTRY%TYPE,
105: SHIPPING_TP_POSTAL_CODE zx_rep_trx_detail_t.SHIPPING_TP_POSTAL_CODE%TYPE);
106:
107:
100: SHIPPING_TP_ADDRESS1 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS1%TYPE,
101: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
102: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
103: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
104: SHIPPING_TP_COUNTRY zx_rep_trx_detail_t.SHIPPING_TP_COUNTRY%TYPE,
105: SHIPPING_TP_POSTAL_CODE zx_rep_trx_detail_t.SHIPPING_TP_POSTAL_CODE%TYPE);
106:
107:
108: TYPE site_ship_ar_tbl IS TABLE OF site_ship_ar_rec
101: SHIPPING_TP_ADDRESS2 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS2%TYPE,
102: SHIPPING_TP_ADDRESS3 zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS3%TYPE,
103: SHIPPING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE,
104: SHIPPING_TP_COUNTRY zx_rep_trx_detail_t.SHIPPING_TP_COUNTRY%TYPE,
105: SHIPPING_TP_POSTAL_CODE zx_rep_trx_detail_t.SHIPPING_TP_POSTAL_CODE%TYPE);
106:
107:
108: TYPE site_ship_ar_tbl IS TABLE OF site_ship_ar_rec
109: INDEX BY BINARY_INTEGER;