DBA Data[Home] [Help]

APPS.DPP_BPEL_UPDATECOST SQL Statements

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

Line: 16

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 46

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 135

		aSqlItem.UPDATE_STATUS := aPlsqlItem.UPDATE_STATUS;
Line: 167

		aPlsqlItem.UPDATE_STATUS := aSqlItem.UPDATE_STATUS;
Line: 194

   PROCEDURE DPP_ITEMCOST_PVT$UPDATE_ITEMC (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_ITEMCOST_PVT_DPP_CST_HDR_,
   P_ITEM_COST_TBL DPP_ITEMCOST_PVT_DPP_TXN_LINE) IS
      P_TXN_HDR_REC_ DPP_ITEMCOST_PVT.DPP_CST_HDR_REC_TYPE;
Line: 200

      P_TXN_HDR_REC_ := DPP_BPEL_UPDATECOST.SQL_TO_PL9(P_TXN_HDR_REC);
Line: 201

      P_ITEM_COST_TBL_ := DPP_BPEL_UPDATECOST.SQL_TO_PL10(P_ITEM_COST_TBL);
Line: 202

      DPP_ITEMCOST_PVT.UPDATE_ITEMCOST(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: 203

   END DPP_ITEMCOST_PVT$UPDATE_ITEMC;