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_UTIL_MISC_WEB

Line 38: gv_browser_title hr_util_misc_web.g_title%TYPE;

34: DEFAULT 'HR_DYNAMIC_APPROVALS_WEB';
35: gv_nav_region_code CONSTANT VARCHAR2(100)
36: DEFAULT 'HR_BUTTON_LABELS_WEB';
37: gn_region_application_id CONSTANT integer := 601;
38: gv_browser_title hr_util_misc_web.g_title%TYPE;
39: gtt_prompts hr_util_misc_web.g_prompts%TYPE;
40: gv_language_code VARCHAR2(200) DEFAULT NULL;
41: gv_approvals_mode wf_activity_attr_values.text_value%TYPE;
42: gv_update_mode wf_activity_attr_values.text_value%TYPE

Line 39: gtt_prompts hr_util_misc_web.g_prompts%TYPE;

35: gv_nav_region_code CONSTANT VARCHAR2(100)
36: DEFAULT 'HR_BUTTON_LABELS_WEB';
37: gn_region_application_id CONSTANT integer := 601;
38: gv_browser_title hr_util_misc_web.g_title%TYPE;
39: gtt_prompts hr_util_misc_web.g_prompts%TYPE;
40: gv_language_code VARCHAR2(200) DEFAULT NULL;
41: gv_approvals_mode wf_activity_attr_values.text_value%TYPE;
42: gv_update_mode wf_activity_attr_values.text_value%TYPE
43: DEFAULT 'OFF';

Line 275: p_Approvers_list hr_util_misc_web.g_varchar2_tab_type

271: --
272:
273: FUNCTION build_where_clause(
274: p_where_for IN VARCHAR2,
275: p_Approvers_list hr_util_misc_web.g_varchar2_tab_type
276: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
277: p_Notifiers_list hr_util_misc_web.g_varchar2_tab_type
278: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
279: p_effective_date IN DATE DEFAULT SYSDATE,

Line 276: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

272:
273: FUNCTION build_where_clause(
274: p_where_for IN VARCHAR2,
275: p_Approvers_list hr_util_misc_web.g_varchar2_tab_type
276: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
277: p_Notifiers_list hr_util_misc_web.g_varchar2_tab_type
278: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
279: p_effective_date IN DATE DEFAULT SYSDATE,
280: p_business_group_id IN NUMBER DEFAULT 0

Line 277: p_Notifiers_list hr_util_misc_web.g_varchar2_tab_type

273: FUNCTION build_where_clause(
274: p_where_for IN VARCHAR2,
275: p_Approvers_list hr_util_misc_web.g_varchar2_tab_type
276: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
277: p_Notifiers_list hr_util_misc_web.g_varchar2_tab_type
278: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
279: p_effective_date IN DATE DEFAULT SYSDATE,
280: p_business_group_id IN NUMBER DEFAULT 0
281:

Line 278: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

274: p_where_for IN VARCHAR2,
275: p_Approvers_list hr_util_misc_web.g_varchar2_tab_type
276: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
277: p_Notifiers_list hr_util_misc_web.g_varchar2_tab_type
278: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
279: p_effective_date IN DATE DEFAULT SYSDATE,
280: p_business_group_id IN NUMBER DEFAULT 0
281:
282: )

Line 286: lv_person_id_list hr_util_misc_web.g_varchar2_tab_type

282: )
283: RETURN LONG
284: IS
285: lv_where LONG ;
286: lv_person_id_list hr_util_misc_web.g_varchar2_tab_type
287: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
288: lv_error_flag boolean;
289: ln_count NUMBER DEFAULT 0;
290: ld_effective_date DATE DEFAULT SYSDATE;

Line 287: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

283: RETURN LONG
284: IS
285: lv_where LONG ;
286: lv_person_id_list hr_util_misc_web.g_varchar2_tab_type
287: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
288: lv_error_flag boolean;
289: ln_count NUMBER DEFAULT 0;
290: ld_effective_date DATE DEFAULT SYSDATE;
291: lv_search VARCHAR2(1000);

Line 479: p_approver_name hr_util_misc_web.g_varchar2_tab_type

475: PROCEDURE update_ame_approvers_list(
476: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
477: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
478: p_act_id IN NUMBER ,
479: p_approver_name hr_util_misc_web.g_varchar2_tab_type
480: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
481: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
482: DEFAULT hr_util_misc_web.g_varchar2_tab_default)
483:

Line 480: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

476: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
477: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
478: p_act_id IN NUMBER ,
479: p_approver_name hr_util_misc_web.g_varchar2_tab_type
480: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
481: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
482: DEFAULT hr_util_misc_web.g_varchar2_tab_default)
483:
484: IS

Line 481: p_approver_flag hr_util_misc_web.g_varchar2_tab_type

477: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
478: p_act_id IN NUMBER ,
479: p_approver_name hr_util_misc_web.g_varchar2_tab_type
480: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
481: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
482: DEFAULT hr_util_misc_web.g_varchar2_tab_default)
483:
484: IS
485: -- Local variables

