APPS.DPP_BPEL_UPDATEEXECDTLS SQL Statements

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

Line: 17

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;

Line: 18

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;

Line: 22

	RETURN DPP_EXECUTIONDETAILS_PVT.DPP_EXE_UPDATE_REC_TYPE IS
	aPlsqlItem DPP_EXECUTIONDETAILS_PVT.DPP_EXE_UPDATE_REC_TYPE;

Line: 33

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;

Line: 34

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;

Line: 37

	FUNCTION PL_TO_SQL6(aPlsqlItem DPP_EXECUTIONDETAILS_PVT.DPP_STATUS_UPDATE_REC_TYPE)
 	RETURN DPP_EXECUTIONDETAILS_PVT_DPP5 IS
	aSqlItem DPP_EXECUTIONDETAILS_PVT_DPP5;

Line: 44

		aSqlItem.UPDATE_STATUS := aPlsqlItem.UPDATE_STATUS;

Line: 48

	RETURN DPP_EXECUTIONDETAILS_PVT.DPP_STATUS_UPDATE_REC_TYPE IS
	aPlsqlItem DPP_EXECUTIONDETAILS_PVT.DPP_STATUS_UPDATE_REC_TYPE;

Line: 52

		aPlsqlItem.UPDATE_STATUS := aSqlItem.UPDATE_STATUS;

Line: 55

	FUNCTION PL_TO_SQL5(aPlsqlItem DPP_EXECUTIONDETAILS_PVT.DPP_STATUS_UPDATE_TBL_TYPE)
 	RETURN DPP_EXECUTIONDETAILS_PVT_DPP4 IS
	aSqlItem DPP_EXECUTIONDETAILS_PVT_DPP4;

Line: 68

	RETURN DPP_EXECUTIONDETAILS_PVT.DPP_STATUS_UPDATE_TBL_TYPE IS
	aPlsqlItem DPP_EXECUTIONDETAILS_PVT.DPP_STATUS_UPDATE_TBL_TYPE;

Line: 79

   P_EXE_UPDATE_REC IN OUT NOCOPY DPP_EXECUTIONDETAILS_PVT_DPP_,P_STATUS_UPDATE_TBL IN OUT NOCOPY DPP_EXECUTIONDETAILS_PVT_DPP4) IS
      P_EXE_UPDATE_REC_ DPP_EXECUTIONDETAILS_PVT.DPP_EXE_UPDATE_REC_TYPE;

Line: 81

      P_STATUS_UPDATE_TBL_ DPP_EXECUTIONDETAILS_PVT.DPP_STATUS_UPDATE_TBL_TYPE;

Line: 83

      P_EXE_UPDATE_REC_ := DPP_BPEL_UPDATEEXECDTLS.SQL_TO_PL4(P_EXE_UPDATE_REC);

Line: 84

      P_STATUS_UPDATE_TBL_ := DPP_BPEL_UPDATEEXECDTLS.SQL_TO_PL5(P_STATUS_UPDATE_TBL);

Line: 85

      DPP_EXECUTIONDETAILS_PVT.UPDATE_EXECUTIONDETAILS(P_API_VERSION,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA,P_EXE_UPDATE_REC_,P_STATUS_UPDATE_TBL_);

Line: 86

      P_EXE_UPDATE_REC := DPP_BPEL_UPDATEEXECDTLS.PL_TO_SQL4(P_EXE_UPDATE_REC_);

Line: 87

      P_STATUS_UPDATE_TBL := DPP_BPEL_UPDATEEXECDTLS.PL_TO_SQL5(P_STATUS_UPDATE_TBL_);