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_VAL_TBL_TYP

Line 3433: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)

3429: aPlsqlItem.SERVICE_REFERENCE_TYPE := aSqlItem.SERVICE_REFERENCE_TYPE;
3430: RETURN aPlsqlItem;
3431: END SQL_TO_PL36;
3432:
3433: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
3434: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS
3435: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;
3436: BEGIN
3437: aSqlItem := OE_ORDER_PUB_LINE_VAL_TBL_TYP();

Line 3434: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS

3430: RETURN aPlsqlItem;
3431: END SQL_TO_PL36;
3432:
3433: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
3434: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS
3435: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;
3436: BEGIN
3437: aSqlItem := OE_ORDER_PUB_LINE_VAL_TBL_TYP();
3438: IF aPlsqlItem.COUNT > 0 THEN

Line 3435: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;

3431: END SQL_TO_PL36;
3432:
3433: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
3434: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS
3435: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;
3436: BEGIN
3437: aSqlItem := OE_ORDER_PUB_LINE_VAL_TBL_TYP();
3438: IF aPlsqlItem.COUNT > 0 THEN
3439: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 3437: aSqlItem := OE_ORDER_PUB_LINE_VAL_TBL_TYP();

3433: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
3434: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS
3435: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;
3436: BEGIN
3437: aSqlItem := OE_ORDER_PUB_LINE_VAL_TBL_TYP();
3438: IF aPlsqlItem.COUNT > 0 THEN
3439: aSqlItem.EXTEND(aPlsqlItem.COUNT);
3440: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
3441: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL36(aPlsqlItem(I));

Line 3447: FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)

3443: END IF;
3444: RETURN aSqlItem;
3445: END PL_TO_SQL13;
3446:
3447: FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)
3448: RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE IS
3449: aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
3450: BEGIN
3451: BEGIN

Line 3448: RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE IS

3444: RETURN aSqlItem;
3445: END PL_TO_SQL13;
3446:
3447: FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)
3448: RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE IS
3449: aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
3450: BEGIN
3451: BEGIN
3452: FOR I IN 1..aSqlItem.COUNT LOOP

Line 3449: aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE;

3445: END PL_TO_SQL13;
3446:
3447: FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)
3448: RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE IS
3449: aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
3450: BEGIN
3451: BEGIN
3452: FOR I IN 1..aSqlItem.COUNT LOOP
3453: aPlsqlItem(I) := SQL_TO_PL36(aSqlItem(I));

Line 5013: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

5009: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5010: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
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,

Line 5014: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

5010: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
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,

Line 5050: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,

5046: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
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,

Line 5070: l_in_line_val_tab OE_ORDER_PUB_LINE_VAL_TBL_TYP;

5066: l_header_rec_old OE_ORDER_PUB_HEADER_REC_TYPE;
5067: l_line_tab_old OE_ORDER_PUB_LINE_TBL_TYPE;
5068:
5069: l_in_line_tab OE_ORDER_PUB_LINE_TBL_TYPE;
5070: l_in_line_val_tab OE_ORDER_PUB_LINE_VAL_TBL_TYP;
5071:
5072: l_action_request_tbl OE_ORDER_PUB_REQUEST_TBL_TYPE;
5073:
5074: TYPE config_process_rec_type IS RECORD (

Line 5159: l_in_line_val_tab := Oe_Order_Pub_Line_Val_Tbl_Typ();

5155: -- If it is a model line and if the mode is UPDATE, just pass only the
5156: -- model line. Nothing else.
5157: --
5158: l_in_line_tab := Oe_Order_Pub_Line_Tbl_Type();
5159: l_in_line_val_tab := Oe_Order_Pub_Line_Val_Tbl_Typ();
5160: DECLARE
5161: l_line_reco OE_ORDER_PUB_LINE_REC_TYPE;
5162: l_line_val_reco OE_ORDER_PUB_LINE_VAL_REC_TYP;
5163: l_count NUMBER := 0;

Line 5799: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

5795: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5796: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
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,

Line 5800: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

5796: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
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,

Line 5836: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,

5832: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,
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 ,

Line 5876: P_LINE_VAL_TBL_ OE_ORDER_PUB.LINE_VAL_TBL_TYPE;

5872: P_HEADER_PAYMENT_VAL_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
5873: P_OLD_HEADER_PAYMENT_VAL_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_VAL_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;

Line 5877: P_OLD_LINE_VAL_TBL_ OE_ORDER_PUB.LINE_VAL_TBL_TYPE;

5873: P_OLD_HEADER_PAYMENT_VAL_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_VAL_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;

Line 5913: X_LINE_VAL_TBL_ OE_ORDER_PUB.LINE_VAL_TBL_TYPE;

5909: X_HEADER_SCREDIT_VAL_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_VAL_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;

Line 6419: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

6415: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
6416: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
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,

Line 6420: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

6416: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
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,

Line 6456: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,

6452: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,
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 ,