APPS.BIM_I_LEAD_MGMT_PVT dependencies on FII_TIME_ENT_PERIOD

Line 264: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_PERIOD_PFROM' THEN

260:
261: p_prev_page_time_id := p_page_parameter_tbl(i).parameter_id;
262: END IF;
263:
264: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_PERIOD_PFROM' THEN
265:
266: p_prev_page_time_id := p_page_parameter_tbl(i).parameter_id;
267: END IF;
268:

Line 283: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_PERIOD_FROM' THEN

279:
280: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_WEEK_FROM' THEN
281: p_curr_page_time_id := p_page_parameter_tbl(i).parameter_id;
282: END IF;
283: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_PERIOD_FROM' THEN
284: p_curr_page_time_id := p_page_parameter_tbl(i).parameter_id;
285: END IF;
286: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_QTR_FROM' THEN
287: p_curr_page_time_id := p_page_parameter_tbl(i).parameter_id;

Line 306: WHEN 'FII_TIME_ENT_PERIOD' THEN p_period_type := 32; p_record_type := 23;

302: -- Retrieve Period_Type info using CASE
303:
304: CASE p_page_period_type
305: WHEN 'FII_TIME_WEEK' THEN p_period_type := 16; p_record_type := 11;
306: WHEN 'FII_TIME_ENT_PERIOD' THEN p_period_type := 32; p_record_type := 23;
307: WHEN 'FII_TIME_ENT_QTR' THEN p_period_type := 64; p_record_type := 55;
308: WHEN 'FII_TIME_ENT_YEAR' THEN p_period_type := 128; p_record_type := 119;
309: ELSE p_period_type := 64; p_record_type := 55;
310: END CASE;

Line 335: -- ER #2467584 for gettig previous time_id e.g. TIME+FII_TIME_ENT_PERIOD_PFROM and TIME+FII_TIME_ENT_PERIOD_PTO

