APPS.PA_HR_UPDATE_PA_ENTITIES dependencies on PA_HR_UPDATE_API

Line 649: avalue => pa_hr_update_api.get_org_name(l_organization_id_child));

645:
646: wf_engine.SetItemAttrText ( itemtype => itemtype,
647: itemkey => itemkey,
648: aname => 'ORGANIZATION_NAME',
649: avalue => pa_hr_update_api.get_org_name(l_organization_id_child));
650:
651: wf_engine.SetItemAttrText ( itemtype => itemtype,
652: itemkey => itemkey,
653: aname => 'CHILD_ORGANIZATION_NAME',

Line 654: avalue => pa_hr_update_api.get_org_name(l_organization_id_parent));

650:
651: wf_engine.SetItemAttrText ( itemtype => itemtype,
652: itemkey => itemkey,
653: aname => 'CHILD_ORGANIZATION_NAME',
654: avalue => pa_hr_update_api.get_org_name(l_organization_id_parent));
655:
656: --
657: -- Call the api to populate the hierarchy denorm table
658: --

Line 809: avalue => pa_hr_update_api.get_job_name(l_job_id));

805:
806: wf_engine.SetItemAttrText ( itemtype => itemtype,
807: itemkey => itemkey,
808: aname => 'JOB_NAME',
809: avalue => pa_hr_update_api.get_job_name(l_job_id));
810:
811: log_message('before calling per_job_extra_billability');
812: --
813: -- Call api to process job billability

Line 817: pa_hr_update_api.per_job_extra_billability

813: -- Call api to process job billability
814: --
815: SAVEPOINT l_job_billability_change ;
816: l_savepoint := true;
817: pa_hr_update_api.per_job_extra_billability
818: (p_calling_mode =>l_calling_mode
819: ,P_job_id =>l_job_id
820: ,P_billable_flag_new =>l_jei_information2_new
821: ,P_billable_flag_old =>l_jei_information2_old

Line 1003: PA_HR_UPDATE_API.update_name ( p_person_id => l_person_id

999: --
1000:
1001: SAVEPOINT l_full_name_change ;
1002: l_savepoint := true;
1003: PA_HR_UPDATE_API.update_name ( p_person_id => l_person_id
1004: ,p_old_name => l_full_name_old
1005: ,p_new_name => l_full_name_new
1006: ,x_return_status => l_return_status
1007: ,x_msg_count => l_msg_count

Line 1173: avalue => pa_hr_update_api.get_org_name(l_org_id));

1169:
1170: wf_engine.SetItemAttrText ( itemtype => itemtype,
1171: itemkey => itemkey,
1172: aname => 'ORGANIZATION_NAME',
1173: avalue => pa_hr_update_api.get_org_name(l_org_id));
1174:
1175: SAVEPOINT l_ou_change ;
1176: l_savepoint := true;
1177:

Line 1180: pa_hr_update_api.default_ou_change

1176: l_savepoint := true;
1177:
1178: IF l_org_info_context = 'Exp Organization Defaults' THEN
1179:
1180: pa_hr_update_api.default_ou_change
1181: ( p_calling_mode => l_calling_mode,
1182: p_organization_id => l_org_id,
1183: p_default_ou_new => l_org_info1_new,
1184: p_default_ou_old => l_org_info1_old,

Line 1192: pa_hr_update_api.proj_res_job_group_change

1188: ) ;
1189:
1190: ELSIF l_org_info_context = 'Project Resource Job Group' THEN
1191:
1192: pa_hr_update_api.proj_res_job_group_change
1193: ( p_calling_mode => l_calling_mode,
1194: p_organization_id => l_org_id,
1195: p_proj_job_group_new => l_org_info1_new,
1196: p_proj_job_group_old => l_org_info1_old,

Line 1385: avalue => pa_hr_update_api.get_job_name(l_job_id_new));

1381:
1382: wf_engine.SetItemAttrText ( itemtype => itemtype,
1383: itemkey => itemkey,
1384: aname => 'JOB_NAME',
1385: avalue => pa_hr_update_api.get_job_name(l_job_id_new));
1386:
1387: /*
1388: wf_engine.SetItemAttrText ( itemtype => itemtype,
1389: itemkey => itemkey,

Line 1391: avalue => pa_hr_update_api.get_grade_name(l_grade_id_new));

1387: /*
1388: wf_engine.SetItemAttrText ( itemtype => itemtype,
1389: itemkey => itemkey,
1390: aname => 'GRADE_NAME',
1391: avalue => pa_hr_update_api.get_grade_name(l_grade_id_new));
1392: */
1393:
1394: SAVEPOINT l_valid_grade_change ;
1395: l_savepoint := true;

Line 1396: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode

1392: */
1393:
1394: SAVEPOINT l_valid_grade_change ;
1395: l_savepoint := true;
1396: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode
1397: ,P_per_valid_grade_job_id => l_job_id_New
1398: ,P_per_valid_grade_id_old => l_grade_id_old
1399: ,P_per_valid_grade_id_new => l_grade_id_New
1400: ,x_return_status => l_return_status

Line 1563: avalue => pa_hr_update_api.get_grade_name(l_grade_id));

1559:
1560: wf_engine.SetItemAttrText ( itemtype => itemtype,
1561: itemkey => itemkey,
1562: aname => 'GRADE_NAME',
1563: avalue => pa_hr_update_api.get_grade_name(l_grade_id));
1564: */
1565:
1566: SAVEPOINT l_job_level_change ;
1567: l_savepoint := true;

Line 1568: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode

1564: */
1565:
1566: SAVEPOINT l_job_level_change ;
1567: l_savepoint := true;
1568: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode
1569: ,P_per_grades_grade_id => l_grade_id
1570: ,P_per_grades_sequence_old => l_job_level_old
1571: ,P_per_grades_sequence_new => l_job_level_new
1572: ,x_return_status => l_return_status

Line 1803: pa_hr_update_api.address_change( p_calling_mode => l_calling_mode

1799: SAVEPOINT l_address_change ;
1800: l_savepoint := true;
1801:
1802: --dbms_output.put_line('Calling address Update');
1803: pa_hr_update_api.address_change( p_calling_mode => l_calling_mode
1804: , p_person_id => l_person_id
1805: , p_country_old => l_country_old
1806: , p_country_new => l_country_new
1807: , p_city_old => l_city_old

Line 2015: avalue => pa_hr_update_api.get_org_name(l_org_id));

2011:
2012: wf_engine.SetItemAttrText ( itemtype => itemtype,
2013: itemkey => itemkey,
2014: aname => 'ORGANIZATION_NAME',
2015: avalue => pa_hr_update_api.get_org_name(l_org_id));
2016:
2017:
2018: IF l_calling_mode = 'UPDATE' THEN
2019:

Line 2029: if(pa_hr_update_api.belongs_ExpOrg(l_org_id) = 'N') then

2025: --The following code checks to see if the organization of the resource belongs
2026: --to some other expenditure hierarchy. The resource must be end_dated / inactivated
2027: --only if he does not belong to any expenditure hierarchy
2028:
2029: if(pa_hr_update_api.belongs_ExpOrg(l_org_id) = 'N') then
2030: -- dbms_output.put_line('Making resources inactive');
2031:
2032: --rmunjulu bug 6815563 -- check if active org resource exists
2033: OPEN chk_org_res_exists_csr(l_org_id);

Line 2039: PA_HR_UPDATE_API.make_resource_inactive( p_calling_mode => l_calling_mode

2035: CLOSE chk_org_res_exists_csr;
2036:
2037: --rmunjulu bug 6815563 -- make resource inactive only if org resource exists
2038: IF nvl(l_org_res_exists,'N') = 'Y' THEN
2039: PA_HR_UPDATE_API.make_resource_inactive( p_calling_mode => l_calling_mode
2040: ,P_Organization_id => l_org_id
2041: ,P_Default_OU => l_org_info1_new
2042: ,P_inactive_date => l_inactive_date_new
2043: ,x_return_status => l_return_status

Line 2051: IF (PA_HR_UPDATE_API.check_pjr_default_ou(l_org_id,l_org_info1_new) = 'Y') THEN /*Added for bug 8568641 */

2047: l_return_status := 'S'; -- Bug : 8783780
2048: END IF; -- rmunjulu bug 6815563
2049: else
2050:
2051: IF (PA_HR_UPDATE_API.check_pjr_default_ou(l_org_id,l_org_info1_new) = 'Y') THEN /*Added for bug 8568641 */
2052: --dbms_output.put_line('Pulling resources');
2053: PA_HR_UPDATE_API.pull_resources( P_Organization_id => l_org_id
2054: ,x_return_status => l_return_status
2055: ,x_msg_count => l_msg_count

Line 2053: PA_HR_UPDATE_API.pull_resources( P_Organization_id => l_org_id

2049: else
2050:
2051: IF (PA_HR_UPDATE_API.check_pjr_default_ou(l_org_id,l_org_info1_new) = 'Y') THEN /*Added for bug 8568641 */
2052: --dbms_output.put_line('Pulling resources');
2053: PA_HR_UPDATE_API.pull_resources( P_Organization_id => l_org_id
2054: ,x_return_status => l_return_status
2055: ,x_msg_count => l_msg_count
2056: ,x_msg_data => l_msg_data);
2057: ELSE

Line 2067: pa_hr_update_api.default_ou_change( p_calling_mode => l_calling_mode,

2063: --dbms_output.put_line('Calling mode is Insert');
2064:
2065: SAVEPOINT l_project_org_change ;
2066: l_savepoint := true;
2067: pa_hr_update_api.default_ou_change( p_calling_mode => l_calling_mode,
2068: p_organization_id => l_org_id,
2069: p_default_ou_new => l_org_info1_new,
2070: p_default_ou_old => l_org_info1_old,
2071: x_return_status => l_return_status,

Line 2257: avalue => pa_hr_update_api.get_job_name(l_from_job_id_new));

2253:
2254: wf_engine.SetItemAttrText ( itemtype => itemtype,
2255: itemkey => itemkey,
2256: aname => 'JOB_NAME',
2257: avalue => pa_hr_update_api.get_job_name(l_from_job_id_new));
2258:
2259: wf_engine.SetItemAttrText ( itemtype => itemtype,
2260: itemkey => itemkey,
2261: aname => 'TO_JOB_NAME',

Line 2262: avalue => pa_hr_update_api.get_job_name(l_to_job_id_new));

2258:
2259: wf_engine.SetItemAttrText ( itemtype => itemtype,
2260: itemkey => itemkey,
2261: aname => 'TO_JOB_NAME',
2262: avalue => pa_hr_update_api.get_job_name(l_to_job_id_new));
2263:
2264: SAVEPOINT l_job_rel_change ;
2265: l_savepoint := true;
2266: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode

Line 2266: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode

2262: avalue => pa_hr_update_api.get_job_name(l_to_job_id_new));
2263:
2264: SAVEPOINT l_job_rel_change ;
2265: l_savepoint := true;
2266: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode
2267: ,P_from_job_id_old => l_from_job_id_old
2268: ,P_from_job_id_new => l_from_job_id_new
2269: ,P_to_job_id_old => l_to_job_id_old
2270: ,P_to_job_id_new => l_to_job_id_new

Line 2517: pa_hr_update_api.Delete_PA_Resource_Denorm (

2513: avalue => l_person_name);
2514:
2515: --Start of addition for bug 3957522
2516: if l_calling_mode = 'DELETE' then
2517: pa_hr_update_api.Delete_PA_Resource_Denorm (
2518: p_person_id => l_person_id
2519: ,p_old_start_date => l_start_date_old
2520: ,p_old_end_date => l_end_date_old
2521: ,x_return_status => l_return_status

Line 2571: if ( l_primary_flag_new = 'Y' and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y') then

2567:
2568: -- End of addition for bug 3957522.
2569: elsif l_calling_mode = 'INSERT' then
2570:
2571: if ( l_primary_flag_new = 'Y' and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y') then
2572: -- Added new if condition for Bug 7423251
2573: IF (pa_hr_update_api.check_job_utilization (p_job_id => l_job_id_new
2574: ,p_person_id => null
2575: ,p_date => null)) = 'Y' then

Line 2573: IF (pa_hr_update_api.check_job_utilization (p_job_id => l_job_id_new

2569: elsif l_calling_mode = 'INSERT' then
2570:
2571: if ( l_primary_flag_new = 'Y' and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y') then
2572: -- Added new if condition for Bug 7423251
2573: IF (pa_hr_update_api.check_job_utilization (p_job_id => l_job_id_new
2574: ,p_person_id => null
2575: ,p_date => null)) = 'Y' then
2576:
2577: --Bug 9762784 Start

Line 2589: IF (pa_hr_update_api.get_defaultou(l_org_id_new) <> -999 and l_chk_asgn = 'Y') THEN --Bug 9762784

2585: CLOSE chk_asgn;
2586: --Bug 9762784 End
2587:
2588: --Added another condition for bug 8227271
2589: IF (pa_hr_update_api.get_defaultou(l_org_id_new) <> -999 and l_chk_asgn = 'Y') THEN --Bug 9762784
2590:
2591: -- call the work flow to update pa objects
2592: SAVEPOINT l_assignment_change;
2593: l_savepoint := true;

Line 2625: END IF ; -- IF (pa_hr_update_api.get_defaultou(l_org_id_new) <> -999) THEN

2621: ,x_msg_count => l_msg_count
2622: ,x_msg_data => l_msg_data
2623: ) ;
2624: end if;
2625: END IF ; -- IF (pa_hr_update_api.get_defaultou(l_org_id_new) <> -999) THEN
2626: end if;
2627:
2628:
2629: l_message_counter := l_message_counter + nvl(l_msg_count,0);

Line 2643: and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y'

2639: elsif l_calling_mode = 'UPDATE' then
2640: SAVEPOINT l_assignment_change;
2641: l_savepoint := true;
2642: if ( l_primary_flag_new = 'Y' and l_primary_flag_old = 'N'
2643: and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y'
2644: and pa_hr_update_api.check_job_utilization (
2645: P_job_id => l_job_id_new,
2646: P_person_id => NULL,
2647: p_date => NULL )= 'Y'

Line 2644: and pa_hr_update_api.check_job_utilization (

2640: SAVEPOINT l_assignment_change;
2641: l_savepoint := true;
2642: if ( l_primary_flag_new = 'Y' and l_primary_flag_old = 'N'
2643: and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y'
2644: and pa_hr_update_api.check_job_utilization (
2645: P_job_id => l_job_id_new,
2646: P_person_id => NULL,
2647: p_date => NULL )= 'Y'
2648: and pa_hr_update_api.get_defaultou(l_org_id_new) <> -999) then -- bug 6886592

Line 2648: and pa_hr_update_api.get_defaultou(l_org_id_new) <> -999) then -- bug 6886592

2644: and pa_hr_update_api.check_job_utilization (
2645: P_job_id => l_job_id_new,
2646: P_person_id => NULL,
2647: p_date => NULL )= 'Y'
2648: and pa_hr_update_api.get_defaultou(l_org_id_new) <> -999) then -- bug 6886592
2649: --dbms_output.put_line('Calling ind pull 1');
2650:
2651: -- call the work flow to update pa objects
2652: pa_r_project_resources_pub.create_resource (

Line 2700: and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'N') then

2696:
2697: --dbms_output.put_line('Primary flags differ');
2698:
2699: if (l_primary_flag_new = 'Y' and l_primary_flag_old = 'N'
2700: and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'N') then
2701:
2702: /*If the assignments organization does not belong to expenditure hierarchy
2703: then the corresponding assignment in pa_resources_denorm must be
2704: end dated

Line 2706: pa_hr_update_api.Update_EndDate(

2702: /*If the assignments organization does not belong to expenditure hierarchy
2703: then the corresponding assignment in pa_resources_denorm must be
2704: end dated
2705: */
2706: pa_hr_update_api.Update_EndDate(
2707: p_person_id => l_person_id,
2708: p_old_start_date => l_start_date_old,
2709: p_new_start_date => l_start_date_new,
2710: p_old_end_date => l_end_date_old,

Line 2720: pa_hr_update_api.Update_PrimaryFlag (

2716:
2717: -- for all other cases, still need to call this API which will call
2718: -- forecast items
2719: -- call the work flow to update pa objects
2720: pa_hr_update_api.Update_PrimaryFlag (
2721: p_person_id => l_person_id
2722: ,p_old_start_date => l_start_date_old
2723: ,p_new_start_date => l_start_date_new
2724: ,p_old_end_date => l_end_date_old

Line 2773: pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y') THEN commented and changed as below for bug 5665503 */

2769: -- END -- Bug 4668272 - added exception handler
2770:
2771: -- Bug 4668272 change l_res_asgn_exists = 'Y' to 'N'
2772: /* if (l_res_asgn_exists = 'N' AND
2773: pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y') THEN commented and changed as below for bug 5665503 */
2774:
2775: if ( (l_res_asgn_exists = 'N' OR (trunc( l_start_date_old) <> trunc(
2776: l_start_date_new)) )
2777: AND ( pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y')

Line 2777: AND ( pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y')

2773: pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y') THEN commented and changed as below for bug 5665503 */
2774:
2775: if ( (l_res_asgn_exists = 'N' OR (trunc( l_start_date_old) <> trunc(
2776: l_start_date_new)) )
2777: AND ( pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y')
2778: and (pa_hr_update_api.check_job_utilization(
2779: P_job_id => l_job_id_new,
2780: P_person_id => NULL,
2781: p_date => NULL )= 'Y')

Line 2778: and (pa_hr_update_api.check_job_utilization(

2774:
2775: if ( (l_res_asgn_exists = 'N' OR (trunc( l_start_date_old) <> trunc(
2776: l_start_date_new)) )
2777: AND ( pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y')
2778: and (pa_hr_update_api.check_job_utilization(
2779: P_job_id => l_job_id_new,
2780: P_person_id => NULL,
2781: p_date => NULL )= 'Y')
2782: and pa_hr_update_api.get_defaultou(l_org_id_new) <> -999) /*bug6886592*/

Line 2782: and pa_hr_update_api.get_defaultou(l_org_id_new) <> -999) /*bug6886592*/

2778: and (pa_hr_update_api.check_job_utilization(
2779: P_job_id => l_job_id_new,
2780: P_person_id => NULL,
2781: p_date => NULL )= 'Y')
2782: and pa_hr_update_api.get_defaultou(l_org_id_new) <> -999) /*bug6886592*/
2783: THEN
2784:
2785: --dbms_output.put_line('Calling ind pull 2 as record does not exist or start date is changed');
2786:

Line 2837: pa_hr_update_api.Update_EndDate (

2833:
2834: --dbms_output.put_line('Date Change');
2835:
2836: -- call the work flow to update pa objects
2837: pa_hr_update_api.Update_EndDate (
2838: p_person_id => l_person_id
2839: ,p_old_start_date => l_start_date_old
2840: ,p_new_start_date => l_start_date_new
2841: ,p_old_end_date => l_end_date_old

Line 2864: if ((pa_hr_update_api.belongs_ExpOrg(l_org_id_old) ='Y' and

2860: --dbms_output.put_line('Organization changed');
2861:
2862: -- call the work flow to update pa objects
2863: -- Bug 9703979
2864: if ((pa_hr_update_api.belongs_ExpOrg(l_org_id_old) ='Y' and
2865: pa_hr_update_api.get_defaultou(l_org_id_old) <> -999)) then
2866: if ((pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y' and
2867: pa_hr_update_api.get_defaultou(l_org_id_new) <> -999))
2868: then

Line 2865: pa_hr_update_api.get_defaultou(l_org_id_old) <> -999)) then

2861:
2862: -- call the work flow to update pa objects
2863: -- Bug 9703979
2864: if ((pa_hr_update_api.belongs_ExpOrg(l_org_id_old) ='Y' and
2865: pa_hr_update_api.get_defaultou(l_org_id_old) <> -999)) then
2866: if ((pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y' and
2867: pa_hr_update_api.get_defaultou(l_org_id_new) <> -999))
2868: then
2869: pa_hr_update_api.Update_Org (

Line 2866: if ((pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y' and

2862: -- call the work flow to update pa objects
2863: -- Bug 9703979
2864: if ((pa_hr_update_api.belongs_ExpOrg(l_org_id_old) ='Y' and
2865: pa_hr_update_api.get_defaultou(l_org_id_old) <> -999)) then
2866: if ((pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y' and
2867: pa_hr_update_api.get_defaultou(l_org_id_new) <> -999))
2868: then
2869: pa_hr_update_api.Update_Org (
2870: p_person_id => l_person_id

Line 2867: pa_hr_update_api.get_defaultou(l_org_id_new) <> -999))

2863: -- Bug 9703979
2864: if ((pa_hr_update_api.belongs_ExpOrg(l_org_id_old) ='Y' and
2865: pa_hr_update_api.get_defaultou(l_org_id_old) <> -999)) then
2866: if ((pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y' and
2867: pa_hr_update_api.get_defaultou(l_org_id_new) <> -999))
2868: then
2869: pa_hr_update_api.Update_Org (
2870: p_person_id => l_person_id
2871: ,p_old_org_id => l_org_id_old

Line 2869: pa_hr_update_api.Update_Org (

2865: pa_hr_update_api.get_defaultou(l_org_id_old) <> -999)) then
2866: if ((pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y' and
2867: pa_hr_update_api.get_defaultou(l_org_id_new) <> -999))
2868: then
2869: pa_hr_update_api.Update_Org (
2870: p_person_id => l_person_id
2871: ,p_old_org_id => l_org_id_old
2872: ,p_new_org_id => l_org_id_new
2873: ,p_old_start_date => l_start_date_old

Line 2896: if ((pa_hr_update_api.check_job_utilization(

2892: end if; -- bug 6886592
2893:
2894: /*bug 6886592*/
2895: if (nvl(l_job_id_old,-1) <> nvl(l_job_id_new,-1) ) THEN
2896: if ((pa_hr_update_api.check_job_utilization(
2897: P_job_id => l_job_id_old,
2898: P_person_id => NULL,
2899: p_date => NULL ))= 'Y'
2900: or

Line 2901: (pa_hr_update_api.check_job_utilization(

2897: P_job_id => l_job_id_old,
2898: P_person_id => NULL,
2899: p_date => NULL ))= 'Y'
2900: or
2901: (pa_hr_update_api.check_job_utilization(
2902: P_job_id => l_job_id_new,
2903: P_person_id => NULL,
2904: p_date => NULL ))= 'Y' ) THEN
2905: -- bug 9687133

Line 2907: pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y' and

2903: P_person_id => NULL,
2904: p_date => NULL ))= 'Y' ) THEN
2905: -- bug 9687133
2906: if (l_job_id_old is not null or (l_job_id_old is null and
2907: pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y' and
2908: pa_hr_update_api.get_defaultou(l_org_id_new) <> -999)) THEN
2909:
2910: --dbms_output.put_line('Job changed');
2911:

Line 2908: pa_hr_update_api.get_defaultou(l_org_id_new) <> -999)) THEN

2904: p_date => NULL ))= 'Y' ) THEN
2905: -- bug 9687133
2906: if (l_job_id_old is not null or (l_job_id_old is null and
2907: pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y' and
2908: pa_hr_update_api.get_defaultou(l_org_id_new) <> -999)) THEN
2909:
2910: --dbms_output.put_line('Job changed');
2911:
2912: -- call the work flow to update pa objects

Line 2913: pa_hr_update_api.Update_Job (

2909:
2910: --dbms_output.put_line('Job changed');
2911:
2912: -- call the work flow to update pa objects
2913: pa_hr_update_api.Update_Job (
2914: p_person_id => l_person_id
2915: ,p_old_job => l_job_id_old
2916: ,p_new_job => l_job_id_new
2917: ,p_new_start_date => l_start_date_new

Line 2940: pa_hr_update_api.Update_Supervisor (

2936:
2937: --dbms_output.put_line('Supervisor changed');
2938:
2939: -- call the work flow to update pa objects
2940: pa_hr_update_api.Update_Supervisor (
2941: p_person_id => l_person_id
2942: ,p_old_supervisor => l_supervisor_old
2943: ,p_new_supervisor => l_supervisor_new
2944: ,p_new_start_date => l_start_date_new

Line 3395: log_message('before calling PA_HR_UPDATE_API.withdraw_cand_nominations, l_resource_effective_end_date: '||l_resource_effective_end_date);

3391: INTO l_resource_effective_end_date
3392: FROM pa_resources_denorm
3393: WHERE person_id = l_person_id;
3394:
3395: log_message('before calling PA_HR_UPDATE_API.withdraw_cand_nominations, l_resource_effective_end_date: '||l_resource_effective_end_date);
3396: PA_HR_UPDATE_API.withdraw_cand_nominations
3397: ( p_person_id => l_person_id,
3398: p_effective_date => l_resource_effective_end_date,
3399: x_return_status => l_return_status,

Line 3396: PA_HR_UPDATE_API.withdraw_cand_nominations

3392: FROM pa_resources_denorm
3393: WHERE person_id = l_person_id;
3394:
3395: log_message('before calling PA_HR_UPDATE_API.withdraw_cand_nominations, l_resource_effective_end_date: '||l_resource_effective_end_date);
3396: PA_HR_UPDATE_API.withdraw_cand_nominations
3397: ( p_person_id => l_person_id,
3398: p_effective_date => l_resource_effective_end_date,
3399: x_return_status => l_return_status,
3400: x_msg_data => l_msg_data,

Line 3402: log_message('after calling PA_HR_UPDATE_API.withdraw_cand_nominations, l_return_status: '||l_return_status);

3398: p_effective_date => l_resource_effective_end_date,
3399: x_return_status => l_return_status,
3400: x_msg_data => l_msg_data,
3401: x_msg_count => l_msg_count);
3402: log_message('after calling PA_HR_UPDATE_API.withdraw_cand_nominations, l_return_status: '||l_return_status);
3403: END IF ;
3404:
3405:
3406: IF l_return_status = 'S' THEN