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 4211: FUNCTION PL_TO_SQL43(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE)

4207: NULL;
4208: END;
4209: RETURN aPlsqlItem;
4210: END SQL_TO_PL19;
4211: FUNCTION PL_TO_SQL43(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE)
4212: RETURN OE_ORDER_PUB_LINE_SCREDIT_VA6 IS
4213: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6;
4214: BEGIN
4215: aSqlItem := OE_ORDER_PUB_LINE_SCREDIT_VA6(NULL, NULL, NULL);

Line 4222: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE IS

4218: aSqlItem.SALES_GROUP := aPlsqlItem.SALES_GROUP;
4219: RETURN aSqlItem;
4220: END PL_TO_SQL43;
4221: FUNCTION SQL_TO_PL43(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6)
4222: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE IS
4223: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;
4224: BEGIN
4225: aPlsqlItem.SALESREP := aSqlItem.SALESREP;
4226: aPlsqlItem.SALES_CREDIT_TYPE := aSqlItem.SALES_CREDIT_TYPE;

Line 4223: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;

4219: RETURN aSqlItem;
4220: END PL_TO_SQL43;
4221: FUNCTION SQL_TO_PL43(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6)
4222: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE IS
4223: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;
4224: BEGIN
4225: aPlsqlItem.SALESREP := aSqlItem.SALESREP;
4226: aPlsqlItem.SALES_CREDIT_TYPE := aSqlItem.SALES_CREDIT_TYPE;
4227: aPlsqlItem.SALES_GROUP := aSqlItem.SALES_GROUP;

Line 4230: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)

4226: aPlsqlItem.SALES_CREDIT_TYPE := aSqlItem.SALES_CREDIT_TYPE;
4227: aPlsqlItem.SALES_GROUP := aSqlItem.SALES_GROUP;
4228: RETURN aPlsqlItem;
4229: END SQL_TO_PL43;
4230: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
4231: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS
4232: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;
4233: BEGIN
4234: aSqlItem := OE_ORDER_PUB_LINE_SCREDIT_VAL();

Line 4231: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS

4227: aPlsqlItem.SALES_GROUP := aSqlItem.SALES_GROUP;
4228: RETURN aPlsqlItem;
4229: END SQL_TO_PL43;
4230: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
4231: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS
4232: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;
4233: BEGIN
4234: aSqlItem := OE_ORDER_PUB_LINE_SCREDIT_VAL();
4235: IF aPlsqlItem.COUNT > 0 THEN

Line 4232: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;

4228: RETURN aPlsqlItem;
4229: END SQL_TO_PL43;
4230: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
4231: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS
4232: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;
4233: BEGIN
4234: aSqlItem := OE_ORDER_PUB_LINE_SCREDIT_VAL();
4235: IF aPlsqlItem.COUNT > 0 THEN
4236: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 4234: aSqlItem := OE_ORDER_PUB_LINE_SCREDIT_VAL();

4230: FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
4231: RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS
4232: aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;
4233: BEGIN
4234: aSqlItem := OE_ORDER_PUB_LINE_SCREDIT_VAL();
4235: IF aPlsqlItem.COUNT > 0 THEN
4236: aSqlItem.EXTEND(aPlsqlItem.COUNT);
4237: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
4238: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL43(aPlsqlItem(I));

Line 4243: FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)

4239: END LOOP;
4240: END IF;
4241: RETURN aSqlItem;
4242: END PL_TO_SQL20;
4243: FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)
4244: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE IS
4245: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
4246: BEGIN
4247: BEGIN

Line 4244: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE IS

4240: END IF;
4241: RETURN aSqlItem;
4242: END PL_TO_SQL20;
4243: FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)
4244: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE IS
4245: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
4246: BEGIN
4247: BEGIN
4248: FOR I IN 1..aSqlItem.COUNT LOOP

Line 4245: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;

4241: RETURN aSqlItem;
4242: END PL_TO_SQL20;
4243: FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)
4244: RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE IS
4245: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
4246: BEGIN
4247: BEGIN
4248: FOR I IN 1..aSqlItem.COUNT LOOP
4249: aPlsqlItem(I) := SQL_TO_PL43(aSqlItem(I));

Line 4822: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

4818: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
4819: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
4820: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
4821: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
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,

Line 4823: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

4819: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
4820: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
4821: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
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,

Line 4852: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,

4848: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
4849: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
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 ,

Line 4899: P_LINE_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;

4895: P_LINE_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
4896: P_OLD_LINE_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
4897: P_LINE_SCREDIT_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
4898: P_OLD_LINE_SCREDIT_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_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;

Line 4900: P_OLD_LINE_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;

4896: P_OLD_LINE_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
4897: P_LINE_SCREDIT_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
4898: P_OLD_LINE_SCREDIT_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_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;

Line 4929: X_LINE_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;

4925: X_LINE_PRICE_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
4926: X_LINE_ADJ_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ATT_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;

Line 5288: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

5284: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5285: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5286: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5287: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
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,

Line 5289: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

5285: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5286: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5287: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
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,

Line 5318: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,

5314: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
5315: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
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 ,