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 120.5 2011/12/27 08:25:33 shramana ship $ */
3:
4: function getaudit(p_inc_id in number,
5: p_from_date in date,

Line 505: csy_kpi_pkg.get_agents_time(

501: trunc(aud.incident_resolved_date) incident_resolved_date,
502: sum(decode(aud.incident_owner_id, to_dttm.old_incident_owner_id,
503: -- decode(to_stat.status_class_code,'WAIT_ON_SUPPORT',
504: -- above decode is removed on 17-dec-03. resl time as per SRD
505: csy_kpi_pkg.get_agents_time(
506: aud.incident_owner_id,
507: decode(from_dttm.old_incident_date,null,from_dttm.incident_date,from_dttm.creation_date),
508: decode(aud.incident_audit_id,to_dttm.incident_audit_id,
509: aud.incident_resolved_date,to_dttm.creation_date)

Line 613: csy_kpi_pkg.get_agents_time(

609: trunc(aud.incident_resolved_date) incident_resolved_date,
610: sum(decode(aud.incident_owner_id, to_dttm.old_incident_owner_id,
611: -- decode(to_stat.status_class_code,'WAIT_ON_SUPPORT',
612: -- 17-dec-03 above decode removed to make it as per SRD
613: csy_kpi_pkg.get_agents_time(
614: aud.incident_owner_id,
615: decode(from_dttm.old_incident_date,null,from_dttm.incident_date,from_dttm.creation_date),
616: decode(aud.incident_audit_id,to_dttm.incident_audit_id,
617: aud.incident_resolved_date,to_dttm.creation_date)

Line 1707: csy_kpi_pkg.get_agents_time(to_dttm.old_incident_owner_id,

1703: nvl (aud.incident_severity_id,-1) incident_severity_id,
1704: nvl (aud.group_id,-1) owner_group_id,
1705: trunc(nvl(aud.inc_responded_by_date,aud.incident_resolved_date)) inc_responded_by_date,
1706: sum(decode(aud.incident_owner_id,to_dttm.old_incident_owner_id,
1707: csy_kpi_pkg.get_agents_time(to_dttm.old_incident_owner_id,
1708: decode(from_dttm.old_incident_date,null,from_dttm.incident_date,from_dttm.creation_date),
1709: decode(aud.incident_audit_id,to_dttm.incident_audit_id,
1710: nvl(aud.inc_responded_by_date,aud.incident_resolved_date),to_dttm.creation_date)),0)
1711: ) * 1440 resp_time,

Line 1787: csy_kpi_pkg.get_agents_time(to_dttm.old_incident_owner_id,

1783: nvl (aud.incident_severity_id,-1) incident_severity_id,
1784: nvl (aud.group_id,-1) owner_group_id,
1785: trunc(nvl(aud.inc_responded_by_date,aud.incident_resolved_date)) inc_responded_by_date,
1786: sum(decode(aud.incident_owner_id,to_dttm.old_incident_owner_id,
1787: csy_kpi_pkg.get_agents_time(to_dttm.old_incident_owner_id,
1788: decode(from_dttm.old_incident_date,null,from_dttm.incident_date,from_dttm.creation_date),
1789: decode(aud.incident_audit_id,to_dttm.incident_audit_id,
1790: nvl(aud.inc_responded_by_date,aud.incident_resolved_date),
1791: to_dttm.creation_date)),0)