331: *WHERE to_date('14-JUL-2002','DD-MON-YYYY') >= start_date
332: *AND to_date('14-JUL-2002','DD-MON-YYYY') <= end_date
333: **********************************************************/
334: -- get values for p_prev_page_time_id
335: -- ER #2467584 for gettig previous time_id e.g. TIME+FII_TIME_ENT_PERIOD_PFROM and TIME+FII_TIME_ENT_PERIOD_PTO
336: /* IF (p_comp_type = 'YEARLY') THEN
337: CASE p_page_period_type
338: WHEN 'FII_TIME_WEEK' THEN
339: l_prior_as_of_date := FII_TIME_API.sd_lyswk(l_as_of_date);

Line 340: WHEN 'FII_TIME_ENT_PERIOD' THEN

336: /* IF (p_comp_type = 'YEARLY') THEN
337: CASE p_page_period_type
338: WHEN 'FII_TIME_WEEK' THEN
339: l_prior_as_of_date := FII_TIME_API.sd_lyswk(l_as_of_date);
340: WHEN 'FII_TIME_ENT_PERIOD' THEN
341: l_prior_as_of_date := FII_TIME_API.ent_sd_lysper_end(l_as_of_date);
342: WHEN 'FII_TIME_ENT_QTR' THEN
343: l_prior_as_of_date := FII_TIME_API.ent_sd_lysqtr_end(l_as_of_date);
344: WHEN 'FII_TIME_ENT_YEAR' THEN

Line 353: WHEN 'FII_TIME_ENT_PERIOD' THEN

349: ELSIF (p_comp_type = 'SEQUENTIAL') THEN
350: CASE p_page_period_type
351: WHEN 'FII_TIME_WEEK' THEN
352: l_prior_as_of_date := FII_TIME_API.sd_pwk(l_as_of_date);
353: WHEN 'FII_TIME_ENT_PERIOD' THEN
354: l_prior_as_of_date := FII_TIME_API.ent_sd_pper_end(l_as_of_date);
355: WHEN 'FII_TIME_ENT_QTR' THEN
356: l_prior_as_of_date := FII_TIME_API.ent_sd_pqtr_end(l_as_of_date);
357: WHEN 'FII_TIME_ENT_YEAR' THEN

Line 373: WHEN 'FII_TIME_ENT_PERIOD' THEN

369: into p_prev_page_time_id
370: from fii_time_week
371: where l_prior_as_of_date BETWEEN start_date AND end_date;
372:
373: WHEN 'FII_TIME_ENT_PERIOD' THEN
374:
375: select MONTH_ID
376: into p_prev_page_time_id
377: from fii_time_month

Line 466: FROM fii_time_ent_period p1, fii_time_ent_period p2

462: Function bil_pper_end(as_of_date date) return DATE is -- will get lastDay of prior''s prior as-of-date period
463: l_date date;
464: CURSOR c_get_pper_end_date(p_as_of_date date) IS
465: SELECT p2.end_date
466: FROM fii_time_ent_period p1, fii_time_ent_period p2
467: WHERE p1.sequence = p2.sequence
468: AND p_as_of_date BETWEEN p1.start_date AND p1.end_date
469: AND p2.ent_year_id = p1.ent_year_id -2;
470: BEGIN

Line 525: WHEN p_page_period_type = 'FII_TIME_ENT_PERIOD' then

521: -- IF p_comp_type = 'YEARLY' then
522: --p_curr_start_date := (fii_time_api.cwk_end(p_curr_as_of_date) - 91);
523: -- p_prev_start_date := (fii_time_api.lyswk_end(p_curr_as_of_date)-91);
524: -- END IF;
525: WHEN p_page_period_type = 'FII_TIME_ENT_PERIOD' then
526: p_table_name := 'fii_time_ent_period_v';
527: -- p_column_name := 'ent_year_id, ent_period_id';
528: --l_curr_end_date := fii_time_api.ent_cper_end(p_curr_as_of_date); -- use &BIS_CURRENT_EFFECTIVE_END_DATE
529: -- p_curr_start_date := fii_time_api.ent_lysper_end(p_curr_as_of_date);

Line 526: p_table_name := 'fii_time_ent_period_v';

522: --p_curr_start_date := (fii_time_api.cwk_end(p_curr_as_of_date) - 91);
523: -- p_prev_start_date := (fii_time_api.lyswk_end(p_curr_as_of_date)-91);
524: -- END IF;
525: WHEN p_page_period_type = 'FII_TIME_ENT_PERIOD' then
526: p_table_name := 'fii_time_ent_period_v';
527: -- p_column_name := 'ent_year_id, ent_period_id';
528: --l_curr_end_date := fii_time_api.ent_cper_end(p_curr_as_of_date); -- use &BIS_CURRENT_EFFECTIVE_END_DATE
529: -- p_curr_start_date := fii_time_api.ent_lysper_end(p_curr_as_of_date);
530: -- p_series_name := 'TO_CHAR(end_date,''Mon'')';

Line 554: WHEN 'FII_TIME_ENT_PERIOD' THEN

550: IF (p_comp_type = 'YEARLY') THEN
551: CASE p_page_period_type
552: WHEN 'FII_TIME_WEEK' THEN
553: p_prev_end_date := FII_TIME_API.sd_lyswk(p_curr_as_of_date);
554: WHEN 'FII_TIME_ENT_PERIOD' THEN
555: p_prev_end_date := FII_TIME_API.ent_sd_lysper_end(p_curr_as_of_date);
556: WHEN 'FII_TIME_ENT_QTR' THEN
557: p_prev_end_date := FII_TIME_API.ent_sd_lysqtr_end(p_curr_as_of_date);
558: WHEN 'FII_TIME_ENT_YEAR' THEN

Line 567: WHEN 'FII_TIME_ENT_PERIOD' THEN

563: ELSIF (p_comp_type = 'SEQUENTIAL') THEN
564: CASE p_page_period_type
565: WHEN 'FII_TIME_WEEK' THEN
566: p_prev_end_date := FII_TIME_API.sd_pwk(p_curr_as_of_date);
567: WHEN 'FII_TIME_ENT_PERIOD' THEN
568: p_prev_end_date := FII_TIME_API.ent_sd_pper_end(p_curr_as_of_date);
569: WHEN 'FII_TIME_ENT_QTR' THEN
570: p_prev_end_date := FII_TIME_API.ent_sd_pqtr_end(p_curr_as_of_date);
571: WHEN 'FII_TIME_ENT_YEAR' THEN