eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.ZX_AR_POPULATE_PKG

Source


1 PACKAGE ZX_AR_POPULATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxrirpopulatpvts.pls 120.4 2006/06/01 01:25:16 skorrapa ship $ */
3 
4 PROCEDURE UPDATE_ADDITIONAL_INFO (P_TRL_GLOBAL_VARIABLES_REC IN OUT
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,
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
21     INDEX BY BINARY_INTEGER;
22 
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
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
37     INDEX BY BINARY_INTEGER;
38 
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,
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;
57 
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,
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
74     INDEX BY BINARY_INTEGER;
75 
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
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
90     INDEX BY BINARY_INTEGER;
91 
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,
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;
110 
111     g_site_ship_ar_tbl     site_ship_ar_tbl;
112 END ZX_AR_POPULATE_PKG;