[Home] [Help]
PACKAGE: APPS.INL_MATCH_GRP
Source
1 PACKAGE INL_MATCH_GRP AUTHID CURRENT_USER AS
2 /* $Header: INLGMATS.pls 120.17.12020000.4 2012/11/23 20:08:40 aicosta ship $ */
3
4 G_MODULE_NAME CONSTANT VARCHAR2(200) := 'INL.PLSQL.INL_MATCH_GRP.';
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INL_MATCH_GRP';
6
7 TYPE inl_int_type IS RECORD (num NUMBER);
8 TYPE inl_int_tbl IS TABLE OF inl_int_type INDEX BY BINARY_INTEGER;
9
10 TYPE inl_matches_int_type IS RECORD (
11 match_int_id NUMBER,
12 adj_group_date DATE, -- OPM Integration
13 match_type_code VARCHAR2(30),
14 from_parent_table_name VARCHAR2(30),
15 from_parent_table_id NUMBER,
16 to_parent_table_name VARCHAR2(30),
17 to_parent_table_id NUMBER,
18 matched_qty NUMBER,
19 matched_uom_code VARCHAR2(3),
20 matched_amt NUMBER,
21 matched_curr_code VARCHAR2(15),
22 matched_curr_conversion_type VARCHAR2(30),
23 matched_curr_conversion_date DATE,
24 matched_curr_conversion_rate NUMBER,
25 replace_estim_qty_flag VARCHAR2(1) := 'N',
26 charge_line_type_id NUMBER,
27 party_id NUMBER,
28 party_site_id NUMBER,
29 tax_code VARCHAR2(30),
30 nrec_tax_amt NUMBER,
31 tax_amt_included_flag VARCHAR2(1),
32 match_id NUMBER,
33 match_amounts_flag VARCHAR2(1),
34 reversal_flag VARCHAR2(1)--Bug#14604983
35 ); --BUG#8264388
36
37 TYPE inl_matches_int_type_tbl IS TABLE OF inl_matches_int_type INDEX BY BINARY_INTEGER;
38
39 G_matches_int_tbl inl_matches_int_type_tbl;
40
41 PROCEDURE Create_MatchesFromAP (
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44 p_commit IN VARCHAR2 := FND_API.G_FALSE,
45 p_invoice_id IN NUMBER,
46 p_match_status_flag IN VARCHAR2 := 'S', --Bug#14604983
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2
50 );
51
52 END INL_MATCH_GRP;