PACKAGE: APPS.BIV_DASH_BIN_PKG

Source

1 PACKAGE BIV_DASH_BIN_PKG AUTHID CURRENT_USER AS
2 	-- $Header: bivdsbns.pls 115.7 2002/11/18 17:23:27 smisra noship $
3 	-- This package is used to render the picasso BIN in setup form home page
4 	-- all procedure are called by seeded AK_REGION via JTF
5 	PROCEDURE load_sr_bin(p_param_str IN VARCHAR2 DEFAULT NULL);
6 
7     -- Monitor Report
8 	PROCEDURE load_sr_sum_report(p_param_str IN VARCHAR2 DEFAULT NULL);
9     function  get_esc_sr_backlog(p_owner number, p_status number) return number;
10 
11     -- Service Request Severity Report
12     PROCEDURE load_sr_sev_report(p_param_str IN VARCHAR2 DEFAULT NULL);
13     FUNCTION get_sr_sev_report_name(p_param_str IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
14     FUNCTION get_sr_sev_column_label(p_param_str IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
15 
16     -- Date util for SR SEv report
17     function get_hours (p_day Date) return VARCHAR2;
18     function check_esc (p_sr_id number) return varchar2;
19 
20 end;