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_DYNAMIC_APPROVAL_WEB

Line 1: PACKAGE BODY hr_dynamic_approval_web AS

1: PACKAGE BODY hr_dynamic_approval_web AS
2: /* $Header: hrdynapr.pkb 120.2.12000000.2 2007/08/08 13:29:12 ckondapi ship $ */
3:
4: -- |---------------------------------------------------------------------------|
5: -- |-- < TIPS Begin > ---------------------------------------------------------|

Line 18: DEFAULT 'hr_dynamic_approval_web';

14: -- |-- < TIPS End >------------------------------------------------------------|
15: -- |---------------------------------------------------------------------------|
16:
17: gv_package CONSTANT VARCHAR2(100)
18: DEFAULT 'hr_dynamic_approval_web';
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);

Line 25: gv_error_table hr_dynamic_approval_web.t_person_table;

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:
28: gv_current_row NUMBER DEFAULT 1;
29: gv_mode VARCHAR2(25) DEFAULT 'RUN';

Line 26: grt_wf_attributes_rec hr_dynamic_approval_web.grt_wf_attributes;

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:
28: gv_current_row NUMBER DEFAULT 1;
29: gv_mode VARCHAR2(25) DEFAULT 'RUN';
30: gv_job_type hr_suit_match_utility_web.g_job_type%TYPE;

Line 51: grt_person_details hr_dynamic_approval_web.person_details;

47: DEFAULT 'HR_DYNAMIC_APPROVALS';
48: gv_process_name wf_process_activities.process_name%TYPE
49: DEFAULT 'HR_HRSSA_DYNA_APPROVAL_PRC' ;
50:
51: grt_person_details hr_dynamic_approval_web.person_details;
52: grt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
53: grt_approver_details_table hr_dynamic_approval_web.t_person_table;
54: gn_approver_index NUMBER DEFAULT 1;
55: gv_additional_approvers VARCHAR2(10) DEFAULT 'NO';

Line 52: grt_person_details_rec_table hr_dynamic_approval_web.t_person_table;

48: gv_process_name wf_process_activities.process_name%TYPE
49: DEFAULT 'HR_HRSSA_DYNA_APPROVAL_PRC' ;
50:
51: grt_person_details hr_dynamic_approval_web.person_details;
52: grt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
53: grt_approver_details_table hr_dynamic_approval_web.t_person_table;
54: gn_approver_index NUMBER DEFAULT 1;
55: gv_additional_approvers VARCHAR2(10) DEFAULT 'NO';
56: gn_additional_approvers NUMBER DEFAULT 0;

Line 53: grt_approver_details_table hr_dynamic_approval_web.t_person_table;

49: DEFAULT 'HR_HRSSA_DYNA_APPROVAL_PRC' ;
50:
51: grt_person_details hr_dynamic_approval_web.person_details;
52: grt_person_details_rec_table hr_dynamic_approval_web.t_person_table;
53: grt_approver_details_table hr_dynamic_approval_web.t_person_table;
54: gn_approver_index NUMBER DEFAULT 1;
55: gv_additional_approvers VARCHAR2(10) DEFAULT 'NO';
56: gn_additional_approvers NUMBER DEFAULT 0;
57: gv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';

Line 60: grt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;

56: gn_additional_approvers NUMBER DEFAULT 0;
57: gv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
58: gv_notifier_name VARCHAR2(100) DEFAULT 'NOTIFIER_';
59: gn_notifiers NUMBER DEFAULT 0;
60: grt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;
61: grt_notifier_error_table hr_dynamic_approval_web.notifier_rec_table;
62: gv_cross_business_group VARCHAR2(10) ;
63: g_package CONSTANT VARCHAR2(100):='hr_dynamic_approval_web';
64:

Line 61: grt_notifier_error_table hr_dynamic_approval_web.notifier_rec_table;

57: gv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
58: gv_notifier_name VARCHAR2(100) DEFAULT 'NOTIFIER_';
59: gn_notifiers NUMBER DEFAULT 0;
60: grt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;
61: grt_notifier_error_table hr_dynamic_approval_web.notifier_rec_table;
62: gv_cross_business_group VARCHAR2(10) ;
63: g_package CONSTANT VARCHAR2(100):='hr_dynamic_approval_web';
64:
65:

Line 63: g_package CONSTANT VARCHAR2(100):='hr_dynamic_approval_web';

59: gn_notifiers NUMBER DEFAULT 0;
60: grt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;
61: grt_notifier_error_table hr_dynamic_approval_web.notifier_rec_table;
62: gv_cross_business_group VARCHAR2(10) ;
63: g_package CONSTANT VARCHAR2(100):='hr_dynamic_approval_web';
64:
65:
66: -- exceptions
67: gv_invalid_person EXCEPTION;

Line 1404: lv_job_title := hr_dynamic_approval_web.get_job_details

1400: grt_notifier_error_table(I).person_id := ln_notifier_id;
1401: grt_notifier_error_table(I).error_exists := 'N';
1402: -- fix for bug # 1570998
1403: --grt_notifier_error_table(I).on_submit:= p_notify_onsubmit_flag (I);
1404: lv_job_title := hr_dynamic_approval_web.get_job_details
1405: (p_person_id =>ln_notifier_id,
1406: p_assignment_id=>ln_assignment_id,
1407: p_effective_date=>ld_effective_date
1408: );

Line 1543: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;

1539:
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 ;

Line 1634: lv_job_title := hr_dynamic_approval_web.get_job_details(p_person_id =>lv_forward_to_id,

1630: p_effective_date =>ld_effective_date);
1631:
1632: lv_full_name := lrt_assignment_details.person_full_name;
1633:
1634: lv_job_title := hr_dynamic_approval_web.get_job_details(p_person_id =>lv_forward_to_id,
1635: p_assignment_id=>ln_assignment_id,
1636: p_effective_date=>ld_effective_date);
1637: -- Insert the data into the person_details_rec_table
1638: grt_person_details_rec_table(gn_approver_index).person_id := lv_forward_to_id ;

Line 1765: grt_approver_details_table(ln_approver_list_index).job_title :=hr_dynamic_approval_web.get_job_details

1761: p_effective_date =>p_effective_date);
1762:
1763: grt_approver_details_table(ln_approver_list_index).full_name := lrt_assignment_details.person_full_name;
1764: grt_approver_details_table(ln_approver_list_index).person_id :=ln_person_id;
1765: grt_approver_details_table(ln_approver_list_index).job_title :=hr_dynamic_approval_web.get_job_details
1766: (p_person_id =>ln_person_id,
1767: p_assignment_id=>ln_assignment_id,
1768: p_effective_date=>p_effective_date);
1769:

Line 1811: lv_job_title := hr_dynamic_approval_web.get_job_details

1807: lrt_assignment_details := hr_misc_web.get_assignment_details(
1808: p_assignment_id => ln_assignment_id,
1809: p_effective_date =>p_effective_date);
1810:
1811: lv_job_title := hr_dynamic_approval_web.get_job_details
1812: (p_person_id =>ln_person_id,
1813: p_assignment_id=>ln_assignment_id,
1814: p_effective_date=>p_effective_date
1815: );

Line 1876: hr_dynamic_approval_web.get_all_approvers(

1872: gv_mode:='RE-ENTER';
1873:
1874: -- repopulate the table
1875:
1876: hr_dynamic_approval_web.get_all_approvers(
1877: p_approver_name =>l_approver_name,
1878: p_approver_flag=>l_approver_flag,
1879: p_item_type =>p_item_type,
1880: p_item_key =>p_item_key

Line 1947: hr_dynamic_approval_web.get_all_approvers(

1943: gv_mode:='RE-ENTER';
1944:
1945: -- repopulate the table
1946:
1947: hr_dynamic_approval_web.get_all_approvers(
1948: p_approver_name =>l_approver_name,
1949: p_approver_flag=>l_approver_flag,
1950: p_item_type =>p_item_type,
1951: p_item_key =>p_item_key

Line 2009: lrt_person_details_rec_table hr_dynamic_approval_web.t_person_table;

2005:
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 ;

Line 2167: lv_job_title := hr_dynamic_approval_web.get_job_details

2163: p_effective_date =>ld_effective_date
2164: );
2165:
2166: lv_full_name := lrt_assignment_details.person_full_name;
2167: lv_job_title := hr_dynamic_approval_web.get_job_details
2168: (p_person_id =>lv_forward_to_id,
2169: p_assignment_id=>ln_assignment_id,
2170: p_effective_date=>ld_effective_date
2171: );

Line 2280: hr_dynamic_approval_web.get_default_approvers(

2276: end if;
2277:
2278:
2279: -- get the default approvers in the system
2280: hr_dynamic_approval_web.get_default_approvers(
2281: p_approver_name =>lv_approver_name,
2282: p_approver_flag=>lv_approver_flag,
2283: p_item_type =>p_item_type,
2284: p_item_key =>p_item_key

Line 2365: hr_dynamic_approval_web.get_job_details

2361: grt_approver_details_table(I).full_name :=
2362: lrt_assignment_details.person_full_name;
2363: grt_approver_details_table(I).person_id :=ln_person_id;
2364: grt_approver_details_table(I).job_title :=
2365: hr_dynamic_approval_web.get_job_details
2366: (p_person_id =>ln_person_id,
2367: p_assignment_id=>ln_assignment_id,
2368: p_effective_date=>p_effective_date
2369: );

Line 2384: hr_dynamic_approval_web.get_job_details

2380: lrt_assignment_details := hr_misc_web.get_assignment_id(p_person_id => ln_person_id);
2381: ln_assignment_id := lrt_assignment_details.assignment_id;
2382:
2383: grt_approver_details_table(I).job_title :=
2384: hr_dynamic_approval_web.get_job_details
2385: (p_person_id =>ln_person_id,
2386: p_assignment_id=>ln_assignment_id,
2387: p_effective_date=>p_effective_date
2388: );

Line 2432: lv_job_title := hr_dynamic_approval_web.get_job_details

2428: p_assignment_id => ln_assignment_id,
2429: p_effective_date =>p_effective_date
2430: );
2431:
2432: lv_job_title := hr_dynamic_approval_web.get_job_details
2433: (p_person_id =>ln_person_id,
2434: p_assignment_id=>ln_assignment_id,
2435: p_effective_date=>p_effective_date
2436: );

Line 2481: l_ddl_data hr_dynamic_approval_web.ddl_data;

2477: p_variable_name in varchar2,
2478: p_variable_value in varchar2 DEFAULT NULL
2479: ,p_attributes IN VARCHAR2 DEFAULT NULL) RETURN LONG IS
2480:
2481: l_ddl_data hr_dynamic_approval_web.ddl_data;
2482: l_lov LONG;
2483: l_count INTEGER;
2484: l_checked VARCHAR2(25);
2485: lv_variable_name VARCHAR2(200) DEFAULT 'p_person_id';

Line 2654: lrt_approver_details_table hr_dynamic_approval_web.approver_rec_table;

2650: AS
2651: -- Local Variables
2652: ln_number_of_approvers NUMBER ;
2653: ln_additional_approvers NUMBER DEFAULT 0;
2654: lrt_approver_details_table hr_dynamic_approval_web.approver_rec_table;
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_';

Line 3034: lrt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;

3030: -- Local Variables
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);

Line 3112: lv_job_title := hr_dynamic_approval_web.get_job_details

3108: -- populate the notifiers rec table
3109: lrt_notifier_details_table(I).person_id := ln_person_id;
3110: lrt_notifier_details_table(I).full_name := lrt_assignment_details.person_full_name;
3111:
3112: lv_job_title := hr_dynamic_approval_web.get_job_details
3113: (p_person_id =>ln_person_id,
3114: p_assignment_id=>ln_assignment_id,
3115: p_effective_date=>p_effective_date
3116: );

Line 3198: lv_job_title := hr_dynamic_approval_web.get_job_details

3194: p_assignment_id => ln_assignment_id,
3195: p_effective_date =>p_effective_date
3196: );
3197:
3198: lv_job_title := hr_dynamic_approval_web.get_job_details
3199: (p_person_id =>ln_person_id,
3200: p_assignment_id=>ln_assignment_id,
3201: p_effective_date=>p_effective_date
3202: );

Line 3395: /* hr_dynamic_approval_web.delete_approver(p_item_type=>p_item_type,

3391: (itemtype => p_item_type,
3392: itemkey => p_item_key,
3393: aname => lv_item_name);
3394: IF ln_person_id IS NULL THEN
3395: /* hr_dynamic_approval_web.delete_approver(p_item_type=>p_item_type,
3396: p_item_key=>p_item_key,
3397: p_approver_index=>I);
3398: */
3399: NULL;

Line 3457: lv_item_name hr_dynamic_approval_web.gv_item_name%type;

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);
3461: lv_isvalid VARCHAR2(10);

Line 4048: lv_item_name hr_dynamic_approval_web.gv_notifier_name%type;

4044: ln_number_of_notifiers NUMBER;
4045: lv_dummy VARCHAR2(10);
4046: lv_exists VARCHAR2(10);
4047: lv_status VARCHAR2(10);
4048: lv_item_name hr_dynamic_approval_web.gv_notifier_name%type;
4049: lv_notify VARCHAR2(10);
4050: lv_submit VARCHAR2(10);
4051: l_proc constant varchar2(100) := g_package || ' Check_OnSubmit_Notifier';
4052: BEGIN

Line 4184: lv_item_name hr_dynamic_approval_web.gv_notifier_name%type;

4180: ln_number_of_notifiers NUMBER;
4181: lv_dummy VARCHAR2(10);
4182: lv_exists VARCHAR2(10);
4183: lv_status VARCHAR2(10);
4184: lv_item_name hr_dynamic_approval_web.gv_notifier_name%type;
4185: lv_notify VARCHAR2(10);
4186: lv_onapproval VARCHAR2(10);
4187: l_proc constant varchar2(100) := g_package || ' Check_OnApproval_Notifier';
4188: BEGIN

Line 5514: lrt_notifier_details_table hr_dynamic_approval_web.notifier_rec_table;

5510: lv_number varchar2(10);
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);

Line 5592: lv_job_title := hr_dynamic_approval_web.get_job_details

5588: -- populate the notifiers rec table
5589: lrt_notifier_details_table(I).person_id := ln_person_id;
5590: lrt_notifier_details_table(I).full_name := lrt_assignment_details.person_full_name;
5591:
5592: lv_job_title := hr_dynamic_approval_web.get_job_details
5593: (p_person_id =>ln_person_id,
5594: p_assignment_id=>ln_assignment_id,
5595: p_effective_date=>trunc(sysdate)
5596: );

Line 5640: end hr_dynamic_approval_web;

5636:
5637:
5638:
5639:
5640: end hr_dynamic_approval_web;