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_T

Line 1917: FUNCTION PL_TO_SQL8(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE)

1913: aPlsqlItem.SALES_GROUP_UPDATED_FLAG := aSqlItem.SALES_GROUP_UPDATED_FLAG;
1914: RETURN aPlsqlItem;
1915: END SQL_TO_PL31;
1916:
1917: FUNCTION PL_TO_SQL8(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE)
1918: RETURN OE_ORDER_PUB_HEADER_SCREDIT_T IS
1919: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T;
1920: BEGIN
1921: aSqlItem := OE_ORDER_PUB_HEADER_SCREDIT_T();

Line 1918: RETURN OE_ORDER_PUB_HEADER_SCREDIT_T IS

1914: RETURN aPlsqlItem;
1915: END SQL_TO_PL31;
1916:
1917: FUNCTION PL_TO_SQL8(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE)
1918: RETURN OE_ORDER_PUB_HEADER_SCREDIT_T IS
1919: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T;
1920: BEGIN
1921: aSqlItem := OE_ORDER_PUB_HEADER_SCREDIT_T();
1922: IF aPlsqlItem.COUNT > 0 THEN

Line 1919: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T;

1915: END SQL_TO_PL31;
1916:
1917: FUNCTION PL_TO_SQL8(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE)
1918: RETURN OE_ORDER_PUB_HEADER_SCREDIT_T IS
1919: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T;
1920: BEGIN
1921: aSqlItem := OE_ORDER_PUB_HEADER_SCREDIT_T();
1922: IF aPlsqlItem.COUNT > 0 THEN
1923: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 1921: aSqlItem := OE_ORDER_PUB_HEADER_SCREDIT_T();

1917: FUNCTION PL_TO_SQL8(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE)
1918: RETURN OE_ORDER_PUB_HEADER_SCREDIT_T IS
1919: aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T;
1920: BEGIN
1921: aSqlItem := OE_ORDER_PUB_HEADER_SCREDIT_T();
1922: IF aPlsqlItem.COUNT > 0 THEN
1923: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1924: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1925: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL31(aPlsqlItem(I));

Line 1931: FUNCTION SQL_TO_PL8(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T)

1927: END IF;
1928: RETURN aSqlItem;
1929: END PL_TO_SQL8;
1930:
1931: FUNCTION SQL_TO_PL8(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T)
1932: RETURN OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE IS
1933: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
1934: BEGIN
1935: BEGIN

Line 1932: RETURN OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE IS

1928: RETURN aSqlItem;
1929: END PL_TO_SQL8;
1930:
1931: FUNCTION SQL_TO_PL8(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T)
1932: RETURN OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE IS
1933: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
1934: BEGIN
1935: BEGIN
1936: FOR I IN 1..aSqlItem.COUNT LOOP

Line 1933: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;

1929: END PL_TO_SQL8;
1930:
1931: FUNCTION SQL_TO_PL8(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T)
1932: RETURN OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE IS
1933: aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
1934: BEGIN
1935: BEGIN
1936: FOR I IN 1..aSqlItem.COUNT LOOP
1937: aPlsqlItem(I) := SQL_TO_PL31(aSqlItem(I));

Line 5003: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,

4999: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
5000: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
5001: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5002: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5003: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
5004: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
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,

Line 5004: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,

5000: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
5001: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5002: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5003: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
5004: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
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,

Line 5045: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,

5041: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
5042: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
5043: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
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,

Line 5789: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,

5785: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
5786: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
5787: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5788: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5789: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
5790: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
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,

Line 5790: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,

5786: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
5787: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5788: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
5789: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
5790: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
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,

Line 5831: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,

5827: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
5828: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,
5829: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,
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 ,

Line 5866: P_HEADER_SCREDIT_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;

5862: P_HEADER_ADJ_ATT_TBL_ OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
5863: P_OLD_HEADER_ADJ_ATT_TBL_ OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
5864: P_HEADER_ADJ_ASSOC_TBL_ OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
5865: P_OLD_HEADER_ADJ_ASSOC_TBL_ OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
5866: P_HEADER_SCREDIT_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
5867: P_OLD_HEADER_SCREDIT_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_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;

Line 5867: P_OLD_HEADER_SCREDIT_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;

5863: P_OLD_HEADER_ADJ_ATT_TBL_ OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
5864: P_HEADER_ADJ_ASSOC_TBL_ OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
5865: P_OLD_HEADER_ADJ_ASSOC_TBL_ OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
5866: P_HEADER_SCREDIT_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
5867: P_OLD_HEADER_SCREDIT_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_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;

Line 5908: X_HEADER_SCREDIT_TBL_ OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;

5904: X_HEADER_ADJ_VAL_TBL_ OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
5905: X_HEADER_PRICE_ATT_TBL_ OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
5906: X_HEADER_ADJ_ATT_TBL_ OE_ORDER_PUB.HEADER_ADJ_ATT_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;

Line 6409: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,

6405: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
6406: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
6407: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
6408: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
6409: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
6410: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
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,

Line 6410: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,

6406: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
6407: P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
6408: P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
6409: P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
6410: P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
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,

Line 6451: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,

6447: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
6448: X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,
6449: X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,
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 ,