eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_INBOUND_INT dependencies on OE_INBOUND_INT

Line 1: PACKAGE BODY Oe_Inbound_Int AS

1: PACKAGE BODY Oe_Inbound_Int AS
2: /* $Header: OEXOEINB.pls 120.34.12020000.3 2013/03/14 09:25:53 sahvivek ship $ */
3:
4:
5: -------------------------

Line 180: l_line_tbl := Oe_Inbound_Int.SQL_TO_PL12(p_x_line_tbl_obj);

176: l_line_tbl oe_order_pub.line_tbl_type;
177: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
178: BEGIN
179:
180: l_line_tbl := Oe_Inbound_Int.SQL_TO_PL12(p_x_line_tbl_obj);
181: l_line_adj_tbl := Oe_Inbound_Int.SQL_TO_PL14(p_x_line_adj_tbl_obj);
182:
183: Add_Manual_Modifier(l_line_tbl, l_line_adj_tbl, p_x_ret_stat);
184:

Line 181: l_line_adj_tbl := Oe_Inbound_Int.SQL_TO_PL14(p_x_line_adj_tbl_obj);

177: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
178: BEGIN
179:
180: l_line_tbl := Oe_Inbound_Int.SQL_TO_PL12(p_x_line_tbl_obj);
181: l_line_adj_tbl := Oe_Inbound_Int.SQL_TO_PL14(p_x_line_adj_tbl_obj);
182:
183: Add_Manual_Modifier(l_line_tbl, l_line_adj_tbl, p_x_ret_stat);
184:
185: p_x_line_tbl_obj := Oe_Inbound_Int.PL_TO_SQL12(l_line_tbl);

Line 185: p_x_line_tbl_obj := Oe_Inbound_Int.PL_TO_SQL12(l_line_tbl);

181: l_line_adj_tbl := Oe_Inbound_Int.SQL_TO_PL14(p_x_line_adj_tbl_obj);
182:
183: Add_Manual_Modifier(l_line_tbl, l_line_adj_tbl, p_x_ret_stat);
184:
185: p_x_line_tbl_obj := Oe_Inbound_Int.PL_TO_SQL12(l_line_tbl);
186: p_x_line_adj_tbl_obj := Oe_Inbound_Int.PL_TO_SQL14(l_line_adj_tbl);
187:
188: EXCEPTION
189: WHEN Others THEN

Line 186: p_x_line_adj_tbl_obj := Oe_Inbound_Int.PL_TO_SQL14(l_line_adj_tbl);

182:
183: Add_Manual_Modifier(l_line_tbl, l_line_adj_tbl, p_x_ret_stat);
184:
185: p_x_line_tbl_obj := Oe_Inbound_Int.PL_TO_SQL12(l_line_tbl);
186: p_x_line_adj_tbl_obj := Oe_Inbound_Int.PL_TO_SQL14(l_line_adj_tbl);
187:
188: EXCEPTION
189: WHEN Others THEN
190: p_x_ret_stat := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 196: 'OE_INBOUND_INT',

192: IF OE_MSG_PUB.Check_Msg_Level(Oe_Msg_Pub.G_Msg_Lvl_Unexp_Error)
193: THEN
194: OE_MSG_PUB.Add_Exc_Msg
195: (
196: 'OE_INBOUND_INT',
197: 'Add_Manual_Modifier_Obj'
198: );
199: END IF;
200: END;

Line 4942: -- Oe_Inbound_Int.G_check_action_ret_status :=

4938: IF aPlsqlItem.COUNT > 0 THEN
4939: aSqlItem.EXTEND(aPlsqlItem.COUNT);
4940: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
4941: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL48(aPlsqlItem(I));
4942: -- Oe_Inbound_Int.G_check_action_ret_status :=
4943: -- aSqlItem(1).return_status;
4944: -- oe_debug_pub.add('Srini psu '
4945: -- ||Oe_Inbound_Int.G_check_action_ret_status);
4946: END LOOP;

Line 4945: -- ||Oe_Inbound_Int.G_check_action_ret_status);

4941: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL48(aPlsqlItem(I));
4942: -- Oe_Inbound_Int.G_check_action_ret_status :=
4943: -- aSqlItem(1).return_status;
4944: -- oe_debug_pub.add('Srini psu '
4945: -- ||Oe_Inbound_Int.G_check_action_ret_status);
4946: END LOOP;
4947: end if;
4948: RETURN aSqlItem;
4949: END PL_TO_SQL25;

Line 5341: Oe_Inbound_Int.Process_Order

5337: ---
5338:
5339:
5340: -- Call to generic web service wrapper for Process_Order(...)
5341: Oe_Inbound_Int.Process_Order
5342: (
5343: P_API_VERSION_NUMBER,
5344: P_INIT_MSG_LIST,
5345: P_RETURN_VALUES,

Line 5438: -- status from Oe_Inbound_Int.Process_Order(...). If that errored

5434: --
5435: -- Bug 9019601.
5436: --
5437: -- This post-processing is to be executed ONLY after the success
5438: -- status from Oe_Inbound_Int.Process_Order(...). If that errored
5439: -- out (X_RETURN_STATUS being 'E' or 'U'), we set the current
5440: -- API's return status to 'E' or 'U' and skip this processing.
5441: -- This will improve overall performance as well.
5442:

Line 5447: oe_debug_pub.ADD('Oe_Inbound_Int.Process_Order failed. Check its processing messages.');

5443: -- Bug 9019061
5444:
5445: IF ( X_RETURN_STATUS IN ('E', 'U') ) THEN
5446:
5447: oe_debug_pub.ADD('Oe_Inbound_Int.Process_Order failed. Check its processing messages.');
5448:
5449: -- Would it be a good idea to push an additional information message onto x_messages?
5450:
5451: ELSE

Line 5765: -- This newer, overloaded form of OE_INBOUND_INT.Process_Order(..)

5761: ------- O2C25
5762:
5763:
5764: ----------------------------------------
5765: -- This newer, overloaded form of OE_INBOUND_INT.Process_Order(..)
5766: -- is the most recent, intended-to-be used one.
5767: ----------------------------------------
5768: PROCEDURE Process_Order (
5769: P_API_VERSION_NUMBER NUMBER,

Line 5958: P_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_HEADER_REC);

5954: oe_debug_pub.add('Line table count is: '||p_line_tbl.COUNT);
5955: END IF;
5956:
5957:
5958: P_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_HEADER_REC);
5959: P_OLD_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_OLD_HEADER_REC);
5960: P_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_HEADER_VAL_REC);
5961: P_OLD_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_OLD_HEADER_VAL_REC);
5962: P_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_HEADER_ADJ_TBL);

Line 5959: P_OLD_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_OLD_HEADER_REC);

5955: END IF;
5956:
5957:
5958: P_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_HEADER_REC);
5959: P_OLD_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_OLD_HEADER_REC);
5960: P_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_HEADER_VAL_REC);
5961: P_OLD_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_OLD_HEADER_VAL_REC);
5962: P_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_HEADER_ADJ_TBL);
5963: P_OLD_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_OLD_HEADER_ADJ_TBL);

Line 5960: P_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_HEADER_VAL_REC);

5956:
5957:
5958: P_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_HEADER_REC);
5959: P_OLD_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_OLD_HEADER_REC);
5960: P_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_HEADER_VAL_REC);
5961: P_OLD_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_OLD_HEADER_VAL_REC);
5962: P_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_HEADER_ADJ_TBL);
5963: P_OLD_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_OLD_HEADER_ADJ_TBL);
5964: P_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_HEADER_ADJ_VAL_TBL);

Line 5961: P_OLD_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_OLD_HEADER_VAL_REC);

5957:
5958: P_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_HEADER_REC);
5959: P_OLD_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_OLD_HEADER_REC);
5960: P_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_HEADER_VAL_REC);
5961: P_OLD_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_OLD_HEADER_VAL_REC);
5962: P_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_HEADER_ADJ_TBL);
5963: P_OLD_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_OLD_HEADER_ADJ_TBL);
5964: P_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_HEADER_ADJ_VAL_TBL);
5965: P_OLD_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_OLD_HEADER_ADJ_VAL_TBL);

Line 5962: P_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_HEADER_ADJ_TBL);

