DBA Data[Home] [Help]

APPS.OE_INBOUND_INT dependencies on OE_ORDER_PUB_LINE_ADJ_VAL_TBL

Line 3553: FUNCTION PL_TO_SQL15(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE)

3549: aPlsqlItem.VERSION_NO := aSqlItem.VERSION_NO;
3550: RETURN aPlsqlItem;
3551: END SQL_TO_PL38;
3552:
3553: FUNCTION PL_TO_SQL15(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE)
3554: RETURN OE_ORDER_PUB_LINE_ADJ_VAL_TBL IS
3555: aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL;
3556: BEGIN
3557: aSqlItem := OE_ORDER_PUB_LINE_ADJ_VAL_TBL();

Line 3554: RETURN OE_ORDER_PUB_LINE_ADJ_VAL_TBL IS

3550: RETURN aPlsqlItem;
3551: END SQL_TO_PL38;
3552:
3553: FUNCTION PL_TO_SQL15(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE)
3554: RETURN OE_ORDER_PUB_LINE_ADJ_VAL_TBL IS
3555: aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL;
3556: BEGIN
3557: aSqlItem := OE_ORDER_PUB_LINE_ADJ_VAL_TBL();
3558: IF aPlsqlItem.COUNT > 0 THEN

Line 3555: aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL;

3551: END SQL_TO_PL38;
3552:
3553: FUNCTION PL_TO_SQL15(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE)
3554: RETURN OE_ORDER_PUB_LINE_ADJ_VAL_TBL IS
3555: aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL;
3556: BEGIN
3557: aSqlItem := OE_ORDER_PUB_LINE_ADJ_VAL_TBL();
3558: IF aPlsqlItem.COUNT > 0 THEN
3559: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 3557: aSqlItem := OE_ORDER_PUB_LINE_ADJ_VAL_TBL();

3553: FUNCTION PL_TO_SQL15(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE)
3554: RETURN OE_ORDER_PUB_LINE_ADJ_VAL_TBL IS
3555: aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL;
3556: BEGIN
3557: aSqlItem := OE_ORDER_PUB_LINE_ADJ_VAL_TBL();
3558: IF aPlsqlItem.COUNT > 0 THEN
3559: aSqlItem.EXTEND(aPlsqlItem.COUNT);
3560: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
3561: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL38(aPlsqlItem(I));

Line 3567: FUNCTION SQL_TO_PL15(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL)

3563: END IF;
3564: RETURN aSqlItem;
3565: END PL_TO_SQL15;
3566:
3567: FUNCTION SQL_TO_PL15(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL)
3568: RETURN OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE IS
3569: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
3570: BEGIN
3571: BEGIN

Line 3568: RETURN OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE IS

3564: RETURN aSqlItem;
3565: END PL_TO_SQL15;
3566:
3567: FUNCTION SQL_TO_PL15(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL)
3568: RETURN OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE IS
3569: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
3570: BEGIN
3571: BEGIN
3572: FOR I IN 1..aSqlItem.COUNT LOOP

Line 3569: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;

3565: END PL_TO_SQL15;
3566:
3567: FUNCTION SQL_TO_PL15(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL)
3568: RETURN OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE IS
3569: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
3570: BEGIN
3571: BEGIN
3572: FOR I IN 1..aSqlItem.COUNT LOOP
3573: aPlsqlItem(I) := SQL_TO_PL38(aSqlItem(I));

Line 4812: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,

4808: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
4809: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
4810: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
4811: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
4812: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
4813: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
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,

Line 4813: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,

4809: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
4810: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
4811: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
4812: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
4813: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
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,

Line 4847: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,

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 ,
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 ,

Line 4889: P_LINE_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;

4885: P_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
4886: P_OLD_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
4887: P_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4888: P_OLD_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4889: P_LINE_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
4890: P_OLD_LINE_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_VAL_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;

Line 4890: P_OLD_LINE_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;

4886: P_OLD_LINE_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
4887: P_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4888: P_OLD_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
4889: P_LINE_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
4890: P_OLD_LINE_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_VAL_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;

Line 4924: X_LINE_ADJ_VAL_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_VAL_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;
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;

Line 5278: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,

5274: P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5275: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5276: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5277: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5278: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
5279: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
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,

Line 5279: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,

5275: P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
5276: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5277: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
5278: P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
5279: P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
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,

Line 5313: X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,

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 ,
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 ,