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();
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
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);
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));
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
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.
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
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,
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,
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 ,
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;
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;
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;
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,
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,
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 ,