5958: P_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_HEADER_REC);
5959: P_OLD_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_OLD_HEADER_REC);
5960: P_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_HEADER_VAL_REC);
5961: P_OLD_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_OLD_HEADER_VAL_REC);
5962: P_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_HEADER_ADJ_TBL);
5963: P_OLD_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_OLD_HEADER_ADJ_TBL);
5964: P_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_HEADER_ADJ_VAL_TBL);
5965: P_OLD_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_OLD_HEADER_ADJ_VAL_TBL);
5966: P_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_HEADER_PRICE_ATT_TBL);

Line 5963: P_OLD_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_OLD_HEADER_ADJ_TBL);

5959: P_OLD_HEADER_REC_ := Oe_Inbound_Int.SQL_TO_PL1(P_OLD_HEADER_REC);
5960: P_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_HEADER_VAL_REC);
5961: P_OLD_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_OLD_HEADER_VAL_REC);
5962: P_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_HEADER_ADJ_TBL);
5963: P_OLD_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_OLD_HEADER_ADJ_TBL);
5964: P_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_HEADER_ADJ_VAL_TBL);
5965: P_OLD_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_OLD_HEADER_ADJ_VAL_TBL);
5966: P_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_HEADER_PRICE_ATT_TBL);
5967: P_OLD_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_OLD_HEADER_PRICE_ATT_TBL);

Line 5964: P_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_HEADER_ADJ_VAL_TBL);

5960: P_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_HEADER_VAL_REC);
5961: P_OLD_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_OLD_HEADER_VAL_REC);
5962: P_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_HEADER_ADJ_TBL);
5963: P_OLD_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_OLD_HEADER_ADJ_TBL);
5964: P_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_HEADER_ADJ_VAL_TBL);
5965: P_OLD_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_OLD_HEADER_ADJ_VAL_TBL);
5966: P_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_HEADER_PRICE_ATT_TBL);
5967: P_OLD_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_OLD_HEADER_PRICE_ATT_TBL);
5968: P_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_HEADER_ADJ_ATT_TBL);

Line 5965: P_OLD_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_OLD_HEADER_ADJ_VAL_TBL);

5961: P_OLD_HEADER_VAL_REC_ := Oe_Inbound_Int.SQL_TO_PL2(P_OLD_HEADER_VAL_REC);
5962: P_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_HEADER_ADJ_TBL);
5963: P_OLD_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_OLD_HEADER_ADJ_TBL);
5964: P_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_HEADER_ADJ_VAL_TBL);
5965: P_OLD_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_OLD_HEADER_ADJ_VAL_TBL);
5966: P_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_HEADER_PRICE_ATT_TBL);
5967: P_OLD_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_OLD_HEADER_PRICE_ATT_TBL);
5968: P_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_HEADER_ADJ_ATT_TBL);
5969: P_OLD_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_OLD_HEADER_ADJ_ATT_TBL);

Line 5966: P_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_HEADER_PRICE_ATT_TBL);

5962: P_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_HEADER_ADJ_TBL);
5963: P_OLD_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_OLD_HEADER_ADJ_TBL);
5964: P_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_HEADER_ADJ_VAL_TBL);
5965: P_OLD_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_OLD_HEADER_ADJ_VAL_TBL);
5966: P_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_HEADER_PRICE_ATT_TBL);
5967: P_OLD_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_OLD_HEADER_PRICE_ATT_TBL);
5968: P_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_HEADER_ADJ_ATT_TBL);
5969: P_OLD_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_OLD_HEADER_ADJ_ATT_TBL);
5970: P_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_HEADER_ADJ_ASSOC_TBL);

Line 5967: P_OLD_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_OLD_HEADER_PRICE_ATT_TBL);

5963: P_OLD_HEADER_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL3(P_OLD_HEADER_ADJ_TBL);
5964: P_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_HEADER_ADJ_VAL_TBL);
5965: P_OLD_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_OLD_HEADER_ADJ_VAL_TBL);
5966: P_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_HEADER_PRICE_ATT_TBL);
5967: P_OLD_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_OLD_HEADER_PRICE_ATT_TBL);
5968: P_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_HEADER_ADJ_ATT_TBL);
5969: P_OLD_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_OLD_HEADER_ADJ_ATT_TBL);
5970: P_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_HEADER_ADJ_ASSOC_TBL);
5971: P_OLD_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_OLD_HEADER_ADJ_ASSOC_TBL);

Line 5968: P_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_HEADER_ADJ_ATT_TBL);

5964: P_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_HEADER_ADJ_VAL_TBL);
5965: P_OLD_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_OLD_HEADER_ADJ_VAL_TBL);
5966: P_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_HEADER_PRICE_ATT_TBL);
5967: P_OLD_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_OLD_HEADER_PRICE_ATT_TBL);
5968: P_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_HEADER_ADJ_ATT_TBL);
5969: P_OLD_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_OLD_HEADER_ADJ_ATT_TBL);
5970: P_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_HEADER_ADJ_ASSOC_TBL);
5971: P_OLD_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_OLD_HEADER_ADJ_ASSOC_TBL);
5972: P_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_HEADER_SCREDIT_TBL);

Line 5969: P_OLD_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_OLD_HEADER_ADJ_ATT_TBL);

5965: P_OLD_HEADER_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL4(P_OLD_HEADER_ADJ_VAL_TBL);
5966: P_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_HEADER_PRICE_ATT_TBL);
5967: P_OLD_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_OLD_HEADER_PRICE_ATT_TBL);
5968: P_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_HEADER_ADJ_ATT_TBL);
5969: P_OLD_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_OLD_HEADER_ADJ_ATT_TBL);
5970: P_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_HEADER_ADJ_ASSOC_TBL);
5971: P_OLD_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_OLD_HEADER_ADJ_ASSOC_TBL);
5972: P_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_HEADER_SCREDIT_TBL);
5973: P_OLD_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_OLD_HEADER_SCREDIT_TBL);

Line 5970: P_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_HEADER_ADJ_ASSOC_TBL);

5966: P_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_HEADER_PRICE_ATT_TBL);
5967: P_OLD_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_OLD_HEADER_PRICE_ATT_TBL);
5968: P_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_HEADER_ADJ_ATT_TBL);
5969: P_OLD_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_OLD_HEADER_ADJ_ATT_TBL);
5970: P_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_HEADER_ADJ_ASSOC_TBL);
5971: P_OLD_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_OLD_HEADER_ADJ_ASSOC_TBL);
5972: P_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_HEADER_SCREDIT_TBL);
5973: P_OLD_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_OLD_HEADER_SCREDIT_TBL);
5974: P_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_HEADER_SCREDIT_VAL_TBL);

Line 5971: P_OLD_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_OLD_HEADER_ADJ_ASSOC_TBL);

5967: P_OLD_HEADER_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL5(P_OLD_HEADER_PRICE_ATT_TBL);
5968: P_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_HEADER_ADJ_ATT_TBL);
5969: P_OLD_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_OLD_HEADER_ADJ_ATT_TBL);
5970: P_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_HEADER_ADJ_ASSOC_TBL);
5971: P_OLD_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_OLD_HEADER_ADJ_ASSOC_TBL);
5972: P_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_HEADER_SCREDIT_TBL);
5973: P_OLD_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_OLD_HEADER_SCREDIT_TBL);
5974: P_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_HEADER_SCREDIT_VAL_TBL);
5975: P_OLD_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_OLD_HEADER_SCREDIT_VAL_TBL);

Line 5972: P_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_HEADER_SCREDIT_TBL);

5968: P_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_HEADER_ADJ_ATT_TBL);
5969: P_OLD_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_OLD_HEADER_ADJ_ATT_TBL);
5970: P_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_HEADER_ADJ_ASSOC_TBL);
5971: P_OLD_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_OLD_HEADER_ADJ_ASSOC_TBL);
5972: P_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_HEADER_SCREDIT_TBL);
5973: P_OLD_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_OLD_HEADER_SCREDIT_TBL);
5974: P_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_HEADER_SCREDIT_VAL_TBL);
5975: P_OLD_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_OLD_HEADER_SCREDIT_VAL_TBL);
5976: P_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_HEADER_PAYMENT_TBL);

Line 5973: P_OLD_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_OLD_HEADER_SCREDIT_TBL);

5969: P_OLD_HEADER_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL6(P_OLD_HEADER_ADJ_ATT_TBL);
5970: P_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_HEADER_ADJ_ASSOC_TBL);
5971: P_OLD_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_OLD_HEADER_ADJ_ASSOC_TBL);
5972: P_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_HEADER_SCREDIT_TBL);
5973: P_OLD_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_OLD_HEADER_SCREDIT_TBL);
5974: P_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_HEADER_SCREDIT_VAL_TBL);
5975: P_OLD_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_OLD_HEADER_SCREDIT_VAL_TBL);
5976: P_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_HEADER_PAYMENT_TBL);
5977: P_OLD_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_OLD_HEADER_PAYMENT_TBL);

Line 5974: P_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_HEADER_SCREDIT_VAL_TBL);

5970: P_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_HEADER_ADJ_ASSOC_TBL);
5971: P_OLD_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_OLD_HEADER_ADJ_ASSOC_TBL);
5972: P_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_HEADER_SCREDIT_TBL);
5973: P_OLD_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_OLD_HEADER_SCREDIT_TBL);
5974: P_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_HEADER_SCREDIT_VAL_TBL);
5975: P_OLD_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_OLD_HEADER_SCREDIT_VAL_TBL);
5976: P_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_HEADER_PAYMENT_TBL);
5977: P_OLD_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_OLD_HEADER_PAYMENT_TBL);
5978: P_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_HEADER_PAYMENT_VAL_TBL);

Line 5975: P_OLD_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_OLD_HEADER_SCREDIT_VAL_TBL);

5971: P_OLD_HEADER_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL7(P_OLD_HEADER_ADJ_ASSOC_TBL);
5972: P_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_HEADER_SCREDIT_TBL);
5973: P_OLD_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_OLD_HEADER_SCREDIT_TBL);
5974: P_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_HEADER_SCREDIT_VAL_TBL);
5975: P_OLD_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_OLD_HEADER_SCREDIT_VAL_TBL);
5976: P_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_HEADER_PAYMENT_TBL);
5977: P_OLD_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_OLD_HEADER_PAYMENT_TBL);
5978: P_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_HEADER_PAYMENT_VAL_TBL);
5979: P_OLD_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_OLD_HEADER_PAYMENT_VAL_TBL);

Line 5976: P_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_HEADER_PAYMENT_TBL);

5972: P_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_HEADER_SCREDIT_TBL);
5973: P_OLD_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_OLD_HEADER_SCREDIT_TBL);
5974: P_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_HEADER_SCREDIT_VAL_TBL);
5975: P_OLD_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_OLD_HEADER_SCREDIT_VAL_TBL);
5976: P_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_HEADER_PAYMENT_TBL);
5977: P_OLD_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_OLD_HEADER_PAYMENT_TBL);
5978: P_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_HEADER_PAYMENT_VAL_TBL);
5979: P_OLD_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_OLD_HEADER_PAYMENT_VAL_TBL);
5980: P_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_LINE_TBL);

Line 5977: P_OLD_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_OLD_HEADER_PAYMENT_TBL);

5973: P_OLD_HEADER_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL8(P_OLD_HEADER_SCREDIT_TBL);
5974: P_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_HEADER_SCREDIT_VAL_TBL);
5975: P_OLD_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_OLD_HEADER_SCREDIT_VAL_TBL);
5976: P_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_HEADER_PAYMENT_TBL);
5977: P_OLD_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_OLD_HEADER_PAYMENT_TBL);
5978: P_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_HEADER_PAYMENT_VAL_TBL);
5979: P_OLD_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_OLD_HEADER_PAYMENT_VAL_TBL);
5980: P_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_LINE_TBL);
5981: --P_OLD_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_OLD_LINE_TBL);

Line 5978: P_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_HEADER_PAYMENT_VAL_TBL);

5974: P_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_HEADER_SCREDIT_VAL_TBL);
5975: P_OLD_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_OLD_HEADER_SCREDIT_VAL_TBL);
5976: P_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_HEADER_PAYMENT_TBL);
5977: P_OLD_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_OLD_HEADER_PAYMENT_TBL);
5978: P_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_HEADER_PAYMENT_VAL_TBL);
5979: P_OLD_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_OLD_HEADER_PAYMENT_VAL_TBL);
5980: P_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_LINE_TBL);
5981: --P_OLD_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_OLD_LINE_TBL);
5982: P_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_LINE_VAL_TBL);

Line 5979: P_OLD_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_OLD_HEADER_PAYMENT_VAL_TBL);

5975: P_OLD_HEADER_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL9(P_OLD_HEADER_SCREDIT_VAL_TBL);
5976: P_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_HEADER_PAYMENT_TBL);
5977: P_OLD_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_OLD_HEADER_PAYMENT_TBL);
5978: P_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_HEADER_PAYMENT_VAL_TBL);
5979: P_OLD_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_OLD_HEADER_PAYMENT_VAL_TBL);
5980: P_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_LINE_TBL);
5981: --P_OLD_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_OLD_LINE_TBL);
5982: P_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_LINE_VAL_TBL);
5983: P_OLD_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_OLD_LINE_VAL_TBL);

Line 5980: P_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_LINE_TBL);

5976: P_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_HEADER_PAYMENT_TBL);
5977: P_OLD_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_OLD_HEADER_PAYMENT_TBL);
5978: P_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_HEADER_PAYMENT_VAL_TBL);
5979: P_OLD_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_OLD_HEADER_PAYMENT_VAL_TBL);
5980: P_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_LINE_TBL);
5981: --P_OLD_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_OLD_LINE_TBL);
5982: P_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_LINE_VAL_TBL);
5983: P_OLD_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_OLD_LINE_VAL_TBL);
5984: P_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_LINE_ADJ_TBL);

Line 5981: --P_OLD_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_OLD_LINE_TBL);

5977: P_OLD_HEADER_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL10(P_OLD_HEADER_PAYMENT_TBL);
5978: P_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_HEADER_PAYMENT_VAL_TBL);
5979: P_OLD_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_OLD_HEADER_PAYMENT_VAL_TBL);
5980: P_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_LINE_TBL);
5981: --P_OLD_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_OLD_LINE_TBL);
5982: P_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_LINE_VAL_TBL);
5983: P_OLD_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_OLD_LINE_VAL_TBL);
5984: P_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_LINE_ADJ_TBL);
5985: P_OLD_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_OLD_LINE_ADJ_TBL);

Line 5982: P_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_LINE_VAL_TBL);

5978: P_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_HEADER_PAYMENT_VAL_TBL);
5979: P_OLD_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_OLD_HEADER_PAYMENT_VAL_TBL);
5980: P_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_LINE_TBL);
5981: --P_OLD_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_OLD_LINE_TBL);
5982: P_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_LINE_VAL_TBL);
5983: P_OLD_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_OLD_LINE_VAL_TBL);
5984: P_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_LINE_ADJ_TBL);
5985: P_OLD_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_OLD_LINE_ADJ_TBL);
5986: P_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_LINE_ADJ_VAL_TBL);

Line 5983: P_OLD_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_OLD_LINE_VAL_TBL);

5979: P_OLD_HEADER_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL11(P_OLD_HEADER_PAYMENT_VAL_TBL);
5980: P_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_LINE_TBL);
5981: --P_OLD_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_OLD_LINE_TBL);
5982: P_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_LINE_VAL_TBL);
5983: P_OLD_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_OLD_LINE_VAL_TBL);
5984: P_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_LINE_ADJ_TBL);
5985: P_OLD_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_OLD_LINE_ADJ_TBL);
5986: P_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_LINE_ADJ_VAL_TBL);
5987: P_OLD_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_OLD_LINE_ADJ_VAL_TBL);

Line 5984: P_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_LINE_ADJ_TBL);

5980: P_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_LINE_TBL);
5981: --P_OLD_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_OLD_LINE_TBL);
5982: P_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_LINE_VAL_TBL);
5983: P_OLD_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_OLD_LINE_VAL_TBL);
5984: P_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_LINE_ADJ_TBL);
5985: P_OLD_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_OLD_LINE_ADJ_TBL);
5986: P_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_LINE_ADJ_VAL_TBL);
5987: P_OLD_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_OLD_LINE_ADJ_VAL_TBL);
5988: P_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_LINE_PRICE_ATT_TBL);

Line 5985: P_OLD_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_OLD_LINE_ADJ_TBL);

5981: --P_OLD_LINE_TBL_ := Oe_Inbound_Int.SQL_TO_PL12(P_OLD_LINE_TBL);
5982: P_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_LINE_VAL_TBL);
5983: P_OLD_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_OLD_LINE_VAL_TBL);
5984: P_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_LINE_ADJ_TBL);
5985: P_OLD_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_OLD_LINE_ADJ_TBL);
5986: P_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_LINE_ADJ_VAL_TBL);
5987: P_OLD_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_OLD_LINE_ADJ_VAL_TBL);
5988: P_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_LINE_PRICE_ATT_TBL);
5989: P_OLD_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_OLD_LINE_PRICE_ATT_TBL);

