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 1328: ,p_scorecard_name in varchar2 default hr_api.g_varchar2

1324: procedure update_scorecard_for_person
1325: (p_effective_date in date
1326: ,p_scorecard_id in number
1327: ,p_object_version_number in number
1328: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
1329: ,p_start_date in date default hr_api.g_date
1330: ,p_end_date in date default hr_api.g_date
1331: ,p_status_code in varchar2 default hr_api.g_varchar2
1332: ) is

Line 1329: ,p_start_date in date default hr_api.g_date

1325: (p_effective_date in date
1326: ,p_scorecard_id in number
1327: ,p_object_version_number in number
1328: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
1329: ,p_start_date in date default hr_api.g_date
1330: ,p_end_date in date default hr_api.g_date
1331: ,p_status_code in varchar2 default hr_api.g_varchar2
1332: ) is
1333:

Line 1330: ,p_end_date in date default hr_api.g_date

1326: ,p_scorecard_id in number
1327: ,p_object_version_number in number
1328: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
1329: ,p_start_date in date default hr_api.g_date
1330: ,p_end_date in date default hr_api.g_date
1331: ,p_status_code in varchar2 default hr_api.g_varchar2
1332: ) is
1333:
1334: -- Declare local variables

Line 1331: ,p_status_code in varchar2 default hr_api.g_varchar2

1327: ,p_object_version_number in number
1328: ,p_scorecard_name in varchar2 default hr_api.g_varchar2
1329: ,p_start_date in date default hr_api.g_date
1330: ,p_end_date in date default hr_api.g_date
1331: ,p_status_code in varchar2 default hr_api.g_varchar2
1332: ) is
1333:
1334: -- Declare local variables
1335: l_proc varchar2(72) := g_package||'update_scorecard_for_person';

Line 1660: ,p_scorecard_id in number default hr_api.g_number

1656: procedure update_scorecard_objective
1657: (p_effective_date in date
1658: ,p_objective_id in number
1659: ,p_object_version_number in number
1660: ,p_scorecard_id in number default hr_api.g_number
1661: ,p_start_date in date default hr_api.g_date
1662: ,p_end_date in date default hr_api.g_date
1663: ,p_objective_name in varchar2 default hr_api.g_varchar2
1664: ,p_valid_from in date default hr_api.g_date

Line 1661: ,p_start_date in date default hr_api.g_date

1657: (p_effective_date in date
1658: ,p_objective_id in number
1659: ,p_object_version_number in number
1660: ,p_scorecard_id in number default hr_api.g_number
1661: ,p_start_date in date default hr_api.g_date
1662: ,p_end_date in date default hr_api.g_date
1663: ,p_objective_name in varchar2 default hr_api.g_varchar2
1664: ,p_valid_from in date default hr_api.g_date
1665: ,p_valid_to in date default hr_api.g_date

Line 1662: ,p_end_date in date default hr_api.g_date

1658: ,p_objective_id in number
1659: ,p_object_version_number in number
1660: ,p_scorecard_id in number default hr_api.g_number
1661: ,p_start_date in date default hr_api.g_date
1662: ,p_end_date in date default hr_api.g_date
1663: ,p_objective_name in varchar2 default hr_api.g_varchar2
1664: ,p_valid_from in date default hr_api.g_date
1665: ,p_valid_to in date default hr_api.g_date
1666: ,p_target_date in date default hr_api.g_date

Line 1663: ,p_objective_name in varchar2 default hr_api.g_varchar2

1659: ,p_object_version_number in number
1660: ,p_scorecard_id in number default hr_api.g_number
1661: ,p_start_date in date default hr_api.g_date
1662: ,p_end_date in date default hr_api.g_date
1663: ,p_objective_name in varchar2 default hr_api.g_varchar2
1664: ,p_valid_from in date default hr_api.g_date
1665: ,p_valid_to in date default hr_api.g_date
1666: ,p_target_date in date default hr_api.g_date
1667: ,p_copied_from_library_id in number default hr_api.g_number

Line 1664: ,p_valid_from in date default hr_api.g_date

1660: ,p_scorecard_id in number default hr_api.g_number
1661: ,p_start_date in date default hr_api.g_date
1662: ,p_end_date in date default hr_api.g_date
1663: ,p_objective_name in varchar2 default hr_api.g_varchar2
1664: ,p_valid_from in date default hr_api.g_date
1665: ,p_valid_to in date default hr_api.g_date
1666: ,p_target_date in date default hr_api.g_date
1667: ,p_copied_from_library_id in number default hr_api.g_number
1668: ,p_next_review_date in date default hr_api.g_date

Line 1665: ,p_valid_to in date default hr_api.g_date

1661: ,p_start_date in date default hr_api.g_date
1662: ,p_end_date in date default hr_api.g_date
1663: ,p_objective_name in varchar2 default hr_api.g_varchar2
1664: ,p_valid_from in date default hr_api.g_date
1665: ,p_valid_to in date default hr_api.g_date
1666: ,p_target_date in date default hr_api.g_date
1667: ,p_copied_from_library_id in number default hr_api.g_number
1668: ,p_next_review_date in date default hr_api.g_date
1669: ,p_group_code in varchar2 default hr_api.g_varchar2

Line 1666: ,p_target_date in date default hr_api.g_date

1662: ,p_end_date in date default hr_api.g_date
1663: ,p_objective_name in varchar2 default hr_api.g_varchar2
1664: ,p_valid_from in date default hr_api.g_date
1665: ,p_valid_to in date default hr_api.g_date
1666: ,p_target_date in date default hr_api.g_date
1667: ,p_copied_from_library_id in number default hr_api.g_number
1668: ,p_next_review_date in date default hr_api.g_date
1669: ,p_group_code in varchar2 default hr_api.g_varchar2
1670: ,p_priority_code in varchar2 default hr_api.g_varchar2

Line 1667: ,p_copied_from_library_id in number default hr_api.g_number

1663: ,p_objective_name in varchar2 default hr_api.g_varchar2
1664: ,p_valid_from in date default hr_api.g_date
1665: ,p_valid_to in date default hr_api.g_date
1666: ,p_target_date in date default hr_api.g_date
1667: ,p_copied_from_library_id in number default hr_api.g_number
1668: ,p_next_review_date in date default hr_api.g_date
1669: ,p_group_code in varchar2 default hr_api.g_varchar2
1670: ,p_priority_code in varchar2 default hr_api.g_varchar2
1671: ,p_appraise_flag in varchar2 default hr_api.g_varchar2

Line 1668: ,p_next_review_date in date default hr_api.g_date

1664: ,p_valid_from in date default hr_api.g_date
1665: ,p_valid_to in date default hr_api.g_date
1666: ,p_target_date in date default hr_api.g_date
1667: ,p_copied_from_library_id in number default hr_api.g_number
1668: ,p_next_review_date in date default hr_api.g_date
1669: ,p_group_code in varchar2 default hr_api.g_varchar2
1670: ,p_priority_code in varchar2 default hr_api.g_varchar2
1671: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
1672: ,p_weighting_percent in number default hr_api.g_number

Line 1669: ,p_group_code in varchar2 default hr_api.g_varchar2

1665: ,p_valid_to in date default hr_api.g_date
1666: ,p_target_date in date default hr_api.g_date
1667: ,p_copied_from_library_id in number default hr_api.g_number
1668: ,p_next_review_date in date default hr_api.g_date
1669: ,p_group_code in varchar2 default hr_api.g_varchar2
1670: ,p_priority_code in varchar2 default hr_api.g_varchar2
1671: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
1672: ,p_weighting_percent in number default hr_api.g_number
1673: ,p_target_value in number default hr_api.g_number

Line 1670: ,p_priority_code in varchar2 default hr_api.g_varchar2

1666: ,p_target_date in date default hr_api.g_date
1667: ,p_copied_from_library_id in number default hr_api.g_number
1668: ,p_next_review_date in date default hr_api.g_date
1669: ,p_group_code in varchar2 default hr_api.g_varchar2
1670: ,p_priority_code in varchar2 default hr_api.g_varchar2
1671: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
1672: ,p_weighting_percent in number default hr_api.g_number
1673: ,p_target_value in number default hr_api.g_number
1674: ,p_uom_code in varchar2 default hr_api.g_varchar2

Line 1671: ,p_appraise_flag in varchar2 default hr_api.g_varchar2

1667: ,p_copied_from_library_id in number default hr_api.g_number
1668: ,p_next_review_date in date default hr_api.g_date
1669: ,p_group_code in varchar2 default hr_api.g_varchar2
1670: ,p_priority_code in varchar2 default hr_api.g_varchar2
1671: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
1672: ,p_weighting_percent in number default hr_api.g_number
1673: ,p_target_value in number default hr_api.g_number
1674: ,p_uom_code in varchar2 default hr_api.g_varchar2
1675: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2

Line 1672: ,p_weighting_percent in number default hr_api.g_number

1668: ,p_next_review_date in date default hr_api.g_date
1669: ,p_group_code in varchar2 default hr_api.g_varchar2
1670: ,p_priority_code in varchar2 default hr_api.g_varchar2
1671: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
1672: ,p_weighting_percent in number default hr_api.g_number
1673: ,p_target_value in number default hr_api.g_number
1674: ,p_uom_code in varchar2 default hr_api.g_varchar2
1675: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
1676: ,p_measure_name in varchar2 default hr_api.g_varchar2

Line 1673: ,p_target_value in number default hr_api.g_number

1669: ,p_group_code in varchar2 default hr_api.g_varchar2
1670: ,p_priority_code in varchar2 default hr_api.g_varchar2
1671: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
1672: ,p_weighting_percent in number default hr_api.g_number
1673: ,p_target_value in number default hr_api.g_number
1674: ,p_uom_code in varchar2 default hr_api.g_varchar2
1675: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
1676: ,p_measure_name in varchar2 default hr_api.g_varchar2
1677: ,p_measure_type_code in varchar2 default hr_api.g_varchar2

Line 1674: ,p_uom_code in varchar2 default hr_api.g_varchar2

1670: ,p_priority_code in varchar2 default hr_api.g_varchar2
1671: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
1672: ,p_weighting_percent in number default hr_api.g_number
1673: ,p_target_value in number default hr_api.g_number
1674: ,p_uom_code in varchar2 default hr_api.g_varchar2
1675: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
1676: ,p_measure_name in varchar2 default hr_api.g_varchar2
1677: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
1678: ,p_measure_comments in varchar2 default hr_api.g_varchar2

Line 1675: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2

1671: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
1672: ,p_weighting_percent in number default hr_api.g_number
1673: ,p_target_value in number default hr_api.g_number
1674: ,p_uom_code in varchar2 default hr_api.g_varchar2
1675: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
1676: ,p_measure_name in varchar2 default hr_api.g_varchar2
1677: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
1678: ,p_measure_comments in varchar2 default hr_api.g_varchar2
1679: ,p_details in varchar2 default hr_api.g_varchar2

Line 1676: ,p_measure_name in varchar2 default hr_api.g_varchar2

1672: ,p_weighting_percent in number default hr_api.g_number
1673: ,p_target_value in number default hr_api.g_number
1674: ,p_uom_code in varchar2 default hr_api.g_varchar2
1675: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
1676: ,p_measure_name in varchar2 default hr_api.g_varchar2
1677: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
1678: ,p_measure_comments in varchar2 default hr_api.g_varchar2
1679: ,p_details in varchar2 default hr_api.g_varchar2
1680: ,p_success_criteria in varchar2 default hr_api.g_varchar2

Line 1677: ,p_measure_type_code in varchar2 default hr_api.g_varchar2

1673: ,p_target_value in number default hr_api.g_number
1674: ,p_uom_code in varchar2 default hr_api.g_varchar2
1675: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
1676: ,p_measure_name in varchar2 default hr_api.g_varchar2
1677: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
1678: ,p_measure_comments in varchar2 default hr_api.g_varchar2
1679: ,p_details in varchar2 default hr_api.g_varchar2
1680: ,p_success_criteria in varchar2 default hr_api.g_varchar2
1681: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1678: ,p_measure_comments in varchar2 default hr_api.g_varchar2

1674: ,p_uom_code in varchar2 default hr_api.g_varchar2
1675: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
1676: ,p_measure_name in varchar2 default hr_api.g_varchar2
1677: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
1678: ,p_measure_comments in varchar2 default hr_api.g_varchar2
1679: ,p_details in varchar2 default hr_api.g_varchar2
1680: ,p_success_criteria in varchar2 default hr_api.g_varchar2
1681: ,p_comments in varchar2 default hr_api.g_varchar2
1682: )

Line 1679: ,p_details in varchar2 default hr_api.g_varchar2

1675: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
1676: ,p_measure_name in varchar2 default hr_api.g_varchar2
1677: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
1678: ,p_measure_comments in varchar2 default hr_api.g_varchar2
1679: ,p_details in varchar2 default hr_api.g_varchar2
1680: ,p_success_criteria in varchar2 default hr_api.g_varchar2
1681: ,p_comments in varchar2 default hr_api.g_varchar2
1682: )
1683: is

Line 1680: ,p_success_criteria in varchar2 default hr_api.g_varchar2

1676: ,p_measure_name in varchar2 default hr_api.g_varchar2
1677: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
1678: ,p_measure_comments in varchar2 default hr_api.g_varchar2
1679: ,p_details in varchar2 default hr_api.g_varchar2
1680: ,p_success_criteria in varchar2 default hr_api.g_varchar2
1681: ,p_comments in varchar2 default hr_api.g_varchar2
1682: )
1683: is
1684:

Line 1681: ,p_comments in varchar2 default hr_api.g_varchar2

1677: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
1678: ,p_measure_comments in varchar2 default hr_api.g_varchar2
1679: ,p_details in varchar2 default hr_api.g_varchar2
1680: ,p_success_criteria in varchar2 default hr_api.g_varchar2
1681: ,p_comments in varchar2 default hr_api.g_varchar2
1682: )
1683: is
1684:
1685: -- Declare local variables

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

5207: log_message('Deleting Score cards for the plan');
5208: OPEN csr_sc_ids(p_plan_id);
5209: LOOP
5210: FETCH csr_sc_ids BULK COLLECT INTO l_sc_ids LIMIT 1000;
5211: --Delete any transactions from HR_API_Transactions and transaction steps
5212: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
5213: DELETE
5214: FROM hr_api_transaction_steps step
5215: WHERE step.transaction_id IN (SELECT trn.transaction_id

Line 5214: FROM hr_api_transaction_steps step

5210: FETCH csr_sc_ids BULK COLLECT INTO l_sc_ids LIMIT 1000;
5211: --Delete any transactions from HR_API_Transactions and transaction steps
5212: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
5213: DELETE
5214: FROM hr_api_transaction_steps step
5215: WHERE step.transaction_id IN (SELECT trn.transaction_id
5216: FROM hr_api_transactions trn
5217: WHERE trn.transaction_ref_id =
5218: l_sc_ids(i)

Line 5216: FROM hr_api_transactions trn

5212: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
5213: DELETE
5214: FROM hr_api_transaction_steps step
5215: WHERE step.transaction_id IN (SELECT trn.transaction_id
5216: FROM hr_api_transactions trn
5217: WHERE trn.transaction_ref_id =
5218: l_sc_ids(i)
5219: AND trn.transaction_ref_table =
5220: 'PER_PERSONAL_SCORECARDS');

Line 5223: FROM hr_api_transactions

5219: AND trn.transaction_ref_table =
5220: 'PER_PERSONAL_SCORECARDS');
5221: FORALL i IN l_sc_ids.FIRST .. l_sc_ids.LAST
5222: DELETE
5223: FROM hr_api_transactions
5224: WHERE transaction_ref_id = l_sc_ids(i)
5225: AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
5226: -- Delete all score card objectives
5227: FORALL i in l_sc_ids.FIRST .. l_sc_ids.LAST

Line 5284: hr_api.mandatory_arg_error(p_api_name => 'BACKOUT_PERF_MGMT_PLAN_CP'

5280: g_package||'backout_perf_mgmt_plan_cp';
5281: BEGIN
5282: hr_utility.set_location('Entering '||l_proc,10);
5283: IF p_plan_id IS NULL THEN
5284: hr_api.mandatory_arg_error(p_api_name => 'BACKOUT_PERF_MGMT_PLAN_CP'
5285: ,p_argument => 'P_PLAN_ID'
5286: ,p_argument_value => p_plan_id);
5287: END IF;
5288: IF p_effective_date IS NULL THEN

Line 5289: hr_api.mandatory_arg_error(p_api_name => 'BACKOUT_PERF_MGMT_PLAN_CP'

5285: ,p_argument => 'P_PLAN_ID'
5286: ,p_argument_value => p_plan_id);
5287: END IF;
5288: IF p_effective_date IS NULL THEN
5289: hr_api.mandatory_arg_error(p_api_name => 'BACKOUT_PERF_MGMT_PLAN_CP'
5290: ,p_argument => 'P_EFFECTIVE_DATE'
5291: ,p_argument_value => p_effective_date);
5292: END IF;
5293: l_request_id := fnd_request.submit_request(

Line 5351: hr_api.mandatory_arg_error(p_api_name => 'BACKOUT_PERF_MGMT_PLAN'

5347: OPEN csr_person_ids(p_plan_id);
5348: FETCH csr_person_ids BULK COLLECT INTO person_ids LIMIT 1000;
5349: CLOSE csr_person_ids;
5350: IF p_plan_id IS NULL THEN
5351: hr_api.mandatory_arg_error(p_api_name => 'BACKOUT_PERF_MGMT_PLAN'
5352: ,p_argument => 'P_PLAN_ID'
5353: ,p_argument_value => p_plan_id);
5354: END IF;
5355: IF p_effective_date IS NULL THEN

Line 5356: hr_api.mandatory_arg_error(p_api_name => 'BACKOUT_PERF_MGMT_PLAN'

5352: ,p_argument => 'P_PLAN_ID'
5353: ,p_argument_value => p_plan_id);
5354: END IF;
5355: IF p_effective_date IS NULL THEN
5356: hr_api.mandatory_arg_error(p_api_name => 'BACKOUT_PERF_MGMT_PLAN'
5357: ,p_argument => 'P_EFFECTIVE_DATE'
5358: ,p_argument_value => p_effective_date);
5359: END IF;
5360: l_effective_date := fnd_date.canonical_to_date(p_effective_date);

Line 5475: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'

5471: BEGIN
5472: --
5473: hr_utility.set_location('Entering '||l_proc,10);
5474: IF p_plan_id IS NULL THEN
5475: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'
5476: ,p_argument => 'P_PLAN_ID'
5477: ,p_argument_value => p_plan_id);
5478: END IF;
5479: IF p_effective_date IS NULL THEN

Line 5480: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'

5476: ,p_argument => 'P_PLAN_ID'
5477: ,p_argument_value => p_plan_id);
5478: END IF;
5479: IF p_effective_date IS NULL THEN
5480: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'
5481: ,p_argument => 'P_EFFECTIVE_DATE'
5482: ,p_argument_value => p_effective_date);
5483: END IF;
5484: IF p_selected_entities_list IS NULL THEN

Line 5485: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'

5481: ,p_argument => 'P_EFFECTIVE_DATE'
5482: ,p_argument_value => p_effective_date);
5483: END IF;
5484: IF p_selected_entities_list IS NULL THEN
5485: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'
5486: ,p_argument => 'P_SELECTED_ENTITIES_LIST'
5487: ,p_argument_value => p_selected_entities_list);
5488: END IF;
5489: IF p_task_code IS NULL THEN

Line 5490: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'

5486: ,p_argument => 'P_SELECTED_ENTITIES_LIST'
5487: ,p_argument_value => p_selected_entities_list);
5488: END IF;
5489: IF p_task_code IS NULL THEN
5490: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'
5491: ,p_argument => 'P_TASK_CODE'
5492: ,p_argument_value => p_task_code);
5493: END IF;
5494: IF hr_api.not_exists_in_hr_lookups(p_effective_date => p_effective_date

Line 5494: IF hr_api.not_exists_in_hr_lookups(p_effective_date => p_effective_date

5490: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'
5491: ,p_argument => 'P_TASK_CODE'
5492: ,p_argument_value => p_task_code);
5493: END IF;
5494: IF hr_api.not_exists_in_hr_lookups(p_effective_date => p_effective_date
5495: ,p_lookup_type => 'HR_WPM_ADMIN_ACTIONS'
5496: ,p_lookup_code => p_task_code) THEN
5497: log_message('Invalid task code selected.'||p_task_code);
5498: hr_utility.set_message(800,'HR_WPM_TASK_CODE_NOT_EXISTS');

Line 6067: FROM hr_api_transaction_steps step

6063: --
6064: PROCEDURE remove_scorecard_details(p_scorecard_id IN NUMBER) IS
6065: BEGIN
6066: DELETE
6067: FROM hr_api_transaction_steps step
6068: WHERE step.transaction_id IN (SELECT trn.transaction_id
6069: FROM hr_api_transactions trn
6070: WHERE trn.transaction_ref_id =
6071: p_scorecard_id

Line 6069: FROM hr_api_transactions trn

6065: BEGIN
6066: DELETE
6067: FROM hr_api_transaction_steps step
6068: WHERE step.transaction_id IN (SELECT trn.transaction_id
6069: FROM hr_api_transactions trn
6070: WHERE trn.transaction_ref_id =
6071: p_scorecard_id
6072: AND trn.transaction_ref_table =
6073: 'PER_PERSONAL_SCORECARDS');

Line 6075: FROM hr_api_transactions

6071: p_scorecard_id
6072: AND trn.transaction_ref_table =
6073: 'PER_PERSONAL_SCORECARDS');
6074: DELETE
6075: FROM hr_api_transactions
6076: WHERE transaction_ref_id = p_scorecard_id
6077: AND transaction_ref_table = 'PER_PERSONAL_SCORECARDS';
6078: --
6079: DELETE

Line 6451: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'

6447:
6448: g_num_errors := 0;
6449: --
6450: IF p_plan_id IS NULL THEN
6451: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'
6452: ,p_argument => 'P_PLAN_ID'
6453: ,p_argument_value => p_plan_id);
6454: END IF;
6455: IF p_effective_date IS NULL THEN

Line 6456: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'

6452: ,p_argument => 'P_PLAN_ID'
6453: ,p_argument_value => p_plan_id);
6454: END IF;
6455: IF p_effective_date IS NULL THEN
6456: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'
6457: ,p_argument => 'P_EFFECTIVE_DATE'
6458: ,p_argument_value => p_effective_date);
6459: END IF;
6460: IF p_selected_entities_list IS NULL THEN

Line 6461: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'

6457: ,p_argument => 'P_EFFECTIVE_DATE'
6458: ,p_argument_value => p_effective_date);
6459: END IF;
6460: IF p_selected_entities_list IS NULL THEN
6461: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'
6462: ,p_argument => 'P_SELECTED_ENTITIES_LIST'
6463: ,p_argument_value => p_selected_entities_list);
6464: END IF;
6465: IF p_task_code IS NULL THEN

Line 6466: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'

6462: ,p_argument => 'P_SELECTED_ENTITIES_LIST'
6463: ,p_argument_value => p_selected_entities_list);
6464: END IF;
6465: IF p_task_code IS NULL THEN
6466: hr_api.mandatory_arg_error(p_api_name => 'PLAN_ADMIN_ACTIONS_CP'
6467: ,p_argument => 'P_TASK_CODE'
6468: ,p_argument_value => p_task_code);
6469: END IF;
6470: l_effective_date := fnd_date.canonical_to_date(p_effective_date);

Line 6471: IF hr_api.not_exists_in_hr_lookups(p_effective_date => l_effective_date

6467: ,p_argument => 'P_TASK_CODE'
6468: ,p_argument_value => p_task_code);
6469: END IF;
6470: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
6471: IF hr_api.not_exists_in_hr_lookups(p_effective_date => l_effective_date
6472: ,p_lookup_type => 'HR_WPM_ADMIN_ACTIONS'
6473: ,p_lookup_code => p_task_code) THEN
6474: log_message('Invalid task code selected.'||p_task_code);
6475: hr_utility.set_message(800,'HR_WPM_TASK_CODE_NOT_EXISTS');