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_PEOPLE_F

Line 23: gn_person_id per_people_f.person_id%TYPE;

19: gv_dynappr_js_file CONSTANT VARCHAR2(100) DEFAULT 'hrdynapr.js';
20: gv_form_name CONSTANT VARCHAR2(100) DEFAULT 'approvalsForm';
21: gv_tip_test_mode BOOLEAN DEFAULT FALSE;
22: gv_user_date_format VARCHAR2(2000);
23: gn_person_id per_people_f.person_id%TYPE;
24: gn_assignment_id per_all_assignments_f.assignment_id%TYPE;
25: gv_error_table hr_dynamic_approval_web.t_person_table;
26: grt_wf_attributes_rec hr_dynamic_approval_web.grt_wf_attributes;
27:

Line 73: p_person IN per_people_f.person_id%TYPE

69: -- Cursors for the Name, Job Title
70:
71: -- CURSOR FOR FULL_NAME
72: CURSOR gc_full_name (
73: p_person IN per_people_f.person_id%TYPE
74: )
75: IS
76: SELECT peo.full_name
77: FROM per_people_f peo

Line 77: FROM per_people_f peo

73: p_person IN per_people_f.person_id%TYPE
74: )
75: IS
76: SELECT peo.full_name
77: FROM per_people_f peo
78: WHERE peo.person_id = p_person;
79:
80: -- curosr for Person_id
81: CURSOR lc_approver ( p_full_name VARCHAR2)

Line 88: CURSOR gc_assignment_id (p_person_id IN per_people_f.person_id%TYPE,

84: FROM per_all_people_f
85: WHERE full_name = p_full_name ;
86:
87: -- assignment id for the approver
88: CURSOR gc_assignment_id (p_person_id IN per_people_f.person_id%TYPE,
89: p_effective_date IN DATE
90: ) IS
91: SELECT paf.assignment_id
92: FROM

Line 486: ln_person_id per_people_f.person_id%TYPE;

482: DEFAULT hr_util_misc_web.g_varchar2_tab_default)
483:
484: IS
485: -- Local variables
486: ln_person_id per_people_f.person_id%TYPE;
487: lv_exists VARCHAR2(10);
488: lv_dummy VARCHAR2(100);
489: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
490: ln_addntl_approvers NUMBER DEFAULT 0;

Line 626: ln_person_id per_people_f.person_id%TYPE;

622: p_mode IN VARCHAR2
623: )
624: IS
625: -- Local variables
626: ln_person_id per_people_f.person_id%TYPE;
627: lv_exists VARCHAR2(10);
628: lv_dummy VARCHAR2(100);
629: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
630: ln_addntl_approvers NUMBER DEFAULT 0;

Line 1142: ln_approver_id per_people_f.person_id%TYPE DEFAULT NULL;

1138: p_approver_flag IN hr_util_misc_web.g_varchar2_tab_type,
1139: p_error_flag OUT NOCOPY BOOLEAN )
1140: IS
1141: -- Local variables
1142: ln_approver_id per_people_f.person_id%TYPE DEFAULT NULL;
1143: lv_job_title VARCHAR2(1000) DEFAULT NULL;
1144: ln_assignment_id NUMBER;
1145: ld_effective_date DATE;
1146: lv_exists VARCHAR2(10) DEFAULT 'N';

Line 1319: ln_notifier_id per_people_f.person_id%TYPE DEFAULT NULL;

1315: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1316: p_error_flag OUT NOCOPY BOOLEAN )
1317: IS
1318: -- Local variables
1319: ln_notifier_id per_people_f.person_id%TYPE DEFAULT NULL;
1320: lv_job_title VARCHAR2(1000) DEFAULT NULL;
1321: ln_assignment_id NUMBER;
1322: ld_effective_date DATE;
1323: lv_exists VARCHAR2(10) DEFAULT 'N';

Line 1544: lv_creator_person_id per_people_f.person_id%TYPE ;

1540: AS
1541:
1542: --local variables
1543: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
1544: lv_creator_person_id per_people_f.person_id%TYPE ;
1545: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
1546: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
1547: lv_current_forward_to_id per_people_f.person_id%TYPE ;
1548: lv_current_forward_from_id per_people_f.person_id%TYPE ;

Line 1545: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;

1541:
1542: --local variables
1543: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
1544: lv_creator_person_id per_people_f.person_id%TYPE ;
1545: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
1546: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
1547: lv_current_forward_to_id per_people_f.person_id%TYPE ;
1548: lv_current_forward_from_id per_people_f.person_id%TYPE ;
1549: lv_result VARCHAR2(20) DEFAULT 'N';

Line 1546: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;

1542: --local variables
1543: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
1544: lv_creator_person_id per_people_f.person_id%TYPE ;
1545: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
1546: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
1547: lv_current_forward_to_id per_people_f.person_id%TYPE ;
1548: lv_current_forward_from_id per_people_f.person_id%TYPE ;
1549: lv_result VARCHAR2(20) DEFAULT 'N';
1550: ln_approver_index NUMBER DEFAULT 1;

Line 1547: lv_current_forward_to_id per_people_f.person_id%TYPE ;

1543: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
1544: lv_creator_person_id per_people_f.person_id%TYPE ;
1545: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
1546: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
1547: lv_current_forward_to_id per_people_f.person_id%TYPE ;
1548: lv_current_forward_from_id per_people_f.person_id%TYPE ;
1549: lv_result VARCHAR2(20) DEFAULT 'N';
1550: ln_approver_index NUMBER DEFAULT 1;
1551: lv_full_name per_people_f.full_name%TYPE;

Line 1548: lv_current_forward_from_id per_people_f.person_id%TYPE ;

1544: lv_creator_person_id per_people_f.person_id%TYPE ;
1545: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
1546: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
1547: lv_current_forward_to_id per_people_f.person_id%TYPE ;
1548: lv_current_forward_from_id per_people_f.person_id%TYPE ;
1549: lv_result VARCHAR2(20) DEFAULT 'N';
1550: ln_approver_index NUMBER DEFAULT 1;
1551: lv_full_name per_people_f.full_name%TYPE;
1552: lv_job_title per_jobs.name%TYPE;

Line 1551: lv_full_name per_people_f.full_name%TYPE;

1547: lv_current_forward_to_id per_people_f.person_id%TYPE ;
1548: lv_current_forward_from_id per_people_f.person_id%TYPE ;
1549: lv_result VARCHAR2(20) DEFAULT 'N';
1550: ln_approver_index NUMBER DEFAULT 1;
1551: lv_full_name per_people_f.full_name%TYPE;
1552: lv_job_title per_jobs.name%TYPE;
1553: ln_assignment_id per_assignments_f.ASSIGNMENT_ID%TYPE;
1554: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;
1555: lrt_assignment_details hr_misc_web.grt_assignment_details;

Line 1688: ln_person_id per_people_f.person_id%TYPE;

1684: ln_num_of_add_apprs NUMBER DEFAULT 0;
1685: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
1686: l_dummy VARCHAR2(100);
1687: ln_def_app_index NUMBER DEFAULT 1;
1688: ln_person_id per_people_f.person_id%TYPE;
1689: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1690: lrt_assignment_details hr_misc_web.grt_assignment_details;
1691: lv_approver_deleted VARCHAR2(100) DEFAULT NULL;
1692: lv_default_approver VARCHAR2(100) DEFAULT 'NO';

Line 2010: lv_creator_person_id per_people_f.person_id%TYPE ;

2006: AS
2007:
2008: --local variables
2009: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
2010: lv_creator_person_id per_people_f.person_id%TYPE ;
2011: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
2012: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
2013: lv_current_forward_to_id per_people_f.person_id%TYPE ;
2014: lv_current_forward_from_id per_people_f.person_id%TYPE ;

Line 2011: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;

2007:
2008: --local variables
2009: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
2010: lv_creator_person_id per_people_f.person_id%TYPE ;
2011: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
2012: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
2013: lv_current_forward_to_id per_people_f.person_id%TYPE ;
2014: lv_current_forward_from_id per_people_f.person_id%TYPE ;
2015: lv_result VARCHAR2(20) DEFAULT 'N';

Line 2012: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;

2008: --local variables
2009: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
2010: lv_creator_person_id per_people_f.person_id%TYPE ;
2011: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
2012: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
2013: lv_current_forward_to_id per_people_f.person_id%TYPE ;
2014: lv_current_forward_from_id per_people_f.person_id%TYPE ;
2015: lv_result VARCHAR2(20) DEFAULT 'N';
2016: ln_approver_index NUMBER DEFAULT 1;

Line 2013: lv_current_forward_to_id per_people_f.person_id%TYPE ;

2009: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
2010: lv_creator_person_id per_people_f.person_id%TYPE ;
2011: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
2012: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
2013: lv_current_forward_to_id per_people_f.person_id%TYPE ;
2014: lv_current_forward_from_id per_people_f.person_id%TYPE ;
2015: lv_result VARCHAR2(20) DEFAULT 'N';
2016: ln_approver_index NUMBER DEFAULT 1;
2017: lv_full_name per_people_f.full_name%TYPE;

Line 2014: lv_current_forward_from_id per_people_f.person_id%TYPE ;

2010: lv_creator_person_id per_people_f.person_id%TYPE ;
2011: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
2012: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
2013: lv_current_forward_to_id per_people_f.person_id%TYPE ;
2014: lv_current_forward_from_id per_people_f.person_id%TYPE ;
2015: lv_result VARCHAR2(20) DEFAULT 'N';
2016: ln_approver_index NUMBER DEFAULT 1;
2017: lv_full_name per_people_f.full_name%TYPE;
2018: lv_job_title per_jobs.name%TYPE;

Line 2017: lv_full_name per_people_f.full_name%TYPE;

2013: lv_current_forward_to_id per_people_f.person_id%TYPE ;
2014: lv_current_forward_from_id per_people_f.person_id%TYPE ;
2015: lv_result VARCHAR2(20) DEFAULT 'N';
2016: ln_approver_index NUMBER DEFAULT 1;
2017: lv_full_name per_people_f.full_name%TYPE;
2018: lv_job_title per_jobs.name%TYPE;
2019: ln_assignment_id per_assignments_f.ASSIGNMENT_ID%TYPE;
2020: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;
2021: lrt_assignment_details hr_misc_web.grt_assignment_details;

Line 2236: ln_person_id per_people_f.person_id%TYPE;

2232: ln_num_of_add_apprs NUMBER DEFAULT 0;
2233: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2234: l_dummy VARCHAR2(100);
2235: ln_def_app_index NUMBER DEFAULT 1;
2236: ln_person_id per_people_f.person_id%TYPE;
2237: ln_assignment_id per_assignments_f.assignment_id%TYPE;
2238: lrt_assignment_details hr_misc_web.grt_assignment_details;
2239: lv_approver_deleted VARCHAR2(100) DEFAULT NULL;
2240: lv_default_approver VARCHAR2(100) DEFAULT 'NO';

Line 2490: ln_person_id per_people_f.person_id%TYPE;

2486: ln_number_of_approvers NUMBER ;
2487: l_dummy VARCHAR2(100);
2488: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2489: ln_def_app_index NUMBER DEFAULT 1;
2490: ln_person_id per_people_f.person_id%TYPE;
2491: ln_full_name per_people_f.full_name%TYPE;
2492: lv_index NUMBER;
2493: -- local variable
2494: l_proc constant varchar2(100) := g_package || ' build_ddl';

Line 2491: ln_full_name per_people_f.full_name%TYPE;

2487: l_dummy VARCHAR2(100);
2488: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2489: ln_def_app_index NUMBER DEFAULT 1;
2490: ln_person_id per_people_f.person_id%TYPE;
2491: ln_full_name per_people_f.full_name%TYPE;
2492: lv_index NUMBER;
2493: -- local variable
2494: l_proc constant varchar2(100) := g_package || ' build_ddl';
2495: BEGIN

Line 2581: ln_from_index_id per_people_f.person_id%TYPE;

2577: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2578: l_dummy NUMBER(1);
2579: lv_item_name_from VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2580: lv_item_name_to VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2581: ln_from_index_id per_people_f.person_id%TYPE;
2582: ln_to_index_id per_people_f.person_id%TYPE;
2583: ln_start_index NUMBER ;
2584: ln_end_index NUMBER ;
2585: ln_loop_index NUMBER;

Line 2582: ln_to_index_id per_people_f.person_id%TYPE;

2578: l_dummy NUMBER(1);
2579: lv_item_name_from VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2580: lv_item_name_to VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2581: ln_from_index_id per_people_f.person_id%TYPE;
2582: ln_to_index_id per_people_f.person_id%TYPE;
2583: ln_start_index NUMBER ;
2584: ln_end_index NUMBER ;
2585: ln_loop_index NUMBER;
2586: lv_exist VARCHAR2(10) DEFAULT 'NO';

Line 2659: ln_from_index_id per_people_f.person_id%TYPE;

2655: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2656: l_dummy NUMBER(1);
2657: lv_item_name_from VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2658: lv_item_name_to VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2659: ln_from_index_id per_people_f.person_id%TYPE;
2660: ln_to_index_id per_people_f.person_id%TYPE;
2661: ln_start_index NUMBER ;
2662: ln_end_index NUMBER ;
2663: ln_loop_index NUMBER;

Line 2660: ln_to_index_id per_people_f.person_id%TYPE;

2656: l_dummy NUMBER(1);
2657: lv_item_name_from VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2658: lv_item_name_to VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2659: ln_from_index_id per_people_f.person_id%TYPE;
2660: ln_to_index_id per_people_f.person_id%TYPE;
2661: ln_start_index NUMBER ;
2662: ln_end_index NUMBER ;
2663: ln_loop_index NUMBER;
2664: lv_exist VARCHAR2(10) DEFAULT 'NO';

Line 2666: ln_current_person_id per_people_f.person_id%TYPE;

2662: ln_end_index NUMBER ;
2663: ln_loop_index NUMBER;
2664: lv_exist VARCHAR2(10) DEFAULT 'NO';
2665: ln_current_index NUMBER;
2666: ln_current_person_id per_people_f.person_id%TYPE;
2667: ln_change_to_index NUMBER;
2668: ln_change_to_person_id per_people_f.person_id%TYPE;
2669: ln_curr_add_appr_index NUMBER DEFAULT 0;
2670: lv_last_addnl_approver VARCHAR2(10) DEFAULT 'NO';

Line 2668: ln_change_to_person_id per_people_f.person_id%TYPE;

2664: lv_exist VARCHAR2(10) DEFAULT 'NO';
2665: ln_current_index NUMBER;
2666: ln_current_person_id per_people_f.person_id%TYPE;
2667: ln_change_to_index NUMBER;
2668: ln_change_to_person_id per_people_f.person_id%TYPE;
2669: ln_curr_add_appr_index NUMBER DEFAULT 0;
2670: lv_last_addnl_approver VARCHAR2(10) DEFAULT 'NO';
2671: lv_valid_approver VARCHAR2(100) DEFAULT 'VALID';
2672: l_proc constant varchar2(100) := g_package || ' delete_approver';

Line 3035: ln_person_id per_people_f.person_id%TYPE;

3031: lv_exist VARCHAR2(10) DEFAULT 'N';
3032: l_dummy VARCHAR2(100) ;
3033: lv_item_name VARCHAR2(100);
3034: lrt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;
3035: ln_person_id per_people_f.person_id%TYPE;
3036: lv_full_name per_people_f.person_id%TYPE;
3037: lv_job_title VARCHAR2(1000);
3038: lv_on_submit VARCHAR2(10);
3039: lv_on_approval VARCHAR2(10);

Line 3036: lv_full_name per_people_f.person_id%TYPE;

3032: l_dummy VARCHAR2(100) ;
3033: lv_item_name VARCHAR2(100);
3034: lrt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;
3035: ln_person_id per_people_f.person_id%TYPE;
3036: lv_full_name per_people_f.person_id%TYPE;
3037: lv_job_title VARCHAR2(1000);
3038: lv_on_submit VARCHAR2(10);
3039: lv_on_approval VARCHAR2(10);
3040: lv_notify VARCHAR2(10);

Line 3333: ln_approver_id per_people_f.person_id%TYPE ;

3329: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type
3330: )
3331: AS
3332: -- Local Varaibles
3333: ln_approver_id per_people_f.person_id%TYPE ;
3334: lv_job_title VARCHAR2(1000) DEFAULT NULL;
3335: ln_assignment_id NUMBER;
3336: ld_effective_date DATE;
3337: lv_exists VARCHAR2(10) DEFAULT 'N';

Line 3442: l_creator_person_id per_people_f.person_id%type;

3438:
3439: -- -------------------------------------------------------------------------
3440: -- local variables
3441: -- -------------------------------------------------------------------------
3442: l_creator_person_id per_people_f.person_id%type;
3443: l_forward_from_person_id per_people_f.person_id%type;
3444: l_forward_from_username wf_users.name%type;
3445: l_forward_from_disp_name wf_users.display_name%type;
3446: l_forward_to_person_id per_people_f.person_id%type;

Line 3443: l_forward_from_person_id per_people_f.person_id%type;

3439: -- -------------------------------------------------------------------------
3440: -- local variables
3441: -- -------------------------------------------------------------------------
3442: l_creator_person_id per_people_f.person_id%type;
3443: l_forward_from_person_id per_people_f.person_id%type;
3444: l_forward_from_username wf_users.name%type;
3445: l_forward_from_disp_name wf_users.display_name%type;
3446: l_forward_to_person_id per_people_f.person_id%type;
3447: l_forward_to_username wf_users.name%type;

Line 3446: l_forward_to_person_id per_people_f.person_id%type;

3442: l_creator_person_id per_people_f.person_id%type;
3443: l_forward_from_person_id per_people_f.person_id%type;
3444: l_forward_from_username wf_users.name%type;
3445: l_forward_from_disp_name wf_users.display_name%type;
3446: l_forward_to_person_id per_people_f.person_id%type;
3447: l_forward_to_username wf_users.name%type;
3448: l_forward_to_disp_name wf_users.display_name%type;
3449: l_proc varchar2(61) := gv_package||' get_next_approver';
3450: l_current_forward_to_id per_people_f.person_id%type;

Line 3450: l_current_forward_to_id per_people_f.person_id%type;

3446: l_forward_to_person_id per_people_f.person_id%type;
3447: l_forward_to_username wf_users.name%type;
3448: l_forward_to_disp_name wf_users.display_name%type;
3449: l_proc varchar2(61) := gv_package||' get_next_approver';
3450: l_current_forward_to_id per_people_f.person_id%type;
3451: l_current_forward_from_id per_people_f.person_id%type;
3452: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
3453: ln_current_approver_index NUMBER ;
3454: ln_curr_def_appr_index NUMBER;

Line 3451: l_current_forward_from_id per_people_f.person_id%type;

3447: l_forward_to_username wf_users.name%type;
3448: l_forward_to_disp_name wf_users.display_name%type;
3449: l_proc varchar2(61) := gv_package||' get_next_approver';
3450: l_current_forward_to_id per_people_f.person_id%type;
3451: l_current_forward_from_id per_people_f.person_id%type;
3452: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
3453: ln_current_approver_index NUMBER ;
3454: ln_curr_def_appr_index NUMBER;
3455: ln_last_default_approver_id per_people_f.person_id%type;

Line 3455: ln_last_default_approver_id per_people_f.person_id%type;

3451: l_current_forward_from_id per_people_f.person_id%type;
3452: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
3453: ln_current_approver_index NUMBER ;
3454: ln_curr_def_appr_index NUMBER;
3455: ln_last_default_approver_id per_people_f.person_id%type;
3456: ln_addntl_approver_id per_people_f.person_id%type;
3457: lv_item_name hr_dynamic_approval_web.gv_item_name%type;
3458: ln_addntl_approvers NUMBER;
3459: lv_exists VARCHAR2(10);

Line 3456: ln_addntl_approver_id per_people_f.person_id%type;

3452: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
3453: ln_current_approver_index NUMBER ;
3454: ln_curr_def_appr_index NUMBER;
3455: ln_last_default_approver_id per_people_f.person_id%type;
3456: ln_addntl_approver_id per_people_f.person_id%type;
3457: lv_item_name hr_dynamic_approval_web.gv_item_name%type;
3458: ln_addntl_approvers NUMBER;
3459: lv_exists VARCHAR2(10);
3460: lv_dummy VARCHAR2(20);

Line 3790: l_creator_person_id per_people_f.person_id%type;

3786: result out nocopy varchar2 )
3787: AS
3788: -- Local Variables
3789: l_proc varchar2(61) := gv_package||'check_final_approver';
3790: l_creator_person_id per_people_f.person_id%type;
3791: l_forward_to_person_id per_people_f.person_id%type;
3792: l_current_forward_to_id per_people_f.person_id%type;
3793: ln_addntl_approvers NUMBER DEFAULT 0;
3794: ln_approval_level NUMBER DEFAULT 0;

Line 3791: l_forward_to_person_id per_people_f.person_id%type;

3787: AS
3788: -- Local Variables
3789: l_proc varchar2(61) := gv_package||'check_final_approver';
3790: l_creator_person_id per_people_f.person_id%type;
3791: l_forward_to_person_id per_people_f.person_id%type;
3792: l_current_forward_to_id per_people_f.person_id%type;
3793: ln_addntl_approvers NUMBER DEFAULT 0;
3794: ln_approval_level NUMBER DEFAULT 0;
3795: ln_curr_def_appr_index NUMBER DEFAULT 1;

Line 3792: l_current_forward_to_id per_people_f.person_id%type;

3788: -- Local Variables
3789: l_proc varchar2(61) := gv_package||'check_final_approver';
3790: l_creator_person_id per_people_f.person_id%type;
3791: l_forward_to_person_id per_people_f.person_id%type;
3792: l_current_forward_to_id per_people_f.person_id%type;
3793: ln_addntl_approvers NUMBER DEFAULT 0;
3794: ln_approval_level NUMBER DEFAULT 0;
3795: ln_curr_def_appr_index NUMBER DEFAULT 1;
3796: ln_last_def_approver NUMBER;

Line 4322: l_creator_person_id per_people_f.person_id%type;

4318: result out nocopy varchar2 )
4319: AS
4320:
4321: -- Local Variables
4322: l_creator_person_id per_people_f.person_id%type;
4323: l_forward_from_person_id per_people_f.person_id%type;
4324: l_forward_from_username wf_users.name%type;
4325: l_forward_from_disp_name wf_users.display_name%type;
4326: l_forward_to_person_id per_people_f.person_id%type;

Line 4323: l_forward_from_person_id per_people_f.person_id%type;

4319: AS
4320:
4321: -- Local Variables
4322: l_creator_person_id per_people_f.person_id%type;
4323: l_forward_from_person_id per_people_f.person_id%type;
4324: l_forward_from_username wf_users.name%type;
4325: l_forward_from_disp_name wf_users.display_name%type;
4326: l_forward_to_person_id per_people_f.person_id%type;
4327: l_forward_to_username wf_users.name%type;

Line 4326: l_forward_to_person_id per_people_f.person_id%type;

4322: l_creator_person_id per_people_f.person_id%type;
4323: l_forward_from_person_id per_people_f.person_id%type;
4324: l_forward_from_username wf_users.name%type;
4325: l_forward_from_disp_name wf_users.display_name%type;
4326: l_forward_to_person_id per_people_f.person_id%type;
4327: l_forward_to_username wf_users.name%type;
4328: l_forward_to_disp_name wf_users.display_name%type;
4329: l_proc varchar2(61) := gv_package||'get_next_approver';
4330: l_current_forward_to_id per_people_f.person_id%type;

Line 4330: l_current_forward_to_id per_people_f.person_id%type;

4326: l_forward_to_person_id per_people_f.person_id%type;
4327: l_forward_to_username wf_users.name%type;
4328: l_forward_to_disp_name wf_users.display_name%type;
4329: l_proc varchar2(61) := gv_package||'get_next_approver';
4330: l_current_forward_to_id per_people_f.person_id%type;
4331: l_current_forward_from_id per_people_f.person_id%type;
4332: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4333: ln_current_approver_index NUMBER ;
4334: ln_curr_def_appr_index NUMBER;

Line 4331: l_current_forward_from_id per_people_f.person_id%type;

4327: l_forward_to_username wf_users.name%type;
4328: l_forward_to_disp_name wf_users.display_name%type;
4329: l_proc varchar2(61) := gv_package||'get_next_approver';
4330: l_current_forward_to_id per_people_f.person_id%type;
4331: l_current_forward_from_id per_people_f.person_id%type;
4332: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4333: ln_current_approver_index NUMBER ;
4334: ln_curr_def_appr_index NUMBER;
4335: ln_last_default_approver_id per_people_f.person_id%type;

Line 4335: ln_last_default_approver_id per_people_f.person_id%type;

4331: l_current_forward_from_id per_people_f.person_id%type;
4332: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4333: ln_current_approver_index NUMBER ;
4334: ln_curr_def_appr_index NUMBER;
4335: ln_last_default_approver_id per_people_f.person_id%type;
4336: ln_addntl_approver_id per_people_f.person_id%type;
4337: ln_addntl_approvers NUMBER;
4338: lv_exists VARCHAR2(10);
4339: lv_dummy VARCHAR2(20);

Line 4336: ln_addntl_approver_id per_people_f.person_id%type;

4332: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4333: ln_current_approver_index NUMBER ;
4334: ln_curr_def_appr_index NUMBER;
4335: ln_last_default_approver_id per_people_f.person_id%type;
4336: ln_addntl_approver_id per_people_f.person_id%type;
4337: ln_addntl_approvers NUMBER;
4338: lv_exists VARCHAR2(10);
4339: lv_dummy VARCHAR2(20);
4340: lv_isvalid VARCHAR2(10);

Line 4343: ln_person_id per_people_f.person_id%type DEFAULT NULL;

4339: lv_dummy VARCHAR2(20);
4340: lv_isvalid VARCHAR2(10);
4341: ln_notifiers NUMBER DEFAULT 0;
4342: ln_current_onsubmit_index NUMBER ;
4343: ln_person_id per_people_f.person_id%type DEFAULT NULL;
4344: lv_notify VARCHAR2(10);
4345: lv_onsubmit VARCHAR2(10);
4346: lv_item_name VARCHAR2(25);
4347: ln_start_index NUMBER;

Line 4523: l_creator_person_id per_people_f.person_id%type;

4519: result out nocopy varchar2 )
4520: AS
4521:
4522: -- Local Variables
4523: l_creator_person_id per_people_f.person_id%type;
4524: l_forward_from_person_id per_people_f.person_id%type;
4525: l_forward_from_username wf_users.name%type;
4526: l_forward_from_disp_name wf_users.display_name%type;
4527: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;

Line 4524: l_forward_from_person_id per_people_f.person_id%type;

4520: AS
4521:
4522: -- Local Variables
4523: l_creator_person_id per_people_f.person_id%type;
4524: l_forward_from_person_id per_people_f.person_id%type;
4525: l_forward_from_username wf_users.name%type;
4526: l_forward_from_disp_name wf_users.display_name%type;
4527: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4528: l_forward_to_username wf_users.name%type;

Line 4527: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;

4523: l_creator_person_id per_people_f.person_id%type;
4524: l_forward_from_person_id per_people_f.person_id%type;
4525: l_forward_from_username wf_users.name%type;
4526: l_forward_from_disp_name wf_users.display_name%type;
4527: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4528: l_forward_to_username wf_users.name%type;
4529: l_forward_to_disp_name wf_users.display_name%type;
4530: l_proc varchar2(61) := g_package||'get_next_approver';
4531: l_current_forward_to_id per_people_f.person_id%type;

Line 4531: l_current_forward_to_id per_people_f.person_id%type;

4527: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4528: l_forward_to_username wf_users.name%type;
4529: l_forward_to_disp_name wf_users.display_name%type;
4530: l_proc varchar2(61) := g_package||'get_next_approver';
4531: l_current_forward_to_id per_people_f.person_id%type;
4532: l_current_forward_from_id per_people_f.person_id%type;
4533: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4534: ln_current_approver_index NUMBER ;
4535: ln_curr_def_appr_index NUMBER;

Line 4532: l_current_forward_from_id per_people_f.person_id%type;

4528: l_forward_to_username wf_users.name%type;
4529: l_forward_to_disp_name wf_users.display_name%type;
4530: l_proc varchar2(61) := g_package||'get_next_approver';
4531: l_current_forward_to_id per_people_f.person_id%type;
4532: l_current_forward_from_id per_people_f.person_id%type;
4533: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4534: ln_current_approver_index NUMBER ;
4535: ln_curr_def_appr_index NUMBER;
4536: ln_last_default_approver_id per_people_f.person_id%type;

Line 4536: ln_last_default_approver_id per_people_f.person_id%type;

4532: l_current_forward_from_id per_people_f.person_id%type;
4533: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4534: ln_current_approver_index NUMBER ;
4535: ln_curr_def_appr_index NUMBER;
4536: ln_last_default_approver_id per_people_f.person_id%type;
4537: ln_addntl_approver_id per_people_f.person_id%type;
4538: ln_addntl_approvers NUMBER;
4539: lv_exists VARCHAR2(10);
4540: lv_dummy VARCHAR2(20);

Line 4537: ln_addntl_approver_id per_people_f.person_id%type;

4533: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4534: ln_current_approver_index NUMBER ;
4535: ln_curr_def_appr_index NUMBER;
4536: ln_last_default_approver_id per_people_f.person_id%type;
4537: ln_addntl_approver_id per_people_f.person_id%type;
4538: ln_addntl_approvers NUMBER;
4539: lv_exists VARCHAR2(10);
4540: lv_dummy VARCHAR2(20);
4541: lv_isvalid VARCHAR2(10);

Line 4544: ln_person_id per_people_f.person_id%type DEFAULT NULL;

4540: lv_dummy VARCHAR2(20);
4541: lv_isvalid VARCHAR2(10);
4542: ln_notifiers NUMBER DEFAULT 0;
4543: ln_current_onapproval_index NUMBER ;
4544: ln_person_id per_people_f.person_id%type DEFAULT NULL;
4545: lv_notify VARCHAR2(10);
4546: lv_onapproval VARCHAR2(10);
4547: lv_item_name VARCHAR2(25);
4548: ln_start_index NUMBER;

Line 5515: ln_person_id per_people_f.person_id%TYPE;

5511: lv_exist VARCHAR2(10) DEFAULT 'N';
5512: l_dummy VARCHAR2(100) ;
5513: lv_item_name VARCHAR2(100);
5514: lrt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;
5515: ln_person_id per_people_f.person_id%TYPE;
5516: lv_full_name per_people_f.person_id%TYPE;
5517: lv_job_title VARCHAR2(1000);
5518: lv_on_submit VARCHAR2(10);
5519: lv_on_approval VARCHAR2(10);

Line 5516: lv_full_name per_people_f.person_id%TYPE;

5512: l_dummy VARCHAR2(100) ;
5513: lv_item_name VARCHAR2(100);
5514: lrt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;
5515: ln_person_id per_people_f.person_id%TYPE;
5516: lv_full_name per_people_f.person_id%TYPE;
5517: lv_job_title VARCHAR2(1000);
5518: lv_on_submit VARCHAR2(10);
5519: lv_on_approval VARCHAR2(10);
5520: lv_notify VARCHAR2(10);