APPS.AHL_EAM_JOB_PVT SQL Statements

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

Line: 26

			SELECT value
			INTO   l_full_path
			FROM   v$parameter
			WHERE  name = 'utl_file_dir';

Line: 36

					    SELECT trim(substr(l_full_path, 1, decode(instr(l_full_path,',')-1,
											  -1, length(l_full_path),
											  instr(l_full_path, ',')-1
											 )
								  )
							   )
					    INTO  l_file_dir
					    FROM  dual;

Line: 132

   SELECT unit_effectivity_id
   FROM ahl_visit_tasks_b vst
   WHERE visit_task_id = p_task_id;

Line: 140

 SELECT
    cs_incident_id, nvl(manually_planned_flag,'N')
 FROM
    AHL_UNIT_EFFECTIVITIES_B UE
 WHERE
    UE.unit_effectivity_id = p_ue_id
    AND NOT EXISTS (SELECT 'x'
                    FROM AHL_UE_RELATIONSHIPS UER
                    WHERE UER.related_ue_id = UE.unit_effectivity_id
                   );

Line: 154

 SELECT
    cs_incident_id, nvl(manually_planned_flag,'N')
 FROM
    AHL_UNIT_EFFECTIVITIES_B UE
 WHERE
    UE.unit_effectivity_id IN (SELECT originator_ue_id
                               FROM AHL_UE_RELATIONSHIPS UER
                               WHERE UER.related_ue_id = p_ue_id
                               );

Line: 287

SELECT SCHEDULED_START_DATE,
       SCHEDULED_COMPLETION_DATE, DATE_RELEASED
  FROM WIP_DISCRETE_JOBS
WHERE WIP_ENTITY_ID = c_wip_entity_id;

Line: 427

    x_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

Line: 464

		-- the EAM code updates the p_release_date parameter
		-- for the above statuses in the call to WIP_CHANGE_STATUS.Release
		--
                /*IF p_workorder_rec.status_code IN ('3', '6') THEN
		  x_eam_wo_rec.date_released := least(Get_Job_Dates_Rec.date_released, p_workorder_rec.scheduled_start_date, sysdate);

Line: 521

    x_eam_wo_relations_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

Line: 593

    x_eam_op_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

Line: 655

    x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

Line: 657

    x_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

Line: 727

    x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

Line: 729

    x_eam_res_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

Line: 777

    x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

Line: 779

    x_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

Line: 1063

PROCEDURE update_job_operations
(
  p_api_version            IN   NUMBER     := 1.0,
  p_init_msg_list          IN   VARCHAR2   := FND_API.G_TRUE,
  p_commit                 IN   VARCHAR2   := FND_API.G_FALSE,
  p_validation_level       IN   NUMBER     := FND_API.G_VALID_LEVEL_FULL,
  p_default                IN   VARCHAR2   := FND_API.G_FALSE,
  p_module_type            IN   VARCHAR2   := NULL,
  x_return_status          OUT  NOCOPY  VARCHAR2,
  x_msg_count              OUT  NOCOPY  NUMBER,
  x_msg_data               OUT  NOCOPY  VARCHAR2,
  p_workorder_rec          IN   AHL_PRD_WORKORDER_PVT.prd_workorder_rec,
  p_operation_tbl          IN   AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
  p_material_req_tbl       IN   AHL_PP_MATERIALS_PVT.req_material_tbl_type,
  p_resource_req_tbl       IN   AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type
)
IS

l_api_name                 VARCHAR2(30) := 'update_job_operations';

Line: 1122

  SAVEPOINT update_job_operations_PVT;

Line: 1269

    ROLLBACK TO update_job_operations_PVT;

Line: 1283

    ROLLBACK TO update_job_operations_PVT;

Line: 1297

    ROLLBACK TO update_job_operations_PVT;

Line: 1319

END update_job_operations;

Line: 1535

SELECT organization_id,scheduled_start_date,scheduled_completion_date,requested_start_date
FROM wip_discrete_jobs
WHERE wip_entity_id = p_wip_entity_id;

Line: 1629

		l_eam_wo_rec.transaction_type     := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;