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_HEADER_ADJ_TBL_T

Line 1245: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)

1241: aPlsqlItem.INVOICED_AMOUNT := aSqlItem.INVOICED_AMOUNT;
1242: RETURN aPlsqlItem;
1243: END SQL_TO_PL26;
1244:
1245: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
1246: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS
1247: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;
1248: BEGIN
1249: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_TBL_T();

Line 1246: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS

1242: RETURN aPlsqlItem;
1243: END SQL_TO_PL26;
1244:
1245: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
1246: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS
1247: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;
1248: BEGIN
1249: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_TBL_T();
1250: IF aPlsqlItem.COUNT > 0 THEN

Line 1247: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;

1243: END SQL_TO_PL26;
1244:
1245: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
1246: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS
1247: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;
1248: BEGIN
1249: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_TBL_T();
1250: IF aPlsqlItem.COUNT > 0 THEN
1251: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 1249: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_TBL_T();

1245: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
1246: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS
1247: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;
1248: BEGIN
1249: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_TBL_T();
1250: IF aPlsqlItem.COUNT > 0 THEN
1251: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1252: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1253: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL26(aPlsqlItem(I));

Line 1259: FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)

1255: END IF;
1256: RETURN aSqlItem;
1257: END PL_TO_SQL3;
1258:
1259: FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)
1260: RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE IS
1261: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
1262: BEGIN
1263: -- Exception handler added to take care of the exception of

Line 1260: RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE IS

1256: RETURN aSqlItem;
1257: END PL_TO_SQL3;
1258:
1259: FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)
1260: RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE IS
1261: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
1262: BEGIN
1263: -- Exception handler added to take care of the exception of
1264: -- uninitialized collection.

Line 1261: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

1257: END PL_TO_SQL3;
1258:
1259: FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)
1260: RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE IS
1261: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
1262: BEGIN
1263: -- Exception handler added to take care of the exception of
1264: -- uninitialized collection.
1265: BEGIN

Line 4993: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

4989: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4990: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4991: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4992: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4993: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4994: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4995: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
4996: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
4997: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

Line 4994: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

4990: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4991: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4992: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4993: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4994: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4995: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
4996: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
4997: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
4998: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

Line 5040: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,

5036: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5037: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
5038: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HDR_REC25,
5039: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
5040: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5041: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
5042: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
5043: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
5044: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,

Line 5779: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

5775: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5776: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5777: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5778: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5779: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5780: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5781: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
5782: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
5783: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

Line 5780: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

5776: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5777: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5778: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5779: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5780: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5781: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
5782: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
5783: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
5784: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

Line 5826: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,

5822: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5823: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
5824: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
5825: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
5826: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
5827: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
5828: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,
5829: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,
5830: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC ,

Line 5856: P_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

5852: P_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;
5853: P_OLD_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;
5854: P_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5855: P_OLD_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5856: P_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
5857: P_OLD_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
5858: P_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
5859: P_OLD_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
5860: P_HEADER_PRICE_ATT_TBL_ OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;

Line 5857: P_OLD_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

5853: P_OLD_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;
5854: P_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5855: P_OLD_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5856: P_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
5857: P_OLD_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
5858: P_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
5859: P_OLD_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
5860: P_HEADER_PRICE_ATT_TBL_ OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
5861: P_OLD_HEADER_PRICE_ATT_TBL_ OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;

Line 5903: X_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

5899: P_OLD_LOT_SERIAL_VAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
5900: P_ACTION_REQUEST_TBL_ OE_ORDER_PUB.REQUEST_TBL_TYPE;
5901: X_HEADER_REC_ OE_ORDER_PUB.HEADER_REC_TYPE;
5902: X_HEADER_VAL_REC_ OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
5903: X_HEADER_ADJ_TBL_ OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
5904: X_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
5905: X_HEADER_PRICE_ATT_TBL_ OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
5906: X_HEADER_ADJ_ATT_TBL_ OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
5907: X_HEADER_ADJ_ASSOC_TBL_ OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;

Line 6399: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

6395: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
6396: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
6397: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
6398: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
6399: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
6400: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
6401: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
6402: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
6403: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

Line 6400: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

6396: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
6397: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
6398: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
6399: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
6400: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
6401: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
6402: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
6403: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
6404: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

Line 6446: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,

6442: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
6443: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
6444: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
6445: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
6446: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
6447: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
6448: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,
6449: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,
6450: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC ,