DBA Data[Home] [Help]

APPS.DPP_BPEL_CREATECLAIMS dependencies on DPP_CLAIMS_PVT_DPP_TXN_LINE_2

Line 156: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_2 IS

152: aPlsqlItem.REASON_FOR_FAILURE := aSqlItem.REASON_FOR_FAILURE;
153: RETURN aPlsqlItem;
154: END SQL_TO_PL5;
155: FUNCTION PL_TO_SQL5(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE)
156: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_2 IS
157: aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_2;
158: BEGIN
159: -- initialize the table
160: aSqlItem := DPP_CLAIMS_PVT_DPP_TXN_LINE_2();

Line 157: aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_2;

153: RETURN aPlsqlItem;
154: END SQL_TO_PL5;
155: FUNCTION PL_TO_SQL5(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE)
156: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_2 IS
157: aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_2;
158: BEGIN
159: -- initialize the table
160: aSqlItem := DPP_CLAIMS_PVT_DPP_TXN_LINE_2();
161: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 160: aSqlItem := DPP_CLAIMS_PVT_DPP_TXN_LINE_2();

156: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_2 IS
157: aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_2;
158: BEGIN
159: -- initialize the table
160: aSqlItem := DPP_CLAIMS_PVT_DPP_TXN_LINE_2();
161: aSqlItem.EXTEND(aPlsqlItem.COUNT);
162: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
163: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL4(aPlsqlItem(I));
164: END LOOP;

Line 167: FUNCTION SQL_TO_PL4(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_2)

163: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL4(aPlsqlItem(I));
164: END LOOP;
165: RETURN aSqlItem;
166: END PL_TO_SQL5;
167: FUNCTION SQL_TO_PL4(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_2)
168: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE IS
169: aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE;
170: BEGIN
171: FOR I IN 1..aSqlItem.COUNT LOOP

Line 179: P_TXN_HDR_REC DPP_CLAIMS_PVT_DPP_TXN_HDR_R1,P_TXN_LINE_TBL DPP_CLAIMS_PVT_DPP_TXN_LINE_2) IS

175: END SQL_TO_PL4;
176:
177: PROCEDURE DPP_CLAIMS_PVT$CREATE_CLAIMS (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,
178: P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
179: P_TXN_HDR_REC DPP_CLAIMS_PVT_DPP_TXN_HDR_R1,P_TXN_LINE_TBL DPP_CLAIMS_PVT_DPP_TXN_LINE_2) IS
180: P_TXN_HDR_REC_ APPS.DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE;
181: P_TXN_LINE_TBL_ APPS.DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE;
182: BEGIN
183: P_TXN_HDR_REC_ := DPP_BPEL_CREATECLAIMS.SQL_TO_PL3(P_TXN_HDR_REC);