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 3233: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)

3229: aPlsqlItem.SERVICE_REFERENCE_TYPE := aSqlItem.SERVICE_REFERENCE_TYPE;
3230: RETURN aPlsqlItem;
3231: END SQL_TO_PL36;
3232:
3233: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
3234: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS
3235: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;
3236: BEGIN
3237: aSqlItem := OE_ORDER_PUB_LINE_VAL_TBL_TYP();

Line 3234: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS

3230: RETURN aPlsqlItem;
3231: END SQL_TO_PL36;
3232:
3233: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
3234: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS
3235: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;
3236: BEGIN
3237: aSqlItem := OE_ORDER_PUB_LINE_VAL_TBL_TYP();
3238: IF aPlsqlItem.COUNT > 0 THEN

Line 3235: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;

3231: END SQL_TO_PL36;
3232:
3233: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
3234: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS
3235: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;
3236: BEGIN
3237: aSqlItem := OE_ORDER_PUB_LINE_VAL_TBL_TYP();
3238: IF aPlsqlItem.COUNT > 0 THEN
3239: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 3237: aSqlItem := OE_ORDER_PUB_LINE_VAL_TBL_TYP();

3233: FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
3234: RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS
3235: aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;
3236: BEGIN
3237: aSqlItem := OE_ORDER_PUB_LINE_VAL_TBL_TYP();
3238: IF aPlsqlItem.COUNT > 0 THEN
3239: aSqlItem.EXTEND(aPlsqlItem.COUNT);
3240: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
3241: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL36(aPlsqlItem(I));

Line 3247: FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)

3243: END IF;
3244: RETURN aSqlItem;
3245: END PL_TO_SQL13;
3246:
3247: FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)
3248: RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE IS
3249: aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
3250: BEGIN
3251: BEGIN

Line 3248: RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE IS

3244: RETURN aSqlItem;
3245: END PL_TO_SQL13;
3246:
3247: FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)
3248: RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE IS
3249: aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
3250: BEGIN
3251: BEGIN
3252: FOR I IN 1..aSqlItem.COUNT LOOP

Line 3249: aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE;

3245: END PL_TO_SQL13;
3246:
3247: FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)
3248: RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE IS
3249: aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
3250: BEGIN
3251: BEGIN
3252: FOR I IN 1..aSqlItem.COUNT LOOP
3253: aPlsqlItem(I) := SQL_TO_PL36(aSqlItem(I));

Line 4808: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

4804: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
4805: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
4806: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
4807: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
4808: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
4809: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
4810: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
4811: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
4812: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,

Line 4809: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

4805: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
4806: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
4807: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
4808: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
4809: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
4810: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
4811: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
4812: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
4813: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,

Line 4845: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,

4841: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,
4842: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
4843: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,
4844: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,
4845: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,
4846: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
4847: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,
4848: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
4849: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,

Line 4885: P_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;

4881: P_HEADER_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
4882: P_OLD_HEADER_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
4883: P_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;
4884: P_OLD_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;
4885: P_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
4886: P_OLD_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
4887: P_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4888: P_OLD_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4889: P_LINE_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;

Line 4886: P_OLD_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;

4882: P_OLD_HEADER_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
4883: P_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;
4884: P_OLD_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;
4885: P_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
4886: P_OLD_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
4887: P_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4888: P_OLD_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4889: P_LINE_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
4890: P_OLD_LINE_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;

Line 4922: X_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;

4918: X_HEADER_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
4919: X_HEADER_PAYMENT_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
4920: X_HEADER_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
4921: X_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;
4922: X_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
4923: X_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4924: X_LINE_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
4925: X_LINE_PRICE_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
4926: X_LINE_ADJ_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;

Line 5274: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

5270: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5271: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5272: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5273: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5274: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5275: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5276: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5277: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5278: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,

Line 5275: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

5271: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5272: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5273: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5274: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5275: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5276: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5277: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5278: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
5279: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,

Line 5311: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,

5307: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,
5308: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
5309: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,
5310: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,
5311: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,
5312: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
5313: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,
5314: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
5315: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,