PACKAGE: APPS.ZX_AP_POPULATE_PKG

Source

1 PACKAGE ZX_AP_POPULATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxrippopulatpvts.pls 120.2.12010000.2 2009/08/05 11:16:37 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_TAXPAYER_ID   zx_rep_trx_detail_t.BILLING_TP_TAXPAYER_ID%TYPE,
7         BILLING_TP_NAME          zx_rep_trx_detail_t.BILLING_TP_NAME%TYPE,
8         BILLING_TP_NAME_ALT      zx_rep_trx_detail_t.BILLING_TP_NAME_ALT%TYPE,
9         BILLING_TP_SIC_CODE      zx_rep_trx_detail_t.BILLING_TP_SIC_CODE%TYPE,
10         BILL_FROM_PARTY_ID      zx_rep_trx_detail_t.BILL_FROM_PARTY_ID%TYPE);
11 
12     TYPE party_info_ap_tbl IS TABLE OF party_info_ap_rec
13     INDEX BY BINARY_INTEGER;
14 
15     g_party_info_ap_tbl     party_info_ap_tbl;
16 
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,
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_ALT zx_rep_trx_detail_t.BILLING_TP_SITE_NAME_ALT%TYPE,
33         BILLING_TP_SITE_NAME     zx_rep_trx_detail_t.BILLING_TP_SITE_NAME%TYPE,
34         BILL_FROM_PARTY_SITE_ID      zx_rep_trx_detail_t.BILL_FROM_PARTY_SITE_ID%TYPE);
35 
36     TYPE party_site_info_ap_tbl IS TABLE OF party_site_info_ap_rec
37     INDEX BY BINARY_INTEGER;
38 
39     g_party_site_tbl     party_site_info_ap_tbl;
40 
41 
42 
43   TYPE lookup_info_rec IS RECORD
44        (
45         lookup_meaning               FND_LOOKUPS.MEANING%TYPE,
46         lookup_description            FND_LOOKUPS.DESCRIPTION%TYPE);
47 
48     TYPE lookup_info_tbl IS TABLE OF lookup_info_rec
49     INDEX BY BINARY_INTEGER;
50 
51     g_lookup_info_tbl             lookup_info_tbl;
52 
53 
54 PROCEDURE update_additional_info(
55           P_TRL_GLOBAL_VARIABLES_REC  IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE);
56 
57 PROCEDURE lookup_desc_meaning(
58            p_lookup_type IN  VARCHAR2,
59            p_lookup_code IN  VARCHAR2,
60            p_meaning     OUT NOCOPY VARCHAR2,
61            p_description OUT NOCOPY VARCHAR2);
62 
63 END ZX_AP_POPULATE_PKG;