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_VAL_T

Line 1297: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)

1293: aPlsqlItem.VERSION_NO := aSqlItem.VERSION_NO;
1294: RETURN aPlsqlItem;
1295: END SQL_TO_PL27;
1296:
1297: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
1298: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS
1299: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;
1300: BEGIN
1301: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_VAL_T();

Line 1298: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS

1294: RETURN aPlsqlItem;
1295: END SQL_TO_PL27;
1296:
1297: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
1298: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS
1299: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;
1300: BEGIN
1301: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_VAL_T();
1302: IF aPlsqlItem.COUNT > 0 THEN

Line 1299: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;

1295: END SQL_TO_PL27;
1296:
1297: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
1298: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS
1299: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;
1300: BEGIN
1301: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_VAL_T();
1302: IF aPlsqlItem.COUNT > 0 THEN
1303: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 1301: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_VAL_T();

1297: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
1298: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS
1299: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;
1300: BEGIN
1301: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_VAL_T();
1302: IF aPlsqlItem.COUNT > 0 THEN
1303: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1304: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1305: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL27(aPlsqlItem(I));

Line 1311: FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)

1307: END IF;
1308: RETURN aSqlItem;
1309: END PL_TO_SQL4;
1310:
1311: FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)
1312: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE IS
1313: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
1314: BEGIN
1315: BEGIN

Line 1312: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE IS

1308: RETURN aSqlItem;
1309: END PL_TO_SQL4;
1310:
1311: FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)
1312: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE IS
1313: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
1314: BEGIN
1315: BEGIN
1316: FOR I IN 1..aSqlItem.COUNT LOOP

Line 1313: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;

1309: END PL_TO_SQL4;
1310:
1311: FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)
1312: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE IS
1313: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
1314: BEGIN
1315: BEGIN
1316: FOR I IN 1..aSqlItem.COUNT LOOP
1317: aPlsqlItem(I) := SQL_TO_PL27(aSqlItem(I));

Line 4995: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

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,
4999: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,

Line 4996: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_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,
4999: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
5000: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,

Line 5041: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_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,
5045: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,

Line 5781: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

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,
5785: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,

Line 5782: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_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,
5785: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
5786: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,

Line 5827: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_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 ,
5831: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,

Line 5858: P_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_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;
5862: P_HEADER_ADJ_ATT_TBL_ OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;

Line 5859: P_OLD_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_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;
5862: P_HEADER_ADJ_ATT_TBL_ OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
5863: P_OLD_HEADER_ADJ_ATT_TBL_ OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;

Line 5904: X_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_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;
5908: X_HEADER_SCREDIT_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;

Line 6401: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

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,
6405: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,

Line 6402: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_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,
6405: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
6406: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,

Line 6447: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_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 ,
6451: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,