PACKAGE: APPS.ZX_AP_ACTG_POPULATE_PKG

Source

1 PACKAGE ZX_AP_ACTG_POPULATE_PKG AS
2 /* $Header: zxripactgpoppvts.pls 120.1 2005/07/29 12:32:24 skorrapa 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);
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 
34     TYPE party_site_info_ap_tbl IS TABLE OF party_site_info_ap_rec
35     INDEX BY BINARY_INTEGER;
36 
37     g_party_site_tbl     party_site_info_ap_tbl;
38 
39 
40 
41   TYPE lookup_info_rec IS RECORD
42        (
43         lookup_meaning               FND_LOOKUPS.MEANING%TYPE,
44         lookup_description            FND_LOOKUPS.DESCRIPTION%TYPE);
45 
46     TYPE lookup_info_tbl IS TABLE OF lookup_info_rec
47     INDEX BY BINARY_INTEGER;
48 
49     g_lookup_info_tbl             lookup_info_tbl;
50 
51 
52 PROCEDURE update_additional_info(
53           P_TRL_GLOBAL_VARIABLES_REC  IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
54            P_MRC_SOB_TYPE IN VARCHAR2);
55 
56 PROCEDURE lookup_desc_meaning(
57            p_lookup_type IN  VARCHAR2,
58            p_lookup_code IN  VARCHAR2,
59            p_meaning     OUT NOCOPY VARCHAR2,
60            p_description OUT NOCOPY VARCHAR2);
61 
62 END ZX_AP_ACTG_POPULATE_PKG;