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_API dependencies on DUAL

Line 530: FROM sys.dual

526: CURSOR get_job_ids(
527: l_job_id per_jobs.job_id%type
528: ) is
529: SELECT l_job_id effected_job_id
530: FROM sys.dual
531: ,per_job_groups pjg
532: WHERE pjg.master_flag = 'Y'
533: AND pjg.job_group_id = get_job_group_id(l_job_id)
534: UNION

Line 1179: FROM sys.dual

1175: CURSOR get_job_ids(
1176: l_job_id per_jobs.job_id%type
1177: ) is
1178: SELECT l_job_id effected_job_id
1179: FROM sys.dual
1180: ,per_job_groups pjg
1181: WHERE pjg.master_flag = 'Y'
1182: AND pjg.job_group_id = get_job_group_id(l_job_id)
1183: UNION

Line 1199: FROM sys.dual

1195: AND pjr.from_job_id = l_job_id
1196: AND pjr.from_job_group_id = pjg.job_group_id
1197: UNION
1198: SELECT l_job_id effected_job_id
1199: FROM sys.dual
1200: ,per_job_groups pjg
1201: WHERE pjg.master_flag = 'N'
1202: AND pjg.job_group_id = get_job_group_id(l_job_id)
1203: AND NOT EXISTS (

Line 1593: v_individual VARCHAR2(1) := 'Y'; -- to process single resource in loop

1589: v_commit VARCHAR2(200) := FND_API.G_FALSE;
1590: -- set to false since the api is being called from trigger
1591: v_validate_only VARCHAR2(200) := FND_API.G_FALSE;
1592: v_internal VARCHAR2(1) := 'Y';
1593: v_individual VARCHAR2(1) := 'Y'; -- to process single resource in loop
1594: v_resource_type VARCHAR2(15):= 'EMPLOYEE';
1595: v_org_type VARCHAR2(15):= 'YES'; --'EXPENDITURES';
1596: v_msg_data VARCHAR2(2000);
1597: v_msg_count NUMBER;

Line 1747: ,P_INDIVIDUAL => v_individual

1743: ,P_COMMIT => v_commit
1744: ,P_VALIDATE_ONLY => v_validate_only
1745: ,P_INTERNAL => v_internal
1746: ,P_PERSON_ID => v_person_id
1747: ,P_INDIVIDUAL => v_individual
1748: ,P_RESOURCE_TYPE => v_resource_type
1749: ,X_RETURN_STATUS => x_return_status
1750: ,X_RESOURCE_ID => v_dummy
1751: ,X_MSG_COUNT => x_msg_count

Line 1798: ,P_INDIVIDUAL => v_individual

1794: ,P_COMMIT => v_commit
1795: ,P_VALIDATE_ONLY => v_validate_only
1796: ,P_INTERNAL => v_internal
1797: ,P_PERSON_ID => v_person_id
1798: ,P_INDIVIDUAL => v_individual
1799: ,P_RESOURCE_TYPE => v_resource_type
1800: ,X_RETURN_STATUS => x_return_status
1801: ,X_RESOURCE_ID => v_dummy
1802: ,X_MSG_COUNT => x_msg_count

Line 2068: l_individual VARCHAR2(1) := 'Y'; -- to process single resource in loop

2064: l_commit VARCHAR2(200) := FND_API.G_FALSE;
2065: -- set to false since the api is being called from trigger
2066: l_validate_only VARCHAR2(200) := FND_API.G_FALSE;
2067: l_internal VARCHAR2(1) := 'Y';
2068: l_individual VARCHAR2(1) := 'Y'; -- to process single resource in loop
2069: l_resource_type VARCHAR2(15):= 'EMPLOYEE';
2070: l_Person_id Per_all_assignments_f.person_id%type;
2071: l_return_status VARCHAR2(2000);
2072: l_msg_data VARCHAR2(2000);

Line 2106: ,P_INDIVIDUAL => l_individual

2102: ,P_COMMIT => l_commit
2103: ,P_VALIDATE_ONLY => l_validate_only
2104: ,P_INTERNAL => l_internal
2105: ,P_PERSON_ID => l_person_id
2106: ,P_INDIVIDUAL => l_individual
2107: ,P_RESOURCE_TYPE => l_resource_type
2108: ,X_RETURN_STATUS => l_return_status
2109: ,X_RESOURCE_ID => l_dummy
2110: ,X_MSG_COUNT => l_msg_count

Line 2893: ,p_individual => 'Y'

2889: ,p_commit => FND_API.G_FALSE
2890: ,p_validate_only => FND_API.G_FALSE
2891: ,p_internal => 'Y'
2892: ,p_person_id => rec.person_id
2893: ,p_individual => 'Y'
2894: ,p_resource_type => 'EMPLOYEE'
2895: ,x_resource_id => l_resource_id
2896: ,x_return_status => x_return_status
2897: ,x_msg_count => x_msg_count

Line 3488: substr(USERENV('CLIENT_INFO'),1,10)) org from dual; */

3484: --MOAC Changes : Bug 4363092: Get the value of current org from PA_MOAC_UTILS.GET_CURRENT_ORG_ID
3485: /* CURSOR check_org_type IS
3486: select decode(substr(USERENV('CLIENT_INFO'),1,1),
3487: ' ', NULL,
3488: substr(USERENV('CLIENT_INFO'),1,10)) org from dual; */
3489:
3490: BEGIN
3491:
3492: --dbms_output.put_line('Inside Update Org');

Line 3519: ,p_individual => 'Y'

3515: ,p_validate_only => NULL
3516: ,p_max_msg_count => NULL
3517: ,p_internal => 'Y'
3518: ,p_person_id => p_person_id
3519: ,p_individual => 'Y'
3520: ,p_resource_type => NULL
3521: ,x_return_status => l_return_status
3522: ,x_msg_count => x_msg_count
3523: ,x_msg_data => x_msg_data

Line 3667: SELECT 'Y' FROM dual WHERE exists

3663: -- This function returns 'Y' if org_id in pa_all_organizations = the PJR default operating unit
3664: -- otherwise , it returns 'N'
3665:
3666: CURSOR c_check_pjr_default_ou IS
3667: SELECT 'Y' FROM dual WHERE exists
3668: (SELECT 'Y' FROM hr_organization_information
3669: WHERE organization_id = P_Organization_id
3670: and org_information_context = 'Exp Organization Defaults'
3671: and org_information1 = P_Default_OU_new);

Line 3708: FROM dual

3704: -- otherwise , it returns 'N'
3705:
3706: CURSOR c_exp_org IS
3707: SELECT 'x'
3708: FROM dual
3709: WHERE exists
3710: (select organization_id
3711: FROM pa_all_organizations
3712: WHERE organization_id = p_org_id

Line 3873: ,p_individual => 'Y'

3869: ,p_commit => FND_API.G_FALSE
3870: ,p_validate_only => FND_API.G_FALSE
3871: ,p_internal => 'Y'
3872: ,p_person_id => p_person_id
3873: ,p_individual => 'Y'
3874: ,p_resource_type => 'EMPLOYEE'
3875: ,x_resource_id => l_resource_id
3876: ,x_return_status => x_return_status
3877: ,x_msg_count => x_msg_count

Line 4252: ,p_individual => 'Y'

4248: ,p_validate_only => NULL
4249: ,p_max_msg_count => NULL
4250: ,p_internal => 'Y'
4251: ,p_person_id => p_person_id
4252: ,p_individual => 'Y'
4253: ,p_resource_type => 'EMPLOYEE'
4254: ,x_return_status => l_return_status
4255: ,x_msg_count => x_msg_count
4256: ,x_msg_data => x_msg_data