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.PAY_US_GEO_UPD_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1127: from hr_organization_information hoi

1123: )
1124: OR (piv.legislation_code is null
1125: and piv.business_group_id is not null
1126: and exists (select 'Y'
1127: from hr_organization_information hoi
1128: where hoi.organization_id = piv.business_group_id
1129: and hoi.org_information_context = 'Business Group Information'
1130: and hoi.org_information9 in ('US','CA')
1131: )

Line 3367: -- hr_organization_information table where the org_information_context

3363: END update_taxability_rules;
3364:
3365: -- This procedure is separate from the above main upgrade_geocodes
3366: -- This procedure will update the org_information1 column in the
3367: -- hr_organization_information table where the org_information_context
3368: -- is 'Local Tax Rules'
3369: -- This procedure will only be run by one process, NOT MULTIPLE TIMES
3370:
3371: PROCEDURE update_org_info(P_GEO_PHASE_ID IN NUMBER,

Line 3377: --Retrieve all changed geocodes in the hr_organization_information table

3373: P_PATCH_NAME IN VARCHAR2)
3374:
3375: IS
3376:
3377: --Retrieve all changed geocodes in the hr_organization_information table
3378:
3379: CURSOR org_info_cur IS
3380: SELECT distinct org_information1
3381: FROM pay_us_modified_geocodes pmod,

Line 3382: hr_organization_information hoi

3378:
3379: CURSOR org_info_cur IS
3380: SELECT distinct org_information1
3381: FROM pay_us_modified_geocodes pmod,
3382: hr_organization_information hoi
3383: WHERE pmod.state_code = substr(hoi.org_information1,1,2)
3384: AND pmod.county_code = substr(hoi.org_information1,4,3)
3385: AND pmod.old_city_code = substr(hoi.org_information1,8,4)
3386: AND pmod.process_type in ('UP','PU','RP')

Line 3390: where pugu.table_name = 'HR_ORGANIZATION_INFORMATION'

3386: AND pmod.process_type in ('UP','PU','RP')
3387: AND pmod.patch_name = p_patch_name
3388: AND hoi.org_information_context = 'Local Tax Rules'
3389: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
3390: where pugu.table_name = 'HR_ORGANIZATION_INFORMATION'
3391: and pugu.new_juri_code = hoi.org_information1
3392: and pugu.process_mode = g_mode
3393: and pugu.process_type = g_process_type
3394: and pugu.id = g_geo_phase_id);

Line 3402: --Retrieve all changed org_information1 on hr_organization_information table.

3398: --
3399: --
3400: --Per bug 2996546
3401: --Added a cursor org_info_ca_cur to the procedure update_org_info
3402: --Retrieve all changed org_information1 on hr_organization_information table.
3403: --and update (for Canadian Legislation)
3404: --
3405:
3406: CURSOR org_info_ca_cur IS

Line 3409: hr_organization_information hoi

3405:
3406: CURSOR org_info_ca_cur IS
3407: SELECT distinct hoi.org_information1, hoi.org_information_id
3408: FROM pay_us_modified_geocodes pmod,
3409: hr_organization_information hoi
3410: WHERE pmod.state_code = 'CA'
3411: AND pmod.county_code = substr(hoi.org_information1,1,2)
3412: AND pmod.patch_name = p_patch_name
3413: AND hoi.org_information_context in

Line 3424: new_geocode hr_organization_information.org_information1%TYPE;

3420: ) ;
3421: org_info_ca_rec org_info_ca_cur%ROWTYPE;
3422: --
3423: --
3424: new_geocode hr_organization_information.org_information1%TYPE;
3425: l_proc_type pay_us_modified_geocodes.process_type%TYPE;
3426: l_error_message_text varchar2(240);
3427:
3428: BEGIN

Line 3454: UPDATE hr_organization_information

3450: hr_utility.set_location('pay_us_geo_upd_pkg.update_org_info',2);
3451:
3452: IF G_MODE = 'UPGRADE' THEN
3453:
3454: UPDATE hr_organization_information
3455: SET org_information1 = new_geocode
3456: WHERE org_information1 = org_info_rec.org_information1
3457: AND org_information_context = 'Local Tax Rules';
3458:

Line 3474: p_location => 'HR_ORGANIZATION_INFORMATION',

3470: p_person_id => null,
3471: p_assign_id => null,
3472: p_old_juri_code => org_info_rec.org_information1,
3473: p_new_juri_code => new_geocode,
3474: p_location => 'HR_ORGANIZATION_INFORMATION',
3475: p_id => null);
3476:
3477: hr_utility.set_location('pay_us_geo_upd_pkg.update_org_info',4);
3478:

Line 3487: --Update of hr_organization_information . org_information1

3483: --
3484: --
3485:
3486: --Per bug 2996546
3487: --Update of hr_organization_information . org_information1
3488: --(Canadian Legislation)
3489:
3490: OPEN org_info_ca_cur;
3491: LOOP

Line 3508: UPDATE hr_organization_information

3504: AND pmod.patch_name = p_patch_name;
3505:
3506: IF G_MODE = 'UPGRADE' THEN
3507:
3508: UPDATE hr_organization_information
3509: SET org_information1 = new_geocode
3510: WHERE org_information1 = org_info_ca_rec.org_information1
3511: AND org_information_id = org_info_ca_rec.org_information_id
3512: AND org_information_context in

Line 3536: p_location => 'HR_ORGANIZATION_INFORMATION',

3532: p_person_id => null,
3533: p_assign_id => null,
3534: p_old_juri_code => org_info_rec.org_information1,
3535: p_new_juri_code => new_geocode,
3536: p_location => 'HR_ORGANIZATION_INFORMATION',
3537: p_id => null);
3538:
3539: hr_utility.set_location('pay_us_geo_upd_pkg.update_org_info',20);
3540: END LOOP ;