APPS.EAM_DIRECT_ITEMS_DEFAULT_PVT SQL Statements

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

Line: 38

                SELECT wip_eam_di_seq_id_s.nextval
                INTO   l_di_seq_id
                FROM   sys.dual;

Line: 182

                    select department_id into x_eam_direct_items_rec.department_id
                      from wip_operations
                      where wip_entity_id = p_eam_direct_items_rec.wip_entity_id
                      and organization_id = p_eam_direct_items_rec.organization_id
                      and operation_seq_num = p_eam_direct_items_rec.operation_seq_num;

Line: 233

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

Line: 418

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

Line: 447

		SELECT
		      WIP_ENTITY_ID                 WIP_ENTITY_ID
			, ORGANIZATION_ID               ORGANIZATION_ID
			, OPERATION_SEQ_NUM             OPERATION_SEQ_NUM
			, DIRECT_ITEM_SEQUENCE_ID             DIRECT_ITEM_SEQUENCE_ID
			, 2                                   TRANSACTION_TYPE
	     FROM wip_eam_direct_items
		 WHERE organization_id = p_organization_id
		 and wip_entity_id = p_wip_entity_id
		 and operation_seq_num = 1;