Line 482: DEFAULT hr_util_misc_web.g_varchar2_tab_default)

478: p_act_id IN NUMBER ,
479: p_approver_name hr_util_misc_web.g_varchar2_tab_type
480: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
481: p_approver_flag hr_util_misc_web.g_varchar2_tab_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;

Line 510: hr_util_misc_web.validate_session(p_person_id => gn_person_id);

506: -------------------------------BEGIN-------------------------------------------
507: BEGIN
508: hr_utility.set_location('Entering: '|| l_proc,5);
509: -- validate the session
510: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
511:
512:
513: -- get AME related WF attribute values
514: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

Line 648: p_approver_name hr_util_misc_web.g_varchar2_tab_type

644: PROCEDURE COMMIT_DATA(
645: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
646: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
647: p_act_id IN NUMBER ,
648: p_approver_name hr_util_misc_web.g_varchar2_tab_type
649: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
650: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
651: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
652: p_notifier_name hr_util_misc_web.g_varchar2_tab_type

Line 649: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

645: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
646: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
647: p_act_id IN NUMBER ,
648: p_approver_name hr_util_misc_web.g_varchar2_tab_type
649: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
650: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
651: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
652: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
653: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

Line 650: p_approver_flag hr_util_misc_web.g_varchar2_tab_type

646: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
647: p_act_id IN NUMBER ,
648: p_approver_name hr_util_misc_web.g_varchar2_tab_type
649: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
650: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
651: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
652: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
653: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
654: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type

Line 651: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

647: p_act_id IN NUMBER ,
648: p_approver_name hr_util_misc_web.g_varchar2_tab_type
649: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
650: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
651: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
652: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
653: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
654: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
655: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

Line 652: p_notifier_name hr_util_misc_web.g_varchar2_tab_type

648: p_approver_name hr_util_misc_web.g_varchar2_tab_type
649: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
650: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
651: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
652: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
653: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
654: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
655: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
656: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type

Line 653: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

649: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
650: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
651: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
652: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
653: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
654: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
655: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
656: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
657: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

Line 654: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type

650: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
651: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
652: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
653: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
654: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
655: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
656: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
657: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
658: p_mode IN VARCHAR2

Line 655: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

651: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
652: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
653: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
654: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
655: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
656: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
657: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
658: p_mode IN VARCHAR2
659: )

Line 656: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type

652: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
653: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
654: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
655: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
656: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
657: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
658: p_mode IN VARCHAR2
659: )
660: IS

Line 657: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

653: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
654: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
655: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
656: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
657: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
658: p_mode IN VARCHAR2
659: )
660: IS
661: -- Local variables

Line 681: hr_util_misc_web.validate_session(p_person_id => gn_person_id);

677: BEGIN
678:
679: hr_utility.set_location('Entering: '|| l_proc,5);
680: -- validate the session
681: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
682:
683: -- get user date format
684: gv_user_date_format := hr_util_misc_web.get_user_date_format;
685:

Line 684: gv_user_date_format := hr_util_misc_web.get_user_date_format;

680: -- validate the session
681: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
682:
683: -- get user date format
684: gv_user_date_format := hr_util_misc_web.get_user_date_format;
685:
686:
687: -- get session language code
688: gv_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

Line 1173: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type,

1169: --
1170: PROCEDURE validate_approvers(
1171: p_item_type in varchar2,
1172: p_item_key in varchar2,
1173: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type,
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

Line 1174: p_approver_flag IN hr_util_misc_web.g_varchar2_tab_type,

1170: PROCEDURE validate_approvers(
1171: p_item_type in varchar2,
1172: p_item_key in varchar2,
1173: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type,
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;

Line 1192: hr_util_misc_web.validate_session(p_person_id => gn_person_id);

1188: --
1189: BEGIN
1190: hr_utility.set_location('Entering: '|| l_proc,5);
1191: -- validate the session
1192: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
1193:
1194: -- get user date format
1195: gv_user_date_format := hr_util_misc_web.get_user_date_format;
1196:

Line 1195: gv_user_date_format := hr_util_misc_web.get_user_date_format;

1191: -- validate the session
1192: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
1193:
1194: -- get user date format
1195: gv_user_date_format := hr_util_misc_web.get_user_date_format;
1196:
1197:
1198: -- get session language code
1199: gv_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

Line 1249: p_errorMsg=>hr_util_misc_web.return_msg_text

1245: gv_error_table(I).default_approver:= p_approver_flag(I);
1246: -- add a row level error here
1247: hr_errors_api.addErrorToTable (
1248: p_rownumber => i,
1249: p_errorMsg=>hr_util_misc_web.return_msg_text
1250: (p_message_name => 'HR_DA_MESG05_WEB'
1251: ,p_application_id => 'PER'));
1252: ELSE
1253: hr_utility.trace('In else of (IF lv_exist = Y): '|| l_proc);

Line 1347: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,

1343: --
1344: PROCEDURE validate_notifiers(
1345: p_item_type in varchar2,
1346: p_item_key in varchar2,
1347: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
1348: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
1349: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1350: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
1351: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

Line 1348: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type

1344: PROCEDURE validate_notifiers(
1345: p_item_type in varchar2,
1346: p_item_key in varchar2,
1347: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
1348: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
1349: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1350: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
1351: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1352: p_error_flag OUT NOCOPY BOOLEAN )

Line 1349: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

1345: p_item_type in varchar2,
1346: p_item_key in varchar2,
1347: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
1348: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
1349: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1350: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
1351: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1352: p_error_flag OUT NOCOPY BOOLEAN )
1353: IS

Line 1350: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type

1346: p_item_key in varchar2,
1347: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
1348: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
1349: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1350: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
1351: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1352: p_error_flag OUT NOCOPY BOOLEAN )
1353: IS
1354: -- Local variables

Line 1351: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

1347: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
1348: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
1349: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1350: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
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;

Line 1370: hr_util_misc_web.validate_session(p_person_id => gn_person_id);

1366: BEGIN
1367:
1368: hr_utility.set_location('Entering: '|| l_proc,5);
1369: -- validate the session
1370: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
1371:
1372: -- get user date format
1373: gv_user_date_format := hr_util_misc_web.get_user_date_format;
1374:

Line 1373: gv_user_date_format := hr_util_misc_web.get_user_date_format;

1369: -- validate the session
1370: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
1371:
1372: -- get user date format
1373: gv_user_date_format := hr_util_misc_web.get_user_date_format;
1374:
1375:
1376: -- get session language code
1377: gv_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

Line 1430: p_errorMsg=>hr_util_misc_web.return_msg_text

1426: --grt_notifier_error_table(I).on_submit:= p_notify_onsubmit_flag (I);
1427: -- add a row level error here
1428: hr_errors_api.addErrorToTable (
1429: p_rownumber => (100+i),
1430: p_errorMsg=>hr_util_misc_web.return_msg_text
1431: (p_message_name => 'HR_DA_MESG06_WEB'
1432: ,p_application_id => 'PER'));
1433: ELSE
1434: hr_utility.trace('In else of (IF lv_exists = Y): '|| l_proc);

Line 1571: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

1567: ||
1568: ||-----------------------------------------------------------------------*/
1569:
1570: PROCEDURE get_ame_default_approvers(
1571: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
1572: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
1573: p_item_type IN wf_items.item_type%TYPE,
1574: p_item_key IN wf_items.item_key%TYPE)
1575:

Line 1572: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

1568: ||-----------------------------------------------------------------------*/
1569:
1570: PROCEDURE get_ame_default_approvers(
1571: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
1572: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
1573: p_item_type IN wf_items.item_type%TYPE,
1574: p_item_key IN wf_items.item_key%TYPE)
1575:
1576: AS

Line 1594: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT

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;
1596: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
1597: hr_util_misc_web.g_varchar2_tab_default;
1598: ln_job_id NUMBER;

Line 1595: hr_util_misc_web.g_varchar2_tab_default;

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;
1596: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
1597: hr_util_misc_web.g_varchar2_tab_default;
1598: ln_job_id NUMBER;
1599: l_curr_org_name VARCHAR2(100);

Line 1596: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT

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;
1596: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
1597: hr_util_misc_web.g_varchar2_tab_default;
1598: ln_job_id NUMBER;
1599: l_curr_org_name VARCHAR2(100);
1600: l_curr_loc_name VARCHAR2(100);

Line 1597: hr_util_misc_web.g_varchar2_tab_default;

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;
1596: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
1597: hr_util_misc_web.g_varchar2_tab_default;
1598: ln_job_id NUMBER;
1599: l_curr_org_name VARCHAR2(100);
1600: l_curr_loc_name VARCHAR2(100);
1601:

Line 1720: PROCEDURE get_all_ame_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type

1716: ||
1717: ||
1718: ||-----------------------------------------------------------------------*/
1719:
1720: PROCEDURE get_all_ame_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
1721: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1722: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
1723: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1724: p_item_type IN wf_items.item_type%TYPE,

Line 1721: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

1717: ||
1718: ||-----------------------------------------------------------------------*/
1719:
1720: PROCEDURE get_all_ame_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
1721: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1722: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
1723: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1724: p_item_type IN wf_items.item_type%TYPE,
1725: p_item_key IN wf_items.item_key%TYPE,

Line 1722: p_approver_flag hr_util_misc_web.g_varchar2_tab_type

1718: ||-----------------------------------------------------------------------*/
1719:
1720: PROCEDURE get_all_ame_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
1721: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1722: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
1723: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1724: p_item_type IN wf_items.item_type%TYPE,
1725: p_item_key IN wf_items.item_key%TYPE,
1726: p_effective_date IN DATE DEFAULT SYSDATE)

Line 1723: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

1719:
1720: PROCEDURE get_all_ame_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
1721: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1722: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
1723: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1724: p_item_type IN wf_items.item_type%TYPE,
1725: p_item_key IN wf_items.item_key%TYPE,
1726: p_effective_date IN DATE DEFAULT SYSDATE)
1727:

Line 1744: lv_approver_name hr_util_misc_web.g_varchar2_tab_type

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);
1744: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
1745: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1746: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
1747: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1748: ln_job_id NUMBER;

Line 1745: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

1741: lv_default_approver VARCHAR2(100) DEFAULT 'NO';
1742: ln_error_count NUMBER DEFAULT 1;
1743: lv_job_title VARCHAR2(1000);
1744: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
1745: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1746: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
1747: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1748: ln_job_id NUMBER;
1749: l_curr_org_name VARCHAR2(100);

Line 1746: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type

1742: ln_error_count NUMBER DEFAULT 1;
1743: lv_job_title VARCHAR2(1000);
1744: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
1745: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1746: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
1747: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1748: ln_job_id NUMBER;
1749: l_curr_org_name VARCHAR2(100);
1750: l_curr_loc_name VARCHAR2(100);

Line 1747: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

1743: lv_job_title VARCHAR2(1000);
1744: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
1745: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1746: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
1747: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1748: ln_job_id NUMBER;
1749: l_curr_org_name VARCHAR2(100);
1750: l_curr_loc_name VARCHAR2(100);
1751: l_proc constant varchar2(100) := g_package || ' et_all_ame_approvers';

Line 1920: l_approver_name hr_util_misc_web.g_varchar2_tab_type;

1916:
1917: AS
1918:
1919: --local variables
1920: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
1921: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
1922: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
1923: l_default_approver hr_dynamic_approver_ss;
1924: l_proc constant varchar2(100) := g_package || ' get_default_approvers_list';

Line 1921: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;

1917: AS
1918:
1919: --local variables
1920: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
1921: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
1922: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
1923: l_default_approver hr_dynamic_approver_ss;
1924: l_proc constant varchar2(100) := g_package || ' get_default_approvers_list';
1925: BEGIN

Line 1990: l_approver_name hr_util_misc_web.g_varchar2_tab_type;

1986:
1987: AS
1988:
1989: --local variables
1990: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
1991: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
1992: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
1993: l_default_approver hr_dynamic_approver_ss;
1994: l_proc constant varchar2(100) := g_package || ' get_default_approvers_list_extra';

Line 1991: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;

1987: AS
1988:
1989: --local variables
1990: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
1991: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
1992: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
1993: l_default_approver hr_dynamic_approver_ss;
1994: l_proc constant varchar2(100) := g_package || ' get_default_approvers_list_extra';
1995: l_error_message long default null;

Line 2062: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2058: ||
2059: ||-----------------------------------------------------------------------*/
2060:
2061: PROCEDURE get_default_approvers(
2062: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2063: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2064: p_item_type IN wf_items.item_type%TYPE,
2065: p_item_key IN wf_items.item_key%TYPE)
2066:

Line 2063: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2059: ||-----------------------------------------------------------------------*/
2060:
2061: PROCEDURE get_default_approvers(
2062: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2063: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2064: p_item_type IN wf_items.item_type%TYPE,
2065: p_item_key IN wf_items.item_key%TYPE)
2066:
2067: AS

Line 2085: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT

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;
2087: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
2088: hr_util_misc_web.g_varchar2_tab_default;
2089: ln_job_id NUMBER;

Line 2086: hr_util_misc_web.g_varchar2_tab_default;

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;
2087: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
2088: hr_util_misc_web.g_varchar2_tab_default;
2089: ln_job_id NUMBER;
2090: l_curr_org_name VARCHAR2(100);

Line 2087: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT

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;
2087: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
2088: hr_util_misc_web.g_varchar2_tab_default;
2089: ln_job_id NUMBER;
2090: l_curr_org_name VARCHAR2(100);
2091: l_curr_loc_name VARCHAR2(100);

Line 2088: hr_util_misc_web.g_varchar2_tab_default;

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;
2087: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
2088: hr_util_misc_web.g_varchar2_tab_default;
2089: ln_job_id NUMBER;
2090: l_curr_org_name VARCHAR2(100);
2091: l_curr_loc_name VARCHAR2(100);
2092:

Line 2111: -- hr_util_misc_web.validate_session(p_person_id => gn_person_id);

2107: hr_utility.set_location('Entering: '|| l_proc,5);
2108: -- validate the session
2109: -- ******************************************************************************
2110: -- commented out for v 4 by pzwalker - replaced with GetItemAttrNumber call
2111: -- hr_util_misc_web.validate_session(p_person_id => gn_person_id);
2112: gn_person_id := wf_engine.GetItemAttrNumber
2113: (itemtype => p_item_type
2114: ,itemkey => p_item_key
2115: ,aname => 'CREATOR_PERSON_ID');

Line 2290: PROCEDURE get_all_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type

2286: ||
2287: ||
2288: ||-----------------------------------------------------------------------*/
2289:
2290: PROCEDURE get_all_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2291: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2292: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2293: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2294: p_item_type IN wf_items.item_type%TYPE,

Line 2291: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

2287: ||
2288: ||-----------------------------------------------------------------------*/
2289:
2290: PROCEDURE get_all_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2291: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2292: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2293: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2294: p_item_type IN wf_items.item_type%TYPE,
2295: p_item_key IN wf_items.item_key%TYPE,

Line 2292: p_approver_flag hr_util_misc_web.g_varchar2_tab_type

2288: ||-----------------------------------------------------------------------*/
2289:
2290: PROCEDURE get_all_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2291: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2292: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2293: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2294: p_item_type IN wf_items.item_type%TYPE,
2295: p_item_key IN wf_items.item_key%TYPE,
2296: p_effective_date IN DATE DEFAULT SYSDATE)

Line 2293: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

2289:
2290: PROCEDURE get_all_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2291: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2292: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2293: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2294: p_item_type IN wf_items.item_type%TYPE,
2295: p_item_key IN wf_items.item_key%TYPE,
2296: p_effective_date IN DATE DEFAULT SYSDATE)
2297:

Line 2313: lv_approver_name hr_util_misc_web.g_varchar2_tab_type

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);
2313: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2314: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2315: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2316: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2317: ln_job_id NUMBER;

Line 2314: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2310: lv_default_approver VARCHAR2(100) DEFAULT 'NO';
2311: ln_error_count NUMBER DEFAULT 1;
2312: lv_job_title VARCHAR2(1000);
2313: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2314: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2315: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2316: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2317: ln_job_id NUMBER;
2318: l_curr_org_name VARCHAR2(100);

Line 2315: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type

2311: ln_error_count NUMBER DEFAULT 1;
2312: lv_job_title VARCHAR2(1000);
2313: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2314: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2315: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2316: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2317: ln_job_id NUMBER;
2318: l_curr_org_name VARCHAR2(100);
2319: l_curr_loc_name VARCHAR2(100);

Line 2316: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2312: lv_job_title VARCHAR2(1000);
2313: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2314: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2315: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2316: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2317: ln_job_id NUMBER;
2318: l_curr_org_name VARCHAR2(100);
2319: l_curr_loc_name VARCHAR2(100);
2320: l_proc constant varchar2(100) := g_package || ' get_all_approvers';

Line 2541: FUNCTION build_ddl(p_approver_name hr_util_misc_web.g_varchar2_tab_type

2537: ||
2538: ||
2539: ||---------------------------------------*/
2540:
2541: FUNCTION build_ddl(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2542: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2543: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2544: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2545: p_item_type IN wf_items.item_type%TYPE,

Line 2542: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

2538: ||
2539: ||---------------------------------------*/
2540:
2541: FUNCTION build_ddl(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2542: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2543: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2544: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2545: p_item_type IN wf_items.item_type%TYPE,
2546: p_item_key IN wf_items.item_key%TYPE ,

Line 2543: p_approver_flag hr_util_misc_web.g_varchar2_tab_type

2539: ||---------------------------------------*/
2540:
2541: FUNCTION build_ddl(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2542: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2543: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2544: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2545: p_item_type IN wf_items.item_type%TYPE,
2546: p_item_key IN wf_items.item_key%TYPE ,
2547: p_variable_name in varchar2,

Line 2544: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

2540:
2541: FUNCTION build_ddl(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2542: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2543: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2544: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2545: p_item_type IN wf_items.item_type%TYPE,
2546: p_item_key IN wf_items.item_key%TYPE ,
2547: p_variable_name in varchar2,
2548: p_variable_value in varchar2 DEFAULT NULL

Line 2586: := hr_util_misc_web.g_new_line || htf.formselectopen

2582: END LOOP;
2583:
2584: hr_utility.trace('Out of ( FOR I IN 1..lv_index): '|| l_proc);
2585: l_lov
2586: := hr_util_misc_web.g_new_line || htf.formselectopen
2587: (cname => upper(p_variable_name)
2588: ,nsize => 1
2589: ,cattributes => p_attributes) ||
2590: hr_util_misc_web.g_new_line ;

Line 2590: hr_util_misc_web.g_new_line ;

2586: := hr_util_misc_web.g_new_line || htf.formselectopen
2587: (cname => upper(p_variable_name)
2588: ,nsize => 1
2589: ,cattributes => p_attributes) ||
2590: hr_util_misc_web.g_new_line ;
2591:
2592: hr_utility.trace('Going into(FOR i IN 1..lv_index LOOP): '|| l_proc);
2593: FOR i IN 1..lv_index LOOP
2594: IF p_variable_value IS NOT NULL THEN

Line 2608: ||'"' ) ;--|| hr_util_misc_web.g_new_line;

2604: (cvalue => l_ddl_data(i).label
2605: ,cselected => l_checked
2606: ,cattributes => 'VALUE="'|| l_ddl_data(i).code
2607: ||'"' ||'INDEX="'|| l_ddl_data(i).code_index
2608: ||'"' ) ;--|| hr_util_misc_web.g_new_line;
2609: END LOOP;
2610: hr_utility.trace('Out of (FOR i IN 1..lv_index LOOP): '|| l_proc);
2611: l_lov := l_lov || htf.formselectclose || hr_util_misc_web.g_new_line;
2612:

Line 2611: l_lov := l_lov || htf.formselectclose || hr_util_misc_web.g_new_line;

2607: ||'"' ||'INDEX="'|| l_ddl_data(i).code_index
2608: ||'"' ) ;--|| hr_util_misc_web.g_new_line;
2609: END LOOP;
2610: hr_utility.trace('Out of (FOR i IN 1..lv_index LOOP): '|| l_proc);
2611: l_lov := l_lov || htf.formselectclose || hr_util_misc_web.g_new_line;
2612:
2613: hr_utility.set_location('Leaving: '|| l_proc,30);
2614:
2615: RETURN l_lov;

Line 2638: PROCEDURE add_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2634: -- and passes the new list back.
2635: --
2636:
2637:
2638: PROCEDURE add_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2639: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2640: p_item_type IN wf_items.item_type%TYPE,
2641: p_item_key IN wf_items.item_key%TYPE,
2642: p_approver_index IN NUMBER DEFAULT 0)

Line 2639: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2635: --
2636:
2637:
2638: PROCEDURE add_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2639: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2640: p_item_type IN wf_items.item_type%TYPE,
2641: p_item_key IN wf_items.item_key%TYPE,
2642: p_approver_index IN NUMBER DEFAULT 0)
2643: AS

Line 2659: lv_approver_name hr_util_misc_web.g_varchar2_tab_type

2655: ln_loop_index NUMBER;
2656: lv_exist VARCHAR2(10) DEFAULT 'NO';
2657: l_proc constant varchar2(100) := g_package || ' add_approver';
2658: --new variables
2659: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2660: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2661: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2662: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2663: BEGIN

Line 2660: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2656: lv_exist VARCHAR2(10) DEFAULT 'NO';
2657: l_proc constant varchar2(100) := g_package || ' add_approver';
2658: --new variables
2659: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2660: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2661: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2662: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2663: BEGIN
2664: hr_utility.set_location('Entering: '|| l_proc,5);

Line 2661: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type

2657: l_proc constant varchar2(100) := g_package || ' add_approver';
2658: --new variables
2659: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2660: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2661: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2662: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2663: BEGIN
2664: hr_utility.set_location('Entering: '|| l_proc,5);
2665: -- validate the session

Line 2662: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2658: --new variables
2659: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2660: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2661: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2662: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2663: BEGIN
2664: hr_utility.set_location('Entering: '|| l_proc,5);
2665: -- validate the session
2666: hr_util_misc_web.validate_session(p_person_id => gn_person_id);

Line 2666: hr_util_misc_web.validate_session(p_person_id => gn_person_id);

2662: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2663: BEGIN
2664: hr_utility.set_location('Entering: '|| l_proc,5);
2665: -- validate the session
2666: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
2667:
2668: -- set the package global variables
2669: gv_mode := 'ADD';
2670: -- new code

Line 2715: PROCEDURE delete_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2711: -- and passes the new list back.
2712: --
2713:
2714:
2715: PROCEDURE delete_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2716: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2717: p_item_type IN wf_items.item_type%TYPE,
2718: p_item_key IN wf_items.item_key%TYPE,
2719: p_approver_index IN NUMBER DEFAULT 1)

Line 2716: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2712: --
2713:
2714:
2715: PROCEDURE delete_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2716: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2717: p_item_type IN wf_items.item_type%TYPE,
2718: p_item_key IN wf_items.item_key%TYPE,
2719: p_approver_index IN NUMBER DEFAULT 1)
2720: AS

Line 2744: lv_approver_name hr_util_misc_web.g_varchar2_tab_type

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';
2743: -- new variables
2744: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2745: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2746: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2747: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2748:

Line 2745: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2741: lv_valid_approver VARCHAR2(100) DEFAULT 'VALID';
2742: l_proc constant varchar2(100) := g_package || ' delete_approver';
2743: -- new variables
2744: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2745: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2746: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2747: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2748:
2749: BEGIN

Line 2746: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type

2742: l_proc constant varchar2(100) := g_package || ' delete_approver';
2743: -- new variables
2744: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2745: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2746: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2747: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2748:
2749: BEGIN
2750: hr_utility.set_location('Entering: '|| l_proc,5);

Line 2747: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2743: -- new variables
2744: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2745: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2746: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2747: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2748:
2749: BEGIN
2750: hr_utility.set_location('Entering: '|| l_proc,5);
2751: -- validate the session

Line 2752: hr_util_misc_web.validate_session(p_person_id => gn_person_id);

2748:
2749: BEGIN
2750: hr_utility.set_location('Entering: '|| l_proc,5);
2751: -- validate the session
2752: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
2753:
2754:
2755: -- get all the additional approvers
2756: -- get number of additional approvers

Line 2904: PROCEDURE delete_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2900: -- and passes the new list back.
2901: --
2902:
2903:
2904: PROCEDURE delete_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2905: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2906: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2907: p_item_type IN wf_items.item_type%TYPE,
2908: p_item_key IN wf_items.item_key%TYPE,

Line 2905: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2901: --
2902:
2903:
2904: PROCEDURE delete_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2905: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2906: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2907: p_item_type IN wf_items.item_type%TYPE,
2908: p_item_key IN wf_items.item_key%TYPE,
2909: p_notifier_index IN NUMBER DEFAULT 1)

Line 2906: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2902:
2903:
2904: PROCEDURE delete_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2905: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2906: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2907: p_item_type IN wf_items.item_type%TYPE,
2908: p_item_key IN wf_items.item_key%TYPE,
2909: p_notifier_index IN NUMBER DEFAULT 1)
2910: AS

Line 2912: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type;

2908: p_item_key IN wf_items.item_key%TYPE,
2909: p_notifier_index IN NUMBER DEFAULT 1)
2910: AS
2911: -- Local Variables
2912: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type;
2913: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type;
2914: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type;
2915: lv_exist VARCHAR2(10);
2916: l_proc constant varchar2(100) := g_package || ' delete_notifier';

Line 2913: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type;

2909: p_notifier_index IN NUMBER DEFAULT 1)
2910: AS
2911: -- Local Variables
2912: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type;
2913: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type;
2914: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type;
2915: lv_exist VARCHAR2(10);
2916: l_proc constant varchar2(100) := g_package || ' delete_notifier';
2917: BEGIN

Line 2914: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type;

2910: AS
2911: -- Local Variables
2912: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type;
2913: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type;
2914: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type;
2915: lv_exist VARCHAR2(10);
2916: l_proc constant varchar2(100) := g_package || ' delete_notifier';
2917: BEGIN
2918: hr_utility.set_location('Entering: '|| l_proc,5);hr_utility.set_location('Going into(FOR I IN 1..p_notifier_name.count): '|| l_proc,10);

Line 3038: PROCEDURE add_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

3034: -- default flags.
3035: --
3036:
3037:
3038: PROCEDURE add_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
3039: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
3040: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
3041: p_item_type IN wf_items.item_type%TYPE
3042: ,p_item_key IN wf_items.item_key%TYPE

Line 3039: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

3035: --
3036:
3037:
3038: PROCEDURE add_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
3039: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
3040: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
3041: p_item_type IN wf_items.item_type%TYPE
3042: ,p_item_key IN wf_items.item_key%TYPE
3043: ,P_PERSON_NAME IN per_all_people_f.full_name%TYPE

Line 3040: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

3036:
3037:
3038: PROCEDURE add_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
3039: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
3040: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
3041: p_item_type IN wf_items.item_type%TYPE
3042: ,p_item_key IN wf_items.item_key%TYPE
3043: ,P_PERSON_NAME IN per_all_people_f.full_name%TYPE
3044: ,p_person_id IN per_all_people_f.person_id%TYPE

Line 3053: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type

3049: l_dummy VARCHAR2(100) ;
3050: lv_item_name VARCHAR2(100);
3051: l_proc constant varchar2(100) := g_package || ' add_notifier';
3052: -- new variables
3053: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type
3054: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3055: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
3056: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3057: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type

Line 3054: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

3050: lv_item_name VARCHAR2(100);
3051: l_proc constant varchar2(100) := g_package || ' add_notifier';
3052: -- new variables
3053: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type
3054: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3055: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
3056: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3057: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
3058: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

Line 3055: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type

3051: l_proc constant varchar2(100) := g_package || ' add_notifier';
3052: -- new variables
3053: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type
3054: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3055: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
3056: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3057: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
3058: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3059: BEGIN

Line 3056: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

3052: -- new variables
3053: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type
3054: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3055: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
3056: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3057: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
3058: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3059: BEGIN
3060:

Line 3057: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type

3053: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type
3054: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3055: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
3056: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3057: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
3058: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3059: BEGIN
3060:
3061: hr_utility.set_location('Entering: '|| l_proc,5);

Line 3058: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

3054: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3055: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
3056: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3057: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
3058: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
3059: BEGIN
3060:
3061: hr_utility.set_location('Entering: '|| l_proc,5);
3062: lv_notifier_name := p_notifier_name;

Line 3092: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,

3088: -- Get all the notifiers for the process
3089: --
3090: --
3091: PROCEDURE Get_all_notifiers(
3092: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
3093: p_notify_onsubmit_flag IN hr_util_misc_web.g_varchar2_tab_type,
3094: p_notify_onapproval_flag IN hr_util_misc_web.g_varchar2_tab_type,
3095: p_item_type IN wf_items.item_type%TYPE,
3096: p_item_key IN wf_items.item_key%TYPE,

Line 3093: p_notify_onsubmit_flag IN hr_util_misc_web.g_varchar2_tab_type,

3089: --
3090: --
3091: PROCEDURE Get_all_notifiers(
3092: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
3093: p_notify_onsubmit_flag IN hr_util_misc_web.g_varchar2_tab_type,
3094: p_notify_onapproval_flag IN hr_util_misc_web.g_varchar2_tab_type,
3095: p_item_type IN wf_items.item_type%TYPE,
3096: p_item_key IN wf_items.item_key%TYPE,
3097: p_effective_date IN DATE

Line 3094: p_notify_onapproval_flag IN hr_util_misc_web.g_varchar2_tab_type,

3090: --
3091: PROCEDURE Get_all_notifiers(
3092: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
3093: p_notify_onsubmit_flag IN hr_util_misc_web.g_varchar2_tab_type,
3094: p_notify_onapproval_flag IN hr_util_misc_web.g_varchar2_tab_type,
3095: p_item_type IN wf_items.item_type%TYPE,
3096: p_item_key IN wf_items.item_key%TYPE,
3097: p_effective_date IN DATE
3098: )

Line 3313: p_Notify_On_Submit hr_util_misc_web.g_varchar2_tab_type DEFAULT

3309: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
3310: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
3311: p_act_id IN NUMBER ,
3312: p_notifiers_num IN NUMBER DEFAULT 0,
3313: p_Notify_On_Submit hr_util_misc_web.g_varchar2_tab_type DEFAULT
3314: hr_util_misc_web.g_varchar2_tab_default,
3315: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT
3316: hr_util_misc_web.g_varchar2_tab_default
3317:

Line 3314: hr_util_misc_web.g_varchar2_tab_default,

3310: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
3311: p_act_id IN NUMBER ,
3312: p_notifiers_num IN NUMBER DEFAULT 0,
3313: p_Notify_On_Submit hr_util_misc_web.g_varchar2_tab_type DEFAULT
3314: hr_util_misc_web.g_varchar2_tab_default,
3315: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT
3316: hr_util_misc_web.g_varchar2_tab_default
3317:
3318: )

Line 3315: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT

3311: p_act_id IN NUMBER ,
3312: p_notifiers_num IN NUMBER DEFAULT 0,
3313: p_Notify_On_Submit hr_util_misc_web.g_varchar2_tab_type DEFAULT
3314: hr_util_misc_web.g_varchar2_tab_default,
3315: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT
3316: hr_util_misc_web.g_varchar2_tab_default
3317:
3318: )
3319: AS

Line 3316: hr_util_misc_web.g_varchar2_tab_default

3312: p_notifiers_num IN NUMBER DEFAULT 0,
3313: p_Notify_On_Submit hr_util_misc_web.g_varchar2_tab_type DEFAULT
3314: hr_util_misc_web.g_varchar2_tab_default,
3315: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT
3316: hr_util_misc_web.g_varchar2_tab_default
3317:
3318: )
3319: AS
3320: -- Local Variables

Line 3399: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type

3395:
3396: PROCEDURE clean_invalid_data( p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
3397: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
3398: p_act_id IN NUMBER ,
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 ;

Line 5400: l_approver_name hr_util_misc_web.g_varchar2_tab_type;

5396:
5397: AS
5398:
5399: --local variables
5400: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5401: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5402: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5403: l_default_approver hr_dynamic_approver_ss;
5404: lv_number varchar2(10);

Line 5401: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;

5397: AS
5398:
5399: --local variables
5400: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5401: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5402: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5403: l_default_approver hr_dynamic_approver_ss;
5404: lv_number varchar2(10);
5405: ln_creator_person_id number;

Line 5517: l_approver_name hr_util_misc_web.g_varchar2_tab_type;

5513:
5514: AS
5515:
5516: --local variables
5517: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5518: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5519: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5520: l_default_approver hr_dynamic_approver_ss;
5521: l_approvers_list hr_dynamic_approver_list_ss;

Line 5518: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;

5514: AS
5515:
5516: --local variables
5517: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5518: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5519: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5520: l_default_approver hr_dynamic_approver_ss;
5521: l_approvers_list hr_dynamic_approver_list_ss;
5522: lv_number varchar2(10);

Line 5650: l_approver_name hr_util_misc_web.g_varchar2_tab_type;

5646:
5647: AS
5648:
5649: --local variables
5650: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5651: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5652: l_additional_notifiers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5653: l_notifier_rec hr_dynamic_approver_ss;
5654: lv_number varchar2(10);

Line 5651: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;

5647: AS
5648:
5649: --local variables
5650: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5651: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5652: l_additional_notifiers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5653: l_notifier_rec hr_dynamic_approver_ss;
5654: lv_number varchar2(10);
5655: lv_exist VARCHAR2(10) DEFAULT 'N';