[Home] [Help]
PACKAGE: APPS.INL_INTERFACE_PVT
Source
1 PACKAGE INL_INTERFACE_PVT AS
2 /* $Header: INLVINTS.pls 120.7.12010000.6 2008/10/31 13:09:02 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
7 CURSOR validLines(p_ship_header_int_id NUMBER, p_group_id NUMBER) IS
8 SELECT ship_line_int_id,
9 ship_line_group_reference,
10 party_id,
11 party_site_id,
12 source_organization_id,
13 ship_line_num,
14 ship_line_type_id,
15 ship_line_src_type_code,
16 ship_line_source_id,
17 currency_code,
18 currency_conversion_type,
19 currency_conversion_date,
20 currency_conversion_rate,
21 inventory_item_id,
22 txn_qty,
23 txn_uom_code,
24 txn_unit_price,
25 primary_qty,
26 primary_uom_code,
27 primary_unit_price,
28 secondary_qty,
29 secondary_uom_code,
30 secondary_unit_price,
31 landed_cost_flag,
32 allocation_enabled_flag,
33 trx_business_category,
34 intended_use,
35 product_fiscal_class,
36 product_category,
37 product_type,
38 user_def_fiscal_class,
39 tax_classification_code,
40 assessable_value,
41 ship_from_party_id,
42 ship_from_party_site_id,
43 ship_to_organization_id,
44 ship_to_location_id,
45 bill_from_party_id,
46 bill_from_party_site_id,
47 bill_to_organization_id,
48 bill_to_location_id,
49 poa_party_id,
50 poa_party_site_id,
51 poo_organization_id,
52 poo_location_id,
53 org_id,
54 interface_source_table,
55 interface_source_line_id,
56 ship_header_id,
57 ship_line_id,
58 attribute_category_lg,
59 attribute1_lg,
60 attribute2_lg,
61 attribute3_lg,
62 attribute4_lg,
63 attribute5_lg,
64 attribute6_lg,
65 attribute7_lg,
66 attribute8_lg,
67 attribute9_lg,
68 attribute10_lg,
69 attribute11_lg,
70 attribute12_lg,
71 attribute13_lg,
72 attribute14_lg,
73 attribute15_lg,
74 attribute_category_sl,
75 attribute1_sl,
76 attribute2_sl,
77 attribute3_sl,
78 attribute4_sl,
79 attribute5_sl,
80 attribute6_sl,
81 attribute7_sl,
82 attribute8_sl,
83 attribute9_sl,
84 attribute10_sl,
85 attribute11_sl,
86 attribute12_sl,
87 attribute13_sl,
88 attribute14_sl,
89 attribute15_sl
90 FROM inl_ship_lines_int
91 WHERE (p_group_id IS NULL
92 OR group_id = p_group_id)
93 AND processing_status_code = 'RUNNING' --'PENDING' before validation 'ERROR' IN CASE OF FAIL
94 AND ship_header_int_id = P_ship_header_int_id
95 ORDER BY ship_line_group_reference,
96 ship_line_src_type_code,
97 ship_header_id,
98 party_id,
99 party_site_id,
100 source_organization_id;
101 TYPE validLines_List_Type IS TABLE OF validLines%ROWTYPE;
102 validLines_List validLines_List_Type ;
103
104 TYPE ship_line_groups_rec_type IS RECORD (ship_line_group_id NUMBER,
105 ship_line_group_reference VARCHAR2(30),
106 ship_header_id NUMBER,
107 ship_line_group_num NUMBER,
108 src_type_code VARCHAR2(30),
109 party_id NUMBER,
110 party_site_id NUMBER,
111 source_organization_id NUMBER,
112 attribute_category VARCHAR2(30),
113 attribute1 VARCHAR2(150),
114 attribute2 VARCHAR2(150),
115 attribute3 VARCHAR2(150),
116 attribute4 VARCHAR2(150),
117 attribute5 VARCHAR2(150),
118 attribute6 VARCHAR2(150),
119 attribute7 VARCHAR2(150),
120 attribute8 VARCHAR2(150),
121 attribute9 VARCHAR2(150),
122 attribute10 VARCHAR2(150),
123 attribute11 VARCHAR2(150),
124 attribute12 VARCHAR2(150),
125 attribute13 VARCHAR2(150),
126 attribute14 VARCHAR2(150),
127 attribute15 VARCHAR2(150));
128
129 rec_ship_line_groups ship_line_groups_rec_type;
130
131 TYPE match_int_type IS RECORD (match_int_id NUMBER,
132 group_id NUMBER,
133 processing_status_code VARCHAR2(25),
134 transaction_type VARCHAR2(25),
135 match_type_code VARCHAR2(30),
136 ship_header_id NUMBER,
137 from_parent_table_name VARCHAR2(30),
138 from_parent_table_id NUMBER,
139 to_parent_table_name VARCHAR2(30),
140 to_parent_table_id NUMBER,
141 parent_match_id NUMBER,
142 matched_qty NUMBER,
143 matched_uom_code VARCHAR2(3),
144 matched_amt NUMBER,
145 matched_curr_code VARCHAR2(15),
146 matched_curr_conversion_type VARCHAR2(30),
147 matched_curr_conversion_date DATE,
148 matched_curr_conversion_rate NUMBER,
149 replace_estim_qty_flag VARCHAR2(1),
150 existing_match_info_flag VARCHAR2(1),
151 charge_line_type_id NUMBER,
152 party_id NUMBER,
153 party_number VARCHAR2(30),
154 party_site_id NUMBER,
155 party_site_number VARCHAR2(30),
156 tax_code VARCHAR2(30),
157 nrec_tax_amt NUMBER,
158 tax_amt_included_flag VARCHAR2(1),
159 match_amount_int_id NUMBER,
160 match_id NUMBER);
161
162 TYPE match_int_list_type IS TABLE OF match_int_type INDEX BY BINARY_INTEGER;
163
164 PROCEDURE Import_LCMShipments(p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
166 p_commit IN VARCHAR2 := FND_API.G_FALSE,
167 p_group_id IN NUMBER,
168 p_org_id IN NUMBER,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2);
172
173 PROCEDURE Import_LCMShipments (errbuf OUT NOCOPY VARCHAR2,
174 retcode OUT NOCOPY VARCHAR2,
175 p_group_id IN NUMBER,
176 p_org_id IN NUMBER);
177
178 PROCEDURE Import_LCMMatches(p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180 p_commit IN VARCHAR2 := FND_API.G_FALSE,
181 p_group_id IN NUMBER,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2);
185
186 PROCEDURE Import_LCMMatches (errbuf OUT NOCOPY VARCHAR2,
187 retcode OUT NOCOPY VARCHAR2,
188 p_group_id IN NUMBER);
189
190 END INL_INTERFACE_PVT;