[Home] [Help]
PACKAGE: APPS.GMF_TRANSACTION_ACCOUNTS_PUB
Source
1 PACKAGE GMF_transaction_accounts_PUB AS
2 /* $Header: GMFXTABS.pls 120.2 2005/09/14 06:19:18 umoogala noship $ */
3
4 Procedure get_accounts
5 ( p_api_version IN NUMBER
6 , p_init_msg_list IN VARCHAR2
7 , p_source IN VARCHAR2
8
9 , x_return_status OUT NOCOPY VARCHAR2
10 , x_msg_data OUT NOCOPY VARCHAR2
11 , x_msg_count OUT NOCOPY NUMBER
12 )
13 ;
14
15 --
16 -- Public record types
17 --
18 TYPE t_rec_gmf_xla_tab_PUR IS RECORD
19 (
20 source_distrib_id_num_1 NUMBER --INPUT
21 , source_distrib_id_num_2 NUMBER --INPUT
22 , source_distrib_id_num_3 NUMBER --INPUT
23 , source_distrib_id_num_4 NUMBER --INPUT
24 , source_distrib_id_num_5 NUMBER --INPUT
25
26 , account_type_code VARCHAR2(30) -- INV, EXP, or AAP: NOT NULL
27
28 --START of source list
29 , organization_id NUMBER --INPUT
30 , inventory_item_id NUMBER --INPUT
31 , item_type VARCHAR2(80) --INPUT
32 , ledger_id NUMBER --INPUT
33 , legal_entity_id NUMBER --INPUT
34 , operating_unit VARCHAR2(15) --INPUT
35 , subinventory_code VARCHAR2(80) --INPUT
36 , subinventory_type VARCHAR2(80) --INPUT
37 , locator_id NUMBER --INPUT
38 , lot_number NUMBER --INPUT
39 , vendor_id NUMBER --INPUT
40 , vendor_site_id NUMBER --INPUT
41 --END of source list
42
43 , target_ccid NUMBER(15) --OUTPUT
44 , concatenated_segments VARCHAR2(2000) --OUTPUT
45 , msg_count NUMBER --OUTPUT
46 , msg_data VARCHAR2(2000) --OUTPUT
47 );
48
49
50 TYPE t_rec_gmf_xla_tab_CTO IS RECORD
51 (
52 source_distrib_id_num_1 NUMBER --INPUT
53 , source_distrib_id_num_2 NUMBER --INPUT
54 , source_distrib_id_num_3 NUMBER --INPUT
55 , source_distrib_id_num_4 NUMBER --INPUT
56 , source_distrib_id_num_5 NUMBER --INPUT
57
58 , account_type_code VARCHAR2(30) -- INV, EXP, or AAP: NOT NULL
59
60 --START of source list
61 , organization_id NUMBER --INPUT
62 , inventory_item_id NUMBER --INPUT
63 , ato_flag VARCHAR2(1) --INPUT
64 , ledger_id NUMBER --INPUT
65 , legal_entity_id NUMBER --INPUT
66 , operating_unit NUMBER --INPUT
67 , vendor_id NUMBER --INPUT
68 , vendor_site_id NUMBER --INPUT
69 , customer_id NUMBER --INPUT
70 , customer_site_id NUMBER --INPUT
71 --END of source list
72
73 , target_ccid NUMBER(15) --OUTPUT
74 , concatenated_segments VARCHAR2(2000) --OUTPUT
75 , msg_count NUMBER --OUTPUT
76 , msg_data VARCHAR2(2000) --OUTPUT
77 );
78
79 --
80 -- Public table types
81 --
82 TYPE t_array_gmf_xla_tab_PUR
83 IS TABLE OF t_rec_gmf_xla_tab_PUR INDEX BY BINARY_INTEGER;
84
85 TYPE t_array_gmf_xla_tab_CTO
86 IS TABLE OF t_rec_gmf_xla_tab_CTO INDEX BY BINARY_INTEGER;
87
88
89 --
90 -- Public variables
91 --
92 g_gmf_accts_tab_PUR t_array_gmf_xla_tab_PUR;
93 g_gmf_accts_tab_CTO t_array_gmf_xla_tab_CTO;
94
95 --
96 -- Global Variables for other teams to use.
97 --
98 G_CHARGE_INV_ACCT VARCHAR2(5) := 'INV';
99 G_CHARGE_EXP_ACCT VARCHAR2(5) := 'EXP';
100 G_ACCRUAL_ACCT VARCHAR2(5) := 'AAP';
101 G_VARIANCE_PPV_ACCT VARCHAR2(5) := 'PPV';
102
103 END GMF_transaction_accounts_PUB;