APPS.FEM_DIMENSION_UTIL_PKG dependencies on FEM_CALENDARS_B

Line 2259: SELECT fem_calendars_b_s.NEXTVAL

2255: WHEN 'SOURCE_SYSTEM' THEN
2256: SELECT fem_source_systems_b_s.NEXTVAL
2257: INTO v_mem_id FROM dual;
2258: WHEN 'CALENDAR' THEN
2259: SELECT fem_calendars_b_s.NEXTVAL
2260: INTO v_mem_id FROM dual;
2261: WHEN 'FLEX' THEN
2262: SELECT fnd_flex_values_s.NEXTVAL
2263: INTO v_mem_id FROM dual;

Line 2339: SELECT fem_calendars_b_s.NEXTVAL

2335: WHEN 'SOURCE_SYSTEM' THEN
2336: SELECT fem_source_systems_b_s.NEXTVAL
2337: INTO v_mem_id FROM dual;
2338: WHEN 'CALENDAR' THEN
2339: SELECT fem_calendars_b_s.NEXTVAL
2340: INTO v_mem_id FROM dual;
2341: WHEN 'FLEX' THEN
2342: SELECT fnd_flex_values_s.NEXTVAL
2343: INTO v_mem_id FROM dual;

Line 2465: SELECT fem_calendars_b_s.NEXTVAL

2461: WHEN 'SOURCE_SYSTEM' THEN
2462: SELECT fem_source_systems_b_s.NEXTVAL
2463: INTO v_mem_id FROM dual;
2464: WHEN 'CALENDAR' THEN
2465: SELECT fem_calendars_b_s.NEXTVAL
2466: INTO v_mem_id FROM dual;
2467: WHEN 'FLEX' THEN
2468: SELECT fnd_flex_values_s.NEXTVAL
2469: INTO v_mem_id FROM dual;

Line 2585: FROM fem_calendars_b

2581:
2582: BEGIN
2583: SELECT LPAD(TO_CHAR(calendar_id),5,'0')
2584: INTO v_calendar_chr
2585: FROM fem_calendars_b
2586: WHERE calendar_id = p_calendar_id;
2587: EXCEPTION
2588: WHEN no_data_found THEN
2589: RETURN null;

Line 2659: FROM fem_calendars_b

2655:
2656: BEGIN
2657: SELECT LPAD(TO_CHAR(calendar_id),5,'0')
2658: INTO v_calendar_chr
2659: FROM fem_calendars_b
2660: WHERE calendar_display_code = p_calendar_dc;
2661: EXCEPTION
2662: WHEN no_data_found THEN
2663: RETURN null;

Line 2797: FROM fem_calendars_b

2793:
2794: BEGIN
2795: SELECT LPAD(TO_CHAR(calendar_id),5,'0')
2796: INTO v_calendar_chr
2797: FROM fem_calendars_b
2798: WHERE calendar_id = p_calendar_id;
2799: EXCEPTION
2800: WHEN no_data_found THEN
2801: v_token_value := FEM_Dimension_Util_Pkg.Get_Dimension_Name(

Line 2942: FROM fem_calendars_b

2938:
2939: BEGIN
2940: SELECT LPAD(TO_CHAR(calendar_id),5,'0')
2941: INTO v_calendar_chr
2942: FROM fem_calendars_b
2943: WHERE calendar_id = p_calendar_id;
2944: EXCEPTION
2945: WHEN no_data_found THEN
2946: v_token_value := FEM_Dimension_Util_Pkg.Get_Dimension_Name(

Line 6218: from fem_calendars_b

6214: -- of the assignment
6215: BEGIN
6216: select calendar_id
6217: into v_first_period_calendar_id
6218: from fem_calendars_b
6219: where calendar_display_code = p_first_period_calendar;
6220: EXCEPTION
6221: WHEN no_data_found THEN
6222: RAISE e_null_param_value;

Line 6251: from fem_calendars_b

6247: -- of the assignment
6248: BEGIN
6249: select calendar_id
6250: into v_last_period_calendar_id
6251: from fem_calendars_b
6252: where calendar_display_code = p_last_period_calendar;
6253: EXCEPTION
6254: WHEN no_data_found THEN
6255: RAISE e_null_param_value;

Line 6705: from fem_calendars_b

6701: -- of the assignment
6702: BEGIN
6703: select calendar_id
6704: into v_first_period_calendar_id
6705: from fem_calendars_b
6706: where calendar_display_code = p_first_period_calendar;
6707: EXCEPTION
6708: WHEN no_data_found THEN
6709: RAISE e_null_param_value;

Line 6738: from fem_calendars_b

6734: -- of the assignment
6735: BEGIN
6736: select calendar_id
6737: into v_last_period_calendar_id
6738: from fem_calendars_b
6739: where calendar_display_code = p_last_period_calendar;
6740: EXCEPTION
6741: WHEN no_data_found THEN
6742: RAISE e_null_param_value;