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 527: FROM sys.dual

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

Line 1176: FROM sys.dual

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

Line 1196: FROM sys.dual

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

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

1582: v_commit VARCHAR2(200) := FND_API.G_FALSE;
1583: -- set to false since the api is being called from trigger
1584: v_validate_only VARCHAR2(200) := FND_API.G_FALSE;
1585: v_internal VARCHAR2(1) := 'Y';
1586: v_individual VARCHAR2(1) := 'Y'; -- to process single resource in loop
1587: v_resource_type VARCHAR2(15):= 'EMPLOYEE';
1588: v_org_type VARCHAR2(15):= 'YES'; --'EXPENDITURES';
1589: v_msg_data VARCHAR2(2000);
1590: v_msg_count NUMBER;

Line 1740: ,P_INDIVIDUAL => v_individual

1736: ,P_COMMIT => v_commit
1737: ,P_VALIDATE_ONLY => v_validate_only
1738: ,P_INTERNAL => v_internal
1739: ,P_PERSON_ID => v_person_id
1740: ,P_INDIVIDUAL => v_individual
1741: ,P_RESOURCE_TYPE => v_resource_type
1742: ,X_RETURN_STATUS => x_return_status
1743: ,X_RESOURCE_ID => v_dummy
1744: ,X_MSG_COUNT => x_msg_count

Line 1791: ,P_INDIVIDUAL => v_individual

1787: ,P_COMMIT => v_commit
1788: ,P_VALIDATE_ONLY => v_validate_only
1789: ,P_INTERNAL => v_internal
1790: ,P_PERSON_ID => v_person_id
1791: ,P_INDIVIDUAL => v_individual
1792: ,P_RESOURCE_TYPE => v_resource_type
1793: ,X_RETURN_STATUS => x_return_status
1794: ,X_RESOURCE_ID => v_dummy
1795: ,X_MSG_COUNT => x_msg_count

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

2057: l_commit VARCHAR2(200) := FND_API.G_FALSE;
2058: -- set to false since the api is being called from trigger
2059: l_validate_only VARCHAR2(200) := FND_API.G_FALSE;
2060: l_internal VARCHAR2(1) := 'Y';
2061: l_individual VARCHAR2(1) := 'Y'; -- to process single resource in loop
2062: l_resource_type VARCHAR2(15):= 'EMPLOYEE';
2063: l_Person_id Per_all_assignments_f.person_id%type;
2064: l_return_status VARCHAR2(2000);
2065: l_msg_data VARCHAR2(2000);

Line 2099: ,P_INDIVIDUAL => l_individual

2095: ,P_COMMIT => l_commit
2096: ,P_VALIDATE_ONLY => l_validate_only
2097: ,P_INTERNAL => l_internal
2098: ,P_PERSON_ID => l_person_id
2099: ,P_INDIVIDUAL => l_individual
2100: ,P_RESOURCE_TYPE => l_resource_type
2101: ,X_RETURN_STATUS => l_return_status
2102: ,X_RESOURCE_ID => l_dummy
2103: ,X_MSG_COUNT => l_msg_count

Line 2886: ,p_individual => 'Y'

2882: ,p_commit => FND_API.G_FALSE
2883: ,p_validate_only => FND_API.G_FALSE
2884: ,p_internal => 'Y'
2885: ,p_person_id => rec.person_id
2886: ,p_individual => 'Y'
2887: ,p_resource_type => 'EMPLOYEE'
2888: ,x_resource_id => l_resource_id
2889: ,x_return_status => x_return_status
2890: ,x_msg_count => x_msg_count

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

3364: --MOAC Changes : Bug 4363092: Get the value of current org from PA_MOAC_UTILS.GET_CURRENT_ORG_ID
3365: /* CURSOR check_org_type IS
3366: select decode(substr(USERENV('CLIENT_INFO'),1,1),
3367: ' ', NULL,
3368: substr(USERENV('CLIENT_INFO'),1,10)) org from dual; */
3369:
3370: BEGIN
3371:
3372: --dbms_output.put_line('Inside Update Org');

Line 3399: ,p_individual => 'Y'

3395: ,p_validate_only => NULL
3396: ,p_max_msg_count => NULL
3397: ,p_internal => 'Y'
3398: ,p_person_id => p_person_id
3399: ,p_individual => 'Y'
3400: ,p_resource_type => NULL
3401: ,x_return_status => l_return_status
3402: ,x_msg_count => x_msg_count
3403: ,x_msg_data => x_msg_data

Line 3546: SELECT 'Y' FROM dual WHERE exists

3542: -- This function returns 'Y' if org_id in pa_all_organizations = the PJR default operating unit
3543: -- otherwise , it returns 'N'
3544:
3545: CURSOR c_check_pjr_default_ou IS
3546: SELECT 'Y' FROM dual WHERE exists
3547: (SELECT 'Y' FROM hr_organization_information
3548: WHERE organization_id = P_Organization_id
3549: and org_information_context = 'Exp Organization Defaults'
3550: and org_information1 = P_Default_OU_new);

Line 3587: FROM dual

3583: -- otherwise , it returns 'N'
3584:
3585: CURSOR c_exp_org IS
3586: SELECT 'x'
3587: FROM dual
3588: WHERE exists
3589: (select organization_id
3590: FROM pa_all_organizations
3591: WHERE organization_id = p_org_id

Line 3739: ,p_individual => 'Y'

3735: ,p_commit => FND_API.G_FALSE
3736: ,p_validate_only => FND_API.G_FALSE
3737: ,p_internal => 'Y'
3738: ,p_person_id => p_person_id
3739: ,p_individual => 'Y'
3740: ,p_resource_type => 'EMPLOYEE'
3741: ,x_resource_id => l_resource_id
3742: ,x_return_status => x_return_status
3743: ,x_msg_count => x_msg_count

Line 4113: ,p_individual => 'Y'

4109: ,p_validate_only => NULL
4110: ,p_max_msg_count => NULL
4111: ,p_internal => 'Y'
4112: ,p_person_id => p_person_id
4113: ,p_individual => 'Y'
4114: ,p_resource_type => 'EMPLOYEE'
4115: ,x_return_status => l_return_status
4116: ,x_msg_count => x_msg_count
4117: ,x_msg_data => x_msg_data