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_BIN_ESC_RSC_PKG dependencies on BIV_CORE_PKG

Line 18: biv_core_pkg.g_report_id := 'BIV_BIN_SR_ESCALATION';

14: l_dummy number;
15: l_err varchar2(2000);
16: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
17: begin
18: biv_core_pkg.g_report_id := 'BIV_BIN_SR_ESCALATION';
19:
20: l_session_id := biv_core_pkg.get_session_id;
21: biv_core_pkg.clean_dcf_table('biv_tmp_bin');
22: if (l_debug = 'Y') then

Line 20: l_session_id := biv_core_pkg.get_session_id;

16: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
17: begin
18: biv_core_pkg.g_report_id := 'BIV_BIN_SR_ESCALATION';
19:
20: l_session_id := biv_core_pkg.get_session_id;
21: biv_core_pkg.clean_dcf_table('biv_tmp_bin');
22: if (l_debug = 'Y') then
23: biv_core_pkg.biv_debug('Parameters:'||p_param_str,
24: biv_core_pkg.g_report_id);

Line 21: biv_core_pkg.clean_dcf_table('biv_tmp_bin');

17: begin
18: biv_core_pkg.g_report_id := 'BIV_BIN_SR_ESCALATION';
19:
20: l_session_id := biv_core_pkg.get_session_id;
21: biv_core_pkg.clean_dcf_table('biv_tmp_bin');
22: if (l_debug = 'Y') then
23: biv_core_pkg.biv_debug('Parameters:'||p_param_str,
24: biv_core_pkg.g_report_id);
25: end if;

Line 23: biv_core_pkg.biv_debug('Parameters:'||p_param_str,

19:
20: l_session_id := biv_core_pkg.get_session_id;
21: biv_core_pkg.clean_dcf_table('biv_tmp_bin');
22: if (l_debug = 'Y') then
23: biv_core_pkg.biv_debug('Parameters:'||p_param_str,
24: biv_core_pkg.g_report_id);
25: end if;
26: commit;
27: /*

Line 24: biv_core_pkg.g_report_id);

20: l_session_id := biv_core_pkg.get_session_id;
21: biv_core_pkg.clean_dcf_table('biv_tmp_bin');
22: if (l_debug = 'Y') then
23: biv_core_pkg.biv_debug('Parameters:'||p_param_str,
24: biv_core_pkg.g_report_id);
25: end if;
26: commit;
27: /*
28: l_new_param_str := 'BIV_TASK_SUMMARY' ||biv_core_pkg.g_param_sep ;

Line 28: l_new_param_str := 'BIV_TASK_SUMMARY' ||biv_core_pkg.g_param_sep ;

24: biv_core_pkg.g_report_id);
25: end if;
26: commit;
27: /*
28: l_new_param_str := 'BIV_TASK_SUMMARY' ||biv_core_pkg.g_param_sep ;
29: l_new_param_str := l_new_param_str || 'jtfBinId' ||
30: biv_core_pkg.g_value_sep || 'BIV_TASK_SUMMARY' ||
31: changed drill down to service request page 5/9/2
32: */

Line 30: biv_core_pkg.g_value_sep || 'BIV_TASK_SUMMARY' ||

26: commit;
27: /*
28: l_new_param_str := 'BIV_TASK_SUMMARY' ||biv_core_pkg.g_param_sep ;
29: l_new_param_str := l_new_param_str || 'jtfBinId' ||
30: biv_core_pkg.g_value_sep || 'BIV_TASK_SUMMARY' ||
31: changed drill down to service request page 5/9/2
32: */
33: -- Change for Bug 3386946
34: l_from_list := ' from jtf_task_references_b r,

Line 40: biv_core_pkg.get_report_parameters(p_param_str);

36: jtf_tasks_b t,
37: cs_incident_statuses_b stat,
38: fnd_lookups lup
39: ' ;
40: biv_core_pkg.get_report_parameters(p_param_str);
41: biv_core_pkg.get_where_clause(l_from_list, l_where_clause);
42: l_where_clause := l_where_clause || '
43: and sr.incident_id = r.OBJECT_ID
44: and sr.incident_status_id = stat.incident_status_id

Line 41: biv_core_pkg.get_where_clause(l_from_list, l_where_clause);

37: cs_incident_statuses_b stat,
38: fnd_lookups lup
39: ' ;
40: biv_core_pkg.get_report_parameters(p_param_str);
41: biv_core_pkg.get_where_clause(l_from_list, l_where_clause);
42: l_where_clause := l_where_clause || '
43: and sr.incident_id = r.OBJECT_ID
44: and sr.incident_status_id = stat.incident_status_id
45: and nvl(stat.close_flag,''N'') <> ''Y''

Line 61: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);

57: count(distinct sr.incident_id),:session_id
58: ' || l_from_list || l_where_clause ||
59: ' group by lup.lookup_code, lup.meaning';
60: if (l_debug = 'Y') then
61: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
62: commit;
63: end if;
64:
65: l_cur := dbms_sql.open_cursor;

Line 67: biv_core_pkg.bind_all_variables(l_cur);

63: end if;
64:
65: l_cur := dbms_sql.open_cursor;
66: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
67: biv_core_pkg.bind_all_variables(l_cur);
68: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
69: l_dummy := dbms_sql.execute(l_cur);
70: dbms_sql.close_cursor(l_cur);
71:

Line 92: l_new_param_str := 'BIV_SERVICE_REQUEST' ||biv_core_pkg.g_param_sep ||

88: and lup.lookup_type = 'JTF_TASK_ESC_LEVEL'
89: and lup.lookup_code = t.escalation_level
90: group by lup.lookup_code, lup.meaning;
91: *********************************************************************/
92: l_new_param_str := 'BIV_SERVICE_REQUEST' ||biv_core_pkg.g_param_sep ||
93: biv_core_pkg.reconstruct_param_str;
94: l_new_param_str := l_new_param_str || 'jtfBinId' ||
95: biv_core_pkg.g_value_sep || 'BIV_SERVICE_REQUEST' ||
96: biv_core_pkg.g_param_sep ||

Line 93: biv_core_pkg.reconstruct_param_str;

89: and lup.lookup_code = t.escalation_level
90: group by lup.lookup_code, lup.meaning;
91: *********************************************************************/
92: l_new_param_str := 'BIV_SERVICE_REQUEST' ||biv_core_pkg.g_param_sep ||
93: biv_core_pkg.reconstruct_param_str;
94: l_new_param_str := l_new_param_str || 'jtfBinId' ||
95: biv_core_pkg.g_value_sep || 'BIV_SERVICE_REQUEST' ||
96: biv_core_pkg.g_param_sep ||
97: 'P_BLOG' ||

Line 95: biv_core_pkg.g_value_sep || 'BIV_SERVICE_REQUEST' ||

91: *********************************************************************/
92: l_new_param_str := 'BIV_SERVICE_REQUEST' ||biv_core_pkg.g_param_sep ||
93: biv_core_pkg.reconstruct_param_str;
94: l_new_param_str := l_new_param_str || 'jtfBinId' ||
95: biv_core_pkg.g_value_sep || 'BIV_SERVICE_REQUEST' ||
96: biv_core_pkg.g_param_sep ||
97: 'P_BLOG' ||
98: biv_core_pkg.g_value_sep || 'Y' ||
99: biv_core_pkg.g_param_sep ||

Line 96: biv_core_pkg.g_param_sep ||

92: l_new_param_str := 'BIV_SERVICE_REQUEST' ||biv_core_pkg.g_param_sep ||
93: biv_core_pkg.reconstruct_param_str;
94: l_new_param_str := l_new_param_str || 'jtfBinId' ||
95: biv_core_pkg.g_value_sep || 'BIV_SERVICE_REQUEST' ||
96: biv_core_pkg.g_param_sep ||
97: 'P_BLOG' ||
98: biv_core_pkg.g_value_sep || 'Y' ||
99: biv_core_pkg.g_param_sep ||
100: 'P_ESC_LVL' ||

Line 98: biv_core_pkg.g_value_sep || 'Y' ||

94: l_new_param_str := l_new_param_str || 'jtfBinId' ||
95: biv_core_pkg.g_value_sep || 'BIV_SERVICE_REQUEST' ||
96: biv_core_pkg.g_param_sep ||
97: 'P_BLOG' ||
98: biv_core_pkg.g_value_sep || 'Y' ||
99: biv_core_pkg.g_param_sep ||
100: 'P_ESC_LVL' ||
101: biv_core_pkg.g_value_sep ;
102:

Line 99: biv_core_pkg.g_param_sep ||

95: biv_core_pkg.g_value_sep || 'BIV_SERVICE_REQUEST' ||
96: biv_core_pkg.g_param_sep ||
97: 'P_BLOG' ||
98: biv_core_pkg.g_value_sep || 'Y' ||
99: biv_core_pkg.g_param_sep ||
100: 'P_ESC_LVL' ||
101: biv_core_pkg.g_value_sep ;
102:
103: update biv_tmp_bin

Line 101: biv_core_pkg.g_value_sep ;

97: 'P_BLOG' ||
98: biv_core_pkg.g_value_sep || 'Y' ||
99: biv_core_pkg.g_param_sep ||
100: 'P_ESC_LVL' ||
101: biv_core_pkg.g_value_sep ;
102:
103: update biv_tmp_bin
104: set col1 = l_new_param_str || col1
105: where report_code = 'BIV_BIN_SR_ESCALATION'

Line 113: biv_core_pkg.biv_debug(l_err, biv_core_pkg.g_report_id);

109: when others then
110: rollback;
111: if (l_debug = 'Y') then
112: l_err := 'Error in SR_escalation:'|| substr(sqlerrm,1,1500);
113: biv_core_pkg.biv_debug(l_err, biv_core_pkg.g_report_id);
114: commit;
115: end if;
116: end sr_esc_bin;
117: --------------------------------

Line 128: biv_core_pkg.get_lookup_meaning('ALL');

124: l_cur number;
125: l_dummy number;
126: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
127: l_all fnd_lookups.meaning % type :=
128: biv_core_pkg.get_lookup_meaning('ALL');
129: begin
130: biv_core_pkg.g_report_id := 'BIV_BIN_RESOURCE';
131: l_session_id := biv_core_pkg.get_session_id;
132: biv_core_pkg.clean_dcf_table('biv_tmp_bin');

Line 130: biv_core_pkg.g_report_id := 'BIV_BIN_RESOURCE';

126: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
127: l_all fnd_lookups.meaning % type :=
128: biv_core_pkg.get_lookup_meaning('ALL');
129: begin
130: biv_core_pkg.g_report_id := 'BIV_BIN_RESOURCE';
131: l_session_id := biv_core_pkg.get_session_id;
132: biv_core_pkg.clean_dcf_table('biv_tmp_bin');
133:
134: biv_core_pkg.get_report_parameters(p_param_str);

Line 131: l_session_id := biv_core_pkg.get_session_id;

127: l_all fnd_lookups.meaning % type :=
128: biv_core_pkg.get_lookup_meaning('ALL');
129: begin
130: biv_core_pkg.g_report_id := 'BIV_BIN_RESOURCE';
131: l_session_id := biv_core_pkg.get_session_id;
132: biv_core_pkg.clean_dcf_table('biv_tmp_bin');
133:
134: biv_core_pkg.get_report_parameters(p_param_str);
135: get_resource_where_clause(l_from_list, l_where_clause);

Line 132: biv_core_pkg.clean_dcf_table('biv_tmp_bin');

128: biv_core_pkg.get_lookup_meaning('ALL');
129: begin
130: biv_core_pkg.g_report_id := 'BIV_BIN_RESOURCE';
131: l_session_id := biv_core_pkg.get_session_id;
132: biv_core_pkg.clean_dcf_table('biv_tmp_bin');
133:
134: biv_core_pkg.get_report_parameters(p_param_str);
135: get_resource_where_clause(l_from_list, l_where_clause);
136:

Line 134: biv_core_pkg.get_report_parameters(p_param_str);

130: biv_core_pkg.g_report_id := 'BIV_BIN_RESOURCE';
131: l_session_id := biv_core_pkg.get_session_id;
132: biv_core_pkg.clean_dcf_table('biv_tmp_bin');
133:
134: biv_core_pkg.get_report_parameters(p_param_str);
135: get_resource_where_clause(l_from_list, l_where_clause);
136:
137: l_new_param_str := 'BIV_RT_AGENT_REPORT' ||biv_core_pkg.g_param_sep ||
138: biv_core_pkg.reconstruct_param_str;

Line 137: l_new_param_str := 'BIV_RT_AGENT_REPORT' ||biv_core_pkg.g_param_sep ||

133:
134: biv_core_pkg.get_report_parameters(p_param_str);
135: get_resource_where_clause(l_from_list, l_where_clause);
136:
137: l_new_param_str := 'BIV_RT_AGENT_REPORT' ||biv_core_pkg.g_param_sep ||
138: biv_core_pkg.reconstruct_param_str;
139: l_new_param_str := l_new_param_str || 'jtfBinId' ||
140: biv_core_pkg.g_value_sep || 'BIV_RT_AGENT_REPORT' ||
141: biv_core_pkg.g_param_sep ||

Line 138: biv_core_pkg.reconstruct_param_str;

134: biv_core_pkg.get_report_parameters(p_param_str);
135: get_resource_where_clause(l_from_list, l_where_clause);
136:
137: l_new_param_str := 'BIV_RT_AGENT_REPORT' ||biv_core_pkg.g_param_sep ||
138: biv_core_pkg.reconstruct_param_str;
139: l_new_param_str := l_new_param_str || 'jtfBinId' ||
140: biv_core_pkg.g_value_sep || 'BIV_RT_AGENT_REPORT' ||
141: biv_core_pkg.g_param_sep ||
142: 'P_SRT_BY' || biv_core_pkg.g_value_sep || '1' ||

Line 140: biv_core_pkg.g_value_sep || 'BIV_RT_AGENT_REPORT' ||

136:
137: l_new_param_str := 'BIV_RT_AGENT_REPORT' ||biv_core_pkg.g_param_sep ||
138: biv_core_pkg.reconstruct_param_str;
139: l_new_param_str := l_new_param_str || 'jtfBinId' ||
140: biv_core_pkg.g_value_sep || 'BIV_RT_AGENT_REPORT' ||
141: biv_core_pkg.g_param_sep ||
142: 'P_SRT_BY' || biv_core_pkg.g_value_sep || '1' ||
143: biv_core_pkg.g_param_sep ||
144: 'P_RSC' || biv_core_pkg.g_value_sep ;

Line 141: biv_core_pkg.g_param_sep ||

137: l_new_param_str := 'BIV_RT_AGENT_REPORT' ||biv_core_pkg.g_param_sep ||
138: biv_core_pkg.reconstruct_param_str;
139: l_new_param_str := l_new_param_str || 'jtfBinId' ||
140: biv_core_pkg.g_value_sep || 'BIV_RT_AGENT_REPORT' ||
141: biv_core_pkg.g_param_sep ||
142: 'P_SRT_BY' || biv_core_pkg.g_value_sep || '1' ||
143: biv_core_pkg.g_param_sep ||
144: 'P_RSC' || biv_core_pkg.g_value_sep ;
145:

Line 142: 'P_SRT_BY' || biv_core_pkg.g_value_sep || '1' ||

138: biv_core_pkg.reconstruct_param_str;
139: l_new_param_str := l_new_param_str || 'jtfBinId' ||
140: biv_core_pkg.g_value_sep || 'BIV_RT_AGENT_REPORT' ||
141: biv_core_pkg.g_param_sep ||
142: 'P_SRT_BY' || biv_core_pkg.g_value_sep || '1' ||
143: biv_core_pkg.g_param_sep ||
144: 'P_RSC' || biv_core_pkg.g_value_sep ;
145:
146: l_sql_sttmnt := '

Line 143: biv_core_pkg.g_param_sep ||

139: l_new_param_str := l_new_param_str || 'jtfBinId' ||
140: biv_core_pkg.g_value_sep || 'BIV_RT_AGENT_REPORT' ||
141: biv_core_pkg.g_param_sep ||
142: 'P_SRT_BY' || biv_core_pkg.g_value_sep || '1' ||
143: biv_core_pkg.g_param_sep ||
144: 'P_RSC' || biv_core_pkg.g_value_sep ;
145:
146: l_sql_sttmnt := '
147: insert into biv_tmp_bin ( report_code, rowno, col1, col2, col4,session_id)

