[Home] [Help]
PACKAGE: APPS.INL_INTERFACE_PVT
Source
1 PACKAGE INL_INTERFACE_PVT AUTHID CURRENT_USER AS
2 /* $Header: INLVINTS.pls 120.28.12020000.2 2013/02/19 17:21:16 acferrei ship $ */
3
4 G_MODULE_NAME CONSTANT VARCHAR2(200) := 'INL.PLSQL.INL_INTERFACE_PVT.';
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INL_INTERFACE_PVT';
6 G_RECORDS_PROCESSED NUMBER := 0;
7 G_RECORDS_INSERTED NUMBER := 0;
8 G_RECORDS_COMPLETED NUMBER := 0; -- Bug 16310024
9 L_FND_FALSE CONSTANT VARCHAR2(1) := fnd_api.g_false; --Bug#9660043
10 L_FND_TRUE CONSTANT VARCHAR2(1) := fnd_api.g_true; --Bug#9660043
11 L_FND_VALID_LEVEL_FULL CONSTANT NUMBER := fnd_api.g_valid_level_full; --Bug#9660043
12 L_FND_MISS_NUM CONSTANT NUMBER := fnd_api.g_miss_num; --Bug#9660043
13 L_FND_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_miss_char; --Bug#9660043
14
15 TYPE match_int_type IS RECORD (
16 match_int_id NUMBER,
17 group_id NUMBER,
18 processing_status_code VARCHAR2(25),
19 transaction_type VARCHAR2(25),
20 match_type_code VARCHAR2(30),
21 ship_header_id NUMBER,
22 from_parent_table_name VARCHAR2(30),
23 from_parent_table_id NUMBER,
24 to_parent_table_name VARCHAR2(30),
25 to_parent_table_id NUMBER,
26 parent_match_id NUMBER,
27 matched_qty NUMBER,
28 matched_uom_code VARCHAR2(3),
29 matched_amt NUMBER,
30 matched_curr_code VARCHAR2(15),
31 matched_curr_conversion_type VARCHAR2(30),
32 matched_curr_conversion_date DATE,
33 matched_curr_conversion_rate NUMBER,
34 replace_estim_qty_flag VARCHAR2(1),
35 existing_match_info_flag VARCHAR2(1),
36 charge_line_type_id NUMBER,
37 party_id NUMBER,
38 party_number VARCHAR2(30),
39 party_site_id NUMBER,
40 party_site_number VARCHAR2(30),
41 tax_code VARCHAR2(30),
42 nrec_tax_amt NUMBER,
43 tax_amt_included_flag VARCHAR2(1),
44 match_amounts_flag VARCHAR2(1), --BUG#8264388
45 match_id NUMBER
46 );
47
48 TYPE match_int_list_type IS TABLE OF match_int_type INDEX BY BINARY_INTEGER;
49
50 PROCEDURE Import_LCMShipments(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
53 p_commit IN VARCHAR2 := L_FND_FALSE,
54 p_group_id IN NUMBER,
55 p_simulation_id IN NUMBER DEFAULT NULL,
56 -- p_org_id IN NUMBER,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62 PROCEDURE Import_LCMShipments (
63 errbuf OUT NOCOPY VARCHAR2,
64 retcode OUT NOCOPY VARCHAR2,
65 p_group_id IN NUMBER
66 -- p_org_id IN NUMBER
67 );
68
69 PROCEDURE Import_LCMMatches(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
72 p_commit IN VARCHAR2 := L_FND_FALSE,
73 p_group_id IN NUMBER,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE Import_LCMMatches (
80 errbuf OUT NOCOPY VARCHAR2,
81 retcode OUT NOCOPY VARCHAR2,
82 p_group_id IN NUMBER
83 );
84
85 PROCEDURE Delete_Ship (
86 p_ship_header_id IN NUMBER,
87 x_return_status OUT NOCOPY VARCHAR2);
88 -- SCM-051
89 PROCEDURE Reset_MatchInt(p_ship_header_id IN NUMBER,
90 x_return_status OUT NOCOPY VARCHAR2);
91
92 -- /SCM-051
93 END INL_INTERFACE_PVT;