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.PA_HR_UPDATE_PA_ENTITIES dependencies on PA_HR_UPDATE_API

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

553:
554: wf_engine.SetItemAttrText ( itemtype => itemtype,
555: itemkey => itemkey,
556: aname => 'ORGANIZATION_NAME',
557: avalue => pa_hr_update_api.get_org_name(l_organization_id_child));
558:
559: wf_engine.SetItemAttrText ( itemtype => itemtype,
560: itemkey => itemkey,
561: aname => 'CHILD_ORGANIZATION_NAME',

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

558:
559: wf_engine.SetItemAttrText ( itemtype => itemtype,
560: itemkey => itemkey,
561: aname => 'CHILD_ORGANIZATION_NAME',
562: avalue => pa_hr_update_api.get_org_name(l_organization_id_parent));
563:
564: --
565: -- Call the api to populate the hierarchy denorm table
566: --

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

713:
714: wf_engine.SetItemAttrText ( itemtype => itemtype,
715: itemkey => itemkey,
716: aname => 'JOB_NAME',
717: avalue => pa_hr_update_api.get_job_name(l_job_id));
718:
719: log_message('before calling per_job_extra_billability');
720: --
721: -- Call api to process job billability

Line 725: pa_hr_update_api.per_job_extra_billability

721: -- Call api to process job billability
722: --
723: SAVEPOINT l_job_billability_change ;
724: l_savepoint := true;
725: pa_hr_update_api.per_job_extra_billability
726: (p_calling_mode =>l_calling_mode
727: ,P_job_id =>l_job_id
728: ,P_billable_flag_new =>l_jei_information2_new
729: ,P_billable_flag_old =>l_jei_information2_old

Line 911: PA_HR_UPDATE_API.update_name ( p_person_id => l_person_id

907: --
908:
909: SAVEPOINT l_full_name_change ;
910: l_savepoint := true;
911: PA_HR_UPDATE_API.update_name ( p_person_id => l_person_id
912: ,p_old_name => l_full_name_old
913: ,p_new_name => l_full_name_new
914: ,x_return_status => l_return_status
915: ,x_msg_count => l_msg_count

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

1077:
1078: wf_engine.SetItemAttrText ( itemtype => itemtype,
1079: itemkey => itemkey,
1080: aname => 'ORGANIZATION_NAME',
1081: avalue => pa_hr_update_api.get_org_name(l_org_id));
1082:
1083: SAVEPOINT l_ou_change ;
1084: l_savepoint := true;
1085:

Line 1088: pa_hr_update_api.default_ou_change

1084: l_savepoint := true;
1085:
1086: IF l_org_info_context = 'Exp Organization Defaults' THEN
1087:
1088: pa_hr_update_api.default_ou_change
1089: ( p_calling_mode => l_calling_mode,
1090: p_organization_id => l_org_id,
1091: p_default_ou_new => l_org_info1_new,
1092: p_default_ou_old => l_org_info1_old,

Line 1100: pa_hr_update_api.proj_res_job_group_change

1096: ) ;
1097:
1098: ELSIF l_org_info_context = 'Project Resource Job Group' THEN
1099:
1100: pa_hr_update_api.proj_res_job_group_change
1101: ( p_calling_mode => l_calling_mode,
1102: p_organization_id => l_org_id,
1103: p_proj_job_group_new => l_org_info1_new,
1104: p_proj_job_group_old => l_org_info1_old,

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

1289:
1290: wf_engine.SetItemAttrText ( itemtype => itemtype,
1291: itemkey => itemkey,
1292: aname => 'JOB_NAME',
1293: avalue => pa_hr_update_api.get_job_name(l_job_id_new));
1294:
1295: /*
1296: wf_engine.SetItemAttrText ( itemtype => itemtype,
1297: itemkey => itemkey,

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

1295: /*
1296: wf_engine.SetItemAttrText ( itemtype => itemtype,
1297: itemkey => itemkey,
1298: aname => 'GRADE_NAME',
1299: avalue => pa_hr_update_api.get_grade_name(l_grade_id_new));
1300: */
1301:
1302: SAVEPOINT l_valid_grade_change ;
1303: l_savepoint := true;

Line 1304: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode

1300: */
1301:
1302: SAVEPOINT l_valid_grade_change ;
1303: l_savepoint := true;
1304: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode
1305: ,P_per_valid_grade_job_id => l_job_id_New
1306: ,P_per_valid_grade_id_old => l_grade_id_old
1307: ,P_per_valid_grade_id_new => l_grade_id_New
1308: ,x_return_status => l_return_status

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

1467:
1468: wf_engine.SetItemAttrText ( itemtype => itemtype,
1469: itemkey => itemkey,
1470: aname => 'GRADE_NAME',
1471: avalue => pa_hr_update_api.get_grade_name(l_grade_id));
1472: */
1473:
1474: SAVEPOINT l_job_level_change ;
1475: l_savepoint := true;

Line 1476: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode

1472: */
1473:
1474: SAVEPOINT l_job_level_change ;
1475: l_savepoint := true;
1476: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode
1477: ,P_per_grades_grade_id => l_grade_id
1478: ,P_per_grades_sequence_old => l_job_level_old
1479: ,P_per_grades_sequence_new => l_job_level_new
1480: ,x_return_status => l_return_status

Line 1711: pa_hr_update_api.address_change( p_calling_mode => l_calling_mode

1707: SAVEPOINT l_address_change ;
1708: l_savepoint := true;
1709:
1710: --dbms_output.put_line('Calling address Update');
1711: pa_hr_update_api.address_change( p_calling_mode => l_calling_mode
1712: , p_person_id => l_person_id
1713: , p_country_old => l_country_old
1714: , p_country_new => l_country_new
1715: , p_city_old => l_city_old

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

1897:
1898: wf_engine.SetItemAttrText ( itemtype => itemtype,
1899: itemkey => itemkey,
1900: aname => 'ORGANIZATION_NAME',
1901: avalue => pa_hr_update_api.get_org_name(l_org_id));
1902:
1903:
1904: IF l_calling_mode = 'UPDATE' THEN
1905:

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

1911: --The following code checks to see if the organization of the resource belongs
1912: --to some other expenditure hierarchy. The resource must be end_dated / inactivated
1913: --only if he does not belong to any expenditure hierarchy
1914:
1915: if(pa_hr_update_api.belongs_ExpOrg(l_org_id) = 'N') then
1916: -- dbms_output.put_line('Making resources inactive');
1917:
1918: PA_HR_UPDATE_API.make_resource_inactive( p_calling_mode => l_calling_mode
1919: ,P_Organization_id => l_org_id

Line 1918: PA_HR_UPDATE_API.make_resource_inactive( p_calling_mode => l_calling_mode

1914:
1915: if(pa_hr_update_api.belongs_ExpOrg(l_org_id) = 'N') then
1916: -- dbms_output.put_line('Making resources inactive');
1917:
1918: PA_HR_UPDATE_API.make_resource_inactive( p_calling_mode => l_calling_mode
1919: ,P_Organization_id => l_org_id
1920: ,P_Default_OU => l_org_info1_new
1921: ,P_inactive_date => l_inactive_date_new
1922: ,x_return_status => l_return_status

Line 1927: PA_HR_UPDATE_API.pull_resources( P_Organization_id => l_org_id

1923: ,x_msg_count => l_msg_count
1924: ,x_msg_data => l_msg_data);
1925: else
1926: --dbms_output.put_line('Pulling resources');
1927: PA_HR_UPDATE_API.pull_resources( P_Organization_id => l_org_id
1928: ,x_return_status => l_return_status
1929: ,x_msg_count => l_msg_count
1930: ,x_msg_data => l_msg_data);
1931: end if;

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

1934: --dbms_output.put_line('Calling mode is Insert');
1935:
1936: SAVEPOINT l_project_org_change ;
1937: l_savepoint := true;
1938: pa_hr_update_api.default_ou_change( p_calling_mode => l_calling_mode,
1939: p_organization_id => l_org_id,
1940: p_default_ou_new => l_org_info1_new,
1941: p_default_ou_old => l_org_info1_old,
1942: x_return_status => l_return_status,

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

2124:
2125: wf_engine.SetItemAttrText ( itemtype => itemtype,
2126: itemkey => itemkey,
2127: aname => 'JOB_NAME',
2128: avalue => pa_hr_update_api.get_job_name(l_from_job_id_new));
2129:
2130: wf_engine.SetItemAttrText ( itemtype => itemtype,
2131: itemkey => itemkey,
2132: aname => 'TO_JOB_NAME',

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

2129:
2130: wf_engine.SetItemAttrText ( itemtype => itemtype,
2131: itemkey => itemkey,
2132: aname => 'TO_JOB_NAME',
2133: avalue => pa_hr_update_api.get_job_name(l_to_job_id_new));
2134:
2135: SAVEPOINT l_job_rel_change ;
2136: l_savepoint := true;
2137: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode

Line 2137: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode

2133: avalue => pa_hr_update_api.get_job_name(l_to_job_id_new));
2134:
2135: SAVEPOINT l_job_rel_change ;
2136: l_savepoint := true;
2137: PA_HR_UPDATE_API.update_job_levels( P_calling_mode => l_calling_mode
2138: ,P_from_job_id_old => l_from_job_id_old
2139: ,P_from_job_id_new => l_from_job_id_new
2140: ,P_to_job_id_old => l_to_job_id_old
2141: ,P_to_job_id_new => l_to_job_id_new

Line 2373: pa_hr_update_api.Delete_PA_Resource_Denorm (

2369: avalue => l_person_name);
2370:
2371: --Start of addition for bug 3957522
2372: if l_calling_mode = 'DELETE' then
2373: pa_hr_update_api.Delete_PA_Resource_Denorm (
2374: p_person_id => l_person_id
2375: ,p_old_start_date => l_start_date_old
2376: ,p_old_end_date => l_end_date_old
2377: ,x_return_status => l_return_status

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

2423:
2424: -- End of addition for bug 3957522.
2425: elsif l_calling_mode = 'INSERT' then
2426:
2427: if ( l_primary_flag_new = 'Y' and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y') then
2428: -- Added new if condition for Bug 7423251
2429: IF (pa_hr_update_api.check_job_utilization (p_job_id => l_job_id_new
2430: ,p_person_id => null
2431: ,p_date => null)) = 'Y' then

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

2425: elsif l_calling_mode = 'INSERT' then
2426:
2427: if ( l_primary_flag_new = 'Y' and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y') then
2428: -- Added new if condition for Bug 7423251
2429: IF (pa_hr_update_api.check_job_utilization (p_job_id => l_job_id_new
2430: ,p_person_id => null
2431: ,p_date => null)) = 'Y' then
2432: -- call the work flow to update pa objects
2433: SAVEPOINT l_assignment_change;

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

2480: SAVEPOINT l_assignment_change;
2481: l_savepoint := true;
2482:
2483: if ( l_primary_flag_new = 'Y' and l_primary_flag_old = 'N'
2484: and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y') then
2485: --dbms_output.put_line('Calling ind pull 1');
2486:
2487: -- call the work flow to update pa objects
2488: pa_r_project_resources_pub.create_resource (

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

2532:
2533: --dbms_output.put_line('Primary flags differ');
2534:
2535: if (l_primary_flag_new = 'Y' and l_primary_flag_old = 'N'
2536: and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'N') then
2537:
2538: /*If the assignments organization does not belong to expenditure hierarchy
2539: then the corresponding assignment in pa_resources_denorm must be
2540: end dated

Line 2542: pa_hr_update_api.Update_EndDate(

2538: /*If the assignments organization does not belong to expenditure hierarchy
2539: then the corresponding assignment in pa_resources_denorm must be
2540: end dated
2541: */
2542: pa_hr_update_api.Update_EndDate(
2543: p_person_id => l_person_id,
2544: p_old_start_date => l_start_date_old,
2545: p_new_start_date => l_start_date_new,
2546: p_old_end_date => l_end_date_old,

Line 2556: pa_hr_update_api.Update_PrimaryFlag (

2552:
2553: -- for all other cases, still need to call this API which will call
2554: -- forecast items
2555: -- call the work flow to update pa objects
2556: pa_hr_update_api.Update_PrimaryFlag (
2557: p_person_id => l_person_id
2558: ,p_old_start_date => l_start_date_old
2559: ,p_new_start_date => l_start_date_new
2560: ,p_old_end_date => l_end_date_old

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

2605: -- END -- Bug 4668272 - added exception handler
2606:
2607: -- Bug 4668272 change l_res_asgn_exists = 'Y' to 'N'
2608: /* if (l_res_asgn_exists = 'N' AND
2609: pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y') THEN commented and changed as below for bug 5665503 */
2610:
2611: if ( l_res_asgn_exists = 'N' OR (trunc( l_start_date_old) <> trunc( l_start_date_new)) )
2612: AND ( pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y')
2613: THEN

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

2608: /* if (l_res_asgn_exists = 'N' AND
2609: pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y') THEN commented and changed as below for bug 5665503 */
2610:
2611: if ( l_res_asgn_exists = 'N' OR (trunc( l_start_date_old) <> trunc( l_start_date_new)) )
2612: AND ( pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'Y')
2613: THEN
2614:
2615: --dbms_output.put_line('Calling ind pull 2 as record does not exist or start date is changed');
2616:

Line 2666: pa_hr_update_api.Update_EndDate (

2662:
2663: --dbms_output.put_line('Date Change');
2664:
2665: -- call the work flow to update pa objects
2666: pa_hr_update_api.Update_EndDate (
2667: p_person_id => l_person_id
2668: ,p_old_start_date => l_start_date_old
2669: ,p_new_start_date => l_start_date_new
2670: ,p_old_end_date => l_end_date_old

Line 2692: pa_hr_update_api.Update_Org (

2688:
2689: --dbms_output.put_line('Organization changed');
2690:
2691: -- call the work flow to update pa objects
2692: pa_hr_update_api.Update_Org (
2693: p_person_id => l_person_id
2694: ,p_old_org_id => l_org_id_old
2695: ,p_new_org_id => l_org_id_new
2696: ,p_old_start_date => l_start_date_old

Line 2721: pa_hr_update_api.Update_Job (

2717:
2718: --dbms_output.put_line('Job changed');
2719:
2720: -- call the work flow to update pa objects
2721: pa_hr_update_api.Update_Job (
2722: p_person_id => l_person_id
2723: ,p_old_job => l_job_id_old
2724: ,p_new_job => l_job_id_new
2725: ,p_new_start_date => l_start_date_new

Line 2748: pa_hr_update_api.Update_Supervisor (

2744:
2745: --dbms_output.put_line('Supervisor changed');
2746:
2747: -- call the work flow to update pa objects
2748: pa_hr_update_api.Update_Supervisor (
2749: p_person_id => l_person_id
2750: ,p_old_supervisor => l_supervisor_old
2751: ,p_new_supervisor => l_supervisor_new
2752: ,p_new_start_date => l_start_date_new

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

3194: INTO l_resource_effective_end_date
3195: FROM pa_resources_denorm
3196: WHERE person_id = l_person_id;
3197:
3198: log_message('before calling PA_HR_UPDATE_API.withdraw_cand_nominations, l_resource_effective_end_date: '||l_resource_effective_end_date);
3199: PA_HR_UPDATE_API.withdraw_cand_nominations
3200: ( p_person_id => l_person_id,
3201: p_effective_date => l_resource_effective_end_date,
3202: x_return_status => l_return_status,

Line 3199: PA_HR_UPDATE_API.withdraw_cand_nominations

3195: FROM pa_resources_denorm
3196: WHERE person_id = l_person_id;
3197:
3198: log_message('before calling PA_HR_UPDATE_API.withdraw_cand_nominations, l_resource_effective_end_date: '||l_resource_effective_end_date);
3199: PA_HR_UPDATE_API.withdraw_cand_nominations
3200: ( p_person_id => l_person_id,
3201: p_effective_date => l_resource_effective_end_date,
3202: x_return_status => l_return_status,
3203: x_msg_data => l_msg_data,

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

3201: p_effective_date => l_resource_effective_end_date,
3202: x_return_status => l_return_status,
3203: x_msg_data => l_msg_data,
3204: x_msg_count => l_msg_count);
3205: log_message('after calling PA_HR_UPDATE_API.withdraw_cand_nominations, l_return_status: '||l_return_status);
3206: END IF ;
3207:
3208:
3209: IF l_return_status = 'S' THEN