APPS.EAM_RES_INST_DEFAULT_PVT SQL Statements

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

Line: 56

                   select start_date into x_eam_res_inst_rec.start_date
                     from wip_operation_resources where
                     wip_entity_id = p_eam_res_inst_rec.wip_entity_id
                     and organization_id = p_eam_res_inst_rec.organization_id
                     and operation_seq_num = p_eam_res_inst_rec.operation_seq_num
                     and resource_seq_num = p_eam_res_inst_rec.resource_seq_num;

Line: 72

                   select completion_date into x_eam_res_inst_rec.completion_date
                     from wip_operation_resources where
                     wip_entity_id = p_eam_res_inst_rec.wip_entity_id
                     and organization_id = p_eam_res_inst_rec.organization_id
                     and operation_seq_num = p_eam_res_inst_rec.operation_seq_num
                     and resource_seq_num = p_eam_res_inst_rec.resource_seq_num;

Line: 113

IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing null columns prior update'); END IF;

Line: 141

IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Done processing null columns prior update'); END IF;