DBA Data[Home] [Help]

APPS.DPP_BPEL_POPCOVINV dependencies on DPP_COVEREDINVENTORY_PVT_DPP8

Line 144: RETURN DPP_COVEREDINVENTORY_PVT_DPP8 IS

140: aPlsqlItem.WH_LINE_TBL := SQL_TO_PL12(aSqlItem.WH_LINE_TBL);
141: RETURN aPlsqlItem;
142: END SQL_TO_PL13;
143: FUNCTION PL_TO_SQL13(aPlsqlItem DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_TBL_TYPE)
144: RETURN DPP_COVEREDINVENTORY_PVT_DPP8 IS
145: aSqlItem DPP_COVEREDINVENTORY_PVT_DPP8;
146: BEGIN
147: -- initialize the table
148: aSqlItem := DPP_COVEREDINVENTORY_PVT_DPP8();

Line 145: aSqlItem DPP_COVEREDINVENTORY_PVT_DPP8;

141: RETURN aPlsqlItem;
142: END SQL_TO_PL13;
143: FUNCTION PL_TO_SQL13(aPlsqlItem DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_TBL_TYPE)
144: RETURN DPP_COVEREDINVENTORY_PVT_DPP8 IS
145: aSqlItem DPP_COVEREDINVENTORY_PVT_DPP8;
146: BEGIN
147: -- initialize the table
148: aSqlItem := DPP_COVEREDINVENTORY_PVT_DPP8();
149: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 148: aSqlItem := DPP_COVEREDINVENTORY_PVT_DPP8();

144: RETURN DPP_COVEREDINVENTORY_PVT_DPP8 IS
145: aSqlItem DPP_COVEREDINVENTORY_PVT_DPP8;
146: BEGIN
147: -- initialize the table
148: aSqlItem := DPP_COVEREDINVENTORY_PVT_DPP8();
149: aSqlItem.EXTEND(aPlsqlItem.COUNT);
150: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
151: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL12(aPlsqlItem(I));
152: END LOOP;

Line 155: FUNCTION SQL_TO_PL8(aSqlItem DPP_COVEREDINVENTORY_PVT_DPP8)

151: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL12(aPlsqlItem(I));
152: END LOOP;
153: RETURN aSqlItem;
154: END PL_TO_SQL13;
155: FUNCTION SQL_TO_PL8(aSqlItem DPP_COVEREDINVENTORY_PVT_DPP8)
156: RETURN DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_TBL_TYPE IS
157: aPlsqlItem DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_TBL_TYPE;
158: BEGIN
159: FOR I IN 1..aSqlItem.COUNT LOOP

Line 167: P_INV_HDR_REC DPP_COVEREDINVENTORY_PVT_DPP7,P_COVERED_INV_TBL DPP_COVEREDINVENTORY_PVT_DPP8) IS

163: END SQL_TO_PL8;
164:
165: PROCEDURE DPP_COVEREDINVENTORY_PVT$POPU (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,
166: P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
167: P_INV_HDR_REC DPP_COVEREDINVENTORY_PVT_DPP7,P_COVERED_INV_TBL DPP_COVEREDINVENTORY_PVT_DPP8) IS
168: P_INV_HDR_REC_ APPS.DPP_COVEREDINVENTORY_PVT.DPP_INV_HDR_REC_TYPE;
169: P_COVERED_INV_TBL_ APPS.DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_TBL_TYPE;
170: BEGIN
171: P_INV_HDR_REC_ := DPP_BPEL_POPCOVINV.SQL_TO_PL7(P_INV_HDR_REC);