APPS.FEM_INTG_CAL_RULE_ENG_PKG dependencies on FEM_INTG_CALENDAR_MAP

Line 359: FEM_INTG_CALENDAR_MAP M,

355: pv_calendar_id,
356: pv_effective_period_num_min,
357: pv_effective_period_num_max
358: FROM
359: FEM_INTG_CALENDAR_MAP M,
360: FEM_OBJECT_DEFINITION_B D,
361: FEM_OBJECT_CATALOG_B C
362: WHERE
363: M.PERIOD_SET_NAME = p_period_set_name AND

Line 623: DELETE FROM FEM_INTG_CALENDAR_MAP

619: -- Delete an invalid mapping record. The next run will create missing
620: -- Calendar, Time Dimension Group, and/or hierarchy and will create a
621: -- valid mapping record.
622: --
623: DELETE FROM FEM_INTG_CALENDAR_MAP
624: WHERE CAL_PER_HIER_OBJ_DEF_ID = pv_cal_per_hier_obj_def_id;
625:
626: COMMIT;
627:

Line 1206: INSERT INTO FEM_INTG_CALENDAR_MAP(

1202:
1203: --
1204: -- Create a mapping record
1205: --
1206: INSERT INTO FEM_INTG_CALENDAR_MAP(
1207: PERIOD_SET_NAME,
1208: PERIOD_TYPE,
1209: CAL_PER_HIER_OBJ_DEF_ID,
1210: DIMENSION_GROUP_ID,

Line 2203: UPDATE FEM_INTG_CALENDAR_MAP

2199: p_token2 => 'TIME',
2200: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2201: );
2202:
2203: UPDATE FEM_INTG_CALENDAR_MAP
2204: SET EFFECTIVE_PERIOD_NUM_MIN = pv_effective_period_num_low,
2205: LAST_UPDATE_DATE = SYSDATE,
2206: LAST_UPDATED_BY = pv_user_id,
2207: LAST_UPDATE_LOGIN = pv_login_id

Line 2213: UPDATE FEM_INTG_CALENDAR_MAP

2209: AND pv_effective_period_num_low < NVL(EFFECTIVE_PERIOD_NUM_MIN,3000*10000);
2210:
2211: pv_row_count_tot := pv_row_count_tot + SQL%ROWCOUNT;
2212:
2213: UPDATE FEM_INTG_CALENDAR_MAP
2214: SET EFFECTIVE_PERIOD_NUM_MAX = pv_effective_period_num_high,
2215: LAST_UPDATE_DATE = SYSDATE,
2216: LAST_UPDATED_BY = pv_user_id,
2217: LAST_UPDATE_LOGIN = pv_login_id