APPS.BIS_BIA_REFRESH_REPORT dependencies on BIS_BIA_REFRESH_REPORT

Line 1: PACKAGE BODY BIS_BIA_REFRESH_REPORT AS

1: PACKAGE BODY BIS_BIA_REFRESH_REPORT AS
2: /* $Header: BISRPTSB.pls 120.0 2005/06/01 14:24:02 appldev noship $ */
3: version CONSTANT CHAR (80)
4: := '$Header: BISRPTSB.pls 120.0 2005/06/01 14:24:02 appldev noship $
5: ';

Line 57: bis_bia_refresh_report.time_interval(c.actual_completion_date

53: FROM (SELECT DISTINCT s.user_request_set_name, s.request_set_name, s.request_set_id,
54: c.actual_completion_date
55: ,c.request_id,
56: u.user_name,
57: bis_bia_refresh_report.time_interval(c.actual_completion_date
58: - c.requested_start_date
59: ) bis_request_refresh_time,
60: RANK () OVER (PARTITION BY s.request_set_id ORDER BY c.actual_completion_date DESC)
61: pos,

Line 163: bis_bia_refresh_report.time_interval(con.actual_completion_date

159: || 'BIS_PRIORITY_REQUEST_ID,
160: stg.request_set_stage_id BIS_REQUEST_SET_STAGE_ID,
161: stg.user_stage_name BIS_REQUEST_SET_STAGE_NAME,
162: con.request_id BIS_REQUEST_ID,
163: bis_bia_refresh_report.time_interval(con.actual_completion_date
164: - con.requested_start_date
165: ) BIS_REQUEST_REFRESH_TIME
166:
167: FROM fnd_concurrent_requests con, fnd_request_set_stages_vl stg

Line 258: , bis_bia_refresh_report.time_interval(rset.actual_completion_date

254: , stage.request_set_stage_id
255: , stage.display_sequence
256: , rset.actual_start_date
257: , rset.actual_completion_date
258: , bis_bia_refresh_report.time_interval(rset.actual_completion_date
259: - rset.actual_start_date
260: ) BIS_REQUEST_REFRESH_TIME
261: , cprog.user_concurrent_program_name
262: FROM fnd_concurrent_requests rset

Line 313: , bis_bia_refresh_report.time_interval(rset.actual_completion_date

309: , stage.request_set_stage_id
310: , stage.display_sequence
311: , rset.actual_start_date
312: , rset.actual_completion_date
313: , bis_bia_refresh_report.time_interval(rset.actual_completion_date
314: - rset.actual_start_date
315: ) BIS_REQUEST_REFRESH_TIME
316: , cprog.user_concurrent_program_name
317: FROM fnd_concurrent_requests rset

Line 370: END BIS_BIA_REFRESH_REPORT;

366: l_dummy := MOD (FLOOR (p_interval * 24 * 60 * 60), 60);
367: l_result := l_result || format (l_dummy);
368: RETURN l_result;
369: END time_interval;
370: END BIS_BIA_REFRESH_REPORT;
371: