DBA Data[Home] [Help]

APPS.OE_INBOUND_INT dependencies on OE_ORDER_PUB_HEADER_PAYMENT_T

Line 1928: FUNCTION PL_TO_SQL10(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE)

1924:
1925: RETURN aPlsqlItem;
1926: END SQL_TO_PL33;
1927:
1928: FUNCTION PL_TO_SQL10(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE)
1929: RETURN OE_ORDER_PUB_HEADER_PAYMENT_T IS
1930: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T;
1931: BEGIN
1932: aSqlItem := OE_ORDER_PUB_HEADER_PAYMENT_T();

Line 1929: RETURN OE_ORDER_PUB_HEADER_PAYMENT_T IS

1925: RETURN aPlsqlItem;
1926: END SQL_TO_PL33;
1927:
1928: FUNCTION PL_TO_SQL10(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE)
1929: RETURN OE_ORDER_PUB_HEADER_PAYMENT_T IS
1930: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T;
1931: BEGIN
1932: aSqlItem := OE_ORDER_PUB_HEADER_PAYMENT_T();
1933: IF aPlsqlItem.COUNT > 0 THEN

Line 1930: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T;

1926: END SQL_TO_PL33;
1927:
1928: FUNCTION PL_TO_SQL10(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE)
1929: RETURN OE_ORDER_PUB_HEADER_PAYMENT_T IS
1930: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T;
1931: BEGIN
1932: aSqlItem := OE_ORDER_PUB_HEADER_PAYMENT_T();
1933: IF aPlsqlItem.COUNT > 0 THEN
1934: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 1932: aSqlItem := OE_ORDER_PUB_HEADER_PAYMENT_T();

1928: FUNCTION PL_TO_SQL10(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE)
1929: RETURN OE_ORDER_PUB_HEADER_PAYMENT_T IS
1930: aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T;
1931: BEGIN
1932: aSqlItem := OE_ORDER_PUB_HEADER_PAYMENT_T();
1933: IF aPlsqlItem.COUNT > 0 THEN
1934: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1935: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1936: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL33(aPlsqlItem(I));

Line 1942: FUNCTION SQL_TO_PL10(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T)

1938: END IF;
1939: RETURN aSqlItem;
1940: END PL_TO_SQL10;
1941:
1942: FUNCTION SQL_TO_PL10(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T)
1943: RETURN OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE IS
1944: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
1945: BEGIN
1946: BEGIN

Line 1943: RETURN OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE IS

1939: RETURN aSqlItem;
1940: END PL_TO_SQL10;
1941:
1942: FUNCTION SQL_TO_PL10(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T)
1943: RETURN OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE IS
1944: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
1945: BEGIN
1946: BEGIN
1947: FOR I IN 1..aSqlItem.COUNT LOOP

Line 1944: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;

1940: END PL_TO_SQL10;
1941:
1942: FUNCTION SQL_TO_PL10(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T)
1943: RETURN OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE IS
1944: aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
1945: BEGIN
1946: BEGIN
1947: FOR I IN 1..aSqlItem.COUNT LOOP
1948: aPlsqlItem(I) := SQL_TO_PL33(aSqlItem(I));

Line 4802: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,

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,
4806: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,

Line 4803: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_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,
4806: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
4807: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,

Line 4842: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,

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 ,
4846: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,

Line 4879: P_HEADER_PAYMENT_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_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;
4883: P_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;

Line 4880: P_OLD_HEADER_PAYMENT_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_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;
4883: P_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;
4884: P_OLD_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;

Line 4919: X_HEADER_PAYMENT_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_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;
4923: X_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

Line 5268: P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,

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,
5272: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,

Line 5269: P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_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,
5272: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5273: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,

Line 5308: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,

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 ,
5312: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,