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_ORDER_PUB_LINE_ADJ_TBL_TYP

Line 12: p_x_line_adj_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,

8: -- Start of Bug 9131751
9: PROCEDURE Add_Manual_Modifier
10: (
11: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
12: p_x_line_adj_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
13: x_ret_stat IN OUT NOCOPY VARCHAR2
14: )
15: IS
16:

Line 172: p_x_line_adj_tbl_obj IN OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

168: --
169: PROCEDURE Add_Manual_Modifier_Obj
170: (
171: p_x_line_tbl_obj IN OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,
172: p_x_line_adj_tbl_obj IN OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
173: p_x_ret_stat IN OUT NOCOPY VARCHAR2
174: )
175: IS
176: l_line_tbl oe_order_pub.line_tbl_type;

Line 177: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

173: p_x_ret_stat IN OUT NOCOPY VARCHAR2
174: )
175: IS
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);

Line 3703: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)

3699: aPlsqlItem.RETROBILL_REQUEST_ID := aSqlItem.RETROBILL_REQUEST_ID;
3700: RETURN aPlsqlItem;
3701: END SQL_TO_PL37;
3702:
3703: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
3704: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS
3705: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
3706: BEGIN
3707: aSqlItem := OE_ORDER_PUB_LINE_ADJ_TBL_TYP();

Line 3704: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS

3700: RETURN aPlsqlItem;
3701: END SQL_TO_PL37;
3702:
3703: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
3704: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS
3705: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
3706: BEGIN
3707: aSqlItem := OE_ORDER_PUB_LINE_ADJ_TBL_TYP();
3708: IF aPlsqlItem.COUNT > 0 THEN

Line 3705: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;

3701: END SQL_TO_PL37;
3702:
3703: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
3704: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS
3705: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
3706: BEGIN
3707: aSqlItem := OE_ORDER_PUB_LINE_ADJ_TBL_TYP();
3708: IF aPlsqlItem.COUNT > 0 THEN
3709: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 3707: aSqlItem := OE_ORDER_PUB_LINE_ADJ_TBL_TYP();

3703: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
3704: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS
3705: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
3706: BEGIN
3707: aSqlItem := OE_ORDER_PUB_LINE_ADJ_TBL_TYP();
3708: IF aPlsqlItem.COUNT > 0 THEN
3709: aSqlItem.EXTEND(aPlsqlItem.COUNT);
3710: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
3711: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL37(aPlsqlItem(I));

Line 3717: FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)

3713: END IF;
3714: RETURN aSqlItem;
3715: END PL_TO_SQL14;
3716:
3717: FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)
3718: RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE IS
3719: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
3720: BEGIN
3721: BEGIN

Line 3718: RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE IS

3714: RETURN aSqlItem;
3715: END PL_TO_SQL14;
3716:
3717: FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)
3718: RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE IS
3719: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
3720: BEGIN
3721: BEGIN
3722: FOR I IN 1..aSqlItem.COUNT LOOP

Line 3719: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

3715: END PL_TO_SQL14;
3716:
3717: FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)
3718: RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE IS
3719: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
3720: BEGIN
3721: BEGIN
3722: FOR I IN 1..aSqlItem.COUNT LOOP
3723: aPlsqlItem(I) := SQL_TO_PL37(aSqlItem(I));

Line 5015: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

5011: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5012: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5013: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5014: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5015: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5016: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5017: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
5018: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
5019: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,

Line 5016: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

5012: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5013: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5014: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5015: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5016: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5017: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
5018: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
5019: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
5020: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,

Line 5051: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,

5047: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
5048: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
5049: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TAB25,
5050: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5051: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
5052: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
5053: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
5054: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
5055: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,

Line 5097: l_line_adj_tbl Oe_Order_Pub_Line_Adj_Tbl_Typ;

5093:
5094: /*
5095: -- Bug 9131751
5096: l_amm_ret_stat VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
5097: l_line_adj_tbl Oe_Order_Pub_Line_Adj_Tbl_Typ;
5098: */
5099: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5100:
5101: BEGIN