Line 5986: P_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_LINE_ADJ_VAL_TBL);

5982: P_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_LINE_VAL_TBL);
5983: P_OLD_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_OLD_LINE_VAL_TBL);
5984: P_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_LINE_ADJ_TBL);
5985: P_OLD_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_OLD_LINE_ADJ_TBL);
5986: P_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_LINE_ADJ_VAL_TBL);
5987: P_OLD_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_OLD_LINE_ADJ_VAL_TBL);
5988: P_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_LINE_PRICE_ATT_TBL);
5989: P_OLD_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_OLD_LINE_PRICE_ATT_TBL);
5990: P_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_LINE_ADJ_ATT_TBL);

Line 5987: P_OLD_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_OLD_LINE_ADJ_VAL_TBL);

5983: P_OLD_LINE_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL13(P_OLD_LINE_VAL_TBL);
5984: P_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_LINE_ADJ_TBL);
5985: P_OLD_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_OLD_LINE_ADJ_TBL);
5986: P_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_LINE_ADJ_VAL_TBL);
5987: P_OLD_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_OLD_LINE_ADJ_VAL_TBL);
5988: P_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_LINE_PRICE_ATT_TBL);
5989: P_OLD_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_OLD_LINE_PRICE_ATT_TBL);
5990: P_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_LINE_ADJ_ATT_TBL);
5991: P_OLD_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_OLD_LINE_ADJ_ATT_TBL);

Line 5988: P_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_LINE_PRICE_ATT_TBL);

5984: P_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_LINE_ADJ_TBL);
5985: P_OLD_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_OLD_LINE_ADJ_TBL);
5986: P_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_LINE_ADJ_VAL_TBL);
5987: P_OLD_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_OLD_LINE_ADJ_VAL_TBL);
5988: P_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_LINE_PRICE_ATT_TBL);
5989: P_OLD_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_OLD_LINE_PRICE_ATT_TBL);
5990: P_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_LINE_ADJ_ATT_TBL);
5991: P_OLD_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_OLD_LINE_ADJ_ATT_TBL);
5992: P_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_LINE_ADJ_ASSOC_TBL);

Line 5989: P_OLD_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_OLD_LINE_PRICE_ATT_TBL);

5985: P_OLD_LINE_ADJ_TBL_ := Oe_Inbound_Int.SQL_TO_PL14(P_OLD_LINE_ADJ_TBL);
5986: P_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_LINE_ADJ_VAL_TBL);
5987: P_OLD_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_OLD_LINE_ADJ_VAL_TBL);
5988: P_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_LINE_PRICE_ATT_TBL);
5989: P_OLD_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_OLD_LINE_PRICE_ATT_TBL);
5990: P_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_LINE_ADJ_ATT_TBL);
5991: P_OLD_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_OLD_LINE_ADJ_ATT_TBL);
5992: P_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_LINE_ADJ_ASSOC_TBL);
5993: P_OLD_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_OLD_LINE_ADJ_ASSOC_TBL);

Line 5990: P_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_LINE_ADJ_ATT_TBL);

5986: P_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_LINE_ADJ_VAL_TBL);
5987: P_OLD_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_OLD_LINE_ADJ_VAL_TBL);
5988: P_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_LINE_PRICE_ATT_TBL);
5989: P_OLD_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_OLD_LINE_PRICE_ATT_TBL);
5990: P_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_LINE_ADJ_ATT_TBL);
5991: P_OLD_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_OLD_LINE_ADJ_ATT_TBL);
5992: P_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_LINE_ADJ_ASSOC_TBL);
5993: P_OLD_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_OLD_LINE_ADJ_ASSOC_TBL);
5994: P_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_LINE_SCREDIT_TBL);

Line 5991: P_OLD_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_OLD_LINE_ADJ_ATT_TBL);

5987: P_OLD_LINE_ADJ_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL15(P_OLD_LINE_ADJ_VAL_TBL);
5988: P_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_LINE_PRICE_ATT_TBL);
5989: P_OLD_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_OLD_LINE_PRICE_ATT_TBL);
5990: P_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_LINE_ADJ_ATT_TBL);
5991: P_OLD_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_OLD_LINE_ADJ_ATT_TBL);
5992: P_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_LINE_ADJ_ASSOC_TBL);
5993: P_OLD_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_OLD_LINE_ADJ_ASSOC_TBL);
5994: P_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_LINE_SCREDIT_TBL);
5995: P_OLD_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_OLD_LINE_SCREDIT_TBL);

Line 5992: P_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_LINE_ADJ_ASSOC_TBL);

5988: P_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_LINE_PRICE_ATT_TBL);
5989: P_OLD_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_OLD_LINE_PRICE_ATT_TBL);
5990: P_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_LINE_ADJ_ATT_TBL);
5991: P_OLD_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_OLD_LINE_ADJ_ATT_TBL);
5992: P_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_LINE_ADJ_ASSOC_TBL);
5993: P_OLD_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_OLD_LINE_ADJ_ASSOC_TBL);
5994: P_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_LINE_SCREDIT_TBL);
5995: P_OLD_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_OLD_LINE_SCREDIT_TBL);
5996: P_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_LINE_SCREDIT_VAL_TBL);

Line 5993: P_OLD_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_OLD_LINE_ADJ_ASSOC_TBL);

5989: P_OLD_LINE_PRICE_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL16(P_OLD_LINE_PRICE_ATT_TBL);
5990: P_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_LINE_ADJ_ATT_TBL);
5991: P_OLD_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_OLD_LINE_ADJ_ATT_TBL);
5992: P_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_LINE_ADJ_ASSOC_TBL);
5993: P_OLD_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_OLD_LINE_ADJ_ASSOC_TBL);
5994: P_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_LINE_SCREDIT_TBL);
5995: P_OLD_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_OLD_LINE_SCREDIT_TBL);
5996: P_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_LINE_SCREDIT_VAL_TBL);
5997: P_OLD_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_OLD_LINE_SCREDIT_VAL_TBL);

Line 5994: P_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_LINE_SCREDIT_TBL);

5990: P_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_LINE_ADJ_ATT_TBL);
5991: P_OLD_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_OLD_LINE_ADJ_ATT_TBL);
5992: P_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_LINE_ADJ_ASSOC_TBL);
5993: P_OLD_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_OLD_LINE_ADJ_ASSOC_TBL);
5994: P_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_LINE_SCREDIT_TBL);
5995: P_OLD_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_OLD_LINE_SCREDIT_TBL);
5996: P_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_LINE_SCREDIT_VAL_TBL);
5997: P_OLD_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_OLD_LINE_SCREDIT_VAL_TBL);
5998: P_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_LINE_PAYMENT_TBL);

Line 5995: P_OLD_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_OLD_LINE_SCREDIT_TBL);

5991: P_OLD_LINE_ADJ_ATT_TBL_ := Oe_Inbound_Int.SQL_TO_PL17(P_OLD_LINE_ADJ_ATT_TBL);
5992: P_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_LINE_ADJ_ASSOC_TBL);
5993: P_OLD_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_OLD_LINE_ADJ_ASSOC_TBL);
5994: P_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_LINE_SCREDIT_TBL);
5995: P_OLD_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_OLD_LINE_SCREDIT_TBL);
5996: P_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_LINE_SCREDIT_VAL_TBL);
5997: P_OLD_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_OLD_LINE_SCREDIT_VAL_TBL);
5998: P_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_LINE_PAYMENT_TBL);
5999: P_OLD_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_OLD_LINE_PAYMENT_TBL);

Line 5996: P_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_LINE_SCREDIT_VAL_TBL);

5992: P_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_LINE_ADJ_ASSOC_TBL);
5993: P_OLD_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_OLD_LINE_ADJ_ASSOC_TBL);
5994: P_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_LINE_SCREDIT_TBL);
5995: P_OLD_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_OLD_LINE_SCREDIT_TBL);
5996: P_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_LINE_SCREDIT_VAL_TBL);
5997: P_OLD_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_OLD_LINE_SCREDIT_VAL_TBL);
5998: P_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_LINE_PAYMENT_TBL);
5999: P_OLD_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_OLD_LINE_PAYMENT_TBL);
6000: P_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_LINE_PAYMENT_VAL_TBL);

Line 5997: P_OLD_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_OLD_LINE_SCREDIT_VAL_TBL);

5993: P_OLD_LINE_ADJ_ASSOC_TBL_ := Oe_Inbound_Int.SQL_TO_PL18(P_OLD_LINE_ADJ_ASSOC_TBL);
5994: P_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_LINE_SCREDIT_TBL);
5995: P_OLD_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_OLD_LINE_SCREDIT_TBL);
5996: P_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_LINE_SCREDIT_VAL_TBL);
5997: P_OLD_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_OLD_LINE_SCREDIT_VAL_TBL);
5998: P_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_LINE_PAYMENT_TBL);
5999: P_OLD_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_OLD_LINE_PAYMENT_TBL);
6000: P_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_LINE_PAYMENT_VAL_TBL);
6001: P_OLD_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_OLD_LINE_PAYMENT_VAL_TBL);

Line 5998: P_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_LINE_PAYMENT_TBL);

5994: P_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_LINE_SCREDIT_TBL);
5995: P_OLD_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_OLD_LINE_SCREDIT_TBL);
5996: P_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_LINE_SCREDIT_VAL_TBL);
5997: P_OLD_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_OLD_LINE_SCREDIT_VAL_TBL);
5998: P_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_LINE_PAYMENT_TBL);
5999: P_OLD_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_OLD_LINE_PAYMENT_TBL);
6000: P_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_LINE_PAYMENT_VAL_TBL);
6001: P_OLD_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_OLD_LINE_PAYMENT_VAL_TBL);
6002: P_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_LOT_SERIAL_TBL);

Line 5999: P_OLD_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_OLD_LINE_PAYMENT_TBL);

5995: P_OLD_LINE_SCREDIT_TBL_ := Oe_Inbound_Int.SQL_TO_PL19(P_OLD_LINE_SCREDIT_TBL);
5996: P_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_LINE_SCREDIT_VAL_TBL);
5997: P_OLD_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_OLD_LINE_SCREDIT_VAL_TBL);
5998: P_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_LINE_PAYMENT_TBL);
5999: P_OLD_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_OLD_LINE_PAYMENT_TBL);
6000: P_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_LINE_PAYMENT_VAL_TBL);
6001: P_OLD_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_OLD_LINE_PAYMENT_VAL_TBL);
6002: P_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_LOT_SERIAL_TBL);
6003: P_OLD_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_OLD_LOT_SERIAL_TBL);

Line 6000: P_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_LINE_PAYMENT_VAL_TBL);

5996: P_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_LINE_SCREDIT_VAL_TBL);
5997: P_OLD_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_OLD_LINE_SCREDIT_VAL_TBL);
5998: P_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_LINE_PAYMENT_TBL);
5999: P_OLD_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_OLD_LINE_PAYMENT_TBL);
6000: P_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_LINE_PAYMENT_VAL_TBL);
6001: P_OLD_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_OLD_LINE_PAYMENT_VAL_TBL);
6002: P_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_LOT_SERIAL_TBL);
6003: P_OLD_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_OLD_LOT_SERIAL_TBL);
6004: P_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_LOT_SERIAL_VAL_TBL);

Line 6001: P_OLD_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_OLD_LINE_PAYMENT_VAL_TBL);

5997: P_OLD_LINE_SCREDIT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL20(P_OLD_LINE_SCREDIT_VAL_TBL);
5998: P_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_LINE_PAYMENT_TBL);
5999: P_OLD_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_OLD_LINE_PAYMENT_TBL);
6000: P_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_LINE_PAYMENT_VAL_TBL);
6001: P_OLD_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_OLD_LINE_PAYMENT_VAL_TBL);
6002: P_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_LOT_SERIAL_TBL);
6003: P_OLD_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_OLD_LOT_SERIAL_TBL);
6004: P_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_LOT_SERIAL_VAL_TBL);
6005: P_OLD_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_OLD_LOT_SERIAL_VAL_TBL);

Line 6002: P_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_LOT_SERIAL_TBL);

5998: P_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_LINE_PAYMENT_TBL);
5999: P_OLD_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_OLD_LINE_PAYMENT_TBL);
6000: P_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_LINE_PAYMENT_VAL_TBL);
6001: P_OLD_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_OLD_LINE_PAYMENT_VAL_TBL);
6002: P_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_LOT_SERIAL_TBL);
6003: P_OLD_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_OLD_LOT_SERIAL_TBL);
6004: P_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_LOT_SERIAL_VAL_TBL);
6005: P_OLD_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_OLD_LOT_SERIAL_VAL_TBL);
6006: P_ACTION_REQUEST_TBL_ := Oe_Inbound_Int.SQL_TO_PL25(P_ACTION_REQUEST_TBL);

Line 6003: P_OLD_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_OLD_LOT_SERIAL_TBL);

5999: P_OLD_LINE_PAYMENT_TBL_ := Oe_Inbound_Int.SQL_TO_PL21(P_OLD_LINE_PAYMENT_TBL);
6000: P_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_LINE_PAYMENT_VAL_TBL);
6001: P_OLD_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_OLD_LINE_PAYMENT_VAL_TBL);
6002: P_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_LOT_SERIAL_TBL);
6003: P_OLD_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_OLD_LOT_SERIAL_TBL);
6004: P_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_LOT_SERIAL_VAL_TBL);
6005: P_OLD_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_OLD_LOT_SERIAL_VAL_TBL);
6006: P_ACTION_REQUEST_TBL_ := Oe_Inbound_Int.SQL_TO_PL25(P_ACTION_REQUEST_TBL);
6007:

Line 6004: P_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_LOT_SERIAL_VAL_TBL);

6000: P_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_LINE_PAYMENT_VAL_TBL);
6001: P_OLD_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_OLD_LINE_PAYMENT_VAL_TBL);
6002: P_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_LOT_SERIAL_TBL);
6003: P_OLD_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_OLD_LOT_SERIAL_TBL);
6004: P_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_LOT_SERIAL_VAL_TBL);
6005: P_OLD_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_OLD_LOT_SERIAL_VAL_TBL);
6006: P_ACTION_REQUEST_TBL_ := Oe_Inbound_Int.SQL_TO_PL25(P_ACTION_REQUEST_TBL);
6007:
6008: --

Line 6005: P_OLD_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_OLD_LOT_SERIAL_VAL_TBL);

6001: P_OLD_LINE_PAYMENT_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL22(P_OLD_LINE_PAYMENT_VAL_TBL);
6002: P_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_LOT_SERIAL_TBL);
6003: P_OLD_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_OLD_LOT_SERIAL_TBL);
6004: P_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_LOT_SERIAL_VAL_TBL);
6005: P_OLD_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_OLD_LOT_SERIAL_VAL_TBL);
6006: P_ACTION_REQUEST_TBL_ := Oe_Inbound_Int.SQL_TO_PL25(P_ACTION_REQUEST_TBL);
6007:
6008: --
6009: -- Code Changes Start: ER 7025965

Line 6006: P_ACTION_REQUEST_TBL_ := Oe_Inbound_Int.SQL_TO_PL25(P_ACTION_REQUEST_TBL);

6002: P_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_LOT_SERIAL_TBL);
6003: P_OLD_LOT_SERIAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL23(P_OLD_LOT_SERIAL_TBL);
6004: P_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_LOT_SERIAL_VAL_TBL);
6005: P_OLD_LOT_SERIAL_VAL_TBL_ := Oe_Inbound_Int.SQL_TO_PL24(P_OLD_LOT_SERIAL_VAL_TBL);
6006: P_ACTION_REQUEST_TBL_ := Oe_Inbound_Int.SQL_TO_PL25(P_ACTION_REQUEST_TBL);
6007:
6008: --
6009: -- Code Changes Start: ER 7025965
6010: --

Line 6282: X_HEADER_REC := Oe_Inbound_Int.PL_TO_SQL1(X_HEADER_REC_);

6278: if l_debug_level > 0 then
6279: oe_debug_pub.add('After calling PO');
6280: end if;
6281:
6282: X_HEADER_REC := Oe_Inbound_Int.PL_TO_SQL1(X_HEADER_REC_);
6283: X_HEADER_VAL_REC := Oe_Inbound_Int.PL_TO_SQL2(X_HEADER_VAL_REC_);
6284: X_HEADER_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL3(X_HEADER_ADJ_TBL_);
6285: X_HEADER_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL4(X_HEADER_ADJ_VAL_TBL_);
6286: X_HEADER_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL5(X_HEADER_PRICE_ATT_TBL_);

Line 6283: X_HEADER_VAL_REC := Oe_Inbound_Int.PL_TO_SQL2(X_HEADER_VAL_REC_);

6279: oe_debug_pub.add('After calling PO');
6280: end if;
6281:
6282: X_HEADER_REC := Oe_Inbound_Int.PL_TO_SQL1(X_HEADER_REC_);
6283: X_HEADER_VAL_REC := Oe_Inbound_Int.PL_TO_SQL2(X_HEADER_VAL_REC_);
6284: X_HEADER_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL3(X_HEADER_ADJ_TBL_);
6285: X_HEADER_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL4(X_HEADER_ADJ_VAL_TBL_);
6286: X_HEADER_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL5(X_HEADER_PRICE_ATT_TBL_);
6287: X_HEADER_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL6(X_HEADER_ADJ_ATT_TBL_);

Line 6284: X_HEADER_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL3(X_HEADER_ADJ_TBL_);

6280: end if;
6281:
6282: X_HEADER_REC := Oe_Inbound_Int.PL_TO_SQL1(X_HEADER_REC_);
6283: X_HEADER_VAL_REC := Oe_Inbound_Int.PL_TO_SQL2(X_HEADER_VAL_REC_);
6284: X_HEADER_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL3(X_HEADER_ADJ_TBL_);
6285: X_HEADER_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL4(X_HEADER_ADJ_VAL_TBL_);
6286: X_HEADER_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL5(X_HEADER_PRICE_ATT_TBL_);
6287: X_HEADER_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL6(X_HEADER_ADJ_ATT_TBL_);
6288: X_HEADER_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL7(X_HEADER_ADJ_ASSOC_TBL_);

Line 6285: X_HEADER_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL4(X_HEADER_ADJ_VAL_TBL_);

6281:
6282: X_HEADER_REC := Oe_Inbound_Int.PL_TO_SQL1(X_HEADER_REC_);
6283: X_HEADER_VAL_REC := Oe_Inbound_Int.PL_TO_SQL2(X_HEADER_VAL_REC_);
6284: X_HEADER_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL3(X_HEADER_ADJ_TBL_);
6285: X_HEADER_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL4(X_HEADER_ADJ_VAL_TBL_);
6286: X_HEADER_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL5(X_HEADER_PRICE_ATT_TBL_);
6287: X_HEADER_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL6(X_HEADER_ADJ_ATT_TBL_);
6288: X_HEADER_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL7(X_HEADER_ADJ_ASSOC_TBL_);
6289: X_HEADER_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL8(X_HEADER_SCREDIT_TBL_);

Line 6286: X_HEADER_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL5(X_HEADER_PRICE_ATT_TBL_);

6282: X_HEADER_REC := Oe_Inbound_Int.PL_TO_SQL1(X_HEADER_REC_);
6283: X_HEADER_VAL_REC := Oe_Inbound_Int.PL_TO_SQL2(X_HEADER_VAL_REC_);
6284: X_HEADER_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL3(X_HEADER_ADJ_TBL_);
6285: X_HEADER_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL4(X_HEADER_ADJ_VAL_TBL_);
6286: X_HEADER_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL5(X_HEADER_PRICE_ATT_TBL_);
6287: X_HEADER_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL6(X_HEADER_ADJ_ATT_TBL_);
6288: X_HEADER_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL7(X_HEADER_ADJ_ASSOC_TBL_);
6289: X_HEADER_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL8(X_HEADER_SCREDIT_TBL_);
6290: X_HEADER_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL9(X_HEADER_SCREDIT_VAL_TBL_);

Line 6287: X_HEADER_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL6(X_HEADER_ADJ_ATT_TBL_);

6283: X_HEADER_VAL_REC := Oe_Inbound_Int.PL_TO_SQL2(X_HEADER_VAL_REC_);
6284: X_HEADER_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL3(X_HEADER_ADJ_TBL_);
6285: X_HEADER_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL4(X_HEADER_ADJ_VAL_TBL_);
6286: X_HEADER_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL5(X_HEADER_PRICE_ATT_TBL_);
6287: X_HEADER_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL6(X_HEADER_ADJ_ATT_TBL_);
6288: X_HEADER_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL7(X_HEADER_ADJ_ASSOC_TBL_);
6289: X_HEADER_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL8(X_HEADER_SCREDIT_TBL_);
6290: X_HEADER_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL9(X_HEADER_SCREDIT_VAL_TBL_);
6291: X_HEADER_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL10(X_HEADER_PAYMENT_TBL_);

Line 6288: X_HEADER_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL7(X_HEADER_ADJ_ASSOC_TBL_);

6284: X_HEADER_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL3(X_HEADER_ADJ_TBL_);
6285: X_HEADER_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL4(X_HEADER_ADJ_VAL_TBL_);
6286: X_HEADER_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL5(X_HEADER_PRICE_ATT_TBL_);
6287: X_HEADER_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL6(X_HEADER_ADJ_ATT_TBL_);
6288: X_HEADER_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL7(X_HEADER_ADJ_ASSOC_TBL_);
6289: X_HEADER_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL8(X_HEADER_SCREDIT_TBL_);
6290: X_HEADER_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL9(X_HEADER_SCREDIT_VAL_TBL_);
6291: X_HEADER_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL10(X_HEADER_PAYMENT_TBL_);
6292: X_HEADER_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL11(X_HEADER_PAYMENT_VAL_TBL_);

Line 6289: X_HEADER_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL8(X_HEADER_SCREDIT_TBL_);

6285: X_HEADER_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL4(X_HEADER_ADJ_VAL_TBL_);
6286: X_HEADER_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL5(X_HEADER_PRICE_ATT_TBL_);
6287: X_HEADER_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL6(X_HEADER_ADJ_ATT_TBL_);
6288: X_HEADER_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL7(X_HEADER_ADJ_ASSOC_TBL_);
6289: X_HEADER_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL8(X_HEADER_SCREDIT_TBL_);
6290: X_HEADER_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL9(X_HEADER_SCREDIT_VAL_TBL_);
6291: X_HEADER_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL10(X_HEADER_PAYMENT_TBL_);
6292: X_HEADER_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL11(X_HEADER_PAYMENT_VAL_TBL_);
6293: X_LINE_TBL := Oe_Inbound_Int.PL_TO_SQL12(X_LINE_TBL_);

Line 6290: X_HEADER_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL9(X_HEADER_SCREDIT_VAL_TBL_);

6286: X_HEADER_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL5(X_HEADER_PRICE_ATT_TBL_);
6287: X_HEADER_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL6(X_HEADER_ADJ_ATT_TBL_);
6288: X_HEADER_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL7(X_HEADER_ADJ_ASSOC_TBL_);
6289: X_HEADER_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL8(X_HEADER_SCREDIT_TBL_);
6290: X_HEADER_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL9(X_HEADER_SCREDIT_VAL_TBL_);
6291: X_HEADER_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL10(X_HEADER_PAYMENT_TBL_);
6292: X_HEADER_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL11(X_HEADER_PAYMENT_VAL_TBL_);
6293: X_LINE_TBL := Oe_Inbound_Int.PL_TO_SQL12(X_LINE_TBL_);
6294: X_LINE_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL13(X_LINE_VAL_TBL_);

Line 6291: X_HEADER_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL10(X_HEADER_PAYMENT_TBL_);

6287: X_HEADER_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL6(X_HEADER_ADJ_ATT_TBL_);
6288: X_HEADER_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL7(X_HEADER_ADJ_ASSOC_TBL_);
6289: X_HEADER_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL8(X_HEADER_SCREDIT_TBL_);
6290: X_HEADER_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL9(X_HEADER_SCREDIT_VAL_TBL_);
6291: X_HEADER_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL10(X_HEADER_PAYMENT_TBL_);
6292: X_HEADER_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL11(X_HEADER_PAYMENT_VAL_TBL_);
6293: X_LINE_TBL := Oe_Inbound_Int.PL_TO_SQL12(X_LINE_TBL_);
6294: X_LINE_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL13(X_LINE_VAL_TBL_);
6295: X_LINE_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL14(X_LINE_ADJ_TBL_);

Line 6292: X_HEADER_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL11(X_HEADER_PAYMENT_VAL_TBL_);

