DBA Data[Home] [Help]

APPS.OE_INBOUND_INT dependencies on OE_ORDER_PUB_LINE_ADJ_TBL_TYP

Line 3503: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)

3499: aPlsqlItem.RETROBILL_REQUEST_ID := aSqlItem.RETROBILL_REQUEST_ID;
3500: RETURN aPlsqlItem;
3501: END SQL_TO_PL37;
3502:
3503: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
3504: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS
3505: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
3506: BEGIN
3507: aSqlItem := OE_ORDER_PUB_LINE_ADJ_TBL_TYP();

Line 3504: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS

3500: RETURN aPlsqlItem;
3501: END SQL_TO_PL37;
3502:
3503: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
3504: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS
3505: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
3506: BEGIN
3507: aSqlItem := OE_ORDER_PUB_LINE_ADJ_TBL_TYP();
3508: IF aPlsqlItem.COUNT > 0 THEN

Line 3505: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;

3501: END SQL_TO_PL37;
3502:
3503: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
3504: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS
3505: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
3506: BEGIN
3507: aSqlItem := OE_ORDER_PUB_LINE_ADJ_TBL_TYP();
3508: IF aPlsqlItem.COUNT > 0 THEN
3509: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 3507: aSqlItem := OE_ORDER_PUB_LINE_ADJ_TBL_TYP();

3503: FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
3504: RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS
3505: aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
3506: BEGIN
3507: aSqlItem := OE_ORDER_PUB_LINE_ADJ_TBL_TYP();
3508: IF aPlsqlItem.COUNT > 0 THEN
3509: aSqlItem.EXTEND(aPlsqlItem.COUNT);
3510: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
3511: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL37(aPlsqlItem(I));

Line 3517: FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)

3513: END IF;
3514: RETURN aSqlItem;
3515: END PL_TO_SQL14;
3516:
3517: FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)
3518: RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE IS
3519: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
3520: BEGIN
3521: BEGIN

Line 3518: RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE IS

3514: RETURN aSqlItem;
3515: END PL_TO_SQL14;
3516:
3517: FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)
3518: RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE IS
3519: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
3520: BEGIN
3521: BEGIN
3522: FOR I IN 1..aSqlItem.COUNT LOOP

Line 3519: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

3515: END PL_TO_SQL14;
3516:
3517: FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)
3518: RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE IS
3519: aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
3520: BEGIN
3521: BEGIN
3522: FOR I IN 1..aSqlItem.COUNT LOOP
3523: aPlsqlItem(I) := SQL_TO_PL37(aSqlItem(I));

Line 4810: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

4806: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
4807: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
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,

Line 4811: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

4807: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
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,

Line 4846: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,

4842: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
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 ,

Line 4887: P_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

4883: P_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_TBL_TYPE;
4884: P_OLD_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_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;

Line 4888: P_OLD_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

4884: P_OLD_LINE_TBL_ APPS.OE_ORDER_PUB.LINE_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;

Line 4923: X_LINE_ADJ_TBL_ APPS.OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;

4919: X_HEADER_PAYMENT_TBL_ APPS.OE_ORDER_PUB.HEADER_PAYMENT_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;

Line 5276: P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

5272: P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
5273: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
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,

Line 5277: P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,

5273: P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
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,

Line 5312: X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,

5308: X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
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 ,