APPS.CSY_KPI_PKG dependencies on CSY_KPI_PKG

Line 1: package body csy_kpi_pkg as

1: package body csy_kpi_pkg as
2: /* $Header: csykpib.pls 115.16 2004/07/30 21:14:09 smisra noship $ */
3: function get_agents_time(p_resource_id number,
4: p_start_date date,
5: p_end_date date) return number is

Line 467: csy_kpi_pkg.get_agents_time(

463: trunc(aud.incident_resolved_date) incident_resolved_date,
464: sum(decode(aud.incident_owner_id, to_dttm.old_incident_owner_id,
465: -- decode(to_stat.status_class_code,'WAIT_ON_SUPPORT',
466: -- above decode is removed on 17-dec-03. resl time as per SRD
467: csy_kpi_pkg.get_agents_time(
468: aud.incident_owner_id,
469: decode(from_dttm.old_incident_date,null,from_dttm.incident_date,from_dttm.creation_date),
470: decode(aud.incident_audit_id,to_dttm.incident_audit_id,
471: aud.incident_resolved_date,to_dttm.creation_date)

Line 575: csy_kpi_pkg.get_agents_time(

571: trunc(aud.incident_resolved_date) incident_resolved_date,
572: sum(decode(aud.incident_owner_id, to_dttm.old_incident_owner_id,
573: -- decode(to_stat.status_class_code,'WAIT_ON_SUPPORT',
574: -- 17-dec-03 above decode removed to make it as per SRD
575: csy_kpi_pkg.get_agents_time(
576: aud.incident_owner_id,
577: decode(from_dttm.old_incident_date,null,from_dttm.incident_date,from_dttm.creation_date),
578: decode(aud.incident_audit_id,to_dttm.incident_audit_id,
579: aud.incident_resolved_date,to_dttm.creation_date)

Line 1669: csy_kpi_pkg.get_agents_time(to_dttm.old_incident_owner_id,

1665: nvl (aud.incident_severity_id,-1) incident_severity_id,
1666: nvl (aud.group_id,-1) owner_group_id,
1667: trunc(nvl(aud.inc_responded_by_date,aud.incident_resolved_date)) inc_responded_by_date,
1668: sum(decode(aud.incident_owner_id,to_dttm.old_incident_owner_id,
1669: csy_kpi_pkg.get_agents_time(to_dttm.old_incident_owner_id,
1670: decode(from_dttm.old_incident_date,null,from_dttm.incident_date,from_dttm.creation_date),
1671: decode(aud.incident_audit_id,to_dttm.incident_audit_id,
1672: nvl(aud.inc_responded_by_date,aud.incident_resolved_date),to_dttm.creation_date)),0)
1673: ) * 1440 resp_time,

Line 1749: csy_kpi_pkg.get_agents_time(to_dttm.old_incident_owner_id,

1745: nvl (aud.incident_severity_id,-1) incident_severity_id,
1746: nvl (aud.group_id,-1) owner_group_id,
1747: trunc(nvl(aud.inc_responded_by_date,aud.incident_resolved_date)) inc_responded_by_date,
1748: sum(decode(aud.incident_owner_id,to_dttm.old_incident_owner_id,
1749: csy_kpi_pkg.get_agents_time(to_dttm.old_incident_owner_id,
1750: decode(from_dttm.old_incident_date,null,from_dttm.incident_date,from_dttm.creation_date),
1751: decode(aud.incident_audit_id,to_dttm.incident_audit_id,
1752: nvl(aud.inc_responded_by_date,aud.incident_resolved_date),
1753: to_dttm.creation_date)),0)