APPS.FEM_GL_POST_PROCESS_PKG dependencies on FEM_CAL_PERIODS_B

Line 27: pv_cal_per_calendar_id fem_cal_periods_b.calendar_id%TYPE;

23: pv_attr_label fem_dim_attributes_b.attribute_varchar_label%TYPE;
24: pv_dim_name fem_dimensions_tl.dimension_name%TYPE;
25:
26: pv_obj_type_cd fem_object_catalog_b.object_type_code%TYPE;
27: pv_cal_per_calendar_id fem_cal_periods_b.calendar_id%TYPE;
28: pv_ledger_calendar_id fem_hierarchies.calendar_id%TYPE;
29: pv_precedent_dataset_code fem_datasets_b.dataset_code%TYPE;
30:
31: Invalid_Budget_ID EXCEPTION;

Line 1570: v_cal_per_dim_group_id fem_cal_periods_b.dimension_group_id%TYPE;

1566: -- one.
1567: -- x_msg_count Returns the number of end-user messages generated.
1568: -- ======================================================================
1569:
1570: v_cal_per_dim_group_id fem_cal_periods_b.dimension_group_id%TYPE;
1571: v_rows_deleted NUMBER;
1572:
1573: v_param_name fem_dimensions_tl.dimension_name%TYPE;
1574: v_param_value VARCHAR2(40);

Line 1670: FROM fem_cal_periods_b

1666: -- Get DIMENSION_GROUP_DISPLAY_CODE for the Calendar Period.
1667:
1668: SELECT dimension_group_id
1669: INTO v_cal_per_dim_group_id
1670: FROM fem_cal_periods_b
1671: WHERE cal_period_id = pv_cal_period_id
1672: AND personal_flag = 'N';
1673:
1674: v_attr_name := FEM_DIMENSION_UTIL_PKG.Get_Dim_Attr_Name

Line 2610: v_cal_per_dim_group_id fem_cal_periods_b.dimension_group_id%TYPE;

2606: -- Notes
2607: -- Called by Validate_Engine_Parameters
2608: -- =======================================================================
2609:
2610: v_cal_per_dim_group_id fem_cal_periods_b.dimension_group_id%TYPE;
2611: v_cp_exists_in_hier VARCHAR2(1);
2612:
2613: BEGIN
2614:

Line 2628: FROM fem_cal_periods_b

2624: -- Display Code, and set the former into a package variable.
2625:
2626: SELECT calendar_id, dimension_group_id
2627: INTO pv_cal_per_calendar_id, v_cal_per_dim_group_id
2628: FROM fem_cal_periods_b
2629: WHERE cal_period_id = pv_cal_period_id
2630: AND enabled_flag = 'Y'
2631: AND personal_flag = 'N';
2632: