PACKAGE: APPS.INL_MATCH_GRP

Source

1 PACKAGE INL_MATCH_GRP AS
2 /* $Header: INLGMATS.pls 120.7.12010000.12 2008/11/28 14:41:06 acferrei 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     match_type_code               VARCHAR2(30),
13     from_parent_table_name        VARCHAR2(30),
14     from_parent_table_id          NUMBER,
15     to_parent_table_name          VARCHAR2(30),
16     to_parent_table_id            NUMBER,
17     matched_qty                   NUMBER,
18     matched_uom_code              VARCHAR2(3),
19     matched_amt                   NUMBER,
20     matched_curr_code             VARCHAR2(15),
21     matched_curr_conversion_type  VARCHAR2(30),
22     matched_curr_conversion_date  DATE,
23     matched_curr_conversion_rate  NUMBER,
24     replace_estim_qty_flag        VARCHAR2(1) := 'N',
25     charge_line_type_id           NUMBER,
26     party_id                      NUMBER,
27     party_site_id                 NUMBER,
28     tax_code                      VARCHAR2(30),
29     nrec_tax_amt                  NUMBER,
30     tax_amt_included_flag         VARCHAR2(1),
31     match_id                      NUMBER);
32 
33 TYPE inl_matches_int_type_tbl IS TABLE OF inl_matches_int_type INDEX BY BINARY_INTEGER;
34 
35 G_matches_int_tbl inl_matches_int_type_tbl;
36 
37 PROCEDURE Create_MatchesFromAP (
38     p_api_version      IN NUMBER,
39     p_init_msg_list    IN VARCHAR2 := FND_API.G_FALSE,
40     p_commit           IN VARCHAR2 := FND_API.G_FALSE,
41     p_invoice_id       IN NUMBER,
42     x_return_status    OUT NOCOPY VARCHAR2,
43     x_msg_count        OUT NOCOPY NUMBER,
44     x_msg_data         OUT NOCOPY VARCHAR2
45 );
46 
47 END INL_MATCH_GRP;