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 4414: FUNCTION PL_TO_SQL45(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE)

4410: NULL;
4411: END;
4412: RETURN aPlsqlItem;
4413: END SQL_TO_PL21;
4414: FUNCTION PL_TO_SQL45(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE)
4415: RETURN OE_ORDER_PUB_LINE_PAYMENT_VA3 IS
4416: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3;
4417: BEGIN
4418: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_VA3(NULL, NULL, NULL, NULL, NULL);

Line 4427: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE IS

4423: aSqlItem.PAYMENT_PERCENTAGE := aPlsqlItem.PAYMENT_PERCENTAGE;
4424: RETURN aSqlItem;
4425: END PL_TO_SQL45;
4426: FUNCTION SQL_TO_PL45(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3)
4427: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE IS
4428: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;
4429: BEGIN
4430: aPlsqlItem.PAYMENT_COLLECTION_EVENT_NAME := aSqlItem.PAYMENT_COLLECTION_EVENT_NAME;
4431: aPlsqlItem.RECEIPT_METHOD := aSqlItem.RECEIPT_METHOD;

Line 4428: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;

4424: RETURN aSqlItem;
4425: END PL_TO_SQL45;
4426: FUNCTION SQL_TO_PL45(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3)
4427: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE IS
4428: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;
4429: BEGIN
4430: aPlsqlItem.PAYMENT_COLLECTION_EVENT_NAME := aSqlItem.PAYMENT_COLLECTION_EVENT_NAME;
4431: aPlsqlItem.RECEIPT_METHOD := aSqlItem.RECEIPT_METHOD;
4432: aPlsqlItem.PAYMENT_TYPE := aSqlItem.PAYMENT_TYPE;

Line 4437: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)

4433: aPlsqlItem.COMMITMENT := aSqlItem.COMMITMENT;
4434: aPlsqlItem.PAYMENT_PERCENTAGE := aSqlItem.PAYMENT_PERCENTAGE;
4435: RETURN aPlsqlItem;
4436: END SQL_TO_PL45;
4437: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
4438: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS
4439: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;
4440: BEGIN
4441: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_VAL();

Line 4438: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS

4434: aPlsqlItem.PAYMENT_PERCENTAGE := aSqlItem.PAYMENT_PERCENTAGE;
4435: RETURN aPlsqlItem;
4436: END SQL_TO_PL45;
4437: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
4438: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS
4439: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;
4440: BEGIN
4441: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_VAL();
4442: IF aPlsqlItem.COUNT > 0 THEN

Line 4439: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;

4435: RETURN aPlsqlItem;
4436: END SQL_TO_PL45;
4437: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
4438: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS
4439: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;
4440: BEGIN
4441: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_VAL();
4442: IF aPlsqlItem.COUNT > 0 THEN
4443: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 4441: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_VAL();

4437: FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
4438: RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS
4439: aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;
4440: BEGIN
4441: aSqlItem := OE_ORDER_PUB_LINE_PAYMENT_VAL();
4442: IF aPlsqlItem.COUNT > 0 THEN
4443: aSqlItem.EXTEND(aPlsqlItem.COUNT);
4444: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
4445: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL45(aPlsqlItem(I));

Line 4450: FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)

4446: END LOOP;
4447: END IF;
4448: RETURN aSqlItem;
4449: END PL_TO_SQL22;
4450: FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)
4451: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE IS
4452: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
4453: BEGIN
4454: BEGIN

Line 4451: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE IS

4447: END IF;
4448: RETURN aSqlItem;
4449: END PL_TO_SQL22;
4450: FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)
4451: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE IS
4452: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
4453: BEGIN
4454: BEGIN
4455: FOR I IN 1..aSqlItem.COUNT LOOP

Line 4452: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;

4448: RETURN aSqlItem;
4449: END PL_TO_SQL22;
4450: FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)
4451: RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE IS
4452: aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
4453: BEGIN
4454: BEGIN
4455: FOR I IN 1..aSqlItem.COUNT LOOP
4456: aPlsqlItem(I) := SQL_TO_PL45(aSqlItem(I));

Line 4826: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

4822: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
4823: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
4824: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
4825: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
4826: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
4827: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
4828: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
4829: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
4830: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

Line 4827: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

4823: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
4824: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
4825: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
4826: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
4827: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
4828: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
4829: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
4830: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
4831: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

Line 4854: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,

4850: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,
4851: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL ,
4852: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,
4853: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
4854: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
4855: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
4856: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
4857: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
4858: P_RTRIM_DATA VARCHAR2

Line 4903: P_LINE_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;

4899: P_LINE_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
4900: P_OLD_LINE_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
4901: P_LINE_PAYMENT_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
4902: P_OLD_LINE_PAYMENT_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
4903: P_LINE_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
4904: P_OLD_LINE_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
4905: P_LOT_SERIAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
4906: P_OLD_LOT_SERIAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
4907: P_LOT_SERIAL_VAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;

Line 4904: P_OLD_LINE_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;

4900: P_OLD_LINE_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
4901: P_LINE_PAYMENT_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
4902: P_OLD_LINE_PAYMENT_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
4903: P_LINE_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
4904: P_OLD_LINE_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
4905: P_LOT_SERIAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
4906: P_OLD_LOT_SERIAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
4907: P_LOT_SERIAL_VAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
4908: P_OLD_LOT_SERIAL_VAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;

Line 4931: X_LINE_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;

4927: X_LINE_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
4928: X_LINE_SCREDIT_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
4929: X_LINE_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
4930: X_LINE_PAYMENT_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
4931: X_LINE_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
4932: X_LOT_SERIAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
4933: X_LOT_SERIAL_VAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
4934: X_ACTION_REQUEST_TBL_ APPS.OE_ORDER_PUB.REQUEST_TBL_TYPE;
4935: l_temp_var VARCHAR2(2000) := NULL;

Line 5292: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

5288: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5289: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5290: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5291: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5292: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5293: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5294: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5295: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5296: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

Line 5293: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,

5289: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5290: P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5291: P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
5292: P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5293: P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
5294: P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5295: P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
5296: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5297: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

Line 5320: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,

5316: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,
5317: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL ,
5318: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,
5319: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
5320: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
5321: X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
5322: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
5323: X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
5324: P_RTRIM_DATA VARCHAR2