PACKAGE: APPS.ZX_AP_ACTG_POPULATE_PKG

Source

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,
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     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 
38     g_party_site_tbl     party_site_info_ap_tbl;
39 
40 
41 
42   TYPE lookup_info_rec IS RECORD
43        (
44         lookup_meaning               FND_LOOKUPS.MEANING%TYPE,
45         lookup_description            FND_LOOKUPS.DESCRIPTION%TYPE);
46 
47     TYPE lookup_info_tbl IS TABLE OF lookup_info_rec
48     INDEX BY BINARY_INTEGER;
49 
50     g_lookup_info_tbl             lookup_info_tbl;
51 
52 
53 PROCEDURE update_additional_info(
54           P_TRL_GLOBAL_VARIABLES_REC  IN OUT NOCOPY ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE,
55            P_MRC_SOB_TYPE IN VARCHAR2);
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_ACTG_POPULATE_PKG;