APPS.DPP_BPEL_UPDATELISTPRICE SQL Statements

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

Line: 17

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;

Line: 47

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;

Line: 95

		aSqlItem.UPDATE_STATUS := aPlsqlItem.UPDATE_STATUS;

Line: 125

		aPlsqlItem.UPDATE_STATUS := aSqlItem.UPDATE_STATUS;

Line: 151

   PROCEDURE DPP_LISTPRICE_PVT$UPDATE_LIST (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 DPP_LISTPRICE_PVT_DPP_TXN_H12,P_ITEM_COST_TBL DPP_LISTPRICE_PVT_DPP_TXN_L13) IS
      P_TXN_HDR_REC_ DPP_LISTPRICE_PVT.DPP_TXN_HDR_REC_TYPE;

Line: 157

      P_TXN_HDR_REC_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL22(P_TXN_HDR_REC);

Line: 158

      P_ITEM_COST_TBL_ := DPP_BPEL_UPDATELISTPRICE.SQL_TO_PL23(P_ITEM_COST_TBL);

Line: 159

      DPP_LISTPRICE_PVT.UPDATE_LISTPRICE(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_ITEM_COST_TBL_);

Line: 160

   END DPP_LISTPRICE_PVT$UPDATE_LIST;