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_PAYMENT_VAL

Line 4614: FUNCTION PL_TO_SQL45(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE)

4610: NULL;
4611: END;
4612: RETURN aPlsqlItem;
4613: END SQL_TO_PL21;
4614: FUNCTION PL_TO_SQL45(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE)
4615: RETURN OE_ORDER_PUB_LINE_PAYMENT_VA3 IS
4616: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3;
4617: BEGIN
4618: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_VA3(NULL, NULL, NULL, NULL, NULL);

Line 4627: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE IS

4623: aSqlItem.PAYMENT_PERCENTAGE := aPlsqlItem.PAYMENT_PERCENTAGE;
4624: RETURN aSqlItem;
4625: END PL_TO_SQL45;
4626: FUNCTION SQL_TO_PL45(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3)
4627: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE IS
4628: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;
4629: BEGIN
4630: aPlsqlItem.PAYMENT_COLLECTION_EVENT_NAME := aSqlItem.PAYMENT_COLLECTION_EVENT_NAME;
4631: aPlsqlItem.RECEIPT_METHOD := aSqlItem.RECEIPT_METHOD;

Line 4628: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;

4624: RETURN aSqlItem;
4625: END PL_TO_SQL45;
4626: FUNCTION SQL_TO_PL45(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3)
4627: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE IS
4628: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;
4629: BEGIN
4630: aPlsqlItem.PAYMENT_COLLECTION_EVENT_NAME := aSqlItem.PAYMENT_COLLECTION_EVENT_NAME;
4631: aPlsqlItem.RECEIPT_METHOD := aSqlItem.RECEIPT_METHOD;
4632: aPlsqlItem.PAYMENT_TYPE := aSqlItem.PAYMENT_TYPE;

Line 4637: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)

4633: aPlsqlItem.COMMITMENT := aSqlItem.COMMITMENT;
4634: aPlsqlItem.PAYMENT_PERCENTAGE := aSqlItem.PAYMENT_PERCENTAGE;
4635: RETURN aPlsqlItem;
4636: END SQL_TO_PL45;
4637: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
4638: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS
4639: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;
4640: BEGIN
4641: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_VAL();

Line 4638: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS

4634: aPlsqlItem.PAYMENT_PERCENTAGE := aSqlItem.PAYMENT_PERCENTAGE;
4635: RETURN aPlsqlItem;
4636: END SQL_TO_PL45;
4637: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
4638: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS
4639: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;
4640: BEGIN
4641: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_VAL();
4642: IF aPlsqlItem.COUNT > 0 THEN

Line 4639: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;

4635: RETURN aPlsqlItem;
4636: END SQL_TO_PL45;
4637: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
4638: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS
4639: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;
4640: BEGIN
4641: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_VAL();
4642: IF aPlsqlItem.COUNT > 0 THEN
4643: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 4641: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_VAL();

4637: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
4638: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS
4639: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;
4640: BEGIN
4641: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_VAL();
4642: IF aPlsqlItem.COUNT > 0 THEN
4643: aSqlItem.EXTEND(aPlsqlItem.COUNT);
4644: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
4645: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL45(aPlsqlItem(I));

Line 4650: FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)

4646: END LOOP;
4647: END IF;
4648: RETURN aSqlItem;
4649: END PL_TO_SQL22;
4650: FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)
4651: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE IS
4652: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
4653: BEGIN
4654: BEGIN

Line 4651: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE IS

4647: END IF;
4648: RETURN aSqlItem;
4649: END PL_TO_SQL22;
4650: FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)
4651: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE IS
4652: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
4653: BEGIN
4654: BEGIN
4655: FOR I IN 1..aSqlItem.COUNT LOOP

Line 4652: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;

4648: RETURN aSqlItem;
4649: END PL_TO_SQL22;
4650: FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)
4651: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE IS
4652: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
4653: BEGIN
4654: BEGIN
4655: FOR I IN 1..aSqlItem.COUNT LOOP
4656: aPlsqlItem(I) := SQL_TO_PL45(aSqlItem(I));

Line 5031: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

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,
5033: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5034: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5035: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

Line 5032: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_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,
5033: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5034: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5035: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5036: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

Line 5059: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,

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 ,
5062: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,
5063: P_RTRIM_DATA VARCHAR2

Line 5817: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

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,
5819: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5820: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5821: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

Line 5818: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_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,
5819: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5820: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5821: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5822: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

Line 5845: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,

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 ,
5848: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
5849: P_RTRIM_DATA VARCHAR2

Line 5894: P_LINE_PAYMENT_VAL_TBL_ OE_ORDER_PUB.LINE_PAYMENT_VAL_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;
5896: P_LOT_SERIAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
5897: P_OLD_LOT_SERIAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
5898: P_LOT_SERIAL_VAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;

Line 5895: P_OLD_LINE_PAYMENT_VAL_TBL_ OE_ORDER_PUB.LINE_PAYMENT_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;
5896: P_LOT_SERIAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
5897: P_OLD_LOT_SERIAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
5898: P_LOT_SERIAL_VAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
5899: P_OLD_LOT_SERIAL_VAL_TBL_ OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;

Line 5922: X_LINE_PAYMENT_VAL_TBL_ OE_ORDER_PUB.LINE_PAYMENT_VAL_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;
5925: X_ACTION_REQUEST_TBL_ OE_ORDER_PUB.REQUEST_TBL_TYPE;
5926: l_temp_var VARCHAR2(2000) := NULL;

Line 6437: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

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,
6439: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
6440: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
6441: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

Line 6438: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_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,
6439: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
6440: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
6441: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
6442: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

Line 6465: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,

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 ,
6468: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
6469: P_RTRIM_DATA VARCHAR2