DBA Data[Home] [Help]

APPS.DPP_BPEL_SELCOVINV dependencies on DPP_COVEREDINVENTORY_PVT_DPP1

Line 144: RETURN DPP_COVEREDINVENTORY_PVT_DPP1 IS

140: aPlsqlItem.WH_LINE_TBL := SQL_TO_PL5(aSqlItem.WH_LINE_TBL);
141: RETURN aPlsqlItem;
142: END SQL_TO_PL6;
143: FUNCTION PL_TO_SQL0(aPlsqlItem DPP_COVEREDINVENTORY_PVT.DPP_INV_COV_TBL_TYPE)
144: RETURN DPP_COVEREDINVENTORY_PVT_DPP1 IS
145: aSqlItem DPP_COVEREDINVENTORY_PVT_DPP1;
146: BEGIN
147: -- initialize the table
148: aSqlItem := DPP_COVEREDINVENTORY_PVT_DPP1();

Line 145: aSqlItem DPP_COVEREDINVENTORY_PVT_DPP1;

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

Line 148: aSqlItem := DPP_COVEREDINVENTORY_PVT_DPP1();

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

Line 155: FUNCTION SQL_TO_PL1(aSqlItem DPP_COVEREDINVENTORY_PVT_DPP1)

151: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL6(aPlsqlItem(I));
152: END LOOP;
153: RETURN aSqlItem;
154: END PL_TO_SQL0;
155: FUNCTION SQL_TO_PL1(aSqlItem DPP_COVEREDINVENTORY_PVT_DPP1)
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_DPP_,P_COVERED_INV_TBL IN OUT NOCOPY DPP_COVEREDINVENTORY_PVT_DPP1) IS

163: END SQL_TO_PL1;
164:
165: PROCEDURE DPP_COVEREDINVENTORY_PVT$SELE (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
166: 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_DPP_,P_COVERED_INV_TBL IN OUT NOCOPY DPP_COVEREDINVENTORY_PVT_DPP1) 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_SELCOVINV.SQL_TO_PL0(P_INV_HDR_REC);