6288: X_HEADER_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL7(X_HEADER_ADJ_ASSOC_TBL_);
6289: X_HEADER_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL8(X_HEADER_SCREDIT_TBL_);
6290: X_HEADER_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL9(X_HEADER_SCREDIT_VAL_TBL_);
6291: X_HEADER_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL10(X_HEADER_PAYMENT_TBL_);
6292: X_HEADER_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL11(X_HEADER_PAYMENT_VAL_TBL_);
6293: X_LINE_TBL := Oe_Inbound_Int.PL_TO_SQL12(X_LINE_TBL_);
6294: X_LINE_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL13(X_LINE_VAL_TBL_);
6295: X_LINE_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL14(X_LINE_ADJ_TBL_);
6296: X_LINE_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL15(X_LINE_ADJ_VAL_TBL_);

Line 6293: X_LINE_TBL := Oe_Inbound_Int.PL_TO_SQL12(X_LINE_TBL_);

6289: X_HEADER_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL8(X_HEADER_SCREDIT_TBL_);
6290: X_HEADER_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL9(X_HEADER_SCREDIT_VAL_TBL_);
6291: X_HEADER_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL10(X_HEADER_PAYMENT_TBL_);
6292: X_HEADER_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL11(X_HEADER_PAYMENT_VAL_TBL_);
6293: X_LINE_TBL := Oe_Inbound_Int.PL_TO_SQL12(X_LINE_TBL_);
6294: X_LINE_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL13(X_LINE_VAL_TBL_);
6295: X_LINE_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL14(X_LINE_ADJ_TBL_);
6296: X_LINE_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL15(X_LINE_ADJ_VAL_TBL_);
6297: X_LINE_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL16(X_LINE_PRICE_ATT_TBL_);

Line 6294: X_LINE_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL13(X_LINE_VAL_TBL_);

6290: X_HEADER_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL9(X_HEADER_SCREDIT_VAL_TBL_);
6291: X_HEADER_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL10(X_HEADER_PAYMENT_TBL_);
6292: X_HEADER_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL11(X_HEADER_PAYMENT_VAL_TBL_);
6293: X_LINE_TBL := Oe_Inbound_Int.PL_TO_SQL12(X_LINE_TBL_);
6294: X_LINE_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL13(X_LINE_VAL_TBL_);
6295: X_LINE_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL14(X_LINE_ADJ_TBL_);
6296: X_LINE_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL15(X_LINE_ADJ_VAL_TBL_);
6297: X_LINE_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL16(X_LINE_PRICE_ATT_TBL_);
6298: X_LINE_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL17(X_LINE_ADJ_ATT_TBL_);

Line 6295: X_LINE_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL14(X_LINE_ADJ_TBL_);

6291: X_HEADER_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL10(X_HEADER_PAYMENT_TBL_);
6292: X_HEADER_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL11(X_HEADER_PAYMENT_VAL_TBL_);
6293: X_LINE_TBL := Oe_Inbound_Int.PL_TO_SQL12(X_LINE_TBL_);
6294: X_LINE_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL13(X_LINE_VAL_TBL_);
6295: X_LINE_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL14(X_LINE_ADJ_TBL_);
6296: X_LINE_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL15(X_LINE_ADJ_VAL_TBL_);
6297: X_LINE_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL16(X_LINE_PRICE_ATT_TBL_);
6298: X_LINE_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL17(X_LINE_ADJ_ATT_TBL_);
6299: X_LINE_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL18(X_LINE_ADJ_ASSOC_TBL_);

Line 6296: X_LINE_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL15(X_LINE_ADJ_VAL_TBL_);

6292: X_HEADER_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL11(X_HEADER_PAYMENT_VAL_TBL_);
6293: X_LINE_TBL := Oe_Inbound_Int.PL_TO_SQL12(X_LINE_TBL_);
6294: X_LINE_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL13(X_LINE_VAL_TBL_);
6295: X_LINE_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL14(X_LINE_ADJ_TBL_);
6296: X_LINE_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL15(X_LINE_ADJ_VAL_TBL_);
6297: X_LINE_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL16(X_LINE_PRICE_ATT_TBL_);
6298: X_LINE_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL17(X_LINE_ADJ_ATT_TBL_);
6299: X_LINE_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL18(X_LINE_ADJ_ASSOC_TBL_);
6300: X_LINE_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL19(X_LINE_SCREDIT_TBL_);

Line 6297: X_LINE_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL16(X_LINE_PRICE_ATT_TBL_);

6293: X_LINE_TBL := Oe_Inbound_Int.PL_TO_SQL12(X_LINE_TBL_);
6294: X_LINE_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL13(X_LINE_VAL_TBL_);
6295: X_LINE_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL14(X_LINE_ADJ_TBL_);
6296: X_LINE_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL15(X_LINE_ADJ_VAL_TBL_);
6297: X_LINE_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL16(X_LINE_PRICE_ATT_TBL_);
6298: X_LINE_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL17(X_LINE_ADJ_ATT_TBL_);
6299: X_LINE_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL18(X_LINE_ADJ_ASSOC_TBL_);
6300: X_LINE_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL19(X_LINE_SCREDIT_TBL_);
6301: X_LINE_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL20(X_LINE_SCREDIT_VAL_TBL_);

Line 6298: X_LINE_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL17(X_LINE_ADJ_ATT_TBL_);

6294: X_LINE_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL13(X_LINE_VAL_TBL_);
6295: X_LINE_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL14(X_LINE_ADJ_TBL_);
6296: X_LINE_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL15(X_LINE_ADJ_VAL_TBL_);
6297: X_LINE_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL16(X_LINE_PRICE_ATT_TBL_);
6298: X_LINE_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL17(X_LINE_ADJ_ATT_TBL_);
6299: X_LINE_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL18(X_LINE_ADJ_ASSOC_TBL_);
6300: X_LINE_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL19(X_LINE_SCREDIT_TBL_);
6301: X_LINE_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL20(X_LINE_SCREDIT_VAL_TBL_);
6302: X_LINE_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL21(X_LINE_PAYMENT_TBL_);

Line 6299: X_LINE_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL18(X_LINE_ADJ_ASSOC_TBL_);

6295: X_LINE_ADJ_TBL := Oe_Inbound_Int.PL_TO_SQL14(X_LINE_ADJ_TBL_);
6296: X_LINE_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL15(X_LINE_ADJ_VAL_TBL_);
6297: X_LINE_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL16(X_LINE_PRICE_ATT_TBL_);
6298: X_LINE_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL17(X_LINE_ADJ_ATT_TBL_);
6299: X_LINE_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL18(X_LINE_ADJ_ASSOC_TBL_);
6300: X_LINE_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL19(X_LINE_SCREDIT_TBL_);
6301: X_LINE_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL20(X_LINE_SCREDIT_VAL_TBL_);
6302: X_LINE_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL21(X_LINE_PAYMENT_TBL_);
6303: X_LINE_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL22(X_LINE_PAYMENT_VAL_TBL_);

Line 6300: X_LINE_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL19(X_LINE_SCREDIT_TBL_);

6296: X_LINE_ADJ_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL15(X_LINE_ADJ_VAL_TBL_);
6297: X_LINE_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL16(X_LINE_PRICE_ATT_TBL_);
6298: X_LINE_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL17(X_LINE_ADJ_ATT_TBL_);
6299: X_LINE_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL18(X_LINE_ADJ_ASSOC_TBL_);
6300: X_LINE_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL19(X_LINE_SCREDIT_TBL_);
6301: X_LINE_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL20(X_LINE_SCREDIT_VAL_TBL_);
6302: X_LINE_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL21(X_LINE_PAYMENT_TBL_);
6303: X_LINE_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL22(X_LINE_PAYMENT_VAL_TBL_);
6304: X_LOT_SERIAL_TBL := Oe_Inbound_Int.PL_TO_SQL23(X_LOT_SERIAL_TBL_);

Line 6301: X_LINE_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL20(X_LINE_SCREDIT_VAL_TBL_);

