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_SCREDIT_VAL

Line 4411: FUNCTION PL_TO_SQL43(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE)

4407: NULL;
4408: END;
4409: RETURN aPlsqlItem;
4410: END SQL_TO_PL19;
4411: FUNCTION PL_TO_SQL43(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE)
4412: RETURN OE_ORDER_PUB_LINE_SCREDIT_VA6 IS
4413: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6;
4414: BEGIN
4415: aSqlItem := OE_ORDER_PUB_LINE_SCREDIT_VA6(NULL, NULL, NULL);

Line 4422: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE IS

4418: aSqlItem.SALES_GROUP := aPlsqlItem.SALES_GROUP;
4419: RETURN aSqlItem;
4420: END PL_TO_SQL43;
4421: FUNCTION SQL_TO_PL43(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6)
4422: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE IS
4423: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;
4424: BEGIN
4425: aPlsqlItem.SALESREP := aSqlItem.SALESREP;
4426: aPlsqlItem.SALES_CREDIT_TYPE := aSqlItem.SALES_CREDIT_TYPE;

Line 4423: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;

4419: RETURN aSqlItem;
4420: END PL_TO_SQL43;
4421: FUNCTION SQL_TO_PL43(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6)
4422: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE IS
4423: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;
4424: BEGIN
4425: aPlsqlItem.SALESREP := aSqlItem.SALESREP;
4426: aPlsqlItem.SALES_CREDIT_TYPE := aSqlItem.SALES_CREDIT_TYPE;
4427: aPlsqlItem.SALES_GROUP := aSqlItem.SALES_GROUP;

Line 4430: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)

4426: aPlsqlItem.SALES_CREDIT_TYPE := aSqlItem.SALES_CREDIT_TYPE;
4427: aPlsqlItem.SALES_GROUP := aSqlItem.SALES_GROUP;
4428: RETURN aPlsqlItem;
4429: END SQL_TO_PL43;
4430: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
4431: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS
4432: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;
4433: BEGIN
4434: aSqlItem := OE_ORDER_PUB_LINE_SCREDIT_VAL();

Line 4431: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS

4427: aPlsqlItem.SALES_GROUP := aSqlItem.SALES_GROUP;
4428: RETURN aPlsqlItem;
4429: END SQL_TO_PL43;
4430: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
4431: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS
4432: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;
4433: BEGIN
4434: aSqlItem := OE_ORDER_PUB_LINE_SCREDIT_VAL();
4435: IF aPlsqlItem.COUNT > 0 THEN

Line 4432: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;

4428: RETURN aPlsqlItem;
4429: END SQL_TO_PL43;
4430: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
4431: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS
4432: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;
4433: BEGIN
4434: aSqlItem := OE_ORDER_PUB_LINE_SCREDIT_VAL();
4435: IF aPlsqlItem.COUNT > 0 THEN
4436: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 4434: aSqlItem := OE_ORDER_PUB_LINE_SCREDIT_VAL();

4430: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
4431: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS
4432: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;
4433: BEGIN
4434: aSqlItem := OE_ORDER_PUB_LINE_SCREDIT_VAL();
4435: IF aPlsqlItem.COUNT > 0 THEN
4436: aSqlItem.EXTEND(aPlsqlItem.COUNT);
4437: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
4438: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL43(aPlsqlItem(I));

Line 4443: FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)

4439: END LOOP;
4440: END IF;
4441: RETURN aSqlItem;
4442: END PL_TO_SQL20;
4443: FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)
4444: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE IS
4445: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
4446: BEGIN
4447: BEGIN

Line 4444: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE IS

4440: END IF;
4441: RETURN aSqlItem;
4442: END PL_TO_SQL20;
4443: FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)
4444: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE IS
4445: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
4446: BEGIN
4447: BEGIN
4448: FOR I IN 1..aSqlItem.COUNT LOOP

Line 4445: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;

4441: RETURN aSqlItem;
4442: END PL_TO_SQL20;
4443: FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)
4444: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE IS
4445: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
4446: BEGIN
4447: BEGIN
4448: FOR I IN 1..aSqlItem.COUNT LOOP
4449: aPlsqlItem(I) := SQL_TO_PL43(aSqlItem(I));

Line 5027: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

5023: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5024: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5025: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5026: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5027: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5028: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5029: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5030: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5031: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

Line 5028: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

5024: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5025: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5026: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5027: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5028: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5029: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5030: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5031: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5032: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

Line 5057: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,

5053: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
5054: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
5055: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5056: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
5057: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
5058: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
5059: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
5060: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5061: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,

Line 5813: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

5809: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5810: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5811: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5812: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5813: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5814: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5815: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5816: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5817: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

Line 5814: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

5810: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5811: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5812: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5813: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5814: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5815: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5816: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5817: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5818: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

Line 5843: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,

5839: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
5840: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
5841: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,
5842: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL ,
5843: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,
5844: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
5845: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
5846: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
5847: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,

Line 5890: P_LINE_SCREDIT_VAL_TBL_ OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;

5886: P_LINE_ADJ_ASSOC_TBL_ OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
5887: P_OLD_LINE_ADJ_ASSOC_TBL_ OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
5888: P_LINE_SCREDIT_TBL_ OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
5889: P_OLD_LINE_SCREDIT_TBL_ OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
5890: P_LINE_SCREDIT_VAL_TBL_ OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
5891: P_OLD_LINE_SCREDIT_VAL_TBL_ OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
5892: P_LINE_PAYMENT_TBL_ OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
5893: P_OLD_LINE_PAYMENT_TBL_ OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
5894: P_LINE_PAYMENT_VAL_TBL_ OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;

Line 5891: P_OLD_LINE_SCREDIT_VAL_TBL_ OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;

5887: P_OLD_LINE_ADJ_ASSOC_TBL_ OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
5888: P_LINE_SCREDIT_TBL_ OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
5889: P_OLD_LINE_SCREDIT_TBL_ OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
5890: P_LINE_SCREDIT_VAL_TBL_ OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
5891: P_OLD_LINE_SCREDIT_VAL_TBL_ OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
5892: P_LINE_PAYMENT_TBL_ OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
5893: P_OLD_LINE_PAYMENT_TBL_ OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
5894: P_LINE_PAYMENT_VAL_TBL_ OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
5895: P_OLD_LINE_PAYMENT_VAL_TBL_ OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;

Line 5920: X_LINE_SCREDIT_VAL_TBL_ OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;

5916: X_LINE_PRICE_ATT_TBL_ OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
5917: X_LINE_ADJ_ATT_TBL_ OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
5918: X_LINE_ADJ_ASSOC_TBL_ OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
5919: X_LINE_SCREDIT_TBL_ OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
5920: X_LINE_SCREDIT_VAL_TBL_ OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
5921: X_LINE_PAYMENT_TBL_ OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
5922: X_LINE_PAYMENT_VAL_TBL_ OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
5923: X_LOT_SERIAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
5924: X_LOT_SERIAL_VAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;

Line 6433: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

6429: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
6430: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
6431: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
6432: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
6433: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
6434: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
6435: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
6436: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
6437: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

Line 6434: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

6430: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
6431: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
6432: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
6433: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
6434: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
6435: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
6436: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
6437: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
6438: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

Line 6463: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,

6459: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
6460: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
6461: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,
6462: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL ,
6463: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,
6464: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
6465: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
6466: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
6467: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,