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.FII_AP_PAY_MGT dependencies on DUAL

Line 298: select nvl(fii_time_api.ent_pyr_END(l_as_of_date), l_start_date-1) into l_ent_pyr_END from dual;

294:
295: select nvl(min(start_date), trunc(sysdate)) into l_start_date from fii_time_ent_year;
296:
297: --l_ent_pyr_start := fii_time_api.ent_pyr_start(l_as_of_date);
298: select nvl(fii_time_api.ent_pyr_END(l_as_of_date), l_start_date-1) into l_ent_pyr_END from dual;
299: select nvl(fii_time_api.ent_cyr_start(l_as_of_date), l_start_date) into l_ent_cyr_start from dual;
300: select nvl(fii_time_api.ent_cyr_END(l_as_of_date), l_start_date) into l_ent_cyr_END from dual;
301:
302: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start

Line 299: select nvl(fii_time_api.ent_cyr_start(l_as_of_date), l_start_date) into l_ent_cyr_start from dual;

295: select nvl(min(start_date), trunc(sysdate)) into l_start_date from fii_time_ent_year;
296:
297: --l_ent_pyr_start := fii_time_api.ent_pyr_start(l_as_of_date);
298: select nvl(fii_time_api.ent_pyr_END(l_as_of_date), l_start_date-1) into l_ent_pyr_END from dual;
299: select nvl(fii_time_api.ent_cyr_start(l_as_of_date), l_start_date) into l_ent_cyr_start from dual;
300: select nvl(fii_time_api.ent_cyr_END(l_as_of_date), l_start_date) into l_ent_cyr_END from dual;
301:
302: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start
303: (fii_time_api.ent_pyr_start(l_as_of_date))),l_start_date-1)

Line 300: select nvl(fii_time_api.ent_cyr_END(l_as_of_date), l_start_date) into l_ent_cyr_END from dual;

296:
297: --l_ent_pyr_start := fii_time_api.ent_pyr_start(l_as_of_date);
298: select nvl(fii_time_api.ent_pyr_END(l_as_of_date), l_start_date-1) into l_ent_pyr_END from dual;
299: select nvl(fii_time_api.ent_cyr_start(l_as_of_date), l_start_date) into l_ent_cyr_start from dual;
300: select nvl(fii_time_api.ent_cyr_END(l_as_of_date), l_start_date) into l_ent_cyr_END from dual;
301:
302: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start
303: (fii_time_api.ent_pyr_start(l_as_of_date))),l_start_date-1)
304: into l_ent_pyr_start from dual; /* Bug 3325387 */

Line 304: into l_ent_pyr_start from dual; /* Bug 3325387 */

300: select nvl(fii_time_api.ent_cyr_END(l_as_of_date), l_start_date) into l_ent_cyr_END from dual;
301:
302: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start
303: (fii_time_api.ent_pyr_start(l_as_of_date))),l_start_date-1)
304: into l_ent_pyr_start from dual; /* Bug 3325387 */
305:
306: CASE l_page_period_type
307: WHEN 'FII_TIME_WEEK' THEN
308: l_period_type := 16;

