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.HR_DYNAMIC_APPROVAL_WEB dependencies on HR_MISC_WEB

Line 218: lrt_assignment_details hr_misc_web.grt_assignment_details;

214: ln_job_id NUMBER;
215: l_curr_org_name VARCHAR2(100);
216: l_curr_loc_name VARCHAR2(100);
217: ln_assignment_id NUMBER;
218: lrt_assignment_details hr_misc_web.grt_assignment_details;
219: l_proc constant varchar2(100) := g_package || ' get_job_details';
220:
221: BEGIN
222: hr_utility.set_location('Entering: '|| l_proc,5);

Line 228: lrt_assignment_details := hr_misc_web.get_assignment_id (

224: hr_utility.trace('In ( IF p_person_id IS NOT NULL): '|| l_proc);
225: -- check assignment id
226: IF p_assignment_id IS NULL THEN
227: -- get assignment id for the person_id
228: lrt_assignment_details := hr_misc_web.get_assignment_id (
229: p_person_id =>p_person_id);
230: ln_assignment_id := lrt_assignment_details.assignment_id;
231: ELSE
232: ln_assignment_id := p_assignment_id;

Line 235: lrt_assignment_details := hr_misc_web.get_assignment_details(

231: ELSE
232: ln_assignment_id := p_assignment_id;
233: END IF;
234: -- get the job details from the assignment record
235: lrt_assignment_details := hr_misc_web.get_assignment_details(
236: p_assignment_id => ln_assignment_id,
237: p_effective_date =>p_effective_date
238: );
239: ln_job_id := lrt_assignment_details.job_id;

Line 1591: lrt_assignment_details hr_misc_web.grt_assignment_details;

1587: lv_full_name per_people_f.full_name%TYPE;
1588: lv_job_title per_jobs.name%TYPE;
1589: ln_assignment_id per_assignments_f.ASSIGNMENT_ID%TYPE;
1590: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;
1591: lrt_assignment_details hr_misc_web.grt_assignment_details;
1592: l_proc constant varchar2(100) := g_package || ' get_ame_default_approvers';
1593: --my new variables
1594: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT
1595: hr_util_misc_web.g_varchar2_tab_default;

Line 1675: lrt_assignment_details := hr_misc_web.get_assignment_id (p_person_id =>lv_forward_to_id);

1671: -- Check if the AME approver is authority approver
1672: if(c_default_approvers(i).api_insertion <> ame_util.apiInsertion) then
1673: lv_forward_to_id := c_default_approvers(i).person_id;
1674: -- get assignment id for the approver
1675: lrt_assignment_details := hr_misc_web.get_assignment_id (p_person_id =>lv_forward_to_id);
1676: ln_assignment_id := lrt_assignment_details.assignment_id;
1677: -- get name and job title for this person id
1678: lrt_assignment_details := hr_misc_web.get_assignment_details(p_assignment_id => ln_assignment_id,
1679: p_effective_date =>ld_effective_date);

Line 1678: lrt_assignment_details := hr_misc_web.get_assignment_details(p_assignment_id => ln_assignment_id,

1674: -- get assignment id for the approver
1675: lrt_assignment_details := hr_misc_web.get_assignment_id (p_person_id =>lv_forward_to_id);
1676: ln_assignment_id := lrt_assignment_details.assignment_id;
1677: -- get name and job title for this person id
1678: lrt_assignment_details := hr_misc_web.get_assignment_details(p_assignment_id => ln_assignment_id,
1679: p_effective_date =>ld_effective_date);
1680:
1681: lv_full_name := lrt_assignment_details.person_full_name;
1682:

Line 1739: lrt_assignment_details hr_misc_web.grt_assignment_details;

1735: l_dummy VARCHAR2(100);
1736: ln_def_app_index NUMBER DEFAULT 1;
1737: ln_person_id per_people_f.person_id%TYPE;
1738: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1739: lrt_assignment_details hr_misc_web.grt_assignment_details;
1740: lv_approver_deleted VARCHAR2(100) DEFAULT NULL;
1741: lv_default_approver VARCHAR2(100) DEFAULT 'NO';
1742: ln_error_count NUMBER DEFAULT 1;
1743: lv_job_title VARCHAR2(1000);

Line 1819: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);

1815: lv_job_title := NULL;
1816: ln_person_id := c_all_approvers(i).person_id;
1817:
1818: -- get the assignment id
1819: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
1820: ln_assignment_id := lrt_assignment_details.assignment_id;
1821: -- get name and job title for this person id
1822: lrt_assignment_details := hr_misc_web.get_assignment_details(p_assignment_id => ln_assignment_id,
1823: p_effective_date =>p_effective_date);

Line 1822: lrt_assignment_details := hr_misc_web.get_assignment_details(p_assignment_id => ln_assignment_id,

1818: -- get the assignment id
1819: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
1820: ln_assignment_id := lrt_assignment_details.assignment_id;
1821: -- get name and job title for this person id
1822: lrt_assignment_details := hr_misc_web.get_assignment_details(p_assignment_id => ln_assignment_id,
1823: p_effective_date =>p_effective_date);
1824:
1825: grt_approver_details_table(ln_approver_list_index).full_name := lrt_assignment_details.person_full_name;
1826: grt_approver_details_table(ln_approver_list_index).person_id :=ln_person_id;

Line 1866: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);

1862: ln_assignment_id:= NULL;
1863: END IF;
1864: CLOSE lc_approver;
1865:
1866: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
1867: ln_assignment_id := lrt_assignment_details.assignment_id;
1868: -- get name and job title for this person id
1869: lrt_assignment_details := hr_misc_web.get_assignment_details(
1870: p_assignment_id => ln_assignment_id,

Line 1869: lrt_assignment_details := hr_misc_web.get_assignment_details(

1865:
1866: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
1867: ln_assignment_id := lrt_assignment_details.assignment_id;
1868: -- get name and job title for this person id
1869: lrt_assignment_details := hr_misc_web.get_assignment_details(
1870: p_assignment_id => ln_assignment_id,
1871: p_effective_date =>p_effective_date);
1872:
1873: lv_job_title := hr_dynamic_approval_web.get_job_details

Line 2082: lrt_assignment_details hr_misc_web.grt_assignment_details;

2078: lv_full_name per_people_f.full_name%TYPE;
2079: lv_job_title per_jobs.name%TYPE;
2080: ln_assignment_id per_assignments_f.ASSIGNMENT_ID%TYPE;
2081: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;
2082: lrt_assignment_details hr_misc_web.grt_assignment_details;
2083: l_proc constant varchar2(100) := g_package || ' get_default_approvers';
2084: --my new variables
2085: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT
2086: hr_util_misc_web.g_varchar2_tab_default;

Line 2227: lrt_assignment_details := hr_misc_web.get_assignment_id (

2223: -- set forward from to old forward to
2224: lv_current_forward_to_id := lv_forward_to_id;
2225:
2226: -- get assignment id for the approver
2227: lrt_assignment_details := hr_misc_web.get_assignment_id (
2228: p_person_id =>lv_forward_to_id);
2229: ln_assignment_id := lrt_assignment_details.assignment_id;
2230: -- get name and job title for this person id
2231: lrt_assignment_details := hr_misc_web.get_assignment_details(

Line 2231: lrt_assignment_details := hr_misc_web.get_assignment_details(

2227: lrt_assignment_details := hr_misc_web.get_assignment_id (
2228: p_person_id =>lv_forward_to_id);
2229: ln_assignment_id := lrt_assignment_details.assignment_id;
2230: -- get name and job title for this person id
2231: lrt_assignment_details := hr_misc_web.get_assignment_details(
2232: p_assignment_id => ln_assignment_id,
2233: p_effective_date =>ld_effective_date
2234: );
2235:

Line 2308: lrt_assignment_details hr_misc_web.grt_assignment_details;

2304: l_dummy VARCHAR2(100);
2305: ln_def_app_index NUMBER DEFAULT 1;
2306: ln_person_id per_people_f.person_id%TYPE;
2307: ln_assignment_id per_assignments_f.assignment_id%TYPE;
2308: lrt_assignment_details hr_misc_web.grt_assignment_details;
2309: lv_approver_deleted VARCHAR2(100) DEFAULT NULL;
2310: lv_default_approver VARCHAR2(100) DEFAULT 'NO';
2311: ln_error_count NUMBER DEFAULT 1;
2312: lv_job_title VARCHAR2(1000);

Line 2424: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);

2420: itemkey => p_item_key,
2421: aname => lv_item_name);
2422:
2423: -- get the assignment id
2424: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
2425: ln_assignment_id := lrt_assignment_details.assignment_id;
2426: -- get name and job title for this person id
2427: lrt_assignment_details := hr_misc_web.get_assignment_details(
2428: p_assignment_id => ln_assignment_id,

Line 2427: lrt_assignment_details := hr_misc_web.get_assignment_details(

2423: -- get the assignment id
2424: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
2425: ln_assignment_id := lrt_assignment_details.assignment_id;
2426: -- get name and job title for this person id
2427: lrt_assignment_details := hr_misc_web.get_assignment_details(
2428: p_assignment_id => ln_assignment_id,
2429: p_effective_date =>p_effective_date
2430: );
2431: grt_approver_details_table(I).full_name :=

Line 2450: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);

2446: grt_person_details_rec_table(ln_def_app_index).full_name ;
2447: grt_approver_details_table(I).person_id :=
2448: grt_person_details_rec_table(ln_def_app_index).person_id;
2449: ln_person_id := grt_person_details_rec_table(ln_def_app_index).person_id;
2450: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
2451: ln_assignment_id := lrt_assignment_details.assignment_id;
2452:
2453: grt_approver_details_table(I).job_title :=
2454: hr_dynamic_approval_web.get_job_details

Line 2494: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);

2490: ln_assignment_id:= NULL;
2491: END IF;
2492: CLOSE lc_approver;
2493:
2494: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
2495: ln_assignment_id := lrt_assignment_details.assignment_id;
2496: -- get name and job title for this person id
2497: lrt_assignment_details := hr_misc_web.get_assignment_details(
2498: p_assignment_id => ln_assignment_id,

Line 2497: lrt_assignment_details := hr_misc_web.get_assignment_details(

2493:
2494: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
2495: ln_assignment_id := lrt_assignment_details.assignment_id;
2496: -- get name and job title for this person id
2497: lrt_assignment_details := hr_misc_web.get_assignment_details(
2498: p_assignment_id => ln_assignment_id,
2499: p_effective_date =>p_effective_date
2500: );
2501:

Line 3112: lrt_assignment_details hr_misc_web.grt_assignment_details;

3108: lv_on_submit VARCHAR2(10);
3109: lv_on_approval VARCHAR2(10);
3110: lv_notify VARCHAR2(10);
3111: ln_assignment_id NUMBER ;
3112: lrt_assignment_details hr_misc_web.grt_assignment_details;
3113: ln_loop_index NUMBER;
3114: ln_job_id NUMBER;
3115: l_curr_org_name VARCHAR2(100);
3116: l_curr_loc_name VARCHAR2(100);

Line 3170: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);

3166: IF lv_exist = 'Y' THEN
3167: hr_utility.trace('In(IF lv_exist = Y): '|| l_proc);
3168: -- get the person and assignment details for this person_id
3169: -- get the assignment id
3170: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
3171: ln_assignment_id := lrt_assignment_details.assignment_id;
3172: -- get name and job title for this person id
3173: lrt_assignment_details := hr_misc_web.get_assignment_details(
3174: p_assignment_id => ln_assignment_id,

Line 3173: lrt_assignment_details := hr_misc_web.get_assignment_details(

3169: -- get the assignment id
3170: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
3171: ln_assignment_id := lrt_assignment_details.assignment_id;
3172: -- get name and job title for this person id
3173: lrt_assignment_details := hr_misc_web.get_assignment_details(
3174: p_assignment_id => ln_assignment_id,
3175: p_effective_date =>p_effective_date
3176: );
3177:

Line 3259: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);

3255: lrt_notifier_details_table(I).person_id := NULL;
3256: ELSE
3257: lrt_notifier_details_table(I).person_id := ln_person_id;
3258: END IF;
3259: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
3260: ln_assignment_id := lrt_assignment_details.assignment_id;
3261:
3262: -- get name and job title for this person id
3263: lrt_assignment_details := hr_misc_web.get_assignment_details(

Line 3263: lrt_assignment_details := hr_misc_web.get_assignment_details(

3259: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
3260: ln_assignment_id := lrt_assignment_details.assignment_id;
3261:
3262: -- get name and job title for this person id
3263: lrt_assignment_details := hr_misc_web.get_assignment_details(
3264: p_assignment_id => ln_assignment_id,
3265: p_effective_date =>p_effective_date
3266: );
3267:

Line 5666: lrt_assignment_details hr_misc_web.grt_assignment_details;

5662: lv_on_submit VARCHAR2(10);
5663: lv_on_approval VARCHAR2(10);
5664: lv_notify VARCHAR2(10);
5665: ln_assignment_id NUMBER ;
5666: lrt_assignment_details hr_misc_web.grt_assignment_details;
5667: ln_loop_index NUMBER;
5668: ln_job_id NUMBER;
5669: l_curr_org_name VARCHAR2(100);
5670: l_curr_loc_name VARCHAR2(100);

Line 5724: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);

5720:
5721: IF lv_exist = 'Y' THEN
5722: -- get the person and assignment details for this person_id
5723: -- get the assignment id
5724: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
5725: ln_assignment_id := lrt_assignment_details.assignment_id;
5726: -- get name and job title for this person id
5727: lrt_assignment_details := hr_misc_web.get_assignment_details(
5728: p_assignment_id => ln_assignment_id,

Line 5727: lrt_assignment_details := hr_misc_web.get_assignment_details(

5723: -- get the assignment id
5724: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
5725: ln_assignment_id := lrt_assignment_details.assignment_id;
5726: -- get name and job title for this person id
5727: lrt_assignment_details := hr_misc_web.get_assignment_details(
5728: p_assignment_id => ln_assignment_id,
5729: p_effective_date =>trunc(sysdate)
5730: );
5731: