APPS.JTF_EC_WORKFLOW_PKG SQL Statements

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

Line: 20

SELECT where_clause,
'SELECT '||select_name||' FROM '||from_table||' WHERE '||select_id|| ' = :RES'
FROM 	jtf_objects_vl
WHERE	object_code = p_resource_type;

Line: 109

SELECT	per.full_name name
FROM 	per_people_f	per,
	fnd_user	f
WHERE 	f.employee_id = per.person_id
AND   	f.user_id = p_user_id
union
SELECT 	user_name	name
FROM	fnd_user
WHERE 	employee_id is null
AND   	user_id = p_user_id;

Line: 180

SELECT	owner_id,
	owner_type_code
FROM 	jtf_tasks_vl
WHERE 	task_number = p_doc_number;

Line: 190

l_sr_sql_statement	VARCHAR2(200)	:= 'SELECT incident_owner_id, resource_type FROM cs_incidents_all_vl WHERE 	incident_number = :p_doc_number';

Line: 193

SELECT	incident_owner_id,
	resource_type
FROM 	cs_incidents_all_vl
WHERE 	incident_number = p_doc_number; */

Line: 204

l_df_sql_statement	VARCHAR2(200)	:= 'SELECT phase_owner_id, phase_owner_resource_type FROM css_def_defects_b WHERE defect_number = :p_doc_number';

Line: 206

/*  l_df_sql_statement	VARCHAR2(200)	:= 'SELECT phase_owner_id, dev_owner_id FROM css_def_defects_all WHERE defect_number = :p_doc_number';  */

Line: 210

SELECT	phase_owner_id,
	dev_owner_id
FROM 	css_def_defects_all
WHERE 	defect_number = p_doc_number; */

Line: 661

l_select_statement	varchar2(500) 	:= NULL;

Line: 671

SELECT 	jo.name object_type,
	jo.object_code,
	tr.object_name object_number
FROM   	jtf_objects_vl jo,
	jtf_task_references_vl tr
WHERE  	tr.task_id = p_task_id
AND	tr.object_type_code = jo.object_code
AND	tr.reference_code = 'ESC';

Line: 756

SELECT 	contact_id
FROM 	jtf_task_contacts
WHERE	task_id = p_task_id
AND	contact_type_code = 'EMP'
AND	nvl(escalation_notify_flag, 'N') = 'Y';

Line: 766

SELECT full_name
FROM   per_all_people_F
WHERE  person_id = p_emp_id;

Line: 777

SELECT 	ct.contact_id,
       	p.subject_party_name contact_name
FROM   	jtf_task_contacts	ct,
       	jtf_party_all_contacts_v p
WHERE  	ct.task_id = p_task_id
AND    	NVL(ct.escalation_notify_flag, 'N') = 'Y'
AND	ct.contact_type_code ='CUST'
AND    	ct.contact_id IN (p.subject_party_id, p.party_id);

Line: 791

SELECT 	manager_person_id
FROM 	jtf_rs_emp_dtls_vl
WHERE	resource_id = p_resource_id;

Line: 1060

SELECT  jtf_task_workflow_process_s.nextval
FROM	dual;

Line: 1068

SELECT 	t.task_name,
	t.task_number,
	t.description,
	t.owner_type_code 	owner_code,
	t.owner_id,
	t.escalation_level,
	t.task_status_id,
	t.planned_end_date 	target_date,
	t.creation_date		date_opened,
	t.last_update_date	date_changed,
	t.last_updated_by		update_id,
	t.created_by		create_id
FROM 	jtf_tasks_vl		t,
	jtf_task_types_vl	tt
WHERE 	t.task_id = p_task_id
AND	t.task_type_id = tt.task_type_id
AND	tt.task_type_id = 22;

Line: 1090

SELECT 	p.party_name	customer_name
FROM   	jtf_tasks_vl	t,
	hz_parties	p
WHERE	t.task_id = p_task_id
AND	t.customer_id = p.party_id;

Line: 1101

SELECT  name
FROM	jtf_ec_statuses_vl
WHERE 	task_status_id = p_status_id;

Line: 1110

SELECT	meaning
FROM	fnd_lookups
WHERE 	lookup_code = p_level
AND	lookup_type = 'JTF_TASK_ESC_LEVEL'
AND	enabled_flag = 'Y'
AND	start_date_active < sysdate
AND	nvl(end_date_active, sysdate) >= sysdate;

Line: 1123

SELECT	meaning
FROM	fnd_lookups
WHERE 	lookup_code = p_level
AND	lookup_type = 'JTF_TASK_ESC_LEVEL';

Line: 1133

SELECT 	object_name
FROM   	jtf_task_references_vl
WHERE  	task_id = p_task_id
AND	reference_code = 'ESC';

Line: 1231

JTF_EC_WORKFLOW_PKG.NotifList.Delete; -- := JTF_EC_WORKFLOW_PKG.G_Miss_NotifList;

Line: 1334

      get_user_name(task_details_rec.update_id,
		l_user_name,
		l_temp_status);

Line: 1688

	 update jtf_tasks_b
         set workflow_process_id = l_itemkey
         where task_id = p_task_id;

Line: 2029

    SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;

Line: 2039

    l_list.DELETE;

Line: 2044

PROCEDURE Raise_Esc_Update_Event(
	 task_id                 IN NUMBER,
     doc_created             IN VARCHAR2,
     owner_changed           IN VARCHAR2,
     owner_type_changed      IN VARCHAR2,
     level_changed           IN VARCHAR2,
     status_changed          IN VARCHAR2,
     target_date_changed     IN VARCHAR2,
     old_owner_id            IN NUMBER,
     old_owner_type_code     IN VARCHAR2,
     old_level               IN VARCHAR2,
     old_status_id           IN NUMBER,
     old_target_date         IN DATE )
IS
	l_esc_rec                JTF_EC_WORKFLOW_PKG.esc_rec_type ;

Line: 2073

	 JTF_EC_WORKFLOW_PKG.Raise_Esc_Update_Event(p_esc_rec => l_esc_rec);

Line: 2074

END Raise_Esc_Update_Event;

Line: 2076

PROCEDURE Raise_Esc_Update_Event(P_ESC_REC IN   JTF_EC_WORKFLOW_PKG.esc_rec_type)
IS
   l_list                   WF_PARAMETER_LIST_T;

Line: 2080

   l_event_name             varchar2(240) := 'oracle.apps.jtf.cac.esc.updateEscalation';

Line: 2086

    SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;

Line: 2107

    l_list.DELETE;

Line: 2110

  END Raise_Esc_Update_Event;

Line: 2163

FUNCTION update_esc_notif_subs(p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t)
RETURN VARCHAR2 IS
    l_wf_process_id           NUMBER;

Line: 2209

      wf_core.CONTEXT('jtf_ec_workflow_pkg', 'update_esc_notif_subs', p_event.event_name, p_subscription_guid);

Line: 2217

      wf_core.CONTEXT('jtf_ec_workflow_pkg', 'update_esc_notif_subs', p_event.event_name, p_subscription_guid);

Line: 2220

  END update_esc_notif_subs;