DBA Data[Home] [Help]

APPS.OE_INBOUND_INT dependencies on OE_ORDER_PUB_LINE_ADJ_ASSOC_T

Line 4056: FUNCTION PL_TO_SQL18(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE)

4052: aPlsqlItem.LOCK_CONTROL := aSqlItem.LOCK_CONTROL;
4053: RETURN aPlsqlItem;
4054: END SQL_TO_PL41;
4055:
4056: FUNCTION PL_TO_SQL18(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE)
4057: RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_T IS
4058: aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T;
4059: BEGIN
4060: aSqlItem := OE_ORDER_PUB_LINE_ADJ_ASSOC_T();

Line 4057: RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_T IS

4053: RETURN aPlsqlItem;
4054: END SQL_TO_PL41;
4055:
4056: FUNCTION PL_TO_SQL18(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE)
4057: RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_T IS
4058: aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T;
4059: BEGIN
4060: aSqlItem := OE_ORDER_PUB_LINE_ADJ_ASSOC_T();
4061: IF aPlsqlItem.COUNT > 0 THEN

Line 4058: aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T;

4054: END SQL_TO_PL41;
4055:
4056: FUNCTION PL_TO_SQL18(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE)
4057: RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_T IS
4058: aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T;
4059: BEGIN
4060: aSqlItem := OE_ORDER_PUB_LINE_ADJ_ASSOC_T();
4061: IF aPlsqlItem.COUNT > 0 THEN
4062: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 4060: aSqlItem := OE_ORDER_PUB_LINE_ADJ_ASSOC_T();

4056: FUNCTION PL_TO_SQL18(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE)
4057: RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_T IS
4058: aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T;
4059: BEGIN
4060: aSqlItem := OE_ORDER_PUB_LINE_ADJ_ASSOC_T();
4061: IF aPlsqlItem.COUNT > 0 THEN
4062: aSqlItem.EXTEND(aPlsqlItem.COUNT);
4063: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
4064: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL41(aPlsqlItem(I));

Line 4070: FUNCTION SQL_TO_PL18(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T)

4066: END IF;
4067: RETURN aSqlItem;
4068: END PL_TO_SQL18;
4069:
4070: FUNCTION SQL_TO_PL18(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T)
4071: RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE IS
4072: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
4073: BEGIN
4074: BEGIN

Line 4071: RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE IS

4067: RETURN aSqlItem;
4068: END PL_TO_SQL18;
4069:
4070: FUNCTION SQL_TO_PL18(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T)
4071: RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE IS
4072: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
4073: BEGIN
4074: BEGIN
4075: FOR I IN 1..aSqlItem.COUNT LOOP

Line 4072: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;

4068: END PL_TO_SQL18;
4069:
4070: FUNCTION SQL_TO_PL18(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T)
4071: RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE IS
4072: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
4073: BEGIN
4074: BEGIN
4075: FOR I IN 1..aSqlItem.COUNT LOOP
4076: aPlsqlItem(I) := SQL_TO_PL41(aSqlItem(I));

Line 4818: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,

4814: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
4815: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
4816: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
4817: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
4818: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
4819: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
4820: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
4821: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
4822: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

Line 4819: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,

4815: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
4816: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
4817: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
4818: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
4819: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
4820: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
4821: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
4822: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
4823: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

Line 4850: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,

4846: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
4847: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,
4848: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
4849: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
4850: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,
4851: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL ,
4852: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,
4853: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
4854: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,

Line 4895: P_LINE_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;

4891: P_LINE_PRICE_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
4892: P_OLD_LINE_PRICE_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
4893: P_LINE_ADJ_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
4894: P_OLD_LINE_ADJ_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
4895: P_LINE_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
4896: P_OLD_LINE_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
4897: P_LINE_SCREDIT_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
4898: P_OLD_LINE_SCREDIT_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
4899: P_LINE_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;

Line 4896: P_OLD_LINE_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;

4892: P_OLD_LINE_PRICE_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
4893: P_LINE_ADJ_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
4894: P_OLD_LINE_ADJ_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
4895: P_LINE_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
4896: P_OLD_LINE_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
4897: P_LINE_SCREDIT_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
4898: P_OLD_LINE_SCREDIT_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
4899: P_LINE_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
4900: P_OLD_LINE_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;

Line 4927: X_LINE_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;

4923: X_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4924: X_LINE_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
4925: X_LINE_PRICE_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
4926: X_LINE_ADJ_ATT_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
4927: X_LINE_ADJ_ASSOC_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
4928: X_LINE_SCREDIT_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
4929: X_LINE_SCREDIT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
4930: X_LINE_PAYMENT_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
4931: X_LINE_PAYMENT_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;

Line 5284: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,

5280: P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
5281: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
5282: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
5283: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
5284: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5285: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5286: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5287: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5288: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

Line 5285: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,

5281: P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
5282: P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
5283: P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
5284: P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5285: P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
5286: P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5287: P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
5288: P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
5289: P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,

Line 5316: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,

5312: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
5313: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,
5314: X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
5315: X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
5316: X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,
5317: X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL ,
5318: X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,
5319: X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
5320: X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,