Line 314: select nvl(fii_time_api.pwk_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;

310: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
311: inv_graph_rec.attribute_value := 'TIME+FII_TIME_WEEK';
312: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
313: l_name := 'replace(fnd_message.get_string(''FII'',''FII_WEEK_LABEL''),''&WEEK_NUMBER'',t.sequence)';
314: select nvl(fii_time_api.pwk_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
315: select nvl(fii_time_api.sd_lyswk(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
316: select nvl(fii_time_api.sd_lyswk(l_p_as_of_date), l_start_date) into l_start from dual;
317: l_begin_date := l_as_of_date - 91;
318: SELECT sequence into l_curr_effective_num

Line 315: select nvl(fii_time_api.sd_lyswk(l_as_of_date), l_start_date) into l_p_as_of_date from dual;

311: inv_graph_rec.attribute_value := 'TIME+FII_TIME_WEEK';
312: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
313: l_name := 'replace(fnd_message.get_string(''FII'',''FII_WEEK_LABEL''),''&WEEK_NUMBER'',t.sequence)';
314: select nvl(fii_time_api.pwk_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
315: select nvl(fii_time_api.sd_lyswk(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
316: select nvl(fii_time_api.sd_lyswk(l_p_as_of_date), l_start_date) into l_start from dual;
317: l_begin_date := l_as_of_date - 91;
318: SELECT sequence into l_curr_effective_num
319: FROM fii_time_week

Line 316: select nvl(fii_time_api.sd_lyswk(l_p_as_of_date), l_start_date) into l_start from dual;

312: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
313: l_name := 'replace(fnd_message.get_string(''FII'',''FII_WEEK_LABEL''),''&WEEK_NUMBER'',t.sequence)';
314: select nvl(fii_time_api.pwk_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
315: select nvl(fii_time_api.sd_lyswk(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
316: select nvl(fii_time_api.sd_lyswk(l_p_as_of_date), l_start_date) into l_start from dual;
317: l_begin_date := l_as_of_date - 91;
318: SELECT sequence into l_curr_effective_num
319: FROM fii_time_week
320: WHERE l_as_of_date between start_date AND END_date;

Line 331: select nvl(fii_time_api.ent_pper_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;

327: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
328: inv_graph_rec.attribute_value :='TIME+FII_TIME_ENT_PERIOD';
329: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
330: l_name := 'to_char(t.start_date,''Mon'')';
331: select nvl(fii_time_api.ent_pper_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
332: select nvl(fii_time_api.ent_sd_lysper_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
333: select nvl(fii_time_api.ent_sd_lysper_END(l_p_as_of_date), l_start_date) into l_start from dual;
334: l_begin_date := l_p_as_of_date;
335: SELECT sequence into l_curr_effective_num

Line 332: select nvl(fii_time_api.ent_sd_lysper_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;

328: inv_graph_rec.attribute_value :='TIME+FII_TIME_ENT_PERIOD';
329: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
330: l_name := 'to_char(t.start_date,''Mon'')';
331: select nvl(fii_time_api.ent_pper_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
332: select nvl(fii_time_api.ent_sd_lysper_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
333: select nvl(fii_time_api.ent_sd_lysper_END(l_p_as_of_date), l_start_date) into l_start from dual;
334: l_begin_date := l_p_as_of_date;
335: SELECT sequence into l_curr_effective_num
336: FROM fii_time_ent_period

Line 333: select nvl(fii_time_api.ent_sd_lysper_END(l_p_as_of_date), l_start_date) into l_start from dual;

329: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
330: l_name := 'to_char(t.start_date,''Mon'')';
331: select nvl(fii_time_api.ent_pper_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
332: select nvl(fii_time_api.ent_sd_lysper_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
333: select nvl(fii_time_api.ent_sd_lysper_END(l_p_as_of_date), l_start_date) into l_start from dual;
334: l_begin_date := l_p_as_of_date;
335: SELECT sequence into l_curr_effective_num
336: FROM fii_time_ent_period
337: WHERE l_as_of_date between start_date AND END_date;

Line 349: select nvl(fii_time_api.ent_pqtr_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;

345: inv_graph_rec.attribute_value :='TIME+FII_TIME_ENT_QTR';
346: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
347: l_name :=
348: 'replace(fnd_message.get_string(''FII'',''FII_QUARTER_LABEL''),''&QUARTER_NUMBER'',t.sequence)';
349: select nvl(fii_time_api.ent_pqtr_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
350: IF (l_time_comp = 'SEQUENTIAL') THEN
351: select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
352: SELECT ent_qtr_id into l_curr_effective_num
353: FROM fii_time_ent_qtr

Line 351: select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;

347: l_name :=
348: 'replace(fnd_message.get_string(''FII'',''FII_QUARTER_LABEL''),''&QUARTER_NUMBER'',t.sequence)';
349: select nvl(fii_time_api.ent_pqtr_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
350: IF (l_time_comp = 'SEQUENTIAL') THEN
351: select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
352: SELECT ent_qtr_id into l_curr_effective_num
353: FROM fii_time_ent_qtr
354: WHERE l_as_of_date between start_date AND END_date;
355: select nvl(fii_time_api.ent_sd_lysqtr_END(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date)), l_start_date) into l_begin_date from dual;

Line 355: select nvl(fii_time_api.ent_sd_lysqtr_END(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date)), l_start_date) into l_begin_date from dual;

351: select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
352: SELECT ent_qtr_id into l_curr_effective_num
353: FROM fii_time_ent_qtr
354: WHERE l_as_of_date between start_date AND END_date;
355: select nvl(fii_time_api.ent_sd_lysqtr_END(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date)), l_start_date) into l_begin_date from dual;
356: select nvl(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date), l_start_date-1) into l_start from dual;
357: ELSE
358: select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
359: SELECT sequence into l_curr_effective_num

Line 356: select nvl(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date), l_start_date-1) into l_start from dual;

352: SELECT ent_qtr_id into l_curr_effective_num
353: FROM fii_time_ent_qtr
354: WHERE l_as_of_date between start_date AND END_date;
355: select nvl(fii_time_api.ent_sd_lysqtr_END(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date)), l_start_date) into l_begin_date from dual;
356: select nvl(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date), l_start_date-1) into l_start from dual;
357: ELSE
358: select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
359: SELECT sequence into l_curr_effective_num
360: FROM fii_time_ent_qtr

Line 358: select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;

354: WHERE l_as_of_date between start_date AND END_date;
355: select nvl(fii_time_api.ent_sd_lysqtr_END(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date)), l_start_date) into l_begin_date from dual;
356: select nvl(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date), l_start_date-1) into l_start from dual;
357: ELSE
358: select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
359: SELECT sequence into l_curr_effective_num
360: FROM fii_time_ent_qtr
361: WHERE l_as_of_date between start_date AND END_date;
362: l_begin_date := l_p_as_of_date;

Line 363: select nvl(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date), l_start_date) into l_start from dual;

359: SELECT sequence into l_curr_effective_num
360: FROM fii_time_ent_qtr
361: WHERE l_as_of_date between start_date AND END_date;
362: l_begin_date := l_p_as_of_date;
363: select nvl(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date), l_start_date) into l_start from dual;
364: END IF;
365:
366: WHEN 'FII_TIME_ENT_YEAR' THEN
367: l_period_type := 128;

Line 375: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_ent_cyr_start))), l_start_date) into l_begin_date from dual;

371: inv_graph_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
372: inv_graph_rec.attribute_value :='TIME+FII_TIME_ENT_YEAR';
373: inv_graph_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
374:
375: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_ent_cyr_start))), l_start_date) into l_begin_date from dual;
376: END CASE;
377:
378: -- p_bis_map_tbl.extEND;
379: -- p_bis_map_tbl(p_bis_map_tbl.count) := l_bis_map_rec;

Line 785: select fii_time_api.ent_pyr_start(l_as_of_date) into l_ent_pyr_start from dual;

781: END CASE;
782:
783: select nvl(min(start_date), trunc(sysdate)) into l_start_date from fii_time_ent_year;
784:
785: select fii_time_api.ent_pyr_start(l_as_of_date) into l_ent_pyr_start from dual;
786: select nvl(fii_time_api.ent_pyr_END(l_as_of_date), l_start_date-1) into l_ent_pyr_END from dual;
787: select fii_time_api.ent_cyr_start(l_as_of_date) into l_ent_cyr_start from dual;
788: select nvl(fii_time_api.ent_cyr_END(l_as_of_date), l_start_date) into l_ent_cyr_END from dual;
789:

Line 786: select nvl(fii_time_api.ent_pyr_END(l_as_of_date), l_start_date-1) into l_ent_pyr_END from dual;

782:
783: select nvl(min(start_date), trunc(sysdate)) into l_start_date from fii_time_ent_year;
784:
785: select fii_time_api.ent_pyr_start(l_as_of_date) into l_ent_pyr_start from dual;
786: select nvl(fii_time_api.ent_pyr_END(l_as_of_date), l_start_date-1) into l_ent_pyr_END from dual;
787: select fii_time_api.ent_cyr_start(l_as_of_date) into l_ent_cyr_start from dual;
788: select nvl(fii_time_api.ent_cyr_END(l_as_of_date), l_start_date) into l_ent_cyr_END from dual;
789:
790:

Line 787: select fii_time_api.ent_cyr_start(l_as_of_date) into l_ent_cyr_start from dual;

783: select nvl(min(start_date), trunc(sysdate)) into l_start_date from fii_time_ent_year;
784:
785: select fii_time_api.ent_pyr_start(l_as_of_date) into l_ent_pyr_start from dual;
786: select nvl(fii_time_api.ent_pyr_END(l_as_of_date), l_start_date-1) into l_ent_pyr_END from dual;
787: select fii_time_api.ent_cyr_start(l_as_of_date) into l_ent_cyr_start from dual;
788: select nvl(fii_time_api.ent_cyr_END(l_as_of_date), l_start_date) into l_ent_cyr_END from dual;
789:
790:
791: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_ent_pyr_start)),l_start_date-1)

Line 788: select nvl(fii_time_api.ent_cyr_END(l_as_of_date), l_start_date) into l_ent_cyr_END from dual;

784:
785: select fii_time_api.ent_pyr_start(l_as_of_date) into l_ent_pyr_start from dual;
786: select nvl(fii_time_api.ent_pyr_END(l_as_of_date), l_start_date-1) into l_ent_pyr_END from dual;
787: select fii_time_api.ent_cyr_start(l_as_of_date) into l_ent_cyr_start from dual;
788: select nvl(fii_time_api.ent_cyr_END(l_as_of_date), l_start_date) into l_ent_cyr_END from dual;
789:
790:
791: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_ent_pyr_start)),l_start_date-1)
792: into l_ent_year_st1 from dual;

Line 792: into l_ent_year_st1 from dual;

788: select nvl(fii_time_api.ent_cyr_END(l_as_of_date), l_start_date) into l_ent_cyr_END from dual;
789:
790:
791: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_ent_pyr_start)),l_start_date-1)
792: into l_ent_year_st1 from dual;
793: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_ent_cyr_start))),l_start_date-1)
794: into l_ent_year_st2 from dual;
795:
796: CASE l_page_period_type

Line 794: into l_ent_year_st2 from dual;

790:
791: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_ent_pyr_start)),l_start_date-1)
792: into l_ent_year_st1 from dual;
793: select nvl(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(l_ent_cyr_start))),l_start_date-1)
794: into l_ent_year_st2 from dual;
795:
796: CASE l_page_period_type
797: WHEN 'FII_TIME_WEEK' THEN
798: l_period_type := 16;

Line 806: select nvl(fii_time_api.pwk_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;

802: elec_late_payment_rec.attribute_value := 'TIME+FII_TIME_WEEK';
803: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
804: l_name := 'replace(fnd_message.get_string(''FII'',''FII_WEEK_LABEL''),
805: ''&WEEK_NUMBER'',t.sequence)';
806: select nvl(fii_time_api.pwk_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
807: select nvl(fii_time_api.sd_lyswk(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
808: select nvl(fii_time_api.sd_lyswk(l_p_as_of_date), l_start_date) into l_start from dual;
809: l_begin_date := l_as_of_date - 91;
810:

Line 807: select nvl(fii_time_api.sd_lyswk(l_as_of_date), l_start_date) into l_p_as_of_date from dual;

803: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
804: l_name := 'replace(fnd_message.get_string(''FII'',''FII_WEEK_LABEL''),
805: ''&WEEK_NUMBER'',t.sequence)';
806: select nvl(fii_time_api.pwk_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
807: select nvl(fii_time_api.sd_lyswk(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
808: select nvl(fii_time_api.sd_lyswk(l_p_as_of_date), l_start_date) into l_start from dual;
809: l_begin_date := l_as_of_date - 91;
810:
811: SELECT sequence into l_curr_effective_num

Line 808: select nvl(fii_time_api.sd_lyswk(l_p_as_of_date), l_start_date) into l_start from dual;

804: l_name := 'replace(fnd_message.get_string(''FII'',''FII_WEEK_LABEL''),
805: ''&WEEK_NUMBER'',t.sequence)';
806: select nvl(fii_time_api.pwk_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
807: select nvl(fii_time_api.sd_lyswk(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
808: select nvl(fii_time_api.sd_lyswk(l_p_as_of_date), l_start_date) into l_start from dual;
809: l_begin_date := l_as_of_date - 91;
810:
811: SELECT sequence into l_curr_effective_num
812: FROM fii_time_week

Line 825: select nvl(fii_time_api.ent_pper_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;

821: elec_late_payment_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
822: elec_late_payment_rec.attribute_value :='TIME+FII_TIME_ENT_PERIOD';
823: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
824: l_name := 'to_char(t.start_date,''Mon'')';
825: select nvl(fii_time_api.ent_pper_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
826: select nvl(fii_time_api.ent_sd_lysper_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
827: select nvl(fii_time_api.ent_sd_lysper_END(l_p_as_of_date), l_start_date) into l_start from dual;
828: l_begin_date := l_p_as_of_date;
829:

Line 826: select nvl(fii_time_api.ent_sd_lysper_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;

822: elec_late_payment_rec.attribute_value :='TIME+FII_TIME_ENT_PERIOD';
823: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
824: l_name := 'to_char(t.start_date,''Mon'')';
825: select nvl(fii_time_api.ent_pper_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
826: select nvl(fii_time_api.ent_sd_lysper_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
827: select nvl(fii_time_api.ent_sd_lysper_END(l_p_as_of_date), l_start_date) into l_start from dual;
828: l_begin_date := l_p_as_of_date;
829:
830: SELECT sequence into l_curr_effective_num

Line 827: select nvl(fii_time_api.ent_sd_lysper_END(l_p_as_of_date), l_start_date) into l_start from dual;

823: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
824: l_name := 'to_char(t.start_date,''Mon'')';
825: select nvl(fii_time_api.ent_pper_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
826: select nvl(fii_time_api.ent_sd_lysper_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
827: select nvl(fii_time_api.ent_sd_lysper_END(l_p_as_of_date), l_start_date) into l_start from dual;
828: l_begin_date := l_p_as_of_date;
829:
830: SELECT sequence into l_curr_effective_num
831: FROM fii_time_ent_period

Line 845: select nvl(fii_time_api.ent_pqtr_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;

841: elec_late_payment_rec.attribute_value :='TIME+FII_TIME_ENT_QTR';
842: elec_late_payment_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
843: l_name :=
844: 'replace(fnd_message.get_string(''FII'',''FII_QUARTER_LABEL''),''&QUARTER_NUMBER'',t.sequence)';
845: select nvl(fii_time_api.ent_pqtr_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
846: IF (l_time_comp = 'SEQUENTIAL') THEN
847: -- select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
848: select nvl(fii_time_api.ent_sd_pqtr_END(l_as_of_date), l_start_date) into
849: l_p_as_of_date from dual;

Line 847: -- select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;

843: l_name :=
844: 'replace(fnd_message.get_string(''FII'',''FII_QUARTER_LABEL''),''&QUARTER_NUMBER'',t.sequence)';
845: select nvl(fii_time_api.ent_pqtr_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
846: IF (l_time_comp = 'SEQUENTIAL') THEN
847: -- select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
848: select nvl(fii_time_api.ent_sd_pqtr_END(l_as_of_date), l_start_date) into
849: l_p_as_of_date from dual;
850:
851: SELECT ent_qtr_id into l_curr_effective_num

Line 849: l_p_as_of_date from dual;

845: select nvl(fii_time_api.ent_pqtr_END(l_as_of_date), l_start_date) into l_cy_period_END from dual;
846: IF (l_time_comp = 'SEQUENTIAL') THEN
847: -- select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
848: select nvl(fii_time_api.ent_sd_pqtr_END(l_as_of_date), l_start_date) into
849: l_p_as_of_date from dual;
850:
851: SELECT ent_qtr_id into l_curr_effective_num
852: FROM fii_time_ent_qtr
853: WHERE l_as_of_date between start_date AND END_date;

Line 854: --select nvl(fii_time_api.ent_sd_lysqtr_END(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date)), l_start_date) into l_begin_date from dual;

850:
851: SELECT ent_qtr_id into l_curr_effective_num
852: FROM fii_time_ent_qtr
853: WHERE l_as_of_date between start_date AND END_date;
854: --select nvl(fii_time_api.ent_sd_lysqtr_END(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date)), l_start_date) into l_begin_date from dual;
855: select
856: nvl(fii_time_api.ent_sd_lysqtr_END(nvl(fii_time_api.ent_sd_lysqtr_END(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date)),
857: l_start_date)), l_start_date) into l_begin_date from dual;
858:

Line 857: l_start_date)), l_start_date) into l_begin_date from dual;

853: WHERE l_as_of_date between start_date AND END_date;
854: --select nvl(fii_time_api.ent_sd_lysqtr_END(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date)), l_start_date) into l_begin_date from dual;
855: select
856: nvl(fii_time_api.ent_sd_lysqtr_END(nvl(fii_time_api.ent_sd_lysqtr_END(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date)),
857: l_start_date)), l_start_date) into l_begin_date from dual;
858:
859: --select nvl(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date), l_start_date-1) into l_start from dual;
860: select
861: fii_time_api.ent_sd_lysqtr_END(nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date),

Line 859: --select nvl(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date), l_start_date-1) into l_start from dual;

855: select
856: nvl(fii_time_api.ent_sd_lysqtr_END(nvl(fii_time_api.ent_sd_lysqtr_END(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date)),
857: l_start_date)), l_start_date) into l_begin_date from dual;
858:
859: --select nvl(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date), l_start_date-1) into l_start from dual;
860: select
861: fii_time_api.ent_sd_lysqtr_END(nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date),
862: l_start_date-1)) into l_start from dual;
863:

Line 862: l_start_date-1)) into l_start from dual;

858:
859: --select nvl(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date), l_start_date-1) into l_start from dual;
860: select
861: fii_time_api.ent_sd_lysqtr_END(nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date),
862: l_start_date-1)) into l_start from dual;
863:
864: ELSE
865: select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
866: SELECT sequence into l_curr_effective_num

Line 865: select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;

861: fii_time_api.ent_sd_lysqtr_END(nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date),
862: l_start_date-1)) into l_start from dual;
863:
864: ELSE
865: select nvl(fii_time_api.ent_sd_lysqtr_END(l_as_of_date), l_start_date) into l_p_as_of_date from dual;
866: SELECT sequence into l_curr_effective_num
867: FROM fii_time_ent_qtr
868: WHERE l_as_of_date between start_date AND END_date;
869: l_begin_date := l_p_as_of_date;

Line 870: select nvl(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date), l_start_date) into l_start from dual;

866: SELECT sequence into l_curr_effective_num
867: FROM fii_time_ent_qtr
868: WHERE l_as_of_date between start_date AND END_date;
869: l_begin_date := l_p_as_of_date;
870: select nvl(fii_time_api.ent_sd_lysqtr_END(l_p_as_of_date), l_start_date) into l_start from dual;
871: END IF;
872: WHEN 'FII_TIME_ENT_YEAR' THEN
873: l_period_type := 128;
874: l_pk := 'ent_year_id';