APPS.DPP_BPEL_UPDATECLAIM SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;

Line: 25

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;

Line: 61

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;

Line: 62

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;

Line: 100

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;

Line: 101

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;

Line: 118

		aSqlItem.UPDATE_STATUS := aPlsqlItem.UPDATE_STATUS;

Line: 137

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;

Line: 138

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;

Line: 155

		aPlsqlItem.UPDATE_STATUS := aSqlItem.UPDATE_STATUS;

Line: 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,
   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,
   P_TXN_LINE_TBL IN OUT NOCOPY DPP_CLAIMS_PVT_DPP_TXN_LINE_5) IS
      P_TXN_HDR_REC_ APPS.DPP_CLAIMS_PVT.DPP_TXN_HDR_REC_TYPE;

Line: 187

      P_TXN_HDR_REC_ := DPP_BPEL_UPDATECLAIM.SQL_TO_PL6(P_TXN_HDR_REC);

Line: 188

      P_TXN_LINE_TBL_ := DPP_BPEL_UPDATECLAIM.SQL_TO_PL7(P_TXN_LINE_TBL);

Line: 189

      APPS.DPP_CLAIMS_PVT.UPDATE_CLAIMS(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,
      X_MSG_COUNT,X_MSG_DATA,P_TXN_HDR_REC_,P_TXN_LINE_TBL_);

Line: 191

      P_TXN_HDR_REC := DPP_BPEL_UPDATECLAIM.PL_TO_SQL6(P_TXN_HDR_REC_);

Line: 192

      P_TXN_LINE_TBL := DPP_BPEL_UPDATECLAIM.PL_TO_SQL7(P_TXN_LINE_TBL_);

Line: 193

   END DPP_CLAIMS_PVT$UPDATE_CLAIMS;