Line 5232: l_line_adj_tbl := Oe_Order_Pub_Line_Adj_Tbl_Typ();

5228: /*
5229: --
5230: -- Bug 9131751: Start
5231: --
5232: l_line_adj_tbl := Oe_Order_Pub_Line_Adj_Tbl_Typ();
5233:
5234: Add_Manual_Modifier_Obj(l_in_line_tab, l_line_adj_tbl, l_amm_ret_stat);
5235:
5236: IF l_amm_ret_stat = Fnd_Api.G_RET_STS_SUCCESS THEN

Line 5801: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

5797: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5798: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5799: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5800: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5801: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5802: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5803: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
5804: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
5805: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,

Line 5802: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

5798: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5799: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5800: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5801: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5802: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5803: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
5804: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
5805: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
5806: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,

Line 5837: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,

5833: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
5834: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,
5835: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,
5836: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,
5837: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
5838: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,
5839: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
5840: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
5841: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,

Line 5878: P_LINE_ADJ_TBL_ OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

5874: P_LINE_TBL_ OE_ORDER_PUB.LINE_TBL_TYPE;
5875: P_OLD_LINE_TBL_ OE_ORDER_PUB.LINE_TBL_TYPE;
5876: P_LINE_VAL_TBL_ OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
5877: P_OLD_LINE_VAL_TBL_ OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
5878: P_LINE_ADJ_TBL_ OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
5879: P_OLD_LINE_ADJ_TBL_ OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
5880: P_LINE_ADJ_VAL_TBL_ OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
5881: P_OLD_LINE_ADJ_VAL_TBL_ OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
5882: P_LINE_PRICE_ATT_TBL_ OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;

Line 5879: P_OLD_LINE_ADJ_TBL_ OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

5875: P_OLD_LINE_TBL_ OE_ORDER_PUB.LINE_TBL_TYPE;
5876: P_LINE_VAL_TBL_ OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
5877: P_OLD_LINE_VAL_TBL_ OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
5878: P_LINE_ADJ_TBL_ OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
5879: P_OLD_LINE_ADJ_TBL_ OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
5880: P_LINE_ADJ_VAL_TBL_ OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
5881: P_OLD_LINE_ADJ_VAL_TBL_ OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
5882: P_LINE_PRICE_ATT_TBL_ OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
5883: P_OLD_LINE_PRICE_ATT_TBL_ OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;

Line 5914: X_LINE_ADJ_TBL_ OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

5910: X_HEADER_PAYMENT_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
5911: X_HEADER_PAYMENT_VAL_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
5912: X_LINE_TBL_ OE_ORDER_PUB.LINE_TBL_TYPE;
5913: X_LINE_VAL_TBL_ OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
5914: X_LINE_ADJ_TBL_ OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
5915: X_LINE_ADJ_VAL_TBL_ OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
5916: X_LINE_PRICE_ATT_TBL_ OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
5917: X_LINE_ADJ_ATT_TBL_ OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
5918: X_LINE_ADJ_ASSOC_TBL_ OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;

Line 5934: l_price_adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type; -- 10171747

5930: L_MSG_DATA VARCHAR2(2000);
5931: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5932: l_booking_action_index NUMBER := NULL; -- Bug 8872110
5933:
5934: l_price_adj_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type; -- 10171747
5935: l_amm_ret_stat VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS; -- 10171747
5936:
5937: -- Bug 11928288
5938: CURSOR bill_seq_id_cur(p_inv_item_id NUMBER) IS

Line 6421: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

6417: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
6418: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
6419: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
6420: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
6421: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
6422: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
6423: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
6424: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
6425: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,

Line 6422: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

6418: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
6419: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
6420: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
6421: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
6422: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
6423: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
6424: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
6425: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
6426: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,

Line 6457: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,

6453: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
6454: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,
6455: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,
6456: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,
6457: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
6458: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,
6459: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
6460: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
6461: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,