DBA Data[Home] [Help]

APPS.DPP_BPEL_UPDATECLAIM dependencies on DPP_CLAIMS_PVT_DPP_TXN_LINE_5

Line 160: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_5 IS

156: aPlsqlItem.REASON_FOR_FAILURE := aSqlItem.REASON_FOR_FAILURE;
157: RETURN aPlsqlItem;
158: END SQL_TO_PL8;
159: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE)
160: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_5 IS
161: aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5;
162: BEGIN
163: -- initialize the table
164: aSqlItem := DPP_CLAIMS_PVT_DPP_TXN_LINE_5();

Line 161: aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5;

157: RETURN aPlsqlItem;
158: END SQL_TO_PL8;
159: FUNCTION PL_TO_SQL7(aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE)
160: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_5 IS
161: aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5;
162: BEGIN
163: -- initialize the table
164: aSqlItem := DPP_CLAIMS_PVT_DPP_TXN_LINE_5();
165: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 164: aSqlItem := DPP_CLAIMS_PVT_DPP_TXN_LINE_5();

160: RETURN DPP_CLAIMS_PVT_DPP_TXN_LINE_5 IS
161: aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5;
162: BEGIN
163: -- initialize the table
164: aSqlItem := DPP_CLAIMS_PVT_DPP_TXN_LINE_5();
165: aSqlItem.EXTEND(aPlsqlItem.COUNT);
166: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
167: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL8(aPlsqlItem(I));
168: END LOOP;

Line 171: FUNCTION SQL_TO_PL7(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5)

167: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL8(aPlsqlItem(I));
168: END LOOP;
169: RETURN aSqlItem;
170: END PL_TO_SQL7;
171: FUNCTION SQL_TO_PL7(aSqlItem DPP_CLAIMS_PVT_DPP_TXN_LINE_5)
172: RETURN DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE IS
173: aPlsqlItem DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE;
174: BEGIN
175: FOR I IN 1..aSqlItem.COUNT LOOP

Line 183: P_TXN_LINE_TBL IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_LINE_5) IS

179: END SQL_TO_PL7;
180:
181: PROCEDURE DPP_CLAIMS_PVT$UPDATE_CLAIMS (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,
182: X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,P_TXN_HDR_REC IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_HDR_R4,
183: P_TXN_LINE_TBL IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_LINE_5) IS
184: P_TXN_HDR_REC_ APPS.DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE;
185: P_TXN_LINE_TBL_ APPS.DPP_CLAIMS_PVT.DPP_TXN_LINE_TBL_TYPE;
186: BEGIN
187: P_TXN_HDR_REC_ := DPP_BPEL_UPDATECLAIM.SQL_TO_PL6(P_TXN_HDR_REC);