1: PACKAGE ZX_AP_ACTG_POPULATE_PKG AUTHID CURRENT_USER AS
2: /* $Header: zxripactgpoppvts.pls 120.2 2009/08/05 11:20:12 msakalab ship $ */
3: TYPE party_info_ap_rec IS RECORD
4: (
5: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
6: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE,
7: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE,
8: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
9: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
2: /* $Header: zxripactgpoppvts.pls 120.2 2009/08/05 11:20:12 msakalab ship $ */
3: TYPE party_info_ap_rec IS RECORD
4: (
5: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
6: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE,
7: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE,
8: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
9: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
10: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE);
3: TYPE party_info_ap_rec IS RECORD
4: (
5: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
6: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE,
7: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE,
8: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
9: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
10: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE);
11:
4: (
5: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
6: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE,
7: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE,
8: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
9: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
10: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE);
11:
12: TYPE party_info_ap_tbl IS TABLE OF party_info_ap_rec
5: BILLING_TP_NUMBER zx_rep_trx_detail_t.BILLING_TP_NUMBER%TYPE,
6: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE,
7: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE,
8: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
9: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
10: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE);
11:
12: TYPE party_info_ap_tbl IS TABLE OF party_info_ap_rec
13: INDEX BY BINARY_INTEGER;
6: BILLING_TP_TAX_REG_NUM zx_rep_trx_detail_t.BILLING_TP_TAX_REG_NUM%TYPE,
7: BILLING_TP_TAXPAYER_ID zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE,
8: BILLING_TP_NAME zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
9: BILLING_TP_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
10: BILLING_TP_SIC_CODE zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE);
11:
12: TYPE party_info_ap_tbl IS TABLE OF party_info_ap_rec
13: INDEX BY BINARY_INTEGER;
14:
17:
18: TYPE party_site_info_ap_rec IS RECORD
19: (
20:
21: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
22: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
23: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
24: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
25: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
18: TYPE party_site_info_ap_rec IS RECORD
19: (
20:
21: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
22: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
23: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
24: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
25: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
26: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
19: (
20:
21: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
22: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
23: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
24: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
25: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
26: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
27: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
20:
21: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
22: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
23: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
24: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
25: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
26: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
27: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
28: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
21: BILLING_TP_CITY zx_rep_trx_detail_t.BILLING_TP_CITY%TYPE,
22: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
23: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
24: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
25: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
26: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
27: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
28: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
29: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
22: BILLING_TP_COUNTY zx_rep_trx_detail_t.BILLING_TP_COUNTY%TYPE,
23: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
24: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
25: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
26: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
27: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
28: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
29: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
30: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE,
23: BILLING_TP_STATE zx_rep_trx_detail_t.BILLING_TP_STATE%TYPE,
24: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
25: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
26: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
27: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
28: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
29: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
30: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE,
31: GDF_PO_VENDOR_SITE_ATT17 zx_rep_trx_detail_t.GDF_PO_VENDOR_SITE_ATT17%TYPE,
24: BILLING_TP_PROVINCE zx_rep_trx_detail_t.BILLING_TP_PROVINCE%TYPE,
25: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
26: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
27: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
28: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
29: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
30: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE,
31: GDF_PO_VENDOR_SITE_ATT17 zx_rep_trx_detail_t.GDF_PO_VENDOR_SITE_ATT17%TYPE,
32: BILLING_TP_SITE_NAME zx_rep_trx_detail_t.BILLING_TP_SITE_NAME%TYPE,
25: BILLING_TP_ADDRESS1 zx_rep_trx_detail_t.BILLING_TP_ADDRESS1%TYPE,
26: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
27: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
28: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
29: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
30: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE,
31: GDF_PO_VENDOR_SITE_ATT17 zx_rep_trx_detail_t.GDF_PO_VENDOR_SITE_ATT17%TYPE,
32: BILLING_TP_SITE_NAME zx_rep_trx_detail_t.BILLING_TP_SITE_NAME%TYPE,
33: BILLING_TP_SITE_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_SITE_NAME_ALT%TYPE);
26: BILLING_TP_ADDRESS2 zx_rep_trx_detail_t.BILLING_TP_ADDRESS2%TYPE,
27: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
28: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
29: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
30: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE,
31: GDF_PO_VENDOR_SITE_ATT17 zx_rep_trx_detail_t.GDF_PO_VENDOR_SITE_ATT17%TYPE,
32: BILLING_TP_SITE_NAME zx_rep_trx_detail_t.BILLING_TP_SITE_NAME%TYPE,
33: BILLING_TP_SITE_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_SITE_NAME_ALT%TYPE);
34:
27: BILLING_TP_ADDRESS3 zx_rep_trx_detail_t.BILLING_TP_ADDRESS3%TYPE,
28: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
29: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
30: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE,
31: GDF_PO_VENDOR_SITE_ATT17 zx_rep_trx_detail_t.GDF_PO_VENDOR_SITE_ATT17%TYPE,
32: BILLING_TP_SITE_NAME zx_rep_trx_detail_t.BILLING_TP_SITE_NAME%TYPE,
33: BILLING_TP_SITE_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_SITE_NAME_ALT%TYPE);
34:
35: TYPE party_site_info_ap_tbl IS TABLE OF party_site_info_ap_rec
28: BILLING_TP_ADDR_LINES_ALT zx_rep_trx_detail_t.BILLING_TP_ADDRESS_LINES_ALT%TYPE,
29: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
30: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE,
31: GDF_PO_VENDOR_SITE_ATT17 zx_rep_trx_detail_t.GDF_PO_VENDOR_SITE_ATT17%TYPE,
32: BILLING_TP_SITE_NAME zx_rep_trx_detail_t.BILLING_TP_SITE_NAME%TYPE,
33: BILLING_TP_SITE_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_SITE_NAME_ALT%TYPE);
34:
35: TYPE party_site_info_ap_tbl IS TABLE OF party_site_info_ap_rec
36: INDEX BY BINARY_INTEGER;
29: BILLING_TP_COUNTRY zx_rep_trx_detail_t.BILLING_TP_COUNTRY%TYPE,
30: BILLING_TP_POSTAL_CODE zx_rep_trx_detail_t.BILLING_TP_POSTAL_CODE%TYPE,
31: GDF_PO_VENDOR_SITE_ATT17 zx_rep_trx_detail_t.GDF_PO_VENDOR_SITE_ATT17%TYPE,
32: BILLING_TP_SITE_NAME zx_rep_trx_detail_t.BILLING_TP_SITE_NAME%TYPE,
33: BILLING_TP_SITE_NAME_ALT zx_rep_trx_detail_t.BILLING_TP_SITE_NAME_ALT%TYPE);
34:
35: TYPE party_site_info_ap_tbl IS TABLE OF party_site_info_ap_rec
36: INDEX BY BINARY_INTEGER;
37: