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.HR_PERF_MGMT_PLAN_INTERNAL dependencies on HR_API

Line 331: hr_api.mandatory_arg_error (p_api_name => l_proc, p_argument => 'P_PLAN_ID', p_argument_value => p_plan_id);

327:
328: IF p_plan_id IS NULL
329: THEN
330: log_message ('Plan ID is passed as null, leaving.' || l_proc);
331: hr_api.mandatory_arg_error (p_api_name => l_proc, p_argument => 'P_PLAN_ID', p_argument_value => p_plan_id);
332: END IF;
333:
334: OPEN csr_plan_supervisor (p_plan_id);
335:

Line 1891: p_scorecard_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,

1887: PROCEDURE update_scorecard_for_person (
1888: p_effective_date IN DATE,
1889: p_scorecard_id IN NUMBER,
1890: p_object_version_number IN NUMBER,
1891: p_scorecard_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1892: p_start_date IN DATE DEFAULT hr_api.g_date,
1893: p_end_date IN DATE DEFAULT hr_api.g_date,
1894: p_status_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1895: p_supervisor_id IN NUMBER DEFAULT NULL,

Line 1892: p_start_date IN DATE DEFAULT hr_api.g_date,

1888: p_effective_date IN DATE,
1889: p_scorecard_id IN NUMBER,
1890: p_object_version_number IN NUMBER,
1891: p_scorecard_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1892: p_start_date IN DATE DEFAULT hr_api.g_date,
1893: p_end_date IN DATE DEFAULT hr_api.g_date,
1894: p_status_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1895: p_supervisor_id IN NUMBER DEFAULT NULL,
1896: p_supervisor_assignment_id IN NUMBER DEFAULT NULL

Line 1893: p_end_date IN DATE DEFAULT hr_api.g_date,

1889: p_scorecard_id IN NUMBER,
1890: p_object_version_number IN NUMBER,
1891: p_scorecard_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1892: p_start_date IN DATE DEFAULT hr_api.g_date,
1893: p_end_date IN DATE DEFAULT hr_api.g_date,
1894: p_status_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1895: p_supervisor_id IN NUMBER DEFAULT NULL,
1896: p_supervisor_assignment_id IN NUMBER DEFAULT NULL
1897: )

Line 1894: p_status_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

1890: p_object_version_number IN NUMBER,
1891: p_scorecard_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1892: p_start_date IN DATE DEFAULT hr_api.g_date,
1893: p_end_date IN DATE DEFAULT hr_api.g_date,
1894: p_status_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
1895: p_supervisor_id IN NUMBER DEFAULT NULL,
1896: p_supervisor_assignment_id IN NUMBER DEFAULT NULL
1897: )
1898: IS

Line 2299: p_scorecard_id IN NUMBER DEFAULT hr_api.g_number,

2295: PROCEDURE update_scorecard_objective (
2296: p_effective_date IN DATE,
2297: p_objective_id IN NUMBER,
2298: p_object_version_number IN NUMBER,
2299: p_scorecard_id IN NUMBER DEFAULT hr_api.g_number,
2300: p_start_date IN DATE DEFAULT hr_api.g_date,
2301: p_end_date IN DATE DEFAULT hr_api.g_date,
2302: p_objective_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2303: p_valid_from IN DATE DEFAULT hr_api.g_date,

Line 2300: p_start_date IN DATE DEFAULT hr_api.g_date,

2296: p_effective_date IN DATE,
2297: p_objective_id IN NUMBER,
2298: p_object_version_number IN NUMBER,
2299: p_scorecard_id IN NUMBER DEFAULT hr_api.g_number,
2300: p_start_date IN DATE DEFAULT hr_api.g_date,
2301: p_end_date IN DATE DEFAULT hr_api.g_date,
2302: p_objective_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2303: p_valid_from IN DATE DEFAULT hr_api.g_date,
2304: p_valid_to IN DATE DEFAULT hr_api.g_date,

Line 2301: p_end_date IN DATE DEFAULT hr_api.g_date,

2297: p_objective_id IN NUMBER,
2298: p_object_version_number IN NUMBER,
2299: p_scorecard_id IN NUMBER DEFAULT hr_api.g_number,
2300: p_start_date IN DATE DEFAULT hr_api.g_date,
2301: p_end_date IN DATE DEFAULT hr_api.g_date,
2302: p_objective_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2303: p_valid_from IN DATE DEFAULT hr_api.g_date,
2304: p_valid_to IN DATE DEFAULT hr_api.g_date,
2305: p_target_date IN DATE DEFAULT hr_api.g_date,

Line 2302: p_objective_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,

2298: p_object_version_number IN NUMBER,
2299: p_scorecard_id IN NUMBER DEFAULT hr_api.g_number,
2300: p_start_date IN DATE DEFAULT hr_api.g_date,
2301: p_end_date IN DATE DEFAULT hr_api.g_date,
2302: p_objective_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2303: p_valid_from IN DATE DEFAULT hr_api.g_date,
2304: p_valid_to IN DATE DEFAULT hr_api.g_date,
2305: p_target_date IN DATE DEFAULT hr_api.g_date,
2306: p_copied_from_library_id IN NUMBER DEFAULT hr_api.g_number,

Line 2303: p_valid_from IN DATE DEFAULT hr_api.g_date,

2299: p_scorecard_id IN NUMBER DEFAULT hr_api.g_number,
2300: p_start_date IN DATE DEFAULT hr_api.g_date,
2301: p_end_date IN DATE DEFAULT hr_api.g_date,
2302: p_objective_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2303: p_valid_from IN DATE DEFAULT hr_api.g_date,
2304: p_valid_to IN DATE DEFAULT hr_api.g_date,
2305: p_target_date IN DATE DEFAULT hr_api.g_date,
2306: p_copied_from_library_id IN NUMBER DEFAULT hr_api.g_number,
2307: p_next_review_date IN DATE DEFAULT hr_api.g_date,

Line 2304: p_valid_to IN DATE DEFAULT hr_api.g_date,

2300: p_start_date IN DATE DEFAULT hr_api.g_date,
2301: p_end_date IN DATE DEFAULT hr_api.g_date,
2302: p_objective_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2303: p_valid_from IN DATE DEFAULT hr_api.g_date,
2304: p_valid_to IN DATE DEFAULT hr_api.g_date,
2305: p_target_date IN DATE DEFAULT hr_api.g_date,
2306: p_copied_from_library_id IN NUMBER DEFAULT hr_api.g_number,
2307: p_next_review_date IN DATE DEFAULT hr_api.g_date,
2308: p_group_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 2305: p_target_date IN DATE DEFAULT hr_api.g_date,

2301: p_end_date IN DATE DEFAULT hr_api.g_date,
2302: p_objective_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2303: p_valid_from IN DATE DEFAULT hr_api.g_date,
2304: p_valid_to IN DATE DEFAULT hr_api.g_date,
2305: p_target_date IN DATE DEFAULT hr_api.g_date,
2306: p_copied_from_library_id IN NUMBER DEFAULT hr_api.g_number,
2307: p_next_review_date IN DATE DEFAULT hr_api.g_date,
2308: p_group_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2309: p_priority_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 2306: p_copied_from_library_id IN NUMBER DEFAULT hr_api.g_number,

2302: p_objective_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2303: p_valid_from IN DATE DEFAULT hr_api.g_date,
2304: p_valid_to IN DATE DEFAULT hr_api.g_date,
2305: p_target_date IN DATE DEFAULT hr_api.g_date,
2306: p_copied_from_library_id IN NUMBER DEFAULT hr_api.g_number,
2307: p_next_review_date IN DATE DEFAULT hr_api.g_date,
2308: p_group_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2309: p_priority_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2310: p_appraise_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 2307: p_next_review_date IN DATE DEFAULT hr_api.g_date,

2303: p_valid_from IN DATE DEFAULT hr_api.g_date,
2304: p_valid_to IN DATE DEFAULT hr_api.g_date,
2305: p_target_date IN DATE DEFAULT hr_api.g_date,
2306: p_copied_from_library_id IN NUMBER DEFAULT hr_api.g_number,
2307: p_next_review_date IN DATE DEFAULT hr_api.g_date,
2308: p_group_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2309: p_priority_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2310: p_appraise_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2311: p_weighting_percent IN NUMBER DEFAULT hr_api.g_number,

Line 2308: p_group_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

2304: p_valid_to IN DATE DEFAULT hr_api.g_date,
2305: p_target_date IN DATE DEFAULT hr_api.g_date,
2306: p_copied_from_library_id IN NUMBER DEFAULT hr_api.g_number,
2307: p_next_review_date IN DATE DEFAULT hr_api.g_date,
2308: p_group_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2309: p_priority_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2310: p_appraise_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2311: p_weighting_percent IN NUMBER DEFAULT hr_api.g_number,
2312: p_target_value IN NUMBER DEFAULT hr_api.g_number,

Line 2309: p_priority_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

2305: p_target_date IN DATE DEFAULT hr_api.g_date,
2306: p_copied_from_library_id IN NUMBER DEFAULT hr_api.g_number,
2307: p_next_review_date IN DATE DEFAULT hr_api.g_date,
2308: p_group_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2309: p_priority_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2310: p_appraise_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2311: p_weighting_percent IN NUMBER DEFAULT hr_api.g_number,
2312: p_target_value IN NUMBER DEFAULT hr_api.g_number,
2313: p_uom_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 2310: p_appraise_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,

2306: p_copied_from_library_id IN NUMBER DEFAULT hr_api.g_number,
2307: p_next_review_date IN DATE DEFAULT hr_api.g_date,
2308: p_group_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2309: p_priority_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2310: p_appraise_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2311: p_weighting_percent IN NUMBER DEFAULT hr_api.g_number,
2312: p_target_value IN NUMBER DEFAULT hr_api.g_number,
2313: p_uom_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2314: p_measurement_style_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 2311: p_weighting_percent IN NUMBER DEFAULT hr_api.g_number,

2307: p_next_review_date IN DATE DEFAULT hr_api.g_date,
2308: p_group_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2309: p_priority_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2310: p_appraise_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2311: p_weighting_percent IN NUMBER DEFAULT hr_api.g_number,
2312: p_target_value IN NUMBER DEFAULT hr_api.g_number,
2313: p_uom_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2314: p_measurement_style_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2315: p_measure_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 2312: p_target_value IN NUMBER DEFAULT hr_api.g_number,

2308: p_group_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2309: p_priority_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2310: p_appraise_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2311: p_weighting_percent IN NUMBER DEFAULT hr_api.g_number,
2312: p_target_value IN NUMBER DEFAULT hr_api.g_number,
2313: p_uom_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2314: p_measurement_style_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2315: p_measure_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2316: p_measure_type_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 2313: p_uom_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

2309: p_priority_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2310: p_appraise_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2311: p_weighting_percent IN NUMBER DEFAULT hr_api.g_number,
2312: p_target_value IN NUMBER DEFAULT hr_api.g_number,
2313: p_uom_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2314: p_measurement_style_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2315: p_measure_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2316: p_measure_type_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2317: p_measure_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 2314: p_measurement_style_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

2310: p_appraise_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2311: p_weighting_percent IN NUMBER DEFAULT hr_api.g_number,
2312: p_target_value IN NUMBER DEFAULT hr_api.g_number,
2313: p_uom_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2314: p_measurement_style_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2315: p_measure_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2316: p_measure_type_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2317: p_measure_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2318: p_details IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 2315: p_measure_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,

2311: p_weighting_percent IN NUMBER DEFAULT hr_api.g_number,
2312: p_target_value IN NUMBER DEFAULT hr_api.g_number,
2313: p_uom_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2314: p_measurement_style_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2315: p_measure_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2316: p_measure_type_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2317: p_measure_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2318: p_details IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2319: p_success_criteria IN VARCHAR2 DEFAULT hr_api.g_varchar2,

Line 2316: p_measure_type_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,

2312: p_target_value IN NUMBER DEFAULT hr_api.g_number,
2313: p_uom_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2314: p_measurement_style_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2315: p_measure_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2316: p_measure_type_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2317: p_measure_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2318: p_details IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2319: p_success_criteria IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2320: p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 2317: p_measure_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,

2313: p_uom_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2314: p_measurement_style_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2315: p_measure_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2316: p_measure_type_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2317: p_measure_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2318: p_details IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2319: p_success_criteria IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2320: p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
2321: )

Line 2318: p_details IN VARCHAR2 DEFAULT hr_api.g_varchar2,

2314: p_measurement_style_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2315: p_measure_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2316: p_measure_type_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2317: p_measure_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2318: p_details IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2319: p_success_criteria IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2320: p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
2321: )
2322: IS

Line 2319: p_success_criteria IN VARCHAR2 DEFAULT hr_api.g_varchar2,

2315: p_measure_name IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2316: p_measure_type_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2317: p_measure_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2318: p_details IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2319: p_success_criteria IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2320: p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
2321: )
2322: IS
2323: -- Declare local variables

Line 2320: p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2

2316: p_measure_type_code IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2317: p_measure_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2318: p_details IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2319: p_success_criteria IN VARCHAR2 DEFAULT hr_api.g_varchar2,
2320: p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
2321: )
2322: IS
2323: -- Declare local variables
2324: l_proc VARCHAR2 (72) := g_package || 'update_scorecard_objective';

Line 2430: SET scorecard_id = decode(p_scorecard_id,hr_api.g_number,per_obj_shd.g_old_rec.scorecard_id,p_scorecard_id)

2426: -- procedure to see if a system default is being used. If a system default
2427: -- is being used then we must set to the 'current' argument value.
2428:
2429: UPDATE per_objectives
2430: SET scorecard_id = decode(p_scorecard_id,hr_api.g_number,per_obj_shd.g_old_rec.scorecard_id,p_scorecard_id)
2431: ,start_date = decode(p_start_date,hr_api.g_date,per_obj_shd.g_old_rec.start_date,p_start_date)
2432: ,name = decode(p_objective_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.name,p_objective_name)
2433: ,target_date = l_target_date
2434: ,copied_from_library_id = decode(p_copied_from_library_id,hr_api.g_number,per_obj_shd.g_old_rec.copied_from_library_id,p_copied_from_library_id)

Line 2431: ,start_date = decode(p_start_date,hr_api.g_date,per_obj_shd.g_old_rec.start_date,p_start_date)

2427: -- is being used then we must set to the 'current' argument value.
2428:
2429: UPDATE per_objectives
2430: SET scorecard_id = decode(p_scorecard_id,hr_api.g_number,per_obj_shd.g_old_rec.scorecard_id,p_scorecard_id)
2431: ,start_date = decode(p_start_date,hr_api.g_date,per_obj_shd.g_old_rec.start_date,p_start_date)
2432: ,name = decode(p_objective_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.name,p_objective_name)
2433: ,target_date = l_target_date
2434: ,copied_from_library_id = decode(p_copied_from_library_id,hr_api.g_number,per_obj_shd.g_old_rec.copied_from_library_id,p_copied_from_library_id)
2435: ,next_review_date = l_next_review_date

Line 2432: ,name = decode(p_objective_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.name,p_objective_name)

2428:
2429: UPDATE per_objectives
2430: SET scorecard_id = decode(p_scorecard_id,hr_api.g_number,per_obj_shd.g_old_rec.scorecard_id,p_scorecard_id)
2431: ,start_date = decode(p_start_date,hr_api.g_date,per_obj_shd.g_old_rec.start_date,p_start_date)
2432: ,name = decode(p_objective_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.name,p_objective_name)
2433: ,target_date = l_target_date
2434: ,copied_from_library_id = decode(p_copied_from_library_id,hr_api.g_number,per_obj_shd.g_old_rec.copied_from_library_id,p_copied_from_library_id)
2435: ,next_review_date = l_next_review_date
2436: ,group_code = decode(p_group_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.group_code,p_group_code)

Line 2434: ,copied_from_library_id = decode(p_copied_from_library_id,hr_api.g_number,per_obj_shd.g_old_rec.copied_from_library_id,p_copied_from_library_id)

2430: SET scorecard_id = decode(p_scorecard_id,hr_api.g_number,per_obj_shd.g_old_rec.scorecard_id,p_scorecard_id)
2431: ,start_date = decode(p_start_date,hr_api.g_date,per_obj_shd.g_old_rec.start_date,p_start_date)
2432: ,name = decode(p_objective_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.name,p_objective_name)
2433: ,target_date = l_target_date
2434: ,copied_from_library_id = decode(p_copied_from_library_id,hr_api.g_number,per_obj_shd.g_old_rec.copied_from_library_id,p_copied_from_library_id)
2435: ,next_review_date = l_next_review_date
2436: ,group_code = decode(p_group_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.group_code,p_group_code)
2437: ,priority_code = decode(p_priority_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.priority_code,p_priority_code)
2438: ,appraise_flag = decode(p_appraise_flag,hr_api.g_varchar2,per_obj_shd.g_old_rec.appraise_flag,p_appraise_flag)

Line 2436: ,group_code = decode(p_group_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.group_code,p_group_code)

2432: ,name = decode(p_objective_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.name,p_objective_name)
2433: ,target_date = l_target_date
2434: ,copied_from_library_id = decode(p_copied_from_library_id,hr_api.g_number,per_obj_shd.g_old_rec.copied_from_library_id,p_copied_from_library_id)
2435: ,next_review_date = l_next_review_date
2436: ,group_code = decode(p_group_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.group_code,p_group_code)
2437: ,priority_code = decode(p_priority_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.priority_code,p_priority_code)
2438: ,appraise_flag = decode(p_appraise_flag,hr_api.g_varchar2,per_obj_shd.g_old_rec.appraise_flag,p_appraise_flag)
2439: ,weighting_percent = decode(p_weighting_percent,hr_api.g_number,per_obj_shd.g_old_rec.weighting_percent,p_weighting_percent)
2440: ,target_value = decode(p_target_value,hr_api.g_number,per_obj_shd.g_old_rec.target_value,p_target_value)

Line 2437: ,priority_code = decode(p_priority_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.priority_code,p_priority_code)

2433: ,target_date = l_target_date
2434: ,copied_from_library_id = decode(p_copied_from_library_id,hr_api.g_number,per_obj_shd.g_old_rec.copied_from_library_id,p_copied_from_library_id)
2435: ,next_review_date = l_next_review_date
2436: ,group_code = decode(p_group_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.group_code,p_group_code)
2437: ,priority_code = decode(p_priority_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.priority_code,p_priority_code)
2438: ,appraise_flag = decode(p_appraise_flag,hr_api.g_varchar2,per_obj_shd.g_old_rec.appraise_flag,p_appraise_flag)
2439: ,weighting_percent = decode(p_weighting_percent,hr_api.g_number,per_obj_shd.g_old_rec.weighting_percent,p_weighting_percent)
2440: ,target_value = decode(p_target_value,hr_api.g_number,per_obj_shd.g_old_rec.target_value,p_target_value)
2441: ,uom_code = decode(p_uom_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.uom_code,p_uom_code)

Line 2438: ,appraise_flag = decode(p_appraise_flag,hr_api.g_varchar2,per_obj_shd.g_old_rec.appraise_flag,p_appraise_flag)

2434: ,copied_from_library_id = decode(p_copied_from_library_id,hr_api.g_number,per_obj_shd.g_old_rec.copied_from_library_id,p_copied_from_library_id)
2435: ,next_review_date = l_next_review_date
2436: ,group_code = decode(p_group_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.group_code,p_group_code)
2437: ,priority_code = decode(p_priority_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.priority_code,p_priority_code)
2438: ,appraise_flag = decode(p_appraise_flag,hr_api.g_varchar2,per_obj_shd.g_old_rec.appraise_flag,p_appraise_flag)
2439: ,weighting_percent = decode(p_weighting_percent,hr_api.g_number,per_obj_shd.g_old_rec.weighting_percent,p_weighting_percent)
2440: ,target_value = decode(p_target_value,hr_api.g_number,per_obj_shd.g_old_rec.target_value,p_target_value)
2441: ,uom_code = decode(p_uom_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.uom_code,p_uom_code)
2442: ,measurement_style_code = decode(p_measurement_style_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measurement_style_code,p_measurement_style_code)

Line 2439: ,weighting_percent = decode(p_weighting_percent,hr_api.g_number,per_obj_shd.g_old_rec.weighting_percent,p_weighting_percent)

2435: ,next_review_date = l_next_review_date
2436: ,group_code = decode(p_group_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.group_code,p_group_code)
2437: ,priority_code = decode(p_priority_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.priority_code,p_priority_code)
2438: ,appraise_flag = decode(p_appraise_flag,hr_api.g_varchar2,per_obj_shd.g_old_rec.appraise_flag,p_appraise_flag)
2439: ,weighting_percent = decode(p_weighting_percent,hr_api.g_number,per_obj_shd.g_old_rec.weighting_percent,p_weighting_percent)
2440: ,target_value = decode(p_target_value,hr_api.g_number,per_obj_shd.g_old_rec.target_value,p_target_value)
2441: ,uom_code = decode(p_uom_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.uom_code,p_uom_code)
2442: ,measurement_style_code = decode(p_measurement_style_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measurement_style_code,p_measurement_style_code)
2443: ,measure_name = decode(p_measure_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_name,p_measure_name)

Line 2440: ,target_value = decode(p_target_value,hr_api.g_number,per_obj_shd.g_old_rec.target_value,p_target_value)

2436: ,group_code = decode(p_group_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.group_code,p_group_code)
2437: ,priority_code = decode(p_priority_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.priority_code,p_priority_code)
2438: ,appraise_flag = decode(p_appraise_flag,hr_api.g_varchar2,per_obj_shd.g_old_rec.appraise_flag,p_appraise_flag)
2439: ,weighting_percent = decode(p_weighting_percent,hr_api.g_number,per_obj_shd.g_old_rec.weighting_percent,p_weighting_percent)
2440: ,target_value = decode(p_target_value,hr_api.g_number,per_obj_shd.g_old_rec.target_value,p_target_value)
2441: ,uom_code = decode(p_uom_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.uom_code,p_uom_code)
2442: ,measurement_style_code = decode(p_measurement_style_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measurement_style_code,p_measurement_style_code)
2443: ,measure_name = decode(p_measure_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_name,p_measure_name)
2444: ,measure_type_code = decode(p_measure_type_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_type_code,p_measure_type_code)

Line 2441: ,uom_code = decode(p_uom_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.uom_code,p_uom_code)

2437: ,priority_code = decode(p_priority_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.priority_code,p_priority_code)
2438: ,appraise_flag = decode(p_appraise_flag,hr_api.g_varchar2,per_obj_shd.g_old_rec.appraise_flag,p_appraise_flag)
2439: ,weighting_percent = decode(p_weighting_percent,hr_api.g_number,per_obj_shd.g_old_rec.weighting_percent,p_weighting_percent)
2440: ,target_value = decode(p_target_value,hr_api.g_number,per_obj_shd.g_old_rec.target_value,p_target_value)
2441: ,uom_code = decode(p_uom_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.uom_code,p_uom_code)
2442: ,measurement_style_code = decode(p_measurement_style_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measurement_style_code,p_measurement_style_code)
2443: ,measure_name = decode(p_measure_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_name,p_measure_name)
2444: ,measure_type_code = decode(p_measure_type_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_type_code,p_measure_type_code)
2445: ,measure_comments = decode(p_measure_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_comments,p_measure_comments)

Line 2442: ,measurement_style_code = decode(p_measurement_style_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measurement_style_code,p_measurement_style_code)

2438: ,appraise_flag = decode(p_appraise_flag,hr_api.g_varchar2,per_obj_shd.g_old_rec.appraise_flag,p_appraise_flag)
2439: ,weighting_percent = decode(p_weighting_percent,hr_api.g_number,per_obj_shd.g_old_rec.weighting_percent,p_weighting_percent)
2440: ,target_value = decode(p_target_value,hr_api.g_number,per_obj_shd.g_old_rec.target_value,p_target_value)
2441: ,uom_code = decode(p_uom_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.uom_code,p_uom_code)
2442: ,measurement_style_code = decode(p_measurement_style_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measurement_style_code,p_measurement_style_code)
2443: ,measure_name = decode(p_measure_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_name,p_measure_name)
2444: ,measure_type_code = decode(p_measure_type_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_type_code,p_measure_type_code)
2445: ,measure_comments = decode(p_measure_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_comments,p_measure_comments)
2446: ,detail = decode(p_details,hr_api.g_varchar2,per_obj_shd.g_old_rec.detail,p_details)

Line 2443: ,measure_name = decode(p_measure_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_name,p_measure_name)

2439: ,weighting_percent = decode(p_weighting_percent,hr_api.g_number,per_obj_shd.g_old_rec.weighting_percent,p_weighting_percent)
2440: ,target_value = decode(p_target_value,hr_api.g_number,per_obj_shd.g_old_rec.target_value,p_target_value)
2441: ,uom_code = decode(p_uom_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.uom_code,p_uom_code)
2442: ,measurement_style_code = decode(p_measurement_style_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measurement_style_code,p_measurement_style_code)
2443: ,measure_name = decode(p_measure_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_name,p_measure_name)
2444: ,measure_type_code = decode(p_measure_type_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_type_code,p_measure_type_code)
2445: ,measure_comments = decode(p_measure_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_comments,p_measure_comments)
2446: ,detail = decode(p_details,hr_api.g_varchar2,per_obj_shd.g_old_rec.detail,p_details)
2447: ,comments = decode(p_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.comments,p_comments)

Line 2444: ,measure_type_code = decode(p_measure_type_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_type_code,p_measure_type_code)

2440: ,target_value = decode(p_target_value,hr_api.g_number,per_obj_shd.g_old_rec.target_value,p_target_value)
2441: ,uom_code = decode(p_uom_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.uom_code,p_uom_code)
2442: ,measurement_style_code = decode(p_measurement_style_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measurement_style_code,p_measurement_style_code)
2443: ,measure_name = decode(p_measure_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_name,p_measure_name)
2444: ,measure_type_code = decode(p_measure_type_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_type_code,p_measure_type_code)
2445: ,measure_comments = decode(p_measure_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_comments,p_measure_comments)
2446: ,detail = decode(p_details,hr_api.g_varchar2,per_obj_shd.g_old_rec.detail,p_details)
2447: ,comments = decode(p_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.comments,p_comments)
2448: ,success_criteria = decode(p_success_criteria,hr_api.g_varchar2,per_obj_shd.g_old_rec.success_criteria,p_success_criteria)

Line 2445: ,measure_comments = decode(p_measure_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_comments,p_measure_comments)

2441: ,uom_code = decode(p_uom_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.uom_code,p_uom_code)
2442: ,measurement_style_code = decode(p_measurement_style_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measurement_style_code,p_measurement_style_code)
2443: ,measure_name = decode(p_measure_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_name,p_measure_name)
2444: ,measure_type_code = decode(p_measure_type_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_type_code,p_measure_type_code)
2445: ,measure_comments = decode(p_measure_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_comments,p_measure_comments)
2446: ,detail = decode(p_details,hr_api.g_varchar2,per_obj_shd.g_old_rec.detail,p_details)
2447: ,comments = decode(p_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.comments,p_comments)
2448: ,success_criteria = decode(p_success_criteria,hr_api.g_varchar2,per_obj_shd.g_old_rec.success_criteria,p_success_criteria)
2449: WHERE objective_id = p_objective_id;

Line 2446: ,detail = decode(p_details,hr_api.g_varchar2,per_obj_shd.g_old_rec.detail,p_details)

2442: ,measurement_style_code = decode(p_measurement_style_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measurement_style_code,p_measurement_style_code)
2443: ,measure_name = decode(p_measure_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_name,p_measure_name)
2444: ,measure_type_code = decode(p_measure_type_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_type_code,p_measure_type_code)
2445: ,measure_comments = decode(p_measure_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_comments,p_measure_comments)
2446: ,detail = decode(p_details,hr_api.g_varchar2,per_obj_shd.g_old_rec.detail,p_details)
2447: ,comments = decode(p_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.comments,p_comments)
2448: ,success_criteria = decode(p_success_criteria,hr_api.g_varchar2,per_obj_shd.g_old_rec.success_criteria,p_success_criteria)
2449: WHERE objective_id = p_objective_id;
2450:

Line 2447: ,comments = decode(p_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.comments,p_comments)

2443: ,measure_name = decode(p_measure_name,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_name,p_measure_name)
2444: ,measure_type_code = decode(p_measure_type_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_type_code,p_measure_type_code)
2445: ,measure_comments = decode(p_measure_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_comments,p_measure_comments)
2446: ,detail = decode(p_details,hr_api.g_varchar2,per_obj_shd.g_old_rec.detail,p_details)
2447: ,comments = decode(p_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.comments,p_comments)
2448: ,success_criteria = decode(p_success_criteria,hr_api.g_varchar2,per_obj_shd.g_old_rec.success_criteria,p_success_criteria)
2449: WHERE objective_id = p_objective_id;
2450:
2451: --

Line 2448: ,success_criteria = decode(p_success_criteria,hr_api.g_varchar2,per_obj_shd.g_old_rec.success_criteria,p_success_criteria)

2444: ,measure_type_code = decode(p_measure_type_code,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_type_code,p_measure_type_code)
2445: ,measure_comments = decode(p_measure_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.measure_comments,p_measure_comments)
2446: ,detail = decode(p_details,hr_api.g_varchar2,per_obj_shd.g_old_rec.detail,p_details)
2447: ,comments = decode(p_comments,hr_api.g_varchar2,per_obj_shd.g_old_rec.comments,p_comments)
2448: ,success_criteria = decode(p_success_criteria,hr_api.g_varchar2,per_obj_shd.g_old_rec.success_criteria,p_success_criteria)
2449: WHERE objective_id = p_objective_id;
2450:
2451: --
2452: IF g_dbg

Line 6931: --Delete any transactions from HR_API_Transactions and transaction steps

6927: LOOP
6928: FETCH csr_sc_ids
6929: BULK COLLECT INTO l_sc_ids LIMIT 1000;
6930:
6931: --Delete any transactions from HR_API_Transactions and transaction steps
6932: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6933: DELETE FROM hr_api_transaction_steps step
6934: WHERE step.transaction_id IN (
6935: SELECT trn.transaction_id

Line 6933: DELETE FROM hr_api_transaction_steps step

6929: BULK COLLECT INTO l_sc_ids LIMIT 1000;
6930:
6931: --Delete any transactions from HR_API_Transactions and transaction steps
6932: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6933: DELETE FROM hr_api_transaction_steps step
6934: WHERE step.transaction_id IN (
6935: SELECT trn.transaction_id
6936: FROM hr_api_transactions trn
6937: WHERE trn.transaction_ref_id = l_sc_ids (i)

Line 6936: FROM hr_api_transactions trn

6932: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6933: DELETE FROM hr_api_transaction_steps step
6934: WHERE step.transaction_id IN (
6935: SELECT trn.transaction_id
6936: FROM hr_api_transactions trn
6937: WHERE trn.transaction_ref_id = l_sc_ids (i)
6938: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');
6939: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6940: DELETE FROM hr_api_transactions

Line 6940: DELETE FROM hr_api_transactions

6936: FROM hr_api_transactions trn
6937: WHERE trn.transaction_ref_id = l_sc_ids (i)
6938: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');
6939: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6940: DELETE FROM hr_api_transactions
6941: WHERE transaction_ref_id = l_sc_ids (i) AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
6942: -- Delete all score card objectives
6943: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
6944: DELETE FROM per_objectives

Line 7005: hr_api.mandatory_arg_error (p_api_name => 'BACKOUT_PERF_MGMT_PLAN_CP',

7001: hr_utility.set_location ('Entering ' || l_proc, 10);
7002:
7003: IF p_plan_id IS NULL
7004: THEN
7005: hr_api.mandatory_arg_error (p_api_name => 'BACKOUT_PERF_MGMT_PLAN_CP',
7006: p_argument => 'P_PLAN_ID',
7007: p_argument_value => p_plan_id
7008: );
7009: END IF;

Line 7013: hr_api.mandatory_arg_error (p_api_name => 'BACKOUT_PERF_MGMT_PLAN_CP',

7009: END IF;
7010:
7011: IF p_effective_date IS NULL
7012: THEN
7013: hr_api.mandatory_arg_error (p_api_name => 'BACKOUT_PERF_MGMT_PLAN_CP',
7014: p_argument => 'P_EFFECTIVE_DATE',
7015: p_argument_value => p_effective_date
7016: );
7017: END IF;

Line 7105: hr_api.mandatory_arg_error (p_api_name => 'BACKOUT_PERF_MGMT_PLAN',

7101: CLOSE csr_person_ids;
7102:
7103: IF p_plan_id IS NULL
7104: THEN
7105: hr_api.mandatory_arg_error (p_api_name => 'BACKOUT_PERF_MGMT_PLAN',
7106: p_argument => 'P_PLAN_ID',
7107: p_argument_value => p_plan_id
7108: );
7109: END IF;

Line 7113: hr_api.mandatory_arg_error (p_api_name => 'BACKOUT_PERF_MGMT_PLAN',

7109: END IF;
7110:
7111: IF p_effective_date IS NULL
7112: THEN
7113: hr_api.mandatory_arg_error (p_api_name => 'BACKOUT_PERF_MGMT_PLAN',
7114: p_argument => 'P_EFFECTIVE_DATE',
7115: p_argument_value => p_effective_date
7116: );
7117: END IF;

Line 7291: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',

7287: hr_utility.set_location ('Entering ' || l_proc, 10);
7288:
7289: IF p_plan_id IS NULL
7290: THEN
7291: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',
7292: p_argument => 'P_PLAN_ID',
7293: p_argument_value => p_plan_id
7294: );
7295: END IF;

Line 7299: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',

7295: END IF;
7296:
7297: IF p_effective_date IS NULL
7298: THEN
7299: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',
7300: p_argument => 'P_EFFECTIVE_DATE',
7301: p_argument_value => p_effective_date
7302: );
7303: END IF;

Line 7307: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',

7303: END IF;
7304:
7305: IF p_selected_entities_list IS NULL
7306: THEN
7307: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',
7308: p_argument => 'P_SELECTED_ENTITIES_LIST',
7309: p_argument_value => p_selected_entities_list
7310: );
7311: END IF;

Line 7315: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',

7311: END IF;
7312:
7313: IF p_task_code IS NULL
7314: THEN
7315: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',
7316: p_argument => 'P_TASK_CODE',
7317: p_argument_value => p_task_code
7318: );
7319: END IF;

Line 8027: DELETE FROM hr_api_transaction_steps step

8023: --
8024: PROCEDURE remove_scorecard_details (p_scorecard_id IN NUMBER)
8025: IS
8026: BEGIN
8027: DELETE FROM hr_api_transaction_steps step
8028: WHERE step.transaction_id IN (
8029: SELECT trn.transaction_id
8030: FROM hr_api_transactions trn
8031: WHERE trn.transaction_ref_id = p_scorecard_id

Line 8030: FROM hr_api_transactions trn

8026: BEGIN
8027: DELETE FROM hr_api_transaction_steps step
8028: WHERE step.transaction_id IN (
8029: SELECT trn.transaction_id
8030: FROM hr_api_transactions trn
8031: WHERE trn.transaction_ref_id = p_scorecard_id
8032: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');
8033:
8034: DELETE FROM hr_api_transactions

Line 8034: DELETE FROM hr_api_transactions

8030: FROM hr_api_transactions trn
8031: WHERE trn.transaction_ref_id = p_scorecard_id
8032: AND trn.transaction_ref_table = 'PER_PERSONAL_SCORECARDS');
8033:
8034: DELETE FROM hr_api_transactions
8035: WHERE transaction_ref_id = p_scorecard_id AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
8036:
8037: --
8038: DELETE FROM per_objectives

Line 9144: hr_api.mandatory_arg_error (p_api_name => 'ADMIN_TRANSFER_SCORECARD',

9140: );
9141:
9142: IF p_sub_taskcode IS NULL
9143: THEN
9144: hr_api.mandatory_arg_error (p_api_name => 'ADMIN_TRANSFER_SCORECARD',
9145: p_argument => 'P_SUB_TASKCODE',
9146: p_argument_value => p_sub_taskcode
9147: );
9148: END IF;

Line 9150: IF hr_api.not_exists_in_hr_lookups (p_effective_date => p_effective_date,

9146: p_argument_value => p_sub_taskcode
9147: );
9148: END IF;
9149:
9150: IF hr_api.not_exists_in_hr_lookups (p_effective_date => p_effective_date,
9151: p_lookup_type => 'PER_PMP_TRNF_ACTIONS',
9152: p_lookup_code => p_sub_taskcode
9153: )
9154: THEN

Line 9227: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',

9223:
9224: --
9225: IF p_plan_id IS NULL
9226: THEN
9227: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',
9228: p_argument => 'P_PLAN_ID',
9229: p_argument_value => p_plan_id
9230: );
9231: END IF;

Line 9235: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',

9231: END IF;
9232:
9233: IF p_effective_date IS NULL
9234: THEN
9235: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',
9236: p_argument => 'P_EFFECTIVE_DATE',
9237: p_argument_value => p_effective_date
9238: );
9239: END IF;

Line 9243: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',

9239: END IF;
9240:
9241: IF p_selected_entities_list IS NULL
9242: THEN
9243: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',
9244: p_argument => 'P_SELECTED_ENTITIES_LIST',
9245: p_argument_value => p_selected_entities_list
9246: );
9247: END IF;

Line 9251: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',

9247: END IF;
9248:
9249: IF p_task_code IS NULL
9250: THEN
9251: hr_api.mandatory_arg_error (p_api_name => 'PLAN_ADMIN_ACTIONS_CP',
9252: p_argument => 'P_TASK_CODE',
9253: p_argument_value => p_task_code
9254: );
9255: END IF;

Line 9268: IF hr_api.not_exists_in_hr_lookups (p_effective_date => l_effective_date,

9264: END IF;
9265: log_message('l_task_code:'||l_task_code);
9266: log_message('l_sub_taskcode:'||l_sub_taskcode);
9267:
9268: IF hr_api.not_exists_in_hr_lookups (p_effective_date => l_effective_date,
9269: p_lookup_type => 'HR_WPM_ADMIN_ACTIONS',
9270: p_lookup_code => l_task_code
9271: )
9272: THEN

Line 9732: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',

9728:
9729: l_plan_rec csr_get_plan_rec%ROWTYPE;
9730: BEGIN
9731: hr_utility.set_location ('Entering:' || l_proc, 10);
9732: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',
9733: p_argument => 'p_effective_date',
9734: p_argument_value => p_effective_date
9735: );
9736: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',

Line 9736: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',

9732: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',
9733: p_argument => 'p_effective_date',
9734: p_argument_value => p_effective_date
9735: );
9736: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',
9737: p_argument => 'p_plan_id',
9738: p_argument_value => p_plan_id
9739: );
9740: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',

Line 9740: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',

9736: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',
9737: p_argument => 'p_plan_id',
9738: p_argument_value => p_plan_id
9739: );
9740: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',
9741: p_argument => 'p_object_version_number',
9742: p_argument_value => p_object_version_number
9743: );
9744: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',

Line 9744: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',

9740: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',
9741: p_argument => 'p_object_version_number',
9742: p_argument_value => p_object_version_number
9743: );
9744: hr_api.mandatory_arg_error (p_api_name => 'submit_publish_plan_rep_cp',
9745: p_argument => 'p_republish_values',
9746: p_argument_value => p_republish_values
9747: );
9748:

Line 11017: IF hr_api.not_exists_in_hr_lookups (p_effective_date => l_effective_date,

11013: --
11014: --
11015: FOR i IN 1 .. l_task_cnt
11016: LOOP --
11017: IF hr_api.not_exists_in_hr_lookups (p_effective_date => l_effective_date,
11018: p_lookup_type => 'HR_WPM_PUBLISH_TASKS',
11019: p_lookup_code => t_task_codes (i)
11020: )
11021: THEN

Line 11113: hr_api.mandatory_arg_error (p_api_name => 'plan_republish',

11109: hr_utility.set_location ('Entering:' || l_proc, 10);
11110: g_errbuf := NULL;
11111: g_retcode := NULL;
11112: --
11113: hr_api.mandatory_arg_error (p_api_name => 'plan_republish',
11114: p_argument => 'p_effective_date',
11115: p_argument_value => p_effective_date
11116: );
11117: hr_api.mandatory_arg_error (p_api_name => 'plan_republish', p_argument => 'p_plan_id', p_argument_value => p_plan_id);

Line 11117: hr_api.mandatory_arg_error (p_api_name => 'plan_republish', p_argument => 'p_plan_id', p_argument_value => p_plan_id);

11113: hr_api.mandatory_arg_error (p_api_name => 'plan_republish',
11114: p_argument => 'p_effective_date',
11115: p_argument_value => p_effective_date
11116: );
11117: hr_api.mandatory_arg_error (p_api_name => 'plan_republish', p_argument => 'p_plan_id', p_argument_value => p_plan_id);
11118: hr_api.mandatory_arg_error (p_api_name => 'plan_republish',
11119: p_argument => 'p_republish_values',
11120: p_argument_value => p_republish_values
11121: );

Line 11118: hr_api.mandatory_arg_error (p_api_name => 'plan_republish',

11114: p_argument => 'p_effective_date',
11115: p_argument_value => p_effective_date
11116: );
11117: hr_api.mandatory_arg_error (p_api_name => 'plan_republish', p_argument => 'p_plan_id', p_argument_value => p_plan_id);
11118: hr_api.mandatory_arg_error (p_api_name => 'plan_republish',
11119: p_argument => 'p_republish_values',
11120: p_argument_value => p_republish_values
11121: );
11122: --