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_REC_TYP

Line 3111: FUNCTION PL_TO_SQL36(aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE)

3107: END;
3108: RETURN aPlsqlItem;
3109: END SQL_TO_PL12;
3110:
3111: FUNCTION PL_TO_SQL36(aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE)
3112: RETURN OE_ORDER_PUB_LINE_VAL_REC_TYP IS
3113: aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP;
3114: BEGIN
3115: aSqlItem := OE_ORDER_PUB_LINE_VAL_REC_TYP(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 3112: RETURN OE_ORDER_PUB_LINE_VAL_REC_TYP IS

3108: RETURN aPlsqlItem;
3109: END SQL_TO_PL12;
3110:
3111: FUNCTION PL_TO_SQL36(aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE)
3112: RETURN OE_ORDER_PUB_LINE_VAL_REC_TYP IS
3113: aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP;
3114: BEGIN
3115: aSqlItem := OE_ORDER_PUB_LINE_VAL_REC_TYP(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
3116: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 3113: aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP;

3109: END SQL_TO_PL12;
3110:
3111: FUNCTION PL_TO_SQL36(aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE)
3112: RETURN OE_ORDER_PUB_LINE_VAL_REC_TYP IS
3113: aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP;
3114: BEGIN
3115: aSqlItem := OE_ORDER_PUB_LINE_VAL_REC_TYP(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
3116: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
3117: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 3115: aSqlItem := OE_ORDER_PUB_LINE_VAL_REC_TYP(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

3111: FUNCTION PL_TO_SQL36(aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE)
3112: RETURN OE_ORDER_PUB_LINE_VAL_REC_TYP IS
3113: aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP;
3114: BEGIN
3115: aSqlItem := OE_ORDER_PUB_LINE_VAL_REC_TYP(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
3116: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
3117: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
3118: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
3119: aSqlItem.ACCOUNTING_RULE := aPlsqlItem.ACCOUNTING_RULE;

Line 3274: FUNCTION SQL_TO_PL36(aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP)

3270: aSqlItem.SERVICE_REFERENCE_TYPE := aPlsqlItem.SERVICE_REFERENCE_TYPE;
3271: RETURN aSqlItem;
3272: END PL_TO_SQL36;
3273:
3274: FUNCTION SQL_TO_PL36(aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP)
3275: RETURN OE_ORDER_PUB.LINE_VAL_REC_TYPE IS
3276: aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE;
3277: BEGIN
3278: aPlsqlItem.ACCOUNTING_RULE := aSqlItem.ACCOUNTING_RULE;

Line 3275: RETURN OE_ORDER_PUB.LINE_VAL_REC_TYPE IS

3271: RETURN aSqlItem;
3272: END PL_TO_SQL36;
3273:
3274: FUNCTION SQL_TO_PL36(aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP)
3275: RETURN OE_ORDER_PUB.LINE_VAL_REC_TYPE IS
3276: aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE;
3277: BEGIN
3278: aPlsqlItem.ACCOUNTING_RULE := aSqlItem.ACCOUNTING_RULE;
3279: aPlsqlItem.AGREEMENT := aSqlItem.AGREEMENT;

Line 3276: aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE;

3272: END PL_TO_SQL36;
3273:
3274: FUNCTION SQL_TO_PL36(aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP)
3275: RETURN OE_ORDER_PUB.LINE_VAL_REC_TYPE IS
3276: aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE;
3277: BEGIN
3278: aPlsqlItem.ACCOUNTING_RULE := aSqlItem.ACCOUNTING_RULE;
3279: aPlsqlItem.AGREEMENT := aSqlItem.AGREEMENT;
3280: aPlsqlItem.COMMITMENT := aSqlItem.COMMITMENT;

Line 5162: l_line_val_reco OE_ORDER_PUB_LINE_VAL_REC_TYP;

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;
5164: BEGIN
5165: FOR i IN p_line_tbl.first..p_line_tbl.last
5166: LOOP