APPS.CSD_TO_FORM_REPAIR_JOB_XREF SQL Statements

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

Line: 23

        p_action_code                  IN   NUMBER,    /* 0 = insert, 1 = update, 2 = delete */
        px_REPAIR_JOB_XREF_ID   IN OUT NOCOPY NUMBER,
        p_CREATED_BY    NUMBER,
        p_CREATION_DATE    DATE,
        p_LAST_UPDATED_BY    NUMBER,
        p_LAST_UPDATE_DATE    DATE,
        p_LAST_UPDATE_LOGIN    NUMBER,
        p_REPAIR_LINE_ID    NUMBER,
        p_WIP_ENTITY_ID    NUMBER,
        p_GROUP_ID    NUMBER,
        p_ORGANIZATION_ID    NUMBER,
        p_QUANTITY    NUMBER,
        p_INVENTORY_ITEM_ID    NUMBER,
        p_ITEM_REVISION    VARCHAR2,
        p_SOURCE_TYPE_CODE 		VARCHAR2,
        p_SOURCE_ID1  			NUMBER,
        p_RO_SERVICE_CODE_ID 		NUMBER,
        p_JOB_NAME      		VARCHAR2,
        p_OBJECT_VERSION_NUMBER    	NUMBER,
        p_ATTRIBUTE_CATEGORY    	VARCHAR2,
        p_ATTRIBUTE1    VARCHAR2,
        p_ATTRIBUTE2    VARCHAR2,
        p_ATTRIBUTE3    VARCHAR2,
        p_ATTRIBUTE4    VARCHAR2,
        p_ATTRIBUTE5    VARCHAR2,
        p_ATTRIBUTE6    VARCHAR2,
        p_ATTRIBUTE7    VARCHAR2,
        p_ATTRIBUTE8    VARCHAR2,
        p_ATTRIBUTE9    VARCHAR2,
        p_ATTRIBUTE10    VARCHAR2,
        p_ATTRIBUTE11    VARCHAR2,
        p_ATTRIBUTE12    VARCHAR2,
        p_ATTRIBUTE13    VARCHAR2,
        p_ATTRIBUTE14    VARCHAR2,
        p_ATTRIBUTE15    VARCHAR2,
       p_quantity_completed NUMBER,
        X_Return_Status              OUT NOCOPY  VARCHAR2,
        X_Msg_Count                  OUT NOCOPY  NUMBER,
        X_Msg_Data                   OUT NOCOPY  VARCHAR2
       )
  IS
      l_repair_job_xref_rec CSD_REPAIR_JOB_XREF_PVT.REPJOBXREF_Rec_Type;

Line: 78

l_repair_job_xref_rec.LAST_UPDATED_BY  :=           p_LAST_UPDATED_BY   ;

Line: 79

l_repair_job_xref_rec.LAST_UPDATE_DATE:=            p_LAST_UPDATE_DATE ;

Line: 80

l_repair_job_xref_rec.LAST_UPDATE_LOGIN:=           p_LAST_UPDATE_LOGIN    ;

Line: 117

          X_Msg_Data := 'Invalid action codes should indicate an Insert, Delete or Update action.';

Line: 151

        csd_gen_utility_pvt.add('CSD_TO_FORM_REPAIR_JOB_XREF.Validate_And_Write Update OVN '||to_char(l_repair_job_xref_rec.OBJECT_VERSION_NUMBER));

Line: 155

           CSD_REPAIR_JOB_XREF_PVT.update_repjobxref(
               P_Api_Version_Number    => p_api_version_number,
               P_Init_Msg_List         => p_init_msg_list,
               P_Commit                => p_commit,
               p_validation_level      => p_validation_level,
               P_repjobxref_rec               => l_repair_job_xref_rec,
               X_Return_Status         => l_return_status,
               X_Msg_Count             => l_msg_count,
               X_Msg_Data              => l_msg_data
               );

Line: 172

        csd_gen_utility_pvt.add('CSD_TO_FORM_REPAIR_JOB_XREF.Validate_And_Write Delete OVN '||to_char(l_repair_job_xref_rec.OBJECT_VERSION_NUMBER));

Line: 176

           CSD_REPAIR_JOB_XREF_PVT.delete_repjobxref(
               P_Api_Version_Number    => p_api_version_number,
               P_Init_Msg_List         => p_init_msg_list,
               P_Commit                => p_commit,
               p_validation_level      => p_validation_level,
               P_repjobxref_rec        => l_repair_job_xref_rec,
               X_Return_Status         => l_return_status,
               X_Msg_Count             => l_msg_count,
               X_Msg_Data              => l_msg_data
               );