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_LOT_SERIAL_VAL_T

Line 4600: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)

4596: aPlsqlItem.LINE := aSqlItem.LINE;
4597: aPlsqlItem.LOT_SERIAL := aSqlItem.LOT_SERIAL;
4598: RETURN aPlsqlItem;
4599: END SQL_TO_PL47;
4600: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
4601: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS
4602: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;
4603: BEGIN
4604: aSqlItem := OE_ORDER_PUB_LOT_SERIAL_VAL_T();

Line 4601: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS

4597: aPlsqlItem.LOT_SERIAL := aSqlItem.LOT_SERIAL;
4598: RETURN aPlsqlItem;
4599: END SQL_TO_PL47;
4600: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
4601: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS
4602: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;
4603: BEGIN
4604: aSqlItem := OE_ORDER_PUB_LOT_SERIAL_VAL_T();
4605: IF aPlsqlItem.COUNT > 0 THEN

Line 4602: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;

4598: RETURN aPlsqlItem;
4599: END SQL_TO_PL47;
4600: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
4601: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS
4602: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;
4603: BEGIN
4604: aSqlItem := OE_ORDER_PUB_LOT_SERIAL_VAL_T();
4605: IF aPlsqlItem.COUNT > 0 THEN
4606: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 4604: aSqlItem := OE_ORDER_PUB_LOT_SERIAL_VAL_T();

4600: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
4601: RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS
4602: aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;
4603: BEGIN
4604: aSqlItem := OE_ORDER_PUB_LOT_SERIAL_VAL_T();
4605: IF aPlsqlItem.COUNT > 0 THEN
4606: aSqlItem.EXTEND(aPlsqlItem.COUNT);
4607: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
4608: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL47(aPlsqlItem(I));

Line 4613: FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)

4609: END LOOP;
4610: END IF;
4611: RETURN aSqlItem;
4612: END PL_TO_SQL24;
4613: FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)
4614: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE IS
4615: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
4616: BEGIN
4617: BEGIN

Line 4614: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE IS

4610: END IF;
4611: RETURN aSqlItem;
4612: END PL_TO_SQL24;
4613: FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)
4614: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE IS
4615: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
4616: BEGIN
4617: BEGIN
4618: FOR I IN 1..aSqlItem.COUNT LOOP

Line 4615: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;

4611: RETURN aSqlItem;
4612: END PL_TO_SQL24;
4613: FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)
4614: RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE IS
4615: aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
4616: BEGIN
4617: BEGIN
4618: FOR I IN 1..aSqlItem.COUNT LOOP
4619: aPlsqlItem(I) := SQL_TO_PL47(aSqlItem(I));

Line 4830: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

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,
4832: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
4833: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
4834: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,

Line 4831: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

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,
4832: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
4833: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
4834: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
4835: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,

Line 4856: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,

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
4859: )
4860: IS

Line 4907: P_LOT_SERIAL_VAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_VAL_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;
4909: P_ACTION_REQUEST_TBL_ APPS.OE_ORDER_PUB.REQUEST_TBL_TYPE;
4910: X_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;
4911: X_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;

Line 4908: P_OLD_LOT_SERIAL_VAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_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;
4909: P_ACTION_REQUEST_TBL_ APPS.OE_ORDER_PUB.REQUEST_TBL_TYPE;
4910: X_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;
4911: X_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
4912: X_HEADER_ADJ_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

Line 4933: X_LOT_SERIAL_VAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_VAL_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;
4936: l_return_status VARCHAR2(256);
4937:

Line 5296: P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

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,
5298: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
5299: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
5300: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,

Line 5297: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,

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,
5298: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
5299: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
5300: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
5301: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,

Line 5322: X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,

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
5325: )
5326: IS