Line 144: 'P_RSC' || biv_core_pkg.g_value_sep ;

140: biv_core_pkg.g_value_sep || 'BIV_RT_AGENT_REPORT' ||
141: biv_core_pkg.g_param_sep ||
142: 'P_SRT_BY' || biv_core_pkg.g_value_sep || '1' ||
143: biv_core_pkg.g_param_sep ||
144: 'P_RSC' || biv_core_pkg.g_value_sep ;
145:
146: l_sql_sttmnt := '
147: insert into biv_tmp_bin ( report_code, rowno, col1, col2, col4,session_id)
148: select ''BIV_BIN_RESOURCE'', rownum, id, descr, total,:session_id

Line 156: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);

152: l_from_list || l_where_clause || '
153: group by ra.mode_of_availability)';
154:
155: if (l_debug = 'Y') then
156: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
157: end if;
158: --
159: l_cur := dbms_sql.open_cursor;
160: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);

Line 161: biv_core_pkg.bind_all_variables(l_cur);

157: end if;
158: --
159: l_cur := dbms_sql.open_cursor;
160: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
161: biv_core_pkg.bind_all_variables(l_cur);
162: if (l_debug = 'Y') then
163: biv_core_pkg.biv_debug('Bef session binding',biv_core_pkg.g_report_id);
164: end if;
165: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);

Line 163: biv_core_pkg.biv_debug('Bef session binding',biv_core_pkg.g_report_id);

159: l_cur := dbms_sql.open_cursor;
160: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
161: biv_core_pkg.bind_all_variables(l_cur);
162: if (l_debug = 'Y') then
163: biv_core_pkg.biv_debug('Bef session binding',biv_core_pkg.g_report_id);
164: end if;
165: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
166: if (l_debug = 'Y') then
167: biv_core_pkg.biv_debug('Bef all binding',biv_core_pkg.g_report_id);

Line 167: biv_core_pkg.biv_debug('Bef all binding',biv_core_pkg.g_report_id);

163: biv_core_pkg.biv_debug('Bef session binding',biv_core_pkg.g_report_id);
164: end if;
165: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
166: if (l_debug = 'Y') then
167: biv_core_pkg.biv_debug('Bef all binding',biv_core_pkg.g_report_id);
168: end if;
169: dbms_sql.bind_variable(l_cur,':all_meaning' , l_all );
170: l_dummy := dbms_sql.execute(l_cur);
171:

Line 186: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);

182: from (select ''WEB'' id, ''WEB'' descr,count(*) total ' ||
183: l_from_list || l_where_clause || ')';
184:
185: if (l_debug = 'Y') then
186: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
187: commit;
188: end if;
189: l_cur := dbms_sql.open_cursor;
190: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);

Line 191: biv_core_pkg.bind_all_variables(l_cur);

187: commit;
188: end if;
189: l_cur := dbms_sql.open_cursor;
190: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
191: biv_core_pkg.bind_all_variables(l_cur);
192: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
193: l_dummy := dbms_sql.execute(l_cur);
194: */
195: /**************************************************************************

Line 210: biv_core_pkg.g_param_sep ||

206: );
207: ***************************************/
208: update biv_tmp_bin
209: set col1 = l_new_param_str || col1 ||
210: biv_core_pkg.g_param_sep ||
211: 'P_DISP' ||
212: biv_core_pkg.g_value_sep || col4
213: where report_code = 'BIV_BIN_RESOURCE'
214: and session_id = l_session_id;

Line 212: biv_core_pkg.g_value_sep || col4

208: update biv_tmp_bin
209: set col1 = l_new_param_str || col1 ||
210: biv_core_pkg.g_param_sep ||
211: 'P_DISP' ||
212: biv_core_pkg.g_value_sep || col4
213: where report_code = 'BIV_BIN_RESOURCE'
214: and session_id = l_session_id;
215: exception
216: when others then

Line 218: biv_core_pkg.biv_debug(sqlerrm,biv_core_pkg.g_report_id);

214: and session_id = l_session_id;
215: exception
216: when others then
217: if (l_debug = 'Y') then
218: biv_core_pkg.biv_debug(sqlerrm,biv_core_pkg.g_report_id);
219: commit;
220: end if;
221: end resource_bin;
222: ---------------------------------------------

Line 234: biv_core_pkg.g_report_id := 'BIV_TASK_SUMMARY';

230: l_cur number;
231: l_dummy number;
232: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
233: begin
234: biv_core_pkg.g_report_id := 'BIV_TASK_SUMMARY';
235: l_session_id := biv_core_pkg.get_session_id;
236: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
237: --l_esc_lvl := biv_core_pkg.get_parameter_value(p_esc_level, 'P_ESC_LVL');
238: -- Change for Bug 3386946

Line 235: l_session_id := biv_core_pkg.get_session_id;

231: l_dummy number;
232: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
233: begin
234: biv_core_pkg.g_report_id := 'BIV_TASK_SUMMARY';
235: l_session_id := biv_core_pkg.get_session_id;
236: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
237: --l_esc_lvl := biv_core_pkg.get_parameter_value(p_esc_level, 'P_ESC_LVL');
238: -- Change for Bug 3386946
239: l_from_list := '

Line 236: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');

232: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
233: begin
234: biv_core_pkg.g_report_id := 'BIV_TASK_SUMMARY';
235: l_session_id := biv_core_pkg.get_session_id;
236: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
237: --l_esc_lvl := biv_core_pkg.get_parameter_value(p_esc_level, 'P_ESC_LVL');
238: -- Change for Bug 3386946
239: l_from_list := '
240: from jtf_task_references_b r,

Line 237: --l_esc_lvl := biv_core_pkg.get_parameter_value(p_esc_level, 'P_ESC_LVL');

233: begin
234: biv_core_pkg.g_report_id := 'BIV_TASK_SUMMARY';
235: l_session_id := biv_core_pkg.get_session_id;
236: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
237: --l_esc_lvl := biv_core_pkg.get_parameter_value(p_esc_level, 'P_ESC_LVL');
238: -- Change for Bug 3386946
239: l_from_list := '
240: from jtf_task_references_b r,
241: cs_incidents_b_sec ina,

Line 247: biv_core_pkg.get_report_parameters(p_param_str);

243: jtf_tasks_b task,
244: jtf_rs_resource_extns rsc,
245: hz_parties p';
246:
247: biv_core_pkg.get_report_parameters(p_param_str);
248: biv_core_pkg.get_where_clause(l_from_list, l_where_clause);
249:
250: l_where_clause := l_where_clause || '
251: and ina.incident_id = r.OBJECT_ID

Line 248: biv_core_pkg.get_where_clause(l_from_list, l_where_clause);

244: jtf_rs_resource_extns rsc,
245: hz_parties p';
246:
247: biv_core_pkg.get_report_parameters(p_param_str);
248: biv_core_pkg.get_where_clause(l_from_list, l_where_clause);
249:
250: l_where_clause := l_where_clause || '
251: and ina.incident_id = r.OBJECT_ID
252: and r.object_type_code = ''SR''

Line 261: --'X' || biv_core_pkg.g_param_sep || 'task_id=' ||t.task_id,

257: and ina.customer_id = p.party_id
258: and task.owner_id = rsc.resource_id
259: and nvl(stat.close_flag,''N'') <> ''Y''';
260:
261: --'X' || biv_core_pkg.g_param_sep || 'task_id=' ||t.task_id,
262: l_sql_sttmnt := '
263: insert into biv_tmp_rt2(report_code, rowno, id,col2, col4,
264: col6, col8, col10, col12, col13,session_id)
265: select ''BIV_TASK_SUMMARY'',

Line 278: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);

274: reason_code,
275: :session_id ' || l_from_list || l_where_clause;
276:
277: if (l_debug = 'Y') then
278: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
279: end if;
280: l_cur := dbms_sql.open_cursor;
281: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
282: biv_core_pkg.bind_all_variables(l_cur);

Line 282: biv_core_pkg.bind_all_variables(l_cur);

278: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
279: end if;
280: l_cur := dbms_sql.open_cursor;
281: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
282: biv_core_pkg.bind_all_variables(l_cur);
283: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
284: l_dummy := dbms_sql.execute(l_cur);
285: dbms_sql.close_cursor(l_cur);
286: update biv_tmp_rt2

Line 287: set col1 = 'task' || biv_core_pkg.g_param_sep ||

283: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
284: l_dummy := dbms_sql.execute(l_cur);
285: dbms_sql.close_cursor(l_cur);
286: update biv_tmp_rt2
287: set col1 = 'task' || biv_core_pkg.g_param_sep ||
288: 'task_id' || biv_core_pkg.g_value_sep || id
289: ;
290: update biv_tmp_rt2 t
291: set col14 = ( select meaning from fnd_lookups lup

Line 288: 'task_id' || biv_core_pkg.g_value_sep || id

284: l_dummy := dbms_sql.execute(l_cur);
285: dbms_sql.close_cursor(l_cur);
286: update biv_tmp_rt2
287: set col1 = 'task' || biv_core_pkg.g_param_sep ||
288: 'task_id' || biv_core_pkg.g_value_sep || id
289: ;
290: update biv_tmp_rt2 t
291: set col14 = ( select meaning from fnd_lookups lup
292: where lup.lookup_code = t.col13

Line 300: 'X' || biv_core_pkg.g_param_sep || 'task_id=' ||t.task_id,

296: insert into biv_tmp_rt2(report_code, rowno, col1,col2, col4,
297: col6, col8, col10, col12, col14,session_id)
298: select 'BIV_TASK_SUMMARY',
299: rownum,
300: 'X' || biv_core_pkg.g_param_sep || 'task_id=' ||t.task_id,
301: t.task_number,
302: p.party_name,
303: stat.name,
304: ina.incident_date,

Line 330: biv_core_pkg.biv_debug(sqlerrm,biv_core_pkg.g_report_id);

326: commit;
327: exception
328: when others then
329: if (l_debug = 'Y') then
330: biv_core_pkg.biv_debug(sqlerrm,biv_core_pkg.g_report_id);
331: end if;
332: end tsk_summry_rep;
333: --------------------------------------------
334: procedure rltd_task_rep(p_sr_id varchar2) is

Line 339: l_session_id := biv_core_pkg.get_session_id;

335: l_sr_id varchar2(20);
336: l_session_id biv_tmp_bin.session_id%type;
337: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
338: begin
339: l_session_id := biv_core_pkg.get_session_id;
340: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
341: l_sr_id := biv_core_pkg.get_parameter_value(p_sr_id, 'P_SR_ID');
342: insert into biv_tmp_rt2(report_code, rowno, col1,col2, col4, col6,
343: col8, col10, col12, col14, col16,session_id)

Line 340: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');

336: l_session_id biv_tmp_bin.session_id%type;
337: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
338: begin
339: l_session_id := biv_core_pkg.get_session_id;
340: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
341: l_sr_id := biv_core_pkg.get_parameter_value(p_sr_id, 'P_SR_ID');
342: insert into biv_tmp_rt2(report_code, rowno, col1,col2, col4, col6,
343: col8, col10, col12, col14, col16,session_id)
344: select 'BIV_RELATED_TASK_REPORT', rownum,

Line 341: l_sr_id := biv_core_pkg.get_parameter_value(p_sr_id, 'P_SR_ID');

337: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
338: begin
339: l_session_id := biv_core_pkg.get_session_id;
340: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
341: l_sr_id := biv_core_pkg.get_parameter_value(p_sr_id, 'P_SR_ID');
342: insert into biv_tmp_rt2(report_code, rowno, col1,col2, col4, col6,
343: col8, col10, col12, col14, col16,session_id)
344: select 'BIV_RELATED_TASK_REPORT', rownum,
345: tsk.task_id,

Line 390: if (biv_core_pkg.g_agrp_cnt > 0 ) then

386: and sysdate between
387: nvl(rsc.start_date_active,sysdate-1)
388: and nvl(rsc.end_date_active, sysdate+1) ';
389: -----
390: if (biv_core_pkg.g_agrp_cnt > 0 ) then
391: p_from_list := p_from_list || ',
392: jtf_rs_groups_denorm adnorm1,
393: jtf_rs_group_members agmmbr';
394: p_where_clause := p_where_clause || '

Line 399: if (biv_core_pkg.g_ogrp_cnt > 0) then

395: and agmmbr.group_id = adnorm1.group_id
396: and rsc.resource_id = agmmbr.resource_id ';
397: end if;
398: -----
399: if (biv_core_pkg.g_ogrp_cnt > 0) then
400: p_from_list := p_from_list || ',
401: jtf_rs_groups_denorm odnorm1,
402: jtf_rs_group_members ogmmbr';
403: p_where_clause := p_where_clause || '

Line 415: biv_core_pkg.add_a_condition(biv_core_pkg.g_ogrp,

411:
412: p_where_clause := p_where_clause || '
413: and category = ''EMPLOYEE''';
414: */
415: biv_core_pkg.add_a_condition(biv_core_pkg.g_ogrp,
416: biv_core_pkg.g_ogrp_cnt,
417: 'odnorm1', 'parent_group_id',
418: null, p_where_clause);
419: biv_core_pkg.add_a_condition(biv_core_pkg.g_agrp,

Line 416: biv_core_pkg.g_ogrp_cnt,

412: p_where_clause := p_where_clause || '
413: and category = ''EMPLOYEE''';
414: */
415: biv_core_pkg.add_a_condition(biv_core_pkg.g_ogrp,
416: biv_core_pkg.g_ogrp_cnt,
417: 'odnorm1', 'parent_group_id',
418: null, p_where_clause);
419: biv_core_pkg.add_a_condition(biv_core_pkg.g_agrp,
420: biv_core_pkg.g_agrp_cnt,

Line 419: biv_core_pkg.add_a_condition(biv_core_pkg.g_agrp,

415: biv_core_pkg.add_a_condition(biv_core_pkg.g_ogrp,
416: biv_core_pkg.g_ogrp_cnt,
417: 'odnorm1', 'parent_group_id',
418: null, p_where_clause);
419: biv_core_pkg.add_a_condition(biv_core_pkg.g_agrp,
420: biv_core_pkg.g_agrp_cnt,
421: 'adnorm1', 'parent_group_id',
422: null, p_where_clause);
423: biv_core_pkg.add_a_condition(biv_core_pkg.g_mgr_id,

Line 420: biv_core_pkg.g_agrp_cnt,

416: biv_core_pkg.g_ogrp_cnt,
417: 'odnorm1', 'parent_group_id',
418: null, p_where_clause);
419: biv_core_pkg.add_a_condition(biv_core_pkg.g_agrp,
420: biv_core_pkg.g_agrp_cnt,
421: 'adnorm1', 'parent_group_id',
422: null, p_where_clause);
423: biv_core_pkg.add_a_condition(biv_core_pkg.g_mgr_id,
424: biv_core_pkg.g_mgr_id_cnt,

Line 423: biv_core_pkg.add_a_condition(biv_core_pkg.g_mgr_id,

419: biv_core_pkg.add_a_condition(biv_core_pkg.g_agrp,
420: biv_core_pkg.g_agrp_cnt,
421: 'adnorm1', 'parent_group_id',
422: null, p_where_clause);
423: biv_core_pkg.add_a_condition(biv_core_pkg.g_mgr_id,
424: biv_core_pkg.g_mgr_id_cnt,
425: 'rsc', 'source_mgr_id',
426: null, p_where_clause);
427: end get_resource_where_clause;

Line 424: biv_core_pkg.g_mgr_id_cnt,

420: biv_core_pkg.g_agrp_cnt,
421: 'adnorm1', 'parent_group_id',
422: null, p_where_clause);
423: biv_core_pkg.add_a_condition(biv_core_pkg.g_mgr_id,
424: biv_core_pkg.g_mgr_id_cnt,
425: 'rsc', 'source_mgr_id',
426: null, p_where_clause);
427: end get_resource_where_clause;
428: -----------------------------