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_HEADER_SCREDIT_V

Line 1746: FUNCTION PL_TO_SQL32(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE)

1742: END;
1743: RETURN aPlsqlItem;
1744: END SQL_TO_PL8;
1745:
1746: FUNCTION PL_TO_SQL32(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE)
1747: RETURN OE_ORDER_PUB_HEADER_SCREDIT11 IS
1748: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11;
1749: BEGIN
1750: aSqlItem := OE_ORDER_PUB_HEADER_SCREDIT11(NULL, NULL, NULL);

Line 1758: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE IS

1754: RETURN aSqlItem;
1755: END PL_TO_SQL32;
1756:
1757: FUNCTION SQL_TO_PL32(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11)
1758: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE IS
1759: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE;
1760: BEGIN
1761: aPlsqlItem.SALESREP := aSqlItem.SALESREP;
1762: aPlsqlItem.SALES_CREDIT_TYPE := aSqlItem.SALES_CREDIT_TYPE;

Line 1759: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE;

1755: END PL_TO_SQL32;
1756:
1757: FUNCTION SQL_TO_PL32(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11)
1758: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE IS
1759: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE;
1760: BEGIN
1761: aPlsqlItem.SALESREP := aSqlItem.SALESREP;
1762: aPlsqlItem.SALES_CREDIT_TYPE := aSqlItem.SALES_CREDIT_TYPE;
1763: aPlsqlItem.SALES_GROUP := aSqlItem.SALES_GROUP;

Line 1767: FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)

1763: aPlsqlItem.SALES_GROUP := aSqlItem.SALES_GROUP;
1764: RETURN aPlsqlItem;
1765: END SQL_TO_PL32;
1766:
1767: FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
1768: RETURN OE_ORDER_PUB_HEADER_SCREDIT_V IS
1769: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V;
1770: BEGIN
1771: aSqlItem := OE_ORDER_PUB_HEADER_SCREDIT_V();

Line 1768: RETURN OE_ORDER_PUB_HEADER_SCREDIT_V IS

1764: RETURN aPlsqlItem;
1765: END SQL_TO_PL32;
1766:
1767: FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
1768: RETURN OE_ORDER_PUB_HEADER_SCREDIT_V IS
1769: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V;
1770: BEGIN
1771: aSqlItem := OE_ORDER_PUB_HEADER_SCREDIT_V();
1772: IF aPlsqlItem.COUNT > 0 THEN

Line 1769: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V;

1765: END SQL_TO_PL32;
1766:
1767: FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
1768: RETURN OE_ORDER_PUB_HEADER_SCREDIT_V IS
1769: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V;
1770: BEGIN
1771: aSqlItem := OE_ORDER_PUB_HEADER_SCREDIT_V();
1772: IF aPlsqlItem.COUNT > 0 THEN
1773: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 1771: aSqlItem := OE_ORDER_PUB_HEADER_SCREDIT_V();

1767: FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
1768: RETURN OE_ORDER_PUB_HEADER_SCREDIT_V IS
1769: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V;
1770: BEGIN
1771: aSqlItem := OE_ORDER_PUB_HEADER_SCREDIT_V();
1772: IF aPlsqlItem.COUNT > 0 THEN
1773: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1774: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1775: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL32(aPlsqlItem(I));

Line 1781: FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)

1777: END IF;
1778: RETURN aSqlItem;
1779: END PL_TO_SQL9;
1780:
1781: FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)
1782: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE IS
1783: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
1784: BEGIN
1785: BEGIN

Line 1782: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE IS

1778: RETURN aSqlItem;
1779: END PL_TO_SQL9;
1780:
1781: FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)
1782: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE IS
1783: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
1784: BEGIN
1785: BEGIN
1786: FOR I IN 1..aSqlItem.COUNT LOOP

Line 1783: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;

1779: END PL_TO_SQL9;
1780:
1781: FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)
1782: RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE IS
1783: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
1784: BEGIN
1785: BEGIN
1786: FOR I IN 1..aSqlItem.COUNT LOOP
1787: aPlsqlItem(I) := SQL_TO_PL32(aSqlItem(I));

Line 4800: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,

4796: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
4797: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
4798: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
4799: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
4800: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
4801: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
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,

Line 4801: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,

4797: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
4798: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
4799: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
4800: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
4801: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
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,

Line 4841: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,

4837: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,
4838: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,
4839: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC ,
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 ,

Line 4877: P_HEADER_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;

4873: P_HEADER_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
4874: P_OLD_HEADER_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
4875: P_HEADER_SCREDIT_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
4876: P_OLD_HEADER_SCREDIT_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
4877: P_HEADER_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
4878: P_OLD_HEADER_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_VAL_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;

Line 4878: P_OLD_HEADER_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;

4874: P_OLD_HEADER_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
4875: P_HEADER_SCREDIT_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
4876: P_OLD_HEADER_SCREDIT_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
4877: P_HEADER_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
4878: P_OLD_HEADER_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_VAL_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;

Line 4918: X_HEADER_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;

4914: X_HEADER_PRICE_ATT_TBL_ APPS.OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
4915: X_HEADER_ADJ_ATT_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
4916: X_HEADER_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_ASSOC_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;

Line 5266: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,

5262: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5263: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5264: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
5265: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
5266: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
5267: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
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,

Line 5267: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,

5263: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5264: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
5265: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
5266: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
5267: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
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,

Line 5307: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,

5303: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,
5304: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,
5305: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC ,
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 ,