APPS.CSM_EMAIL_QUERY_PKG dependencies on CSM_EMAIL_QUERY_PKG

Line 1: PACKAGE BODY CSM_EMAIL_QUERY_PKG AS

1: PACKAGE BODY CSM_EMAIL_QUERY_PKG AS
2: /* $Header: csmeqpb.pls 120.6 2011/02/15 05:16:37 trajasek noship $ */
3:
4:
5: /*

Line 18: g_object_name CONSTANT VARCHAR2(30) := 'CSM_EMAIL_QUERY_PKG'; -- package name

14: --
15: -- --------- ------------------- ------------------------------------------
16:
17: /*** Globals ***/
18: g_object_name CONSTANT VARCHAR2(30) := 'CSM_EMAIL_QUERY_PKG'; -- package name
19: -- g_omfs_resp_id CONSTANT NUMBER := 23675; -- Oracle Mobile Field Service
20: -- g_omfs_appl_id CONSTANT NUMBER := 883; -- Field Service/Palm
21: g_user_id NUMBER;
22: g_user_name VARCHAR2(240);

Line 826: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_start_date), '''|| g_date_format_mask ||''') scheduled_start_date,

822: res.source_name assignee,
823: ct.task_number task_number,
824: ctl.task_name as subject,
825: jtstl.name task_status,
826: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_start_date), '''|| g_date_format_mask ||''') scheduled_start_date,
827: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_end_date), '''|| g_date_format_mask ||''') scheduled_end_date
828: FROM jtf_rs_resource_extns res,
829: jtf_task_assignments a,
830: jtf_tasks_b ct,

Line 827: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_end_date), '''|| g_date_format_mask ||''') scheduled_end_date

823: ct.task_number task_number,
824: ctl.task_name as subject,
825: jtstl.name task_status,
826: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_start_date), '''|| g_date_format_mask ||''') scheduled_start_date,
827: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_end_date), '''|| g_date_format_mask ||''') scheduled_end_date
828: FROM jtf_rs_resource_extns res,
829: jtf_task_assignments a,
830: jtf_tasks_b ct,
831: jtf_tasks_tl ctl,

Line 869: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_start_date), '''|| g_date_format_mask ||''') scheduled_start_date,

865: gtl.GROUP_NAME assignee,
866: ct.task_number task_number,
867: ctl.task_name as subject,
868: jtstl.name task_status,
869: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_start_date), '''|| g_date_format_mask ||''') scheduled_start_date,
870: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_end_date), '''|| g_date_format_mask ||''') scheduled_end_date
871: FROM jtf_task_assignments a,
872: jtf_tasks_b ct,
873: jtf_tasks_tl ctl,

Line 870: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_end_date), '''|| g_date_format_mask ||''') scheduled_end_date

866: ct.task_number task_number,
867: ctl.task_name as subject,
868: jtstl.name task_status,
869: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_start_date), '''|| g_date_format_mask ||''') scheduled_start_date,
870: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_end_date), '''|| g_date_format_mask ||''') scheduled_end_date
871: FROM jtf_task_assignments a,
872: jtf_tasks_b ct,
873: jtf_tasks_tl ctl,
874: cs_incidents_all_b cia,

Line 2838: END CSM_EMAIL_QUERY_PKG;

2834:
2835: END GET_PART_RETURN_INFO;
2836:
2837:
2838: END CSM_EMAIL_QUERY_PKG;
2839: