DBA Data[Home] [Help]

APPS.OE_INBOUND_INT dependencies on OE_ORDER_PUB_HEADER_ADJ_VAL_T

Line 1097: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)

1093: aPlsqlItem.VERSION_NO := aSqlItem.VERSION_NO;
1094: RETURN aPlsqlItem;
1095: END SQL_TO_PL27;
1096:
1097: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
1098: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS
1099: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;
1100: BEGIN
1101: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_VAL_T();

Line 1098: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS

1094: RETURN aPlsqlItem;
1095: END SQL_TO_PL27;
1096:
1097: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
1098: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS
1099: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;
1100: BEGIN
1101: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_VAL_T();
1102: IF aPlsqlItem.COUNT > 0 THEN

Line 1099: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;

1095: END SQL_TO_PL27;
1096:
1097: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
1098: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS
1099: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;
1100: BEGIN
1101: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_VAL_T();
1102: IF aPlsqlItem.COUNT > 0 THEN
1103: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 1101: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_VAL_T();

1097: FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
1098: RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS
1099: aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;
1100: BEGIN
1101: aSqlItem := OE_ORDER_PUB_HEADER_ADJ_VAL_T();
1102: IF aPlsqlItem.COUNT > 0 THEN
1103: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1104: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1105: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL27(aPlsqlItem(I));

Line 1111: FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)

1107: END IF;
1108: RETURN aSqlItem;
1109: END PL_TO_SQL4;
1110:
1111: FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)
1112: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE IS
1113: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
1114: BEGIN
1115: BEGIN

Line 1112: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE IS

1108: RETURN aSqlItem;
1109: END PL_TO_SQL4;
1110:
1111: FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)
1112: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE IS
1113: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
1114: BEGIN
1115: BEGIN
1116: FOR I IN 1..aSqlItem.COUNT LOOP

Line 1113: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;

1109: END PL_TO_SQL4;
1110:
1111: FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)
1112: RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE IS
1113: aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
1114: BEGIN
1115: BEGIN
1116: FOR I IN 1..aSqlItem.COUNT LOOP
1117: aPlsqlItem(I) := SQL_TO_PL27(aSqlItem(I));

Line 4790: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

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,
4794: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,

Line 4791: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_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,
4794: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
4795: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,

Line 4836: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_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 ,
4840: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,

Line 4867: P_HEADER_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_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;
4871: P_HEADER_ADJ_ATT_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;

Line 4868: P_OLD_HEADER_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_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;
4871: P_HEADER_ADJ_ATT_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
4872: P_OLD_HEADER_ADJ_ATT_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;

Line 4913: X_HEADER_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.HEADER_ADJ_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;
4917: X_HEADER_SCREDIT_TBL_ APPS.OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;

Line 5256: P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,

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,
5260: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,

Line 5257: P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_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,
5260: P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
5261: P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,

Line 5302: X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_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 ,
5306: X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,