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_TBL_TYPE

Line 2878: FUNCTION PL_TO_SQL12(aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE)

2874:
2875: RETURN aPlsqlItem;
2876: END SQL_TO_PL35;
2877:
2878: FUNCTION PL_TO_SQL12(aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE)
2879: RETURN OE_ORDER_PUB_LINE_TBL_TYPE IS
2880: aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE;
2881: BEGIN
2882: aSqlItem := OE_ORDER_PUB_LINE_TBL_TYPE();

Line 2879: RETURN OE_ORDER_PUB_LINE_TBL_TYPE IS

2875: RETURN aPlsqlItem;
2876: END SQL_TO_PL35;
2877:
2878: FUNCTION PL_TO_SQL12(aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE)
2879: RETURN OE_ORDER_PUB_LINE_TBL_TYPE IS
2880: aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE;
2881: BEGIN
2882: aSqlItem := OE_ORDER_PUB_LINE_TBL_TYPE();
2883: IF aPlsqlItem.COUNT > 0 THEN

Line 2880: aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE;

2876: END SQL_TO_PL35;
2877:
2878: FUNCTION PL_TO_SQL12(aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE)
2879: RETURN OE_ORDER_PUB_LINE_TBL_TYPE IS
2880: aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE;
2881: BEGIN
2882: aSqlItem := OE_ORDER_PUB_LINE_TBL_TYPE();
2883: IF aPlsqlItem.COUNT > 0 THEN
2884: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 2882: aSqlItem := OE_ORDER_PUB_LINE_TBL_TYPE();

2878: FUNCTION PL_TO_SQL12(aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE)
2879: RETURN OE_ORDER_PUB_LINE_TBL_TYPE IS
2880: aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE;
2881: BEGIN
2882: aSqlItem := OE_ORDER_PUB_LINE_TBL_TYPE();
2883: IF aPlsqlItem.COUNT > 0 THEN
2884: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2885: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2886: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL35(aPlsqlItem(I));

Line 2892: FUNCTION SQL_TO_PL12(aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE)

2888: END IF;
2889: RETURN aSqlItem;
2890: END PL_TO_SQL12;
2891:
2892: FUNCTION SQL_TO_PL12(aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE)
2893: RETURN OE_ORDER_PUB.LINE_TBL_TYPE IS
2894: aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE;
2895: BEGIN
2896: BEGIN

Line 2893: RETURN OE_ORDER_PUB.LINE_TBL_TYPE IS

2889: RETURN aSqlItem;
2890: END PL_TO_SQL12;
2891:
2892: FUNCTION SQL_TO_PL12(aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE)
2893: RETURN OE_ORDER_PUB.LINE_TBL_TYPE IS
2894: aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE;
2895: BEGIN
2896: BEGIN
2897: FOR I IN 1..aSqlItem.COUNT LOOP

Line 2894: aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE;

2890: END PL_TO_SQL12;
2891:
2892: FUNCTION SQL_TO_PL12(aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE)
2893: RETURN OE_ORDER_PUB.LINE_TBL_TYPE IS
2894: aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE;
2895: BEGIN
2896: BEGIN
2897: FOR I IN 1..aSqlItem.COUNT LOOP
2898: oe_debug_pub.add('Inside SQL_TO_PL12', 1);

Line 4806: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,

4802: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
4803: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
4804: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
4805: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
4806: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
4807: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
4808: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
4809: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
4810: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

Line 4807: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,

4803: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
4804: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
4805: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
4806: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
4807: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
4808: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
4809: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
4810: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
4811: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

Line 4844: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,

4840: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,
4841: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,
4842: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
4843: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,
4844: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,
4845: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,
4846: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
4847: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,
4848: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,

Line 4883: P_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;

4879: P_HEADER_PAYMENT_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
4880: P_OLD_HEADER_PAYMENT_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
4881: P_HEADER_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
4882: P_OLD_HEADER_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
4883: P_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;
4884: P_OLD_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;
4885: P_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
4886: P_OLD_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
4887: P_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

Line 4884: P_OLD_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;

4880: P_OLD_HEADER_PAYMENT_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
4881: P_HEADER_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
4882: P_OLD_HEADER_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
4883: P_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;
4884: P_OLD_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;
4885: P_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
4886: P_OLD_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
4887: P_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4888: P_OLD_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

Line 4921: X_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;

4917: X_HEADER_SCREDIT_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
4918: X_HEADER_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
4919: X_HEADER_PAYMENT_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
4920: X_HEADER_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
4921: X_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;
4922: X_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
4923: X_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4924: X_LINE_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
4925: X_LINE_PRICE_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;

Line 5272: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,

5268: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
5269: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
5270: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5271: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5272: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5273: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5274: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5275: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5276: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

Line 5273: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,

5269: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
5270: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5271: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5272: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5273: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5274: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5275: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5276: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5277: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

Line 5310: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,

5306: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,
5307: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,
5308: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
5309: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,
5310: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,
5311: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,
5312: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
5313: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,
5314: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,