6297: X_LINE_PRICE_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL16(X_LINE_PRICE_ATT_TBL_);
6298: X_LINE_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL17(X_LINE_ADJ_ATT_TBL_);
6299: X_LINE_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL18(X_LINE_ADJ_ASSOC_TBL_);
6300: X_LINE_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL19(X_LINE_SCREDIT_TBL_);
6301: X_LINE_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL20(X_LINE_SCREDIT_VAL_TBL_);
6302: X_LINE_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL21(X_LINE_PAYMENT_TBL_);
6303: X_LINE_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL22(X_LINE_PAYMENT_VAL_TBL_);
6304: X_LOT_SERIAL_TBL := Oe_Inbound_Int.PL_TO_SQL23(X_LOT_SERIAL_TBL_);
6305: X_LOT_SERIAL_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL24(X_LOT_SERIAL_VAL_TBL_);

Line 6302: X_LINE_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL21(X_LINE_PAYMENT_TBL_);

6298: X_LINE_ADJ_ATT_TBL := Oe_Inbound_Int.PL_TO_SQL17(X_LINE_ADJ_ATT_TBL_);
6299: X_LINE_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL18(X_LINE_ADJ_ASSOC_TBL_);
6300: X_LINE_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL19(X_LINE_SCREDIT_TBL_);
6301: X_LINE_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL20(X_LINE_SCREDIT_VAL_TBL_);
6302: X_LINE_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL21(X_LINE_PAYMENT_TBL_);
6303: X_LINE_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL22(X_LINE_PAYMENT_VAL_TBL_);
6304: X_LOT_SERIAL_TBL := Oe_Inbound_Int.PL_TO_SQL23(X_LOT_SERIAL_TBL_);
6305: X_LOT_SERIAL_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL24(X_LOT_SERIAL_VAL_TBL_);
6306: X_ACTION_REQUEST_TBL := Oe_Inbound_Int.PL_TO_SQL25(X_ACTION_REQUEST_TBL_);

Line 6303: X_LINE_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL22(X_LINE_PAYMENT_VAL_TBL_);

6299: X_LINE_ADJ_ASSOC_TBL := Oe_Inbound_Int.PL_TO_SQL18(X_LINE_ADJ_ASSOC_TBL_);
6300: X_LINE_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL19(X_LINE_SCREDIT_TBL_);
6301: X_LINE_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL20(X_LINE_SCREDIT_VAL_TBL_);
6302: X_LINE_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL21(X_LINE_PAYMENT_TBL_);
6303: X_LINE_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL22(X_LINE_PAYMENT_VAL_TBL_);
6304: X_LOT_SERIAL_TBL := Oe_Inbound_Int.PL_TO_SQL23(X_LOT_SERIAL_TBL_);
6305: X_LOT_SERIAL_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL24(X_LOT_SERIAL_VAL_TBL_);
6306: X_ACTION_REQUEST_TBL := Oe_Inbound_Int.PL_TO_SQL25(X_ACTION_REQUEST_TBL_);
6307: X_ACTION_REQUEST_TBL := Oe_Inbound_Int.PL_TO_SQL25(X_ACTION_REQUEST_TBL_);

Line 6304: X_LOT_SERIAL_TBL := Oe_Inbound_Int.PL_TO_SQL23(X_LOT_SERIAL_TBL_);

6300: X_LINE_SCREDIT_TBL := Oe_Inbound_Int.PL_TO_SQL19(X_LINE_SCREDIT_TBL_);
6301: X_LINE_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL20(X_LINE_SCREDIT_VAL_TBL_);
6302: X_LINE_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL21(X_LINE_PAYMENT_TBL_);
6303: X_LINE_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL22(X_LINE_PAYMENT_VAL_TBL_);
6304: X_LOT_SERIAL_TBL := Oe_Inbound_Int.PL_TO_SQL23(X_LOT_SERIAL_TBL_);
6305: X_LOT_SERIAL_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL24(X_LOT_SERIAL_VAL_TBL_);
6306: X_ACTION_REQUEST_TBL := Oe_Inbound_Int.PL_TO_SQL25(X_ACTION_REQUEST_TBL_);
6307: X_ACTION_REQUEST_TBL := Oe_Inbound_Int.PL_TO_SQL25(X_ACTION_REQUEST_TBL_);
6308:

Line 6305: X_LOT_SERIAL_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL24(X_LOT_SERIAL_VAL_TBL_);

6301: X_LINE_SCREDIT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL20(X_LINE_SCREDIT_VAL_TBL_);
6302: X_LINE_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL21(X_LINE_PAYMENT_TBL_);
6303: X_LINE_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL22(X_LINE_PAYMENT_VAL_TBL_);
6304: X_LOT_SERIAL_TBL := Oe_Inbound_Int.PL_TO_SQL23(X_LOT_SERIAL_TBL_);
6305: X_LOT_SERIAL_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL24(X_LOT_SERIAL_VAL_TBL_);
6306: X_ACTION_REQUEST_TBL := Oe_Inbound_Int.PL_TO_SQL25(X_ACTION_REQUEST_TBL_);
6307: X_ACTION_REQUEST_TBL := Oe_Inbound_Int.PL_TO_SQL25(X_ACTION_REQUEST_TBL_);
6308:
6309: -- Bug 8872110

Line 6306: X_ACTION_REQUEST_TBL := Oe_Inbound_Int.PL_TO_SQL25(X_ACTION_REQUEST_TBL_);

6302: X_LINE_PAYMENT_TBL := Oe_Inbound_Int.PL_TO_SQL21(X_LINE_PAYMENT_TBL_);
6303: X_LINE_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL22(X_LINE_PAYMENT_VAL_TBL_);
6304: X_LOT_SERIAL_TBL := Oe_Inbound_Int.PL_TO_SQL23(X_LOT_SERIAL_TBL_);
6305: X_LOT_SERIAL_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL24(X_LOT_SERIAL_VAL_TBL_);
6306: X_ACTION_REQUEST_TBL := Oe_Inbound_Int.PL_TO_SQL25(X_ACTION_REQUEST_TBL_);
6307: X_ACTION_REQUEST_TBL := Oe_Inbound_Int.PL_TO_SQL25(X_ACTION_REQUEST_TBL_);
6308:
6309: -- Bug 8872110
6310: IF x_return_status = 'S' AND

Line 6307: X_ACTION_REQUEST_TBL := Oe_Inbound_Int.PL_TO_SQL25(X_ACTION_REQUEST_TBL_);

6303: X_LINE_PAYMENT_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL22(X_LINE_PAYMENT_VAL_TBL_);
6304: X_LOT_SERIAL_TBL := Oe_Inbound_Int.PL_TO_SQL23(X_LOT_SERIAL_TBL_);
6305: X_LOT_SERIAL_VAL_TBL := Oe_Inbound_Int.PL_TO_SQL24(X_LOT_SERIAL_VAL_TBL_);
6306: X_ACTION_REQUEST_TBL := Oe_Inbound_Int.PL_TO_SQL25(X_ACTION_REQUEST_TBL_);
6307: X_ACTION_REQUEST_TBL := Oe_Inbound_Int.PL_TO_SQL25(X_ACTION_REQUEST_TBL_);
6308:
6309: -- Bug 8872110
6310: IF x_return_status = 'S' AND
6311: l_booking_action_index IS NOT NULL AND

Line 6319: IF Oe_Inbound_Int.G_check_action_ret_status IN ('E','U')

6315: THEN
6316: x_return_status := x_action_request_tbl_(l_booking_action_index).return_status;
6317: END IF;
6318:
6319: IF Oe_Inbound_Int.G_check_action_ret_status IN ('E','U')
6320: OR
6321: x_return_status IN ('E', 'U')
6322: THEN
6323: if l_debug_level > 0 then

Line 6380: -- Oe_Inbound_Int.Process_Order(...) API with the older signature.

6376: END Process_Order; -- Overloaded form with newer signature
6377:
6378: ------------------------------
6379:
6380: -- Oe_Inbound_Int.Process_Order(...) API with the older signature.
6381: --
6382: -- Deprecated. Retained only for backward compatibility purposes.
6383: -- All the clients should use the appropriate overloaded form of the API
6384: -- with newer signature (because the newer signature supports the retrieval

Line 6478: oe_debug_pub.add('Oe_Inbound_Int.Process_Order with deprecated signature invoked...');

6474: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6475:
6476: BEGIN
6477: if l_debug_level > 0 then
6478: oe_debug_pub.add('Oe_Inbound_Int.Process_Order with deprecated signature invoked...');
6479: oe_debug_pub.add('Calling...');
6480: end if;
6481:
6482: Process_Order (

Line 6601: END Oe_Inbound_Int;

6597: RAISE;
6598: END;
6599: ----------------- O2C25: End --------
6600:
6601: END Oe_Inbound_Int;