eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIV_RT_SR_AGE_REPORT_PKG dependencies on BIV_CORE_PKG

Line 29: g_v_sp VARCHAR2(5) := biv_core_pkg.g_value_sep;

25: g_query VARCHAR2(5000);
26: g_select VARCHAR2(3000);
27: g_table VARCHAR2(1000);
28: g_where VARCHAR2(1000);
29: g_v_sp VARCHAR2(5) := biv_core_pkg.g_value_sep;
30: g_p_sp VARCHAR2(5) := biv_core_pkg.g_param_sep;
31: g_session_id NUMBER ;
32: g_debug_flag VARCHAR2(1) := nvl(fnd_profile.value('BIV:DEBUG'),'N');
33:

Line 30: g_p_sp VARCHAR2(5) := biv_core_pkg.g_param_sep;

26: g_select VARCHAR2(3000);
27: g_table VARCHAR2(1000);
28: g_where VARCHAR2(1000);
29: g_v_sp VARCHAR2(5) := biv_core_pkg.g_value_sep;
30: g_p_sp VARCHAR2(5) := biv_core_pkg.g_param_sep;
31: g_session_id NUMBER ;
32: g_debug_flag VARCHAR2(1) := nvl(fnd_profile.value('BIV:DEBUG'),'N');
33:
34: PROCEDURE load_sr_backlog_age_report(p_param_str IN VARCHAR2 /*DEFAULT NULL*/) IS

Line 40: biv_core_pkg.clean_dcf_table('BIV_TMP_HS2');

36: l_return_num PLS_INTEGER := 0;
37: l_total_label VARCHAR2(10);
38: x_where_clause varchar2(2000);
39: BEGIN
40: biv_core_pkg.clean_dcf_table('BIV_TMP_HS2');
41: g_session_id := biv_core_pkg.get_session_id;
42: -- set profile options
43: if g_debug_flag = 'Y' then
44: biv_core_pkg.biv_debug('Param Str:'||p_param_str,

Line 41: g_session_id := biv_core_pkg.get_session_id;

37: l_total_label VARCHAR2(10);
38: x_where_clause varchar2(2000);
39: BEGIN
40: biv_core_pkg.clean_dcf_table('BIV_TMP_HS2');
41: g_session_id := biv_core_pkg.get_session_id;
42: -- set profile options
43: if g_debug_flag = 'Y' then
44: biv_core_pkg.biv_debug('Param Str:'||p_param_str,
45: g_report_code);

Line 44: biv_core_pkg.biv_debug('Param Str:'||p_param_str,

40: biv_core_pkg.clean_dcf_table('BIV_TMP_HS2');
41: g_session_id := biv_core_pkg.get_session_id;
42: -- set profile options
43: if g_debug_flag = 'Y' then
44: biv_core_pkg.biv_debug('Param Str:'||p_param_str,
45: g_report_code);
46: end if;
47: g_sev_1 := fnd_profile.value('BIV:INC_SEVERITY_1');
48: g_sev_2 := fnd_profile.value('BIV:INC_SEVERITY_2');

Line 60: g_agrp := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');

56: if g_sev_4 is null then g_sev_4 := 0; end if;
57: if g_sev_5 is null then g_sev_5 := 0; end if;
58:
59: -- set params
60: g_agrp := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
61: g_ogrp := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
62: g_party_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CUST_ID');
63: g_cntr_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CNTR_ID');
64: g_prod_id := biv_core_pkg.get_parameter_value(p_param_str,'P_PRD_ID');

Line 61: g_ogrp := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');

57: if g_sev_5 is null then g_sev_5 := 0; end if;
58:
59: -- set params
60: g_agrp := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
61: g_ogrp := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
62: g_party_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CUST_ID');
63: g_cntr_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CNTR_ID');
64: g_prod_id := biv_core_pkg.get_parameter_value(p_param_str,'P_PRD_ID');
65: g_manager := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');

Line 62: g_party_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CUST_ID');

58:
59: -- set params
60: g_agrp := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
61: g_ogrp := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
62: g_party_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CUST_ID');
63: g_cntr_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CNTR_ID');
64: g_prod_id := biv_core_pkg.get_parameter_value(p_param_str,'P_PRD_ID');
65: g_manager := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
66: g_esc_level := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');

Line 63: g_cntr_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CNTR_ID');

59: -- set params
60: g_agrp := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
61: g_ogrp := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
62: g_party_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CUST_ID');
63: g_cntr_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CNTR_ID');
64: g_prod_id := biv_core_pkg.get_parameter_value(p_param_str,'P_PRD_ID');
65: g_manager := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
66: g_esc_level := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');
67:

Line 64: g_prod_id := biv_core_pkg.get_parameter_value(p_param_str,'P_PRD_ID');

60: g_agrp := biv_core_pkg.get_parameter_value(p_param_str,'P_AGRP');
61: g_ogrp := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
62: g_party_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CUST_ID');
63: g_cntr_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CNTR_ID');
64: g_prod_id := biv_core_pkg.get_parameter_value(p_param_str,'P_PRD_ID');
65: g_manager := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
66: g_esc_level := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');
67:
68: -- set report code

Line 65: g_manager := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');

61: g_ogrp := biv_core_pkg.get_parameter_value(p_param_str,'P_OGRP');
62: g_party_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CUST_ID');
63: g_cntr_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CNTR_ID');
64: g_prod_id := biv_core_pkg.get_parameter_value(p_param_str,'P_PRD_ID');
65: g_manager := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
66: g_esc_level := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');
67:
68: -- set report code
69: g_report_code := 'BIV_RT_SR_AGE_REPORT';

Line 66: g_esc_level := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');

62: g_party_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CUST_ID');
63: g_cntr_id := biv_core_pkg.get_parameter_value(p_param_str,'P_CNTR_ID');
64: g_prod_id := biv_core_pkg.get_parameter_value(p_param_str,'P_PRD_ID');
65: g_manager := biv_core_pkg.get_parameter_value(p_param_str,'P_MGR_ID');
66: g_esc_level := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');
67:
68: -- set report code
69: g_report_code := 'BIV_RT_SR_AGE_REPORT';
70: biv_core_pkg.g_report_id := 'BIV_RT_SR_AGE_REPORT';

Line 70: biv_core_pkg.g_report_id := 'BIV_RT_SR_AGE_REPORT';

66: g_esc_level := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');
67:
68: -- set report code
69: g_report_code := 'BIV_RT_SR_AGE_REPORT';
70: biv_core_pkg.g_report_id := 'BIV_RT_SR_AGE_REPORT';
71:
72: -- set extra URL
73: g_extra_param := get_extra_param;
74:

Line 76: biv_core_pkg.get_report_parameters(p_param_str);

72: -- set extra URL
73: g_extra_param := get_extra_param;
74:
75: -- build query
76: biv_core_pkg.get_report_parameters(p_param_str);
77: g_select := get_select;
78: g_table := get_table;
79: biv_core_pkg.get_where_clause(g_table,x_where_clause);
80: g_where := x_where_clause || get_where;

Line 79: biv_core_pkg.get_where_clause(g_table,x_where_clause);

75: -- build query
76: biv_core_pkg.get_report_parameters(p_param_str);
77: g_select := get_select;
78: g_table := get_table;
79: biv_core_pkg.get_where_clause(g_table,x_where_clause);
80: g_where := x_where_clause || get_where;
81:
82: g_query := g_select || ' '|| g_table || ' '|| g_where;
83: g_query := g_query || ' group by ins.name, sr.incident_status_id order by ins.name ';

Line 86: biv_core_pkg.biv_debug(g_query,g_report_code);

82: g_query := g_select || ' '|| g_table || ' '|| g_where;
83: g_query := g_query || ' group by ins.name, sr.incident_status_id order by ins.name ';
84:
85: if g_debug_flag = 'Y' then
86: biv_core_pkg.biv_debug(g_query,g_report_code);
87: biv_core_pkg.biv_debug('session_id:'||
88: to_char(g_session_id),g_report_code);
89: commit;
90: end if;

Line 87: biv_core_pkg.biv_debug('session_id:'||

83: g_query := g_query || ' group by ins.name, sr.incident_status_id order by ins.name ';
84:
85: if g_debug_flag = 'Y' then
86: biv_core_pkg.biv_debug(g_query,g_report_code);
87: biv_core_pkg.biv_debug('session_id:'||
88: to_char(g_session_id),g_report_code);
89: commit;
90: end if;
91:

Line 94: biv_core_pkg.bind_all_variables(l_cur_id);

90: end if;
91:
92: l_cur_id := DBMS_SQL.OPEN_CURSOR;
93: DBMS_SQL.PARSE(l_cur_id,g_query,DBMS_SQL.NATIVE);
94: biv_core_pkg.bind_all_variables(l_cur_id);
95: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',g_session_id);
96: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_1_a',g_sev_1);
97: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_2_a',g_sev_2);
98: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_sev_3_a',g_sev_3);

Line 118: biv_core_pkg.biv_debug('Updating Hyperlinks',g_report_code);

114: commit;
115:
116: -- update the average, URL
117: if (g_debug_flag = 'Y') then
118: biv_core_pkg.biv_debug('Updating Hyperlinks',g_report_code);
119: end if;
120: UPDATE biv_tmp_hs2
121: SET col3 = 'BIV_SERVICE_REQUEST'||g_p_sp||'jtfBinId'||g_v_sp||'BIV_SERVICE_REQUEST'||g_p_sp||'P_STS_ID'||g_v_sp||col3||g_p_sp||'P_SEV'||g_v_sp||g_sev_1||g_p_sp||'P_BLOG'||g_v_sp||'Y'||g_extra_param,
122: col7 = 'BIV_SERVICE_REQUEST'||g_p_sp||'jtfBinId'||g_v_sp||'BIV_SERVICE_REQUEST'||g_p_sp||'P_STS_ID'||g_v_sp||col7||g_p_sp||'P_SEV'||g_v_sp||g_sev_2||g_p_sp||'P_BLOG'||g_v_sp||'Y'||g_extra_param,

Line 132: where session_id = biv_core_pkg.get_session_id;

128: col14 = decode(col12,0,0,round(col14/col12)),
129: col18 = decode(col16,0,0,round(col18/col16)),
130: col22 = decode(col20,0,0,round(col22/col20)),
131: rowno = 1
132: where session_id = biv_core_pkg.get_session_id;
133: commit;
134:
135: select attribute_label_long INTO l_total_label
136: from ak_attributes_vl

Line 141: biv_core_pkg.biv_debug('Adding Total Row',g_report_code);

137: where attribute_code = 'P_SR_SEV_RPT_6'
138: and attribute_application_id = 862;
139:
140: if (g_debug_flag = 'Y') then
141: biv_core_pkg.biv_debug('Adding Total Row',g_report_code);
142: end if;
143: -- insert the total row
144: INSERT INTO biv_tmp_hs2 (report_code,session_id,col2,
145: col3,col4,col6,

Line 167: where session_id = biv_core_pkg.get_session_id

163: 'BIV_SERVICE_REQUEST'||g_p_sp||'jtfBinId'||g_v_sp||'BIV_SERVICE_REQUEST'||g_p_sp||'P_SEV'||g_v_sp||g_sev_5||g_p_sp||'P_BLOG'||g_v_sp||'Y'||g_extra_param,
164: nvl(sum(col20),0),
165: '',
166: '',2 FROM biv_tmp_hs2
167: where session_id = biv_core_pkg.get_session_id
168: ;
169:
170: commit;
171: if (g_debug_flag = 'Y') then

Line 172: biv_core_pkg.biv_debug('End of report',g_report_code);

168: ;
169:
170: commit;
171: if (g_debug_flag = 'Y') then
172: biv_core_pkg.biv_debug('End of report',g_report_code);
173: end if;
174: EXCEPTION
175: WHEN OTHERS THEN
176: rollback;

Line 181: biv_core_pkg.biv_debug(g_err,g_report_code);

177: if (g_debug_flag = 'Y') then
178: g_err := 'Err in BIV_RT_SR_AGE_REPORT_PKG.' ||
179: 'load_sr_backlog_age_report:' ||
180: substr(sqlerrm,1,500);
181: biv_core_pkg.biv_debug(g_err,g_report_code);
182: end if;
183:
184: END load_sr_backlog_age_report;
185: