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 PER_ASSIGNMENTS_F

Line 106: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

102:
103:
104: -- CURSOR FOR JOB TITLE
105: CURSOR gc_job_details (
106: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
107: p_effective_date IN DATE
108: ) IS
109: SELECT pj.name
110: FROM per_jobs_vl pj,

Line 111: per_assignments_f paf

107: p_effective_date IN DATE
108: ) IS
109: SELECT pj.name
110: FROM per_jobs_vl pj,
111: per_assignments_f paf
112: WHERE paf.assignment_id = p_assignment_id
113: AND paf.job_id = pj.job_id
114: AND paf.primary_flag = 'Y'
115: AND paf.business_group_id+0 = pj.business_group_id+0

Line 122: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

118: ORDER BY paf.effective_start_date DESC;
119:
120: -- cursor for JOB ID
121: CURSOR gc_job_id (
122: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
123: p_effective_date IN DATE
124: ) IS
125: SELECT pj.job_id
126: FROM per_jobs pj,

Line 127: per_assignments_f paf

123: p_effective_date IN DATE
124: ) IS
125: SELECT pj.job_id
126: FROM per_jobs pj,
127: per_assignments_f paf
128: WHERE paf.assignment_id = p_assignment_id
129: AND paf.job_id = pj.job_id
130: AND paf.primary_flag = 'Y'
131: AND paf.business_group_id+0 = pj.business_group_id+0

Line 1589: ln_assignment_id per_assignments_f.ASSIGNMENT_ID%TYPE;

1585: lv_result VARCHAR2(20) DEFAULT 'N';
1586: ln_approver_index NUMBER DEFAULT 1;
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

Line 1590: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;

1586: ln_approver_index NUMBER DEFAULT 1;
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

Line 1738: ln_assignment_id per_assignments_f.assignment_id%TYPE;

1734: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
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;

Line 2080: ln_assignment_id per_assignments_f.ASSIGNMENT_ID%TYPE;

2076: lv_result VARCHAR2(20) DEFAULT 'N';
2077: ln_approver_index NUMBER DEFAULT 1;
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

Line 2081: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;

2077: ln_approver_index NUMBER DEFAULT 1;
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

Line 2307: ln_assignment_id per_assignments_f.assignment_id%TYPE;

2303: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
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;