DBA Data[Home] [Help]

APPS.OE_INBOUND_INT dependencies on OE_ORDER_PUB_HEADER_ADJ_TBL_T

Line 1045: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)

1041: aPlsqlItem.INVOICED_AMOUNT := aSqlItem.INVOICED_AMOUNT;
1042: RETURN aPlsqlItem;
1043: END SQL_TO_PL26;
1044:
1045: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
1046: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS
1047: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;
1048: BEGIN
1049: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_TBL_T();

Line 1046: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS

1042: RETURN aPlsqlItem;
1043: END SQL_TO_PL26;
1044:
1045: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
1046: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS
1047: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;
1048: BEGIN
1049: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_TBL_T();
1050: IF aPlsqlItem.COUNT > 0 THEN

Line 1047: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;

1043: END SQL_TO_PL26;
1044:
1045: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
1046: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS
1047: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;
1048: BEGIN
1049: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_TBL_T();
1050: IF aPlsqlItem.COUNT > 0 THEN
1051: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 1049: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_TBL_T();

1045: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
1046: RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS
1047: aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;
1048: BEGIN
1049: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_TBL_T();
1050: IF aPlsqlItem.COUNT > 0 THEN
1051: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1052: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1053: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL26(aPlsqlItem(I));

Line 1059: FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)

1055: END IF;
1056: RETURN aSqlItem;
1057: END PL_TO_SQL3;
1058:
1059: FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)
1060: RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE IS
1061: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
1062: BEGIN
1063: -- Exception handler added to take care of the exception of

Line 1060: RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE IS

1056: RETURN aSqlItem;
1057: END PL_TO_SQL3;
1058:
1059: FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)
1060: RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE IS
1061: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
1062: BEGIN
1063: -- Exception handler added to take care of the exception of
1064: -- uninitialized collection.

Line 1061: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

1057: END PL_TO_SQL3;
1058:
1059: FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)
1060: RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE IS
1061: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
1062: BEGIN
1063: -- Exception handler added to take care of the exception of
1064: -- uninitialized collection.
1065: BEGIN

Line 4788: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

4784: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4785: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4786: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4787: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4788: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4789: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4790: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
4791: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
4792: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

Line 4789: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

4785: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
4786: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4787: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
4788: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4789: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
4790: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
4791: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
4792: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
4793: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

Line 4835: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,

4831: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
4832: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
4833: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
4834: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
4835: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
4836: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
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 ,

Line 4865: P_HEADER_ADJ_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

4861: P_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;
4862: P_OLD_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;
4863: P_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
4864: P_OLD_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
4865: P_HEADER_ADJ_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
4866: P_OLD_HEADER_ADJ_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
4867: P_HEADER_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
4868: P_OLD_HEADER_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
4869: P_HEADER_PRICE_ATT_TBL_ APPS.OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;

Line 4866: P_OLD_HEADER_ADJ_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

4862: P_OLD_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;
4863: P_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
4864: P_OLD_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
4865: P_HEADER_ADJ_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
4866: P_OLD_HEADER_ADJ_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
4867: P_HEADER_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
4868: P_OLD_HEADER_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
4869: P_HEADER_PRICE_ATT_TBL_ APPS.OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
4870: P_OLD_HEADER_PRICE_ATT_TBL_ APPS.OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;

Line 4912: X_HEADER_ADJ_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;

4908: P_OLD_LOT_SERIAL_VAL_TBL_ APPS.OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
4909: P_ACTION_REQUEST_TBL_ APPS.OE_ORDER_PUB.REQUEST_TBL_TYPE;
4910: X_HEADER_REC_ APPS.OE_ORDER_PUB.HEADER_REC_TYPE;
4911: X_HEADER_VAL_REC_ APPS.OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
4912: X_HEADER_ADJ_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
4913: X_HEADER_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_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;

Line 5254: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

5250: P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5251: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5252: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5253: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5254: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5255: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5256: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
5257: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
5258: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

Line 5255: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,

5251: P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
5252: P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5253: P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
5254: P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5255: P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
5256: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
5257: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
5258: P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
5259: P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,

Line 5301: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,

5297: P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
5298: P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
5299: X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
5300: X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
5301: X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
5302: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
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 ,