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_PRICE_ATT

Line 1326: FUNCTION PL_TO_SQL28(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE)

1322: END;
1323: RETURN aPlsqlItem;
1324: END SQL_TO_PL4;
1325:
1326: FUNCTION PL_TO_SQL28(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE)
1327: RETURN OE_ORDER_PUB_HEADER_PRICE_AT6 IS
1328: aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6;
1329: BEGIN
1330: aSqlItem := OE_ORDER_PUB_HEADER_PRICE_AT6(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 1475: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE IS

1471: RETURN aSqlItem;
1472: END PL_TO_SQL28;
1473:
1474: FUNCTION SQL_TO_PL28(aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6)
1475: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE IS
1476: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE;
1477: BEGIN
1478: aPlsqlItem.ORDER_PRICE_ATTRIB_ID := aSqlItem.ORDER_PRICE_ATTRIB_ID;
1479: aPlsqlItem.HEADER_ID := aSqlItem.HEADER_ID;

Line 1476: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE;

1472: END PL_TO_SQL28;
1473:
1474: FUNCTION SQL_TO_PL28(aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6)
1475: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE IS
1476: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE;
1477: BEGIN
1478: aPlsqlItem.ORDER_PRICE_ATTRIB_ID := aSqlItem.ORDER_PRICE_ATTRIB_ID;
1479: aPlsqlItem.HEADER_ID := aSqlItem.HEADER_ID;
1480: aPlsqlItem.LINE_ID := aSqlItem.LINE_ID;

Line 1618: FUNCTION PL_TO_SQL5(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE)

1614: aPlsqlItem.CHANGE_REQUEST_CODE := aSqlItem.CHANGE_REQUEST_CODE;
1615: RETURN aPlsqlItem;
1616: END SQL_TO_PL28;
1617:
1618: FUNCTION PL_TO_SQL5(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE)
1619: RETURN OE_ORDER_PUB_HEADER_PRICE_ATT IS
1620: aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT;
1621: BEGIN
1622: aSqlItem := OE_ORDER_PUB_HEADER_PRICE_ATT();

Line 1619: RETURN OE_ORDER_PUB_HEADER_PRICE_ATT IS

1615: RETURN aPlsqlItem;
1616: END SQL_TO_PL28;
1617:
1618: FUNCTION PL_TO_SQL5(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE)
1619: RETURN OE_ORDER_PUB_HEADER_PRICE_ATT IS
1620: aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT;
1621: BEGIN
1622: aSqlItem := OE_ORDER_PUB_HEADER_PRICE_ATT();
1623: IF aPlsqlItem.COUNT > 0 THEN

Line 1620: aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT;

1616: END SQL_TO_PL28;
1617:
1618: FUNCTION PL_TO_SQL5(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE)
1619: RETURN OE_ORDER_PUB_HEADER_PRICE_ATT IS
1620: aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT;
1621: BEGIN
1622: aSqlItem := OE_ORDER_PUB_HEADER_PRICE_ATT();
1623: IF aPlsqlItem.COUNT > 0 THEN
1624: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 1622: aSqlItem := OE_ORDER_PUB_HEADER_PRICE_ATT();

1618: FUNCTION PL_TO_SQL5(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE)
1619: RETURN OE_ORDER_PUB_HEADER_PRICE_ATT IS
1620: aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT;
1621: BEGIN
1622: aSqlItem := OE_ORDER_PUB_HEADER_PRICE_ATT();
1623: IF aPlsqlItem.COUNT > 0 THEN
1624: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1625: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1626: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL28(aPlsqlItem(I));

Line 1632: FUNCTION SQL_TO_PL5(aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT)

1628: END IF;
1629: RETURN aSqlItem;
1630: END PL_TO_SQL5;
1631:
1632: FUNCTION SQL_TO_PL5(aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT)
1633: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE IS
1634: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
1635: BEGIN
1636: BEGIN

Line 1633: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE IS

1629: RETURN aSqlItem;
1630: END PL_TO_SQL5;
1631:
1632: FUNCTION SQL_TO_PL5(aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT)
1633: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE IS
1634: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
1635: BEGIN
1636: BEGIN
1637: FOR I IN 1..aSqlItem.COUNT LOOP

Line 1634: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;

1630: END PL_TO_SQL5;
1631:
1632: FUNCTION SQL_TO_PL5(aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT)
1633: RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE IS
1634: aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
1635: BEGIN
1636: BEGIN
1637: FOR I IN 1..aSqlItem.COUNT LOOP
1638: aPlsqlItem(I) := SQL_TO_PL28(aSqlItem(I));

Line 4997: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

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,
5001: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,

Line 4998: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

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,
5001: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5002: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,

Line 5042: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,

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

Line 5783: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

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,
5787: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,

Line 5784: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

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,
5787: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5788: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,

Line 5828: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,

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

Line 5860: P_HEADER_PRICE_ATT_TBL_ OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_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;
5864: P_HEADER_ADJ_ASSOC_TBL_ OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;

Line 5861: P_OLD_HEADER_PRICE_ATT_TBL_ OE_ORDER_PUB.HEADER_PRICE_ATT_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;
5864: P_HEADER_ADJ_ASSOC_TBL_ OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
5865: P_OLD_HEADER_ADJ_ASSOC_TBL_ OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;

Line 5905: X_HEADER_PRICE_ATT_TBL_ OE_ORDER_PUB.HEADER_PRICE_ATT_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;
5909: X_HEADER_SCREDIT_VAL_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;

Line 6403: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

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,
6407: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,

Line 6404: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

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,
6407: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
6408: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,

Line 6448: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,

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