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.

[Home] [Help]

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 662: ln_person_id per_people_f.person_id%TYPE;

658: p_mode IN VARCHAR2
659: )
660: IS
661: -- Local variables
662: ln_person_id per_people_f.person_id%TYPE;
663: lv_exists VARCHAR2(10);
664: lv_dummy VARCHAR2(100);
665: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
666: ln_addntl_approvers NUMBER DEFAULT 0;

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

1174: p_approver_flag IN hr_util_misc_web.g_varchar2_tab_type,
1175: p_error_flag OUT NOCOPY BOOLEAN )
1176: IS
1177: -- Local variables
1178: ln_approver_id per_people_f.person_id%TYPE DEFAULT NULL;
1179: lv_job_title VARCHAR2(1000) DEFAULT NULL;
1180: ln_assignment_id NUMBER;
1181: ld_effective_date DATE;
1182: lv_exists VARCHAR2(10) DEFAULT 'N';

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

1351: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1352: p_error_flag OUT NOCOPY BOOLEAN )
1353: IS
1354: -- Local variables
1355: ln_notifier_id per_people_f.person_id%TYPE DEFAULT NULL;
1356: lv_job_title VARCHAR2(1000) DEFAULT NULL;
1357: ln_assignment_id NUMBER;
1358: ld_effective_date DATE;
1359: lv_exists VARCHAR2(10) DEFAULT 'N';

Line 1580: lv_creator_person_id per_people_f.person_id%TYPE ;

1576: AS
1577:
1578: --local variables
1579: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
1580: lv_creator_person_id per_people_f.person_id%TYPE ;
1581: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
1582: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
1583: lv_current_forward_to_id per_people_f.person_id%TYPE ;
1584: lv_current_forward_from_id per_people_f.person_id%TYPE ;

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

1577:
1578: --local variables
1579: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
1580: lv_creator_person_id per_people_f.person_id%TYPE ;
1581: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
1582: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
1583: lv_current_forward_to_id per_people_f.person_id%TYPE ;
1584: lv_current_forward_from_id per_people_f.person_id%TYPE ;
1585: lv_result VARCHAR2(20) DEFAULT 'N';

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

1578: --local variables
1579: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
1580: lv_creator_person_id per_people_f.person_id%TYPE ;
1581: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
1582: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
1583: lv_current_forward_to_id per_people_f.person_id%TYPE ;
1584: lv_current_forward_from_id per_people_f.person_id%TYPE ;
1585: lv_result VARCHAR2(20) DEFAULT 'N';
1586: ln_approver_index NUMBER DEFAULT 1;

Line 1583: lv_current_forward_to_id per_people_f.person_id%TYPE ;

1579: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
1580: lv_creator_person_id per_people_f.person_id%TYPE ;
1581: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
1582: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
1583: lv_current_forward_to_id per_people_f.person_id%TYPE ;
1584: lv_current_forward_from_id per_people_f.person_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;

Line 1584: lv_current_forward_from_id per_people_f.person_id%TYPE ;

1580: lv_creator_person_id per_people_f.person_id%TYPE ;
1581: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
1582: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
1583: lv_current_forward_to_id per_people_f.person_id%TYPE ;
1584: lv_current_forward_from_id per_people_f.person_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;

Line 1587: lv_full_name per_people_f.full_name%TYPE;

1583: lv_current_forward_to_id per_people_f.person_id%TYPE ;
1584: lv_current_forward_from_id per_people_f.person_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;

Line 1737: ln_person_id per_people_f.person_id%TYPE;

1733: ln_num_of_add_apprs NUMBER DEFAULT 0;
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';

Line 2071: lv_creator_person_id per_people_f.person_id%TYPE ;

2067: AS
2068:
2069: --local variables
2070: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
2071: lv_creator_person_id per_people_f.person_id%TYPE ;
2072: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
2073: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
2074: lv_current_forward_to_id per_people_f.person_id%TYPE ;
2075: lv_current_forward_from_id per_people_f.person_id%TYPE ;

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

2068:
2069: --local variables
2070: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
2071: lv_creator_person_id per_people_f.person_id%TYPE ;
2072: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
2073: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
2074: lv_current_forward_to_id per_people_f.person_id%TYPE ;
2075: lv_current_forward_from_id per_people_f.person_id%TYPE ;
2076: lv_result VARCHAR2(20) DEFAULT 'N';

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

2069: --local variables
2070: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
2071: lv_creator_person_id per_people_f.person_id%TYPE ;
2072: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
2073: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
2074: lv_current_forward_to_id per_people_f.person_id%TYPE ;
2075: lv_current_forward_from_id per_people_f.person_id%TYPE ;
2076: lv_result VARCHAR2(20) DEFAULT 'N';
2077: ln_approver_index NUMBER DEFAULT 1;

Line 2074: lv_current_forward_to_id per_people_f.person_id%TYPE ;

2070: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
2071: lv_creator_person_id per_people_f.person_id%TYPE ;
2072: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
2073: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
2074: lv_current_forward_to_id per_people_f.person_id%TYPE ;
2075: lv_current_forward_from_id per_people_f.person_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;

Line 2075: lv_current_forward_from_id per_people_f.person_id%TYPE ;

2071: lv_creator_person_id per_people_f.person_id%TYPE ;
2072: lv_forward_from_id per_people_f.person_id%TYPE DEFAULT NULL;
2073: lv_forward_to_id per_people_f.person_id%TYPE DEFAULT NULL;
2074: lv_current_forward_to_id per_people_f.person_id%TYPE ;
2075: lv_current_forward_from_id per_people_f.person_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;

Line 2078: lv_full_name per_people_f.full_name%TYPE;

2074: lv_current_forward_to_id per_people_f.person_id%TYPE ;
2075: lv_current_forward_from_id per_people_f.person_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;

Line 2306: ln_person_id per_people_f.person_id%TYPE;

2302: ln_num_of_add_apprs NUMBER DEFAULT 0;
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';

Line 2560: ln_person_id per_people_f.person_id%TYPE;

2556: ln_number_of_approvers NUMBER ;
2557: l_dummy VARCHAR2(100);
2558: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2559: ln_def_app_index NUMBER DEFAULT 1;
2560: ln_person_id per_people_f.person_id%TYPE;
2561: ln_full_name per_people_f.full_name%TYPE;
2562: lv_index NUMBER;
2563: -- local variable
2564: l_proc constant varchar2(100) := g_package || ' build_ddl';

Line 2561: ln_full_name per_people_f.full_name%TYPE;

2557: l_dummy VARCHAR2(100);
2558: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2559: ln_def_app_index NUMBER DEFAULT 1;
2560: ln_person_id per_people_f.person_id%TYPE;
2561: ln_full_name per_people_f.full_name%TYPE;
2562: lv_index NUMBER;
2563: -- local variable
2564: l_proc constant varchar2(100) := g_package || ' build_ddl';
2565: BEGIN

Line 2651: ln_from_index_id per_people_f.person_id%TYPE;

2647: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2648: l_dummy NUMBER(1);
2649: lv_item_name_from VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2650: lv_item_name_to VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2651: ln_from_index_id per_people_f.person_id%TYPE;
2652: ln_to_index_id per_people_f.person_id%TYPE;
2653: ln_start_index NUMBER ;
2654: ln_end_index NUMBER ;
2655: ln_loop_index NUMBER;

Line 2652: ln_to_index_id per_people_f.person_id%TYPE;

2648: l_dummy NUMBER(1);
2649: lv_item_name_from VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2650: lv_item_name_to VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2651: ln_from_index_id per_people_f.person_id%TYPE;
2652: ln_to_index_id per_people_f.person_id%TYPE;
2653: ln_start_index NUMBER ;
2654: ln_end_index NUMBER ;
2655: ln_loop_index NUMBER;
2656: lv_exist VARCHAR2(10) DEFAULT 'NO';

Line 2729: ln_from_index_id per_people_f.person_id%TYPE;

2725: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2726: l_dummy NUMBER(1);
2727: lv_item_name_from VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2728: lv_item_name_to VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2729: ln_from_index_id per_people_f.person_id%TYPE;
2730: ln_to_index_id per_people_f.person_id%TYPE;
2731: ln_start_index NUMBER ;
2732: ln_end_index NUMBER ;
2733: ln_loop_index NUMBER;

Line 2730: ln_to_index_id per_people_f.person_id%TYPE;

2726: l_dummy NUMBER(1);
2727: lv_item_name_from VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2728: lv_item_name_to VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2729: ln_from_index_id per_people_f.person_id%TYPE;
2730: ln_to_index_id per_people_f.person_id%TYPE;
2731: ln_start_index NUMBER ;
2732: ln_end_index NUMBER ;
2733: ln_loop_index NUMBER;
2734: lv_exist VARCHAR2(10) DEFAULT 'NO';

Line 2736: ln_current_person_id per_people_f.person_id%TYPE;

2732: ln_end_index NUMBER ;
2733: ln_loop_index NUMBER;
2734: lv_exist VARCHAR2(10) DEFAULT 'NO';
2735: ln_current_index NUMBER;
2736: ln_current_person_id per_people_f.person_id%TYPE;
2737: ln_change_to_index NUMBER;
2738: ln_change_to_person_id per_people_f.person_id%TYPE;
2739: ln_curr_add_appr_index NUMBER DEFAULT 0;
2740: lv_last_addnl_approver VARCHAR2(10) DEFAULT 'NO';

Line 2738: ln_change_to_person_id per_people_f.person_id%TYPE;

2734: lv_exist VARCHAR2(10) DEFAULT 'NO';
2735: ln_current_index NUMBER;
2736: ln_current_person_id per_people_f.person_id%TYPE;
2737: ln_change_to_index NUMBER;
2738: ln_change_to_person_id per_people_f.person_id%TYPE;
2739: ln_curr_add_appr_index NUMBER DEFAULT 0;
2740: lv_last_addnl_approver VARCHAR2(10) DEFAULT 'NO';
2741: lv_valid_approver VARCHAR2(100) DEFAULT 'VALID';
2742: l_proc constant varchar2(100) := g_package || ' delete_approver';

Line 3105: ln_person_id per_people_f.person_id%TYPE;

3101: lv_exist VARCHAR2(10) DEFAULT 'N';
3102: l_dummy VARCHAR2(100) ;
3103: lv_item_name VARCHAR2(100);
3104: lrt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;
3105: ln_person_id per_people_f.person_id%TYPE;
3106: lv_full_name per_people_f.person_id%TYPE;
3107: lv_job_title VARCHAR2(1000);
3108: lv_on_submit VARCHAR2(10);
3109: lv_on_approval VARCHAR2(10);

Line 3106: lv_full_name per_people_f.person_id%TYPE;

3102: l_dummy VARCHAR2(100) ;
3103: lv_item_name VARCHAR2(100);
3104: lrt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;
3105: ln_person_id per_people_f.person_id%TYPE;
3106: lv_full_name per_people_f.person_id%TYPE;
3107: lv_job_title VARCHAR2(1000);
3108: lv_on_submit VARCHAR2(10);
3109: lv_on_approval VARCHAR2(10);
3110: lv_notify VARCHAR2(10);

Line 3403: ln_approver_id per_people_f.person_id%TYPE ;

3399: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type
3400: )
3401: AS
3402: -- Local Varaibles
3403: ln_approver_id per_people_f.person_id%TYPE ;
3404: lv_job_title VARCHAR2(1000) DEFAULT NULL;
3405: ln_assignment_id NUMBER;
3406: ld_effective_date DATE;
3407: lv_exists VARCHAR2(10) DEFAULT 'N';

Line 3512: l_creator_person_id per_people_f.person_id%type;

3508:
3509: -- -------------------------------------------------------------------------
3510: -- local variables
3511: -- -------------------------------------------------------------------------
3512: l_creator_person_id per_people_f.person_id%type;
3513: l_forward_from_person_id per_people_f.person_id%type;
3514: l_forward_from_username wf_users.name%type;
3515: l_forward_from_disp_name wf_users.display_name%type;
3516: l_forward_to_person_id per_people_f.person_id%type;

Line 3513: l_forward_from_person_id per_people_f.person_id%type;

3509: -- -------------------------------------------------------------------------
3510: -- local variables
3511: -- -------------------------------------------------------------------------
3512: l_creator_person_id per_people_f.person_id%type;
3513: l_forward_from_person_id per_people_f.person_id%type;
3514: l_forward_from_username wf_users.name%type;
3515: l_forward_from_disp_name wf_users.display_name%type;
3516: l_forward_to_person_id per_people_f.person_id%type;
3517: l_forward_to_username wf_users.name%type;

Line 3516: l_forward_to_person_id per_people_f.person_id%type;

3512: l_creator_person_id per_people_f.person_id%type;
3513: l_forward_from_person_id per_people_f.person_id%type;
3514: l_forward_from_username wf_users.name%type;
3515: l_forward_from_disp_name wf_users.display_name%type;
3516: l_forward_to_person_id per_people_f.person_id%type;
3517: l_forward_to_username wf_users.name%type;
3518: l_forward_to_disp_name wf_users.display_name%type;
3519: l_proc varchar2(61) := gv_package||' get_next_approver';
3520: l_current_forward_to_id per_people_f.person_id%type;

Line 3520: l_current_forward_to_id per_people_f.person_id%type;

3516: l_forward_to_person_id per_people_f.person_id%type;
3517: l_forward_to_username wf_users.name%type;
3518: l_forward_to_disp_name wf_users.display_name%type;
3519: l_proc varchar2(61) := gv_package||' get_next_approver';
3520: l_current_forward_to_id per_people_f.person_id%type;
3521: l_current_forward_from_id per_people_f.person_id%type;
3522: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
3523: ln_current_approver_index NUMBER ;
3524: ln_curr_def_appr_index NUMBER;

Line 3521: l_current_forward_from_id per_people_f.person_id%type;

3517: l_forward_to_username wf_users.name%type;
3518: l_forward_to_disp_name wf_users.display_name%type;
3519: l_proc varchar2(61) := gv_package||' get_next_approver';
3520: l_current_forward_to_id per_people_f.person_id%type;
3521: l_current_forward_from_id per_people_f.person_id%type;
3522: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
3523: ln_current_approver_index NUMBER ;
3524: ln_curr_def_appr_index NUMBER;
3525: ln_last_default_approver_id per_people_f.person_id%type;

Line 3525: ln_last_default_approver_id per_people_f.person_id%type;

3521: l_current_forward_from_id per_people_f.person_id%type;
3522: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
3523: ln_current_approver_index NUMBER ;
3524: ln_curr_def_appr_index NUMBER;
3525: ln_last_default_approver_id per_people_f.person_id%type;
3526: ln_addntl_approver_id per_people_f.person_id%type;
3527: lv_item_name hr_dynamic_approval_web.gv_item_name%type;
3528: ln_addntl_approvers NUMBER;
3529: lv_exists VARCHAR2(10);

Line 3526: ln_addntl_approver_id per_people_f.person_id%type;

3522: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
3523: ln_current_approver_index NUMBER ;
3524: ln_curr_def_appr_index NUMBER;
3525: ln_last_default_approver_id per_people_f.person_id%type;
3526: ln_addntl_approver_id per_people_f.person_id%type;
3527: lv_item_name hr_dynamic_approval_web.gv_item_name%type;
3528: ln_addntl_approvers NUMBER;
3529: lv_exists VARCHAR2(10);
3530: lv_dummy VARCHAR2(20);

Line 3874: l_creator_person_id per_people_f.person_id%type;

3870: result out nocopy varchar2 )
3871: AS
3872: -- Local Variables
3873: l_proc varchar2(61) := gv_package||'check_final_approver';
3874: l_creator_person_id per_people_f.person_id%type;
3875: l_forward_to_person_id per_people_f.person_id%type;
3876: l_current_forward_to_id per_people_f.person_id%type;
3877: ln_addntl_approvers NUMBER DEFAULT 0;
3878: ln_approval_level NUMBER DEFAULT 0;

Line 3875: l_forward_to_person_id per_people_f.person_id%type;

3871: AS
3872: -- Local Variables
3873: l_proc varchar2(61) := gv_package||'check_final_approver';
3874: l_creator_person_id per_people_f.person_id%type;
3875: l_forward_to_person_id per_people_f.person_id%type;
3876: l_current_forward_to_id per_people_f.person_id%type;
3877: ln_addntl_approvers NUMBER DEFAULT 0;
3878: ln_approval_level NUMBER DEFAULT 0;
3879: ln_curr_def_appr_index NUMBER DEFAULT 1;

Line 3876: l_current_forward_to_id per_people_f.person_id%type;

3872: -- Local Variables
3873: l_proc varchar2(61) := gv_package||'check_final_approver';
3874: l_creator_person_id per_people_f.person_id%type;
3875: l_forward_to_person_id per_people_f.person_id%type;
3876: l_current_forward_to_id per_people_f.person_id%type;
3877: ln_addntl_approvers NUMBER DEFAULT 0;
3878: ln_approval_level NUMBER DEFAULT 0;
3879: ln_curr_def_appr_index NUMBER DEFAULT 1;
3880: ln_last_def_approver NUMBER;

Line 4438: l_creator_person_id per_people_f.person_id%type;

4434: result out nocopy varchar2 )
4435: AS
4436:
4437: -- Local Variables
4438: l_creator_person_id per_people_f.person_id%type;
4439: l_forward_from_person_id per_people_f.person_id%type;
4440: l_forward_from_username wf_users.name%type;
4441: l_forward_from_disp_name wf_users.display_name%type;
4442: l_forward_to_person_id per_people_f.person_id%type;

Line 4439: l_forward_from_person_id per_people_f.person_id%type;

4435: AS
4436:
4437: -- Local Variables
4438: l_creator_person_id per_people_f.person_id%type;
4439: l_forward_from_person_id per_people_f.person_id%type;
4440: l_forward_from_username wf_users.name%type;
4441: l_forward_from_disp_name wf_users.display_name%type;
4442: l_forward_to_person_id per_people_f.person_id%type;
4443: l_forward_to_username wf_users.name%type;

Line 4442: l_forward_to_person_id per_people_f.person_id%type;

4438: l_creator_person_id per_people_f.person_id%type;
4439: l_forward_from_person_id per_people_f.person_id%type;
4440: l_forward_from_username wf_users.name%type;
4441: l_forward_from_disp_name wf_users.display_name%type;
4442: l_forward_to_person_id per_people_f.person_id%type;
4443: l_forward_to_username wf_users.name%type;
4444: l_forward_to_disp_name wf_users.display_name%type;
4445: l_proc varchar2(61) := gv_package||'get_next_approver';
4446: l_current_forward_to_id per_people_f.person_id%type;

Line 4446: l_current_forward_to_id per_people_f.person_id%type;

4442: l_forward_to_person_id per_people_f.person_id%type;
4443: l_forward_to_username wf_users.name%type;
4444: l_forward_to_disp_name wf_users.display_name%type;
4445: l_proc varchar2(61) := gv_package||'get_next_approver';
4446: l_current_forward_to_id per_people_f.person_id%type;
4447: l_current_forward_from_id per_people_f.person_id%type;
4448: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4449: ln_current_approver_index NUMBER ;
4450: ln_curr_def_appr_index NUMBER;

Line 4447: l_current_forward_from_id per_people_f.person_id%type;

4443: l_forward_to_username wf_users.name%type;
4444: l_forward_to_disp_name wf_users.display_name%type;
4445: l_proc varchar2(61) := gv_package||'get_next_approver';
4446: l_current_forward_to_id per_people_f.person_id%type;
4447: l_current_forward_from_id per_people_f.person_id%type;
4448: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4449: ln_current_approver_index NUMBER ;
4450: ln_curr_def_appr_index NUMBER;
4451: ln_last_default_approver_id per_people_f.person_id%type;

Line 4451: ln_last_default_approver_id per_people_f.person_id%type;

4447: l_current_forward_from_id per_people_f.person_id%type;
4448: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4449: ln_current_approver_index NUMBER ;
4450: ln_curr_def_appr_index NUMBER;
4451: ln_last_default_approver_id per_people_f.person_id%type;
4452: ln_addntl_approver_id per_people_f.person_id%type;
4453: ln_addntl_approvers NUMBER;
4454: lv_exists VARCHAR2(10);
4455: lv_dummy VARCHAR2(20);

Line 4452: ln_addntl_approver_id per_people_f.person_id%type;

4448: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4449: ln_current_approver_index NUMBER ;
4450: ln_curr_def_appr_index NUMBER;
4451: ln_last_default_approver_id per_people_f.person_id%type;
4452: ln_addntl_approver_id per_people_f.person_id%type;
4453: ln_addntl_approvers NUMBER;
4454: lv_exists VARCHAR2(10);
4455: lv_dummy VARCHAR2(20);
4456: lv_isvalid VARCHAR2(10);

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

4455: lv_dummy VARCHAR2(20);
4456: lv_isvalid VARCHAR2(10);
4457: ln_notifiers NUMBER DEFAULT 0;
4458: ln_current_onsubmit_index NUMBER ;
4459: ln_person_id per_people_f.person_id%type DEFAULT NULL;
4460: lv_notify VARCHAR2(10);
4461: lv_onsubmit VARCHAR2(10);
4462: lv_item_name VARCHAR2(25);
4463: ln_start_index NUMBER;

Line 4639: l_creator_person_id per_people_f.person_id%type;

4635: result out nocopy varchar2 )
4636: AS
4637:
4638: -- Local Variables
4639: l_creator_person_id per_people_f.person_id%type;
4640: l_forward_from_person_id per_people_f.person_id%type;
4641: l_forward_from_username wf_users.name%type;
4642: l_forward_from_disp_name wf_users.display_name%type;
4643: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;

Line 4640: l_forward_from_person_id per_people_f.person_id%type;

4636: AS
4637:
4638: -- Local Variables
4639: l_creator_person_id per_people_f.person_id%type;
4640: l_forward_from_person_id per_people_f.person_id%type;
4641: l_forward_from_username wf_users.name%type;
4642: l_forward_from_disp_name wf_users.display_name%type;
4643: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4644: l_forward_to_username wf_users.name%type;

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

4639: l_creator_person_id per_people_f.person_id%type;
4640: l_forward_from_person_id per_people_f.person_id%type;
4641: l_forward_from_username wf_users.name%type;
4642: l_forward_from_disp_name wf_users.display_name%type;
4643: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4644: l_forward_to_username wf_users.name%type;
4645: l_forward_to_disp_name wf_users.display_name%type;
4646: l_proc varchar2(61) := g_package||'get_next_approver';
4647: l_current_forward_to_id per_people_f.person_id%type;

Line 4647: l_current_forward_to_id per_people_f.person_id%type;

4643: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4644: l_forward_to_username wf_users.name%type;
4645: l_forward_to_disp_name wf_users.display_name%type;
4646: l_proc varchar2(61) := g_package||'get_next_approver';
4647: l_current_forward_to_id per_people_f.person_id%type;
4648: l_current_forward_from_id per_people_f.person_id%type;
4649: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4650: ln_current_approver_index NUMBER ;
4651: ln_curr_def_appr_index NUMBER;

Line 4648: l_current_forward_from_id per_people_f.person_id%type;

4644: l_forward_to_username wf_users.name%type;
4645: l_forward_to_disp_name wf_users.display_name%type;
4646: l_proc varchar2(61) := g_package||'get_next_approver';
4647: l_current_forward_to_id per_people_f.person_id%type;
4648: l_current_forward_from_id per_people_f.person_id%type;
4649: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4650: ln_current_approver_index NUMBER ;
4651: ln_curr_def_appr_index NUMBER;
4652: ln_last_default_approver_id per_people_f.person_id%type;

Line 4652: ln_last_default_approver_id per_people_f.person_id%type;

4648: l_current_forward_from_id per_people_f.person_id%type;
4649: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4650: ln_current_approver_index NUMBER ;
4651: ln_curr_def_appr_index NUMBER;
4652: ln_last_default_approver_id per_people_f.person_id%type;
4653: ln_addntl_approver_id per_people_f.person_id%type;
4654: ln_addntl_approvers NUMBER;
4655: lv_exists VARCHAR2(10);
4656: lv_dummy VARCHAR2(20);

Line 4653: ln_addntl_approver_id per_people_f.person_id%type;

4649: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
4650: ln_current_approver_index NUMBER ;
4651: ln_curr_def_appr_index NUMBER;
4652: ln_last_default_approver_id per_people_f.person_id%type;
4653: ln_addntl_approver_id per_people_f.person_id%type;
4654: ln_addntl_approvers NUMBER;
4655: lv_exists VARCHAR2(10);
4656: lv_dummy VARCHAR2(20);
4657: lv_isvalid VARCHAR2(10);

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

4656: lv_dummy VARCHAR2(20);
4657: lv_isvalid VARCHAR2(10);
4658: ln_notifiers NUMBER DEFAULT 0;
4659: ln_current_onapproval_index NUMBER ;
4660: ln_person_id per_people_f.person_id%type DEFAULT NULL;
4661: lv_notify VARCHAR2(10);
4662: lv_onapproval VARCHAR2(10);
4663: lv_item_name VARCHAR2(25);
4664: ln_start_index NUMBER;

Line 5659: ln_person_id per_people_f.person_id%TYPE;

5655: lv_exist VARCHAR2(10) DEFAULT 'N';
5656: l_dummy VARCHAR2(100) ;
5657: lv_item_name VARCHAR2(100);
5658: lrt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;
5659: ln_person_id per_people_f.person_id%TYPE;
5660: lv_full_name per_people_f.person_id%TYPE;
5661: lv_job_title VARCHAR2(1000);
5662: lv_on_submit VARCHAR2(10);
5663: lv_on_approval VARCHAR2(10);

Line 5660: lv_full_name per_people_f.person_id%TYPE;

5656: l_dummy VARCHAR2(100) ;
5657: lv_item_name VARCHAR2(100);
5658: lrt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;
5659: ln_person_id per_people_f.person_id%TYPE;
5660: lv_full_name per_people_f.person_id%TYPE;
5661: lv_job_title VARCHAR2(1000);
5662: lv_on_submit VARCHAR2(10);
5663: lv_on_approval VARCHAR2(10);
5664: lv_notify VARCHAR2(10);