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_PAYMENT_V

Line 2157: FUNCTION PL_TO_SQL34(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE)

2153: END;
2154: RETURN aPlsqlItem;
2155: END SQL_TO_PL10;
2156:
2157: FUNCTION PL_TO_SQL34(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE)
2158: RETURN OE_ORDER_PUB_HEADER_PAYMENT_5 IS
2159: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5;
2160: BEGIN
2161: aSqlItem := OE_ORDER_PUB_HEADER_PAYMENT_5(NULL, NULL, NULL, NULL, NULL);

Line 2171: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE IS

2167: RETURN aSqlItem;
2168: END PL_TO_SQL34;
2169:
2170: FUNCTION SQL_TO_PL34(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5)
2171: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE IS
2172: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE;
2173: BEGIN
2174: aPlsqlItem.PAYMENT_COLLECTION_EVENT_NAME := aSqlItem.PAYMENT_COLLECTION_EVENT_NAME;
2175: aPlsqlItem.RECEIPT_METHOD := aSqlItem.RECEIPT_METHOD;

Line 2172: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE;

2168: END PL_TO_SQL34;
2169:
2170: FUNCTION SQL_TO_PL34(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5)
2171: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE IS
2172: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE;
2173: BEGIN
2174: aPlsqlItem.PAYMENT_COLLECTION_EVENT_NAME := aSqlItem.PAYMENT_COLLECTION_EVENT_NAME;
2175: aPlsqlItem.RECEIPT_METHOD := aSqlItem.RECEIPT_METHOD;
2176: aPlsqlItem.PAYMENT_TYPE := aSqlItem.PAYMENT_TYPE;

Line 2182: FUNCTION PL_TO_SQL11(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE)

2178: aPlsqlItem.PAYMENT_PERCENTAGE := aSqlItem.PAYMENT_PERCENTAGE;
2179: RETURN aPlsqlItem;
2180: END SQL_TO_PL34;
2181:
2182: FUNCTION PL_TO_SQL11(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE)
2183: RETURN OE_ORDER_PUB_HEADER_PAYMENT_V IS
2184: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V;
2185: BEGIN
2186: aSqlItem := OE_ORDER_PUB_HEADER_PAYMENT_V();

Line 2183: RETURN OE_ORDER_PUB_HEADER_PAYMENT_V IS

2179: RETURN aPlsqlItem;
2180: END SQL_TO_PL34;
2181:
2182: FUNCTION PL_TO_SQL11(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE)
2183: RETURN OE_ORDER_PUB_HEADER_PAYMENT_V IS
2184: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V;
2185: BEGIN
2186: aSqlItem := OE_ORDER_PUB_HEADER_PAYMENT_V();
2187: IF aPlsqlItem.COUNT > 0 THEN

Line 2184: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V;

2180: END SQL_TO_PL34;
2181:
2182: FUNCTION PL_TO_SQL11(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE)
2183: RETURN OE_ORDER_PUB_HEADER_PAYMENT_V IS
2184: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V;
2185: BEGIN
2186: aSqlItem := OE_ORDER_PUB_HEADER_PAYMENT_V();
2187: IF aPlsqlItem.COUNT > 0 THEN
2188: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 2186: aSqlItem := OE_ORDER_PUB_HEADER_PAYMENT_V();

2182: FUNCTION PL_TO_SQL11(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE)
2183: RETURN OE_ORDER_PUB_HEADER_PAYMENT_V IS
2184: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V;
2185: BEGIN
2186: aSqlItem := OE_ORDER_PUB_HEADER_PAYMENT_V();
2187: IF aPlsqlItem.COUNT > 0 THEN
2188: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2189: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2190: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL34(aPlsqlItem(I));

Line 2196: FUNCTION SQL_TO_PL11(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V)

2192: END IF;
2193: RETURN aSqlItem;
2194: END PL_TO_SQL11;
2195:
2196: FUNCTION SQL_TO_PL11(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V)
2197: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE IS
2198: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
2199: BEGIN
2200: BEGIN

Line 2197: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE IS

2193: RETURN aSqlItem;
2194: END PL_TO_SQL11;
2195:
2196: FUNCTION SQL_TO_PL11(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V)
2197: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE IS
2198: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
2199: BEGIN
2200: BEGIN
2201: FOR I IN 1..aSqlItem.COUNT LOOP

Line 2198: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;

2194: END PL_TO_SQL11;
2195:
2196: FUNCTION SQL_TO_PL11(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V)
2197: RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE IS
2198: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
2199: BEGIN
2200: BEGIN
2201: FOR I IN 1..aSqlItem.COUNT LOOP
2202: aPlsqlItem(I) := SQL_TO_PL34(aSqlItem(I));

Line 5009: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,

5005: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
5006: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
5007: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
5008: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
5009: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5010: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5011: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5012: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5013: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

Line 5010: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,

5006: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
5007: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
5008: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
5009: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5010: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5011: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5012: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5013: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5014: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

Line 5048: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,

5044: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5045: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
5046: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
5047: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
5048: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
5049: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TAB25,
5050: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5051: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
5052: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,

Line 5795: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,

5791: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
5792: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
5793: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
5794: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
5795: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5796: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5797: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5798: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5799: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

Line 5796: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,

5792: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
5793: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
5794: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
5795: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5796: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
5797: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5798: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5799: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5800: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

Line 5834: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,

5830: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC ,
5831: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,
5832: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,
5833: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
5834: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,
5835: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,
5836: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,
5837: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
5838: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,

Line 5872: P_HEADER_PAYMENT_VAL_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;

5868: P_HEADER_SCREDIT_VAL_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
5869: P_OLD_HEADER_SCREDIT_VAL_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
5870: P_HEADER_PAYMENT_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
5871: P_OLD_HEADER_PAYMENT_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
5872: P_HEADER_PAYMENT_VAL_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
5873: P_OLD_HEADER_PAYMENT_VAL_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
5874: P_LINE_TBL_ OE_ORDER_PUB.LINE_TBL_TYPE;
5875: P_OLD_LINE_TBL_ OE_ORDER_PUB.LINE_TBL_TYPE;
5876: P_LINE_VAL_TBL_ OE_ORDER_PUB.LINE_VAL_TBL_TYPE;

Line 5873: P_OLD_HEADER_PAYMENT_VAL_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;

5869: P_OLD_HEADER_SCREDIT_VAL_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
5870: P_HEADER_PAYMENT_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
5871: P_OLD_HEADER_PAYMENT_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
5872: P_HEADER_PAYMENT_VAL_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
5873: P_OLD_HEADER_PAYMENT_VAL_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
5874: P_LINE_TBL_ OE_ORDER_PUB.LINE_TBL_TYPE;
5875: P_OLD_LINE_TBL_ OE_ORDER_PUB.LINE_TBL_TYPE;
5876: P_LINE_VAL_TBL_ OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
5877: P_OLD_LINE_VAL_TBL_ OE_ORDER_PUB.LINE_VAL_TBL_TYPE;

Line 5911: X_HEADER_PAYMENT_VAL_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;

5907: X_HEADER_ADJ_ASSOC_TBL_ OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
5908: X_HEADER_SCREDIT_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
5909: X_HEADER_SCREDIT_VAL_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
5910: X_HEADER_PAYMENT_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
5911: X_HEADER_PAYMENT_VAL_TBL_ OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
5912: X_LINE_TBL_ OE_ORDER_PUB.LINE_TBL_TYPE;
5913: X_LINE_VAL_TBL_ OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
5914: X_LINE_ADJ_TBL_ OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
5915: X_LINE_ADJ_VAL_TBL_ OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;

Line 6415: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,

6411: P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
6412: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
6413: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
6414: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
6415: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
6416: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
6417: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
6418: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
6419: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

Line 6416: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,

6412: P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
6413: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
6414: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
6415: P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
6416: P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
6417: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
6418: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
6419: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
6420: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,

Line 6454: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,

6450: X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC ,
6451: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,
6452: X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,
6453: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
6454: X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,
6455: X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,
6456: X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,
6457: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
6458: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,