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.BEN_PD_COPY_TO_BEN_ONE dependencies on FF_FORMULAS_F

Line 988: INSERT INTO ff_formulas_f

984: hr_utility.set_location (' p_effective_end_date' || p_effective_end_date,10);
985:
986: --Perform an insert if the dml operation is insert
987:
988: INSERT INTO ff_formulas_f
989: (formula_id, effective_start_date, effective_end_date,
990: legislation_code, formula_type_id, formula_name,
991: description, formula_text, sticky_flag,
992: compile_flag, business_group_id, last_update_date,

Line 1017: UPDATE ff_formulas_f

1013: hr_utility.set_location (' p_effective_end_date' || p_effective_end_date,10);
1014:
1015: IF p_datetrack_mode = hr_api.g_update
1016: THEN
1017: UPDATE ff_formulas_f
1018: SET effective_end_date = (p_process_date - 1),
1019: last_update_date = p_last_update_date,
1020: last_updated_by = p_last_updated_by,
1021: last_update_login = p_last_update_login,

Line 1029: INSERT INTO ff_formulas_f

1025: AND effective_start_date = p_effective_start_date
1026: AND effective_end_date = p_effective_end_date
1027: AND business_group_id = p_business_group_id;
1028:
1029: INSERT INTO ff_formulas_f
1030: (formula_id, effective_start_date, effective_end_date,
1031: legislation_code, formula_type_id, formula_name,
1032: description, formula_text, sticky_flag,
1033: compile_flag, business_group_id,

Line 1048: UPDATE ff_formulas_f

1044: END IF;
1045:
1046: IF p_datetrack_mode = hr_api.g_correction
1047: THEN
1048: UPDATE ff_formulas_f
1049: SET legislation_code = p_legislation_code,
1050: formula_type_id = p_formula_type_id,
1051: formula_name = p_formula_name,
1052: description = p_description,

Line 1069: UPDATE ff_formulas_f

1065: END IF;
1066:
1067: IF p_datetrack_mode = hr_api.g_update_override
1068: THEN
1069: UPDATE ff_formulas_f
1070: SET effective_end_date = (p_process_date - 1),
1071: last_update_date = p_last_update_date,
1072: last_updated_by = p_last_updated_by,
1073: last_update_login = p_last_update_login,

Line 1081: DELETE FROM ff_formulas_f

1077: AND effective_start_date = p_effective_start_date
1078: AND effective_end_date = p_effective_end_date
1079: AND business_group_id = p_business_group_id;
1080:
1081: DELETE FROM ff_formulas_f
1082: WHERE formula_id = p_formula_id
1083: AND business_group_id = p_business_group_id
1084: AND effective_start_date >= p_process_date;
1085:

Line 1086: INSERT INTO ff_formulas_f

1082: WHERE formula_id = p_formula_id
1083: AND business_group_id = p_business_group_id
1084: AND effective_start_date >= p_process_date;
1085:
1086: INSERT INTO ff_formulas_f
1087: (formula_id, effective_start_date, effective_end_date,
1088: legislation_code, formula_type_id, formula_name,
1089: description, formula_text, sticky_flag,
1090: compile_flag, business_group_id,

Line 1106: UPDATE ff_formulas_f

1102: END IF;
1103:
1104: IF p_datetrack_mode = hr_api.g_update_change_insert
1105: THEN
1106: UPDATE ff_formulas_f
1107: SET effective_end_date = (p_process_date - 1),
1108: last_update_date = p_last_update_date,
1109: last_updated_by = p_last_updated_by,
1110: last_update_login = p_last_update_login,

Line 1118: INSERT INTO ff_formulas_f

1114: AND business_group_id = p_business_group_id
1115: AND effective_start_date = p_effective_start_date
1116: AND effective_start_date = p_effective_end_date;
1117:
1118: INSERT INTO ff_formulas_f
1119: (formula_id, effective_start_date, effective_end_date,
1120: legislation_code, formula_type_id, formula_name,
1121: description, formula_text, sticky_flag,
1122: compile_flag, business_group_id,

Line 1210: FROM ff_formulas_f fff

1206: c_new_pk_id NUMBER
1207: )
1208: IS
1209: SELECT fff.formula_id new_value
1210: FROM ff_formulas_f fff
1211: WHERE fff.formula_name = c_fff_name -- 5250824, 5253679 (FF Case Sensitive)
1212: AND fff.business_group_id = c_business_group_id
1213: AND fff.formula_id <> c_new_pk_id
1214: AND EXISTS (

Line 1216: FROM ff_formulas_f fff1

1212: AND fff.business_group_id = c_business_group_id
1213: AND fff.formula_id <> c_new_pk_id
1214: AND EXISTS (
1215: SELECT NULL
1216: FROM ff_formulas_f fff1
1217: WHERE fff1.formula_name = c_fff_name -- 5250824 , 5253679 (FF Case Sensitive)
1218: AND fff1.business_group_id = c_business_group_id
1219: AND fff1.effective_start_date <= c_effective_start_date)
1220: AND EXISTS (

Line 1222: FROM ff_formulas_f fff2

1218: AND fff1.business_group_id = c_business_group_id
1219: AND fff1.effective_start_date <= c_effective_start_date)
1220: AND EXISTS (
1221: SELECT NULL
1222: FROM ff_formulas_f fff2
1223: WHERE fff2.formula_name = c_fff_name -- 5250824, 5253679 (FF Case Sensitive)
1224: AND fff2.business_group_id = c_business_group_id
1225: AND fff2.effective_end_date >= c_effective_end_date);
1226:

Line 1258: l_formula_name ff_formulas_f.formula_name%TYPE; -- 5253679 (FF Case Sensitive)

1254: l_min_esd DATE;
1255: l_max_eed DATE;
1256: l_formula_type_id NUMBER;
1257: l_effective_date DATE;
1258: l_formula_name ff_formulas_f.formula_name%TYPE; -- 5253679 (FF Case Sensitive)
1259: BEGIN
1260: --
1261: hr_utility.set_location ('Entering Formula creation ', 10);
1262:

Line 1375: dt_api.check_min_max_dates (p_base_table_name => 'FF_FORMULAS_F',

1371: THEN
1372: --
1373: --TEMPIK
1374: l_dt_rec_found :=
1375: dt_api.check_min_max_dates (p_base_table_name => 'FF_FORMULAS_F',
1376: p_base_key_column => 'FORMULA_ID',
1377: p_base_key_value => l_new_value,
1378: p_from_date => l_min_esd,
1379: p_to_date => l_max_eed

Line 1457: ben_pd_copy_to_ben_one.ben_chk_col_len ('FORMULA_NAME', 'FF_FORMULAS_F',l_prefix|| r_fff.information112|| l_suffix);

1453: --
1454: END IF;
1455:
1456: --
1457: ben_pd_copy_to_ben_one.ben_chk_col_len ('FORMULA_NAME', 'FF_FORMULAS_F',l_prefix|| r_fff.information112|| l_suffix);
1458: l_effective_date := r_fff.information2;
1459:
1460: IF ( ben_pd_copy_to_ben_one.g_copy_effective_date IS NOT NULL
1461: AND l_effective_date < ben_pd_copy_to_ben_one.g_copy_effective_date

Line 1471: hr_utility.set_location (' In the Insert FF_FORMULAS_F ', 70);

1467: IF l_first_rec AND NOT l_update
1468: THEN
1469: -- Call Create routine.
1470: --
1471: hr_utility.set_location (' In the Insert FF_FORMULAS_F ', 70);
1472:
1473: --
1474: --
1475: --