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_ACTG_POPULATE_PKG

Source


1 PACKAGE ZX_AR_ACTG_POPULATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxriractgpoppvts.pls 120.2 2006/02/08 14:32:07 rjreddy ship $ */
3 
4 PROCEDURE UPDATE_ADDITIONAL_INFO (P_TRL_GLOBAL_VARIABLES_REC IN OUT
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,
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;
20 
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,
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;
35 
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,
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;
54 
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,
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;
70 
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,
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;
85 
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,
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;
104 
105     g_site_ship_ar_tbl     site_ship_ar_tbl;
106 END ZX_AR_ACTG_POPULATE_PKG;