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 506: hr_util_misc_web.validate_session(p_person_id => gn_person_id);

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

Line 612: p_approver_name hr_util_misc_web.g_varchar2_tab_type

608: PROCEDURE COMMIT_DATA(
609: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
610: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
611: p_act_id IN NUMBER ,
612: p_approver_name hr_util_misc_web.g_varchar2_tab_type
613: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
614: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
615: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
616: p_notifier_name hr_util_misc_web.g_varchar2_tab_type

Line 613: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

609: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
610: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
611: p_act_id IN NUMBER ,
612: p_approver_name hr_util_misc_web.g_varchar2_tab_type
613: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
614: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
615: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
616: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
617: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

Line 614: p_approver_flag hr_util_misc_web.g_varchar2_tab_type

610: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
611: p_act_id IN NUMBER ,
612: p_approver_name hr_util_misc_web.g_varchar2_tab_type
613: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
614: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
615: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
616: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
617: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
618: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type

Line 615: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

611: p_act_id IN NUMBER ,
612: p_approver_name hr_util_misc_web.g_varchar2_tab_type
613: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
614: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
615: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
616: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
617: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
618: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
619: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

Line 616: p_notifier_name hr_util_misc_web.g_varchar2_tab_type

612: p_approver_name hr_util_misc_web.g_varchar2_tab_type
613: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
614: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
615: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
616: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
617: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
618: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
619: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
620: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type

Line 617: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

613: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
614: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
615: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
616: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
617: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
618: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
619: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
620: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
621: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

Line 618: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type

614: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
615: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
616: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
617: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
618: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
619: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
620: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
621: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
622: p_mode IN VARCHAR2

Line 619: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

615: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
616: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
617: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
618: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
619: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
620: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
621: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
622: p_mode IN VARCHAR2
623: )

Line 620: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type

616: p_notifier_name hr_util_misc_web.g_varchar2_tab_type
617: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
618: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
619: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
620: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
621: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
622: p_mode IN VARCHAR2
623: )
624: IS

Line 621: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

617: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
618: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
619: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
620: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
621: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
622: p_mode IN VARCHAR2
623: )
624: IS
625: -- Local variables

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

641: BEGIN
642:
643: hr_utility.set_location('Entering: '|| l_proc,5);
644: -- validate the session
645: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
646:
647: -- get user date format
648: gv_user_date_format := hr_util_misc_web.get_user_date_format;
649:

Line 648: gv_user_date_format := hr_util_misc_web.get_user_date_format;

644: -- validate the session
645: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
646:
647: -- get user date format
648: gv_user_date_format := hr_util_misc_web.get_user_date_format;
649:
650:
651: -- get session language code
652: gv_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

Line 1137: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type,

1133: --
1134: PROCEDURE validate_approvers(
1135: p_item_type in varchar2,
1136: p_item_key in varchar2,
1137: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type,
1138: p_approver_flag IN hr_util_misc_web.g_varchar2_tab_type,
1139: p_error_flag OUT NOCOPY BOOLEAN )
1140: IS
1141: -- Local variables

Line 1138: p_approver_flag IN hr_util_misc_web.g_varchar2_tab_type,

1134: PROCEDURE validate_approvers(
1135: p_item_type in varchar2,
1136: p_item_key in varchar2,
1137: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type,
1138: p_approver_flag IN hr_util_misc_web.g_varchar2_tab_type,
1139: p_error_flag OUT NOCOPY BOOLEAN )
1140: IS
1141: -- Local variables
1142: ln_approver_id per_people_f.person_id%TYPE DEFAULT NULL;

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

1152: --
1153: BEGIN
1154: hr_utility.set_location('Entering: '|| l_proc,5);
1155: -- validate the session
1156: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
1157:
1158: -- get user date format
1159: gv_user_date_format := hr_util_misc_web.get_user_date_format;
1160:

Line 1159: gv_user_date_format := hr_util_misc_web.get_user_date_format;

1155: -- validate the session
1156: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
1157:
1158: -- get user date format
1159: gv_user_date_format := hr_util_misc_web.get_user_date_format;
1160:
1161:
1162: -- get session language code
1163: gv_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

Line 1213: p_errorMsg=>hr_util_misc_web.return_msg_text

1209: gv_error_table(I).default_approver:= p_approver_flag(I);
1210: -- add a row level error here
1211: hr_errors_api.addErrorToTable (
1212: p_rownumber => i,
1213: p_errorMsg=>hr_util_misc_web.return_msg_text
1214: (p_message_name => 'HR_DA_MESG05_WEB'
1215: ,p_application_id => 'PER'));
1216: ELSE
1217: hr_utility.trace('In else of (IF lv_exist = Y): '|| l_proc);

Line 1311: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,

1307: --
1308: PROCEDURE validate_notifiers(
1309: p_item_type in varchar2,
1310: p_item_key in varchar2,
1311: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
1312: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
1313: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1314: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
1315: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

Line 1312: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type

1308: PROCEDURE validate_notifiers(
1309: p_item_type in varchar2,
1310: p_item_key in varchar2,
1311: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
1312: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
1313: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1314: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
1315: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1316: p_error_flag OUT NOCOPY BOOLEAN )

Line 1313: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

1309: p_item_type in varchar2,
1310: p_item_key in varchar2,
1311: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
1312: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
1313: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1314: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
1315: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1316: p_error_flag OUT NOCOPY BOOLEAN )
1317: IS

Line 1314: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type

1310: p_item_key in varchar2,
1311: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
1312: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
1313: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1314: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
1315: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1316: p_error_flag OUT NOCOPY BOOLEAN )
1317: IS
1318: -- Local variables

Line 1315: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

1311: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
1312: p_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
1313: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1314: p_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
1315: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1316: p_error_flag OUT NOCOPY BOOLEAN )
1317: IS
1318: -- Local variables
1319: ln_notifier_id per_people_f.person_id%TYPE DEFAULT NULL;

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

1330: BEGIN
1331:
1332: hr_utility.set_location('Entering: '|| l_proc,5);
1333: -- validate the session
1334: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
1335:
1336: -- get user date format
1337: gv_user_date_format := hr_util_misc_web.get_user_date_format;
1338:

Line 1337: gv_user_date_format := hr_util_misc_web.get_user_date_format;

1333: -- validate the session
1334: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
1335:
1336: -- get user date format
1337: gv_user_date_format := hr_util_misc_web.get_user_date_format;
1338:
1339:
1340: -- get session language code
1341: gv_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

Line 1394: p_errorMsg=>hr_util_misc_web.return_msg_text

1390: --grt_notifier_error_table(I).on_submit:= p_notify_onsubmit_flag (I);
1391: -- add a row level error here
1392: hr_errors_api.addErrorToTable (
1393: p_rownumber => (100+i),
1394: p_errorMsg=>hr_util_misc_web.return_msg_text
1395: (p_message_name => 'HR_DA_MESG06_WEB'
1396: ,p_application_id => 'PER'));
1397: ELSE
1398: hr_utility.trace('In else of (IF lv_exists = Y): '|| l_proc);

Line 1535: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

1531: ||
1532: ||-----------------------------------------------------------------------*/
1533:
1534: PROCEDURE get_ame_default_approvers(
1535: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
1536: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
1537: p_item_type IN wf_items.item_type%TYPE,
1538: p_item_key IN wf_items.item_key%TYPE)
1539:

Line 1536: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

1532: ||-----------------------------------------------------------------------*/
1533:
1534: PROCEDURE get_ame_default_approvers(
1535: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
1536: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
1537: p_item_type IN wf_items.item_type%TYPE,
1538: p_item_key IN wf_items.item_key%TYPE)
1539:
1540: AS

Line 1558: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT

1554: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;
1555: lrt_assignment_details hr_misc_web.grt_assignment_details;
1556: l_proc constant varchar2(100) := g_package || ' get_ame_default_approvers';
1557: --my new variables
1558: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT
1559: hr_util_misc_web.g_varchar2_tab_default;
1560: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
1561: hr_util_misc_web.g_varchar2_tab_default;
1562: ln_job_id NUMBER;

Line 1559: hr_util_misc_web.g_varchar2_tab_default;

1555: lrt_assignment_details hr_misc_web.grt_assignment_details;
1556: l_proc constant varchar2(100) := g_package || ' get_ame_default_approvers';
1557: --my new variables
1558: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT
1559: hr_util_misc_web.g_varchar2_tab_default;
1560: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
1561: hr_util_misc_web.g_varchar2_tab_default;
1562: ln_job_id NUMBER;
1563: l_curr_org_name VARCHAR2(100);

Line 1560: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT

1556: l_proc constant varchar2(100) := g_package || ' get_ame_default_approvers';
1557: --my new variables
1558: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT
1559: hr_util_misc_web.g_varchar2_tab_default;
1560: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
1561: hr_util_misc_web.g_varchar2_tab_default;
1562: ln_job_id NUMBER;
1563: l_curr_org_name VARCHAR2(100);
1564: l_curr_loc_name VARCHAR2(100);

Line 1561: hr_util_misc_web.g_varchar2_tab_default;

1557: --my new variables
1558: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT
1559: hr_util_misc_web.g_varchar2_tab_default;
1560: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
1561: hr_util_misc_web.g_varchar2_tab_default;
1562: ln_job_id NUMBER;
1563: l_curr_org_name VARCHAR2(100);
1564: l_curr_loc_name VARCHAR2(100);
1565:

Line 1671: PROCEDURE get_all_ame_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type

1667: ||
1668: ||
1669: ||-----------------------------------------------------------------------*/
1670:
1671: PROCEDURE get_all_ame_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
1672: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1673: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
1674: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1675: p_item_type IN wf_items.item_type%TYPE,

Line 1672: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

1668: ||
1669: ||-----------------------------------------------------------------------*/
1670:
1671: PROCEDURE get_all_ame_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
1672: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1673: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
1674: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1675: p_item_type IN wf_items.item_type%TYPE,
1676: p_item_key IN wf_items.item_key%TYPE,

Line 1673: p_approver_flag hr_util_misc_web.g_varchar2_tab_type

1669: ||-----------------------------------------------------------------------*/
1670:
1671: PROCEDURE get_all_ame_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
1672: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1673: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
1674: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1675: p_item_type IN wf_items.item_type%TYPE,
1676: p_item_key IN wf_items.item_key%TYPE,
1677: p_effective_date IN DATE DEFAULT SYSDATE)

Line 1674: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

1670:
1671: PROCEDURE get_all_ame_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
1672: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1673: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
1674: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
1675: p_item_type IN wf_items.item_type%TYPE,
1676: p_item_key IN wf_items.item_key%TYPE,
1677: p_effective_date IN DATE DEFAULT SYSDATE)
1678:

Line 1695: lv_approver_name hr_util_misc_web.g_varchar2_tab_type

1691: lv_approver_deleted VARCHAR2(100) DEFAULT NULL;
1692: lv_default_approver VARCHAR2(100) DEFAULT 'NO';
1693: ln_error_count NUMBER DEFAULT 1;
1694: lv_job_title VARCHAR2(1000);
1695: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
1696: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1697: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
1698: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1699: ln_job_id NUMBER;

Line 1696: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

1692: lv_default_approver VARCHAR2(100) DEFAULT 'NO';
1693: ln_error_count NUMBER DEFAULT 1;
1694: lv_job_title VARCHAR2(1000);
1695: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
1696: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1697: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
1698: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1699: ln_job_id NUMBER;
1700: l_curr_org_name VARCHAR2(100);

Line 1697: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type

1693: ln_error_count NUMBER DEFAULT 1;
1694: lv_job_title VARCHAR2(1000);
1695: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
1696: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1697: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
1698: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1699: ln_job_id NUMBER;
1700: l_curr_org_name VARCHAR2(100);
1701: l_curr_loc_name VARCHAR2(100);

Line 1698: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

1694: lv_job_title VARCHAR2(1000);
1695: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
1696: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1697: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
1698: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
1699: ln_job_id NUMBER;
1700: l_curr_org_name VARCHAR2(100);
1701: l_curr_loc_name VARCHAR2(100);
1702: l_proc constant varchar2(100) := g_package || ' et_all_ame_approvers';

Line 1859: l_approver_name hr_util_misc_web.g_varchar2_tab_type;

1855:
1856: AS
1857:
1858: --local variables
1859: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
1860: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
1861: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
1862: l_default_approver hr_dynamic_approver_ss;
1863: l_proc constant varchar2(100) := g_package || ' get_default_approvers_list';

Line 1860: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;

1856: AS
1857:
1858: --local variables
1859: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
1860: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
1861: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
1862: l_default_approver hr_dynamic_approver_ss;
1863: l_proc constant varchar2(100) := g_package || ' get_default_approvers_list';
1864: BEGIN

Line 1929: l_approver_name hr_util_misc_web.g_varchar2_tab_type;

1925:
1926: AS
1927:
1928: --local variables
1929: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
1930: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
1931: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
1932: l_default_approver hr_dynamic_approver_ss;
1933: l_proc constant varchar2(100) := g_package || ' get_default_approvers_list_extra';

Line 1930: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;

1926: AS
1927:
1928: --local variables
1929: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
1930: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
1931: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
1932: l_default_approver hr_dynamic_approver_ss;
1933: l_proc constant varchar2(100) := g_package || ' get_default_approvers_list_extra';
1934: l_error_message long default null;

Line 2001: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

1997: ||
1998: ||-----------------------------------------------------------------------*/
1999:
2000: PROCEDURE get_default_approvers(
2001: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2002: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2003: p_item_type IN wf_items.item_type%TYPE,
2004: p_item_key IN wf_items.item_key%TYPE)
2005:

Line 2002: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

1998: ||-----------------------------------------------------------------------*/
1999:
2000: PROCEDURE get_default_approvers(
2001: p_approver_name OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2002: p_approver_flag OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2003: p_item_type IN wf_items.item_type%TYPE,
2004: p_item_key IN wf_items.item_key%TYPE)
2005:
2006: AS

Line 2024: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT

2020: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;
2021: lrt_assignment_details hr_misc_web.grt_assignment_details;
2022: l_proc constant varchar2(100) := g_package || ' get_default_approvers';
2023: --my new variables
2024: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT
2025: hr_util_misc_web.g_varchar2_tab_default;
2026: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
2027: hr_util_misc_web.g_varchar2_tab_default;
2028: ln_job_id NUMBER;

Line 2025: hr_util_misc_web.g_varchar2_tab_default;

2021: lrt_assignment_details hr_misc_web.grt_assignment_details;
2022: l_proc constant varchar2(100) := g_package || ' get_default_approvers';
2023: --my new variables
2024: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT
2025: hr_util_misc_web.g_varchar2_tab_default;
2026: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
2027: hr_util_misc_web.g_varchar2_tab_default;
2028: ln_job_id NUMBER;
2029: l_curr_org_name VARCHAR2(100);

Line 2026: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT

2022: l_proc constant varchar2(100) := g_package || ' get_default_approvers';
2023: --my new variables
2024: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT
2025: hr_util_misc_web.g_varchar2_tab_default;
2026: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
2027: hr_util_misc_web.g_varchar2_tab_default;
2028: ln_job_id NUMBER;
2029: l_curr_org_name VARCHAR2(100);
2030: l_curr_loc_name VARCHAR2(100);

Line 2027: hr_util_misc_web.g_varchar2_tab_default;

2023: --my new variables
2024: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT
2025: hr_util_misc_web.g_varchar2_tab_default;
2026: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type DEFAULT
2027: hr_util_misc_web.g_varchar2_tab_default;
2028: ln_job_id NUMBER;
2029: l_curr_org_name VARCHAR2(100);
2030: l_curr_loc_name VARCHAR2(100);
2031:

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

2044: hr_utility.set_location('Entering: '|| l_proc,5);
2045: -- validate the session
2046: -- ******************************************************************************
2047: -- commented out for v 4 by pzwalker - replaced with GetItemAttrNumber call
2048: -- hr_util_misc_web.validate_session(p_person_id => gn_person_id);
2049: gn_person_id := wf_engine.GetItemAttrNumber
2050: (itemtype => p_item_type
2051: ,itemkey => p_item_key
2052: ,aname => 'CREATOR_PERSON_ID');

Line 2220: PROCEDURE get_all_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type

2216: ||
2217: ||
2218: ||-----------------------------------------------------------------------*/
2219:
2220: PROCEDURE get_all_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2221: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2222: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2223: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2224: p_item_type IN wf_items.item_type%TYPE,

Line 2221: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

2217: ||
2218: ||-----------------------------------------------------------------------*/
2219:
2220: PROCEDURE get_all_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2221: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2222: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2223: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2224: p_item_type IN wf_items.item_type%TYPE,
2225: p_item_key IN wf_items.item_key%TYPE,

Line 2222: p_approver_flag hr_util_misc_web.g_varchar2_tab_type

2218: ||-----------------------------------------------------------------------*/
2219:
2220: PROCEDURE get_all_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2221: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2222: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2223: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2224: p_item_type IN wf_items.item_type%TYPE,
2225: p_item_key IN wf_items.item_key%TYPE,
2226: p_effective_date IN DATE DEFAULT SYSDATE)

Line 2223: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

2219:
2220: PROCEDURE get_all_approvers(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2221: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2222: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2223: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2224: p_item_type IN wf_items.item_type%TYPE,
2225: p_item_key IN wf_items.item_key%TYPE,
2226: p_effective_date IN DATE DEFAULT SYSDATE)
2227:

Line 2243: lv_approver_name hr_util_misc_web.g_varchar2_tab_type

2239: lv_approver_deleted VARCHAR2(100) DEFAULT NULL;
2240: lv_default_approver VARCHAR2(100) DEFAULT 'NO';
2241: ln_error_count NUMBER DEFAULT 1;
2242: lv_job_title VARCHAR2(1000);
2243: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2244: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2245: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2246: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2247: ln_job_id NUMBER;

Line 2244: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2240: lv_default_approver VARCHAR2(100) DEFAULT 'NO';
2241: ln_error_count NUMBER DEFAULT 1;
2242: lv_job_title VARCHAR2(1000);
2243: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2244: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2245: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2246: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2247: ln_job_id NUMBER;
2248: l_curr_org_name VARCHAR2(100);

Line 2245: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type

2241: ln_error_count NUMBER DEFAULT 1;
2242: lv_job_title VARCHAR2(1000);
2243: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2244: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2245: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2246: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2247: ln_job_id NUMBER;
2248: l_curr_org_name VARCHAR2(100);
2249: l_curr_loc_name VARCHAR2(100);

Line 2246: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2242: lv_job_title VARCHAR2(1000);
2243: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2244: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2245: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2246: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2247: ln_job_id NUMBER;
2248: l_curr_org_name VARCHAR2(100);
2249: l_curr_loc_name VARCHAR2(100);
2250: l_proc constant varchar2(100) := g_package || ' get_all_approvers';

Line 2471: FUNCTION build_ddl(p_approver_name hr_util_misc_web.g_varchar2_tab_type

2467: ||
2468: ||
2469: ||---------------------------------------*/
2470:
2471: FUNCTION build_ddl(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2472: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2473: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2474: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2475: p_item_type IN wf_items.item_type%TYPE,

Line 2472: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

2468: ||
2469: ||---------------------------------------*/
2470:
2471: FUNCTION build_ddl(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2472: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2473: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2474: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2475: p_item_type IN wf_items.item_type%TYPE,
2476: p_item_key IN wf_items.item_key%TYPE ,

Line 2473: p_approver_flag hr_util_misc_web.g_varchar2_tab_type

2469: ||---------------------------------------*/
2470:
2471: FUNCTION build_ddl(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2472: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2473: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2474: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2475: p_item_type IN wf_items.item_type%TYPE,
2476: p_item_key IN wf_items.item_key%TYPE ,
2477: p_variable_name in varchar2,

Line 2474: DEFAULT hr_util_misc_web.g_varchar2_tab_default,

2470:
2471: FUNCTION build_ddl(p_approver_name hr_util_misc_web.g_varchar2_tab_type
2472: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2473: p_approver_flag hr_util_misc_web.g_varchar2_tab_type
2474: DEFAULT hr_util_misc_web.g_varchar2_tab_default,
2475: p_item_type IN wf_items.item_type%TYPE,
2476: p_item_key IN wf_items.item_key%TYPE ,
2477: p_variable_name in varchar2,
2478: p_variable_value in varchar2 DEFAULT NULL

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

2512: END LOOP;
2513:
2514: hr_utility.trace('Out of ( FOR I IN 1..lv_index): '|| l_proc);
2515: l_lov
2516: := hr_util_misc_web.g_new_line || htf.formselectopen
2517: (cname => upper(p_variable_name)
2518: ,nsize => 1
2519: ,cattributes => p_attributes) ||
2520: hr_util_misc_web.g_new_line ;

Line 2520: hr_util_misc_web.g_new_line ;

2516: := hr_util_misc_web.g_new_line || htf.formselectopen
2517: (cname => upper(p_variable_name)
2518: ,nsize => 1
2519: ,cattributes => p_attributes) ||
2520: hr_util_misc_web.g_new_line ;
2521:
2522: hr_utility.trace('Going into(FOR i IN 1..lv_index LOOP): '|| l_proc);
2523: FOR i IN 1..lv_index LOOP
2524: IF p_variable_value IS NOT NULL THEN

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

2534: (cvalue => l_ddl_data(i).label
2535: ,cselected => l_checked
2536: ,cattributes => 'VALUE="'|| l_ddl_data(i).code
2537: ||'"' ||'INDEX="'|| l_ddl_data(i).code_index
2538: ||'"' ) ;--|| hr_util_misc_web.g_new_line;
2539: END LOOP;
2540: hr_utility.trace('Out of (FOR i IN 1..lv_index LOOP): '|| l_proc);
2541: l_lov := l_lov || htf.formselectclose || hr_util_misc_web.g_new_line;
2542:

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

2537: ||'"' ||'INDEX="'|| l_ddl_data(i).code_index
2538: ||'"' ) ;--|| hr_util_misc_web.g_new_line;
2539: END LOOP;
2540: hr_utility.trace('Out of (FOR i IN 1..lv_index LOOP): '|| l_proc);
2541: l_lov := l_lov || htf.formselectclose || hr_util_misc_web.g_new_line;
2542:
2543: hr_utility.set_location('Leaving: '|| l_proc,30);
2544:
2545: RETURN l_lov;

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

2564: -- and passes the new list back.
2565: --
2566:
2567:
2568: PROCEDURE add_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2569: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2570: p_item_type IN wf_items.item_type%TYPE,
2571: p_item_key IN wf_items.item_key%TYPE,
2572: p_approver_index IN NUMBER DEFAULT 0)

Line 2569: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2565: --
2566:
2567:
2568: PROCEDURE add_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2569: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2570: p_item_type IN wf_items.item_type%TYPE,
2571: p_item_key IN wf_items.item_key%TYPE,
2572: p_approver_index IN NUMBER DEFAULT 0)
2573: AS

Line 2589: lv_approver_name hr_util_misc_web.g_varchar2_tab_type

2585: ln_loop_index NUMBER;
2586: lv_exist VARCHAR2(10) DEFAULT 'NO';
2587: l_proc constant varchar2(100) := g_package || ' add_approver';
2588: --new variables
2589: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2590: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2591: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2592: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2593: BEGIN

Line 2590: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2586: lv_exist VARCHAR2(10) DEFAULT 'NO';
2587: l_proc constant varchar2(100) := g_package || ' add_approver';
2588: --new variables
2589: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2590: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2591: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2592: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2593: BEGIN
2594: hr_utility.set_location('Entering: '|| l_proc,5);

Line 2591: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type

2587: l_proc constant varchar2(100) := g_package || ' add_approver';
2588: --new variables
2589: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2590: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2591: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2592: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2593: BEGIN
2594: hr_utility.set_location('Entering: '|| l_proc,5);
2595: -- validate the session

Line 2592: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2588: --new variables
2589: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2590: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2591: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2592: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2593: BEGIN
2594: hr_utility.set_location('Entering: '|| l_proc,5);
2595: -- validate the session
2596: hr_util_misc_web.validate_session(p_person_id => gn_person_id);

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

2592: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2593: BEGIN
2594: hr_utility.set_location('Entering: '|| l_proc,5);
2595: -- validate the session
2596: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
2597:
2598: -- set the package global variables
2599: gv_mode := 'ADD';
2600: -- new code

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

2641: -- and passes the new list back.
2642: --
2643:
2644:
2645: PROCEDURE delete_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2646: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2647: p_item_type IN wf_items.item_type%TYPE,
2648: p_item_key IN wf_items.item_key%TYPE,
2649: p_approver_index IN NUMBER DEFAULT 1)

Line 2646: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2642: --
2643:
2644:
2645: PROCEDURE delete_approver(p_approver_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2646: p_approver_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2647: p_item_type IN wf_items.item_type%TYPE,
2648: p_item_key IN wf_items.item_key%TYPE,
2649: p_approver_index IN NUMBER DEFAULT 1)
2650: AS

Line 2674: lv_approver_name hr_util_misc_web.g_varchar2_tab_type

2670: lv_last_addnl_approver VARCHAR2(10) DEFAULT 'NO';
2671: lv_valid_approver VARCHAR2(100) DEFAULT 'VALID';
2672: l_proc constant varchar2(100) := g_package || ' delete_approver';
2673: -- new variables
2674: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2675: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2676: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2677: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2678:

Line 2675: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2671: lv_valid_approver VARCHAR2(100) DEFAULT 'VALID';
2672: l_proc constant varchar2(100) := g_package || ' delete_approver';
2673: -- new variables
2674: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2675: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2676: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2677: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2678:
2679: BEGIN

Line 2676: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type

2672: l_proc constant varchar2(100) := g_package || ' delete_approver';
2673: -- new variables
2674: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2675: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2676: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2677: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2678:
2679: BEGIN
2680: hr_utility.set_location('Entering: '|| l_proc,5);

Line 2677: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2673: -- new variables
2674: lv_approver_name hr_util_misc_web.g_varchar2_tab_type
2675: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2676: lv_approver_flag hr_util_misc_web.g_varchar2_tab_type
2677: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2678:
2679: BEGIN
2680: hr_utility.set_location('Entering: '|| l_proc,5);
2681: -- validate the session

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

2678:
2679: BEGIN
2680: hr_utility.set_location('Entering: '|| l_proc,5);
2681: -- validate the session
2682: hr_util_misc_web.validate_session(p_person_id => gn_person_id);
2683:
2684:
2685: -- get all the additional approvers
2686: -- get number of additional approvers

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

2830: -- and passes the new list back.
2831: --
2832:
2833:
2834: PROCEDURE delete_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2835: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2836: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2837: p_item_type IN wf_items.item_type%TYPE,
2838: p_item_key IN wf_items.item_key%TYPE,

Line 2835: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2831: --
2832:
2833:
2834: PROCEDURE delete_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2835: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2836: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2837: p_item_type IN wf_items.item_type%TYPE,
2838: p_item_key IN wf_items.item_key%TYPE,
2839: p_notifier_index IN NUMBER DEFAULT 1)

Line 2836: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2832:
2833:
2834: PROCEDURE delete_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2835: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2836: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2837: p_item_type IN wf_items.item_type%TYPE,
2838: p_item_key IN wf_items.item_key%TYPE,
2839: p_notifier_index IN NUMBER DEFAULT 1)
2840: AS

Line 2842: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type;

2838: p_item_key IN wf_items.item_key%TYPE,
2839: p_notifier_index IN NUMBER DEFAULT 1)
2840: AS
2841: -- Local Variables
2842: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type;
2843: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type;
2844: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type;
2845: lv_exist VARCHAR2(10);
2846: l_proc constant varchar2(100) := g_package || ' delete_notifier';

Line 2843: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type;

2839: p_notifier_index IN NUMBER DEFAULT 1)
2840: AS
2841: -- Local Variables
2842: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type;
2843: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type;
2844: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type;
2845: lv_exist VARCHAR2(10);
2846: l_proc constant varchar2(100) := g_package || ' delete_notifier';
2847: BEGIN

Line 2844: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type;

2840: AS
2841: -- Local Variables
2842: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type;
2843: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type;
2844: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type;
2845: lv_exist VARCHAR2(10);
2846: l_proc constant varchar2(100) := g_package || ' delete_notifier';
2847: BEGIN
2848: 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 2968: PROCEDURE add_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2964: -- default flags.
2965: --
2966:
2967:
2968: PROCEDURE add_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2969: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2970: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2971: p_item_type IN wf_items.item_type%TYPE
2972: ,p_item_key IN wf_items.item_key%TYPE

Line 2969: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2965: --
2966:
2967:
2968: PROCEDURE add_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2969: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2970: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2971: p_item_type IN wf_items.item_type%TYPE
2972: ,p_item_key IN wf_items.item_key%TYPE
2973: ,P_PERSON_NAME IN per_all_people_f.full_name%TYPE

Line 2970: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,

2966:
2967:
2968: PROCEDURE add_notifier(p_notifier_name IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2969: p_notify_onsubmit_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2970: p_notify_onapproval_flag IN OUT NOCOPY hr_util_misc_web.g_varchar2_tab_type,
2971: p_item_type IN wf_items.item_type%TYPE
2972: ,p_item_key IN wf_items.item_key%TYPE
2973: ,P_PERSON_NAME IN per_all_people_f.full_name%TYPE
2974: ,p_person_id IN per_all_people_f.person_id%TYPE

Line 2983: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type

2979: l_dummy VARCHAR2(100) ;
2980: lv_item_name VARCHAR2(100);
2981: l_proc constant varchar2(100) := g_package || ' add_notifier';
2982: -- new variables
2983: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type
2984: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2985: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
2986: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2987: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type

Line 2984: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2980: lv_item_name VARCHAR2(100);
2981: l_proc constant varchar2(100) := g_package || ' add_notifier';
2982: -- new variables
2983: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type
2984: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2985: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
2986: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2987: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
2988: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

Line 2985: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type

2981: l_proc constant varchar2(100) := g_package || ' add_notifier';
2982: -- new variables
2983: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type
2984: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2985: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
2986: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2987: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
2988: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2989: BEGIN

Line 2986: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2982: -- new variables
2983: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type
2984: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2985: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
2986: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2987: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
2988: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2989: BEGIN
2990:

Line 2987: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type

2983: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type
2984: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2985: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
2986: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2987: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
2988: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2989: BEGIN
2990:
2991: hr_utility.set_location('Entering: '|| l_proc,5);

Line 2988: DEFAULT hr_util_misc_web.g_varchar2_tab_default;

2984: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2985: lv_notify_onsubmit_flag hr_util_misc_web.g_varchar2_tab_type
2986: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2987: lv_notify_onapproval_flag hr_util_misc_web.g_varchar2_tab_type
2988: DEFAULT hr_util_misc_web.g_varchar2_tab_default;
2989: BEGIN
2990:
2991: hr_utility.set_location('Entering: '|| l_proc,5);
2992: lv_notifier_name := p_notifier_name;

Line 3022: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,

3018: -- Get all the notifiers for the process
3019: --
3020: --
3021: PROCEDURE Get_all_notifiers(
3022: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
3023: p_notify_onsubmit_flag IN hr_util_misc_web.g_varchar2_tab_type,
3024: p_notify_onapproval_flag IN hr_util_misc_web.g_varchar2_tab_type,
3025: p_item_type IN wf_items.item_type%TYPE,
3026: p_item_key IN wf_items.item_key%TYPE,

Line 3023: p_notify_onsubmit_flag IN hr_util_misc_web.g_varchar2_tab_type,

3019: --
3020: --
3021: PROCEDURE Get_all_notifiers(
3022: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
3023: p_notify_onsubmit_flag IN hr_util_misc_web.g_varchar2_tab_type,
3024: p_notify_onapproval_flag IN hr_util_misc_web.g_varchar2_tab_type,
3025: p_item_type IN wf_items.item_type%TYPE,
3026: p_item_key IN wf_items.item_key%TYPE,
3027: p_effective_date IN DATE

Line 3024: p_notify_onapproval_flag IN hr_util_misc_web.g_varchar2_tab_type,

3020: --
3021: PROCEDURE Get_all_notifiers(
3022: p_notifier_name IN hr_util_misc_web.g_varchar2_tab_type,
3023: p_notify_onsubmit_flag IN hr_util_misc_web.g_varchar2_tab_type,
3024: p_notify_onapproval_flag IN hr_util_misc_web.g_varchar2_tab_type,
3025: p_item_type IN wf_items.item_type%TYPE,
3026: p_item_key IN wf_items.item_key%TYPE,
3027: p_effective_date IN DATE
3028: )

Line 3243: p_Notify_On_Submit hr_util_misc_web.g_varchar2_tab_type DEFAULT

3239: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
3240: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
3241: p_act_id IN NUMBER ,
3242: p_notifiers_num IN NUMBER DEFAULT 0,
3243: p_Notify_On_Submit hr_util_misc_web.g_varchar2_tab_type DEFAULT
3244: hr_util_misc_web.g_varchar2_tab_default,
3245: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT
3246: hr_util_misc_web.g_varchar2_tab_default
3247:

Line 3244: hr_util_misc_web.g_varchar2_tab_default,

3240: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
3241: p_act_id IN NUMBER ,
3242: p_notifiers_num IN NUMBER DEFAULT 0,
3243: p_Notify_On_Submit hr_util_misc_web.g_varchar2_tab_type DEFAULT
3244: hr_util_misc_web.g_varchar2_tab_default,
3245: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT
3246: hr_util_misc_web.g_varchar2_tab_default
3247:
3248: )

Line 3245: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT

3241: p_act_id IN NUMBER ,
3242: p_notifiers_num IN NUMBER DEFAULT 0,
3243: p_Notify_On_Submit hr_util_misc_web.g_varchar2_tab_type DEFAULT
3244: hr_util_misc_web.g_varchar2_tab_default,
3245: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT
3246: hr_util_misc_web.g_varchar2_tab_default
3247:
3248: )
3249: AS

Line 3246: hr_util_misc_web.g_varchar2_tab_default

3242: p_notifiers_num IN NUMBER DEFAULT 0,
3243: p_Notify_On_Submit hr_util_misc_web.g_varchar2_tab_type DEFAULT
3244: hr_util_misc_web.g_varchar2_tab_default,
3245: p_Notify_On_Approval hr_util_misc_web.g_varchar2_tab_type DEFAULT
3246: hr_util_misc_web.g_varchar2_tab_default
3247:
3248: )
3249: AS
3250: -- Local Variables

Line 3329: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type

3325:
3326: PROCEDURE clean_invalid_data( p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
3327: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
3328: p_act_id IN NUMBER ,
3329: p_approvers_name IN hr_util_misc_web.g_varchar2_tab_type
3330: )
3331: AS
3332: -- Local Varaibles
3333: ln_approver_id per_people_f.person_id%TYPE ;

Line 5284: l_approver_name hr_util_misc_web.g_varchar2_tab_type;

5280:
5281: AS
5282:
5283: --local variables
5284: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5285: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5286: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5287: l_default_approver hr_dynamic_approver_ss;
5288: lv_number varchar2(10);

Line 5285: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;

5281: AS
5282:
5283: --local variables
5284: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5285: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5286: l_default_approvers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5287: l_default_approver hr_dynamic_approver_ss;
5288: lv_number varchar2(10);
5289: ln_creator_person_id number;

Line 5401: l_approver_name hr_util_misc_web.g_varchar2_tab_type;

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

Line 5402: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;

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

Line 5506: l_approver_name hr_util_misc_web.g_varchar2_tab_type;

5502:
5503: AS
5504:
5505: --local variables
5506: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5507: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5508: l_additional_notifiers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5509: l_notifier_rec hr_dynamic_approver_ss;
5510: lv_number varchar2(10);

Line 5507: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;

5503: AS
5504:
5505: --local variables
5506: l_approver_name hr_util_misc_web.g_varchar2_tab_type;
5507: l_approver_flag hr_util_misc_web.g_varchar2_tab_type;
5508: l_additional_notifiers_list hr_dynamic_approver_list_ss := hr_dynamic_approver_list_ss();
5509: l_notifier_rec hr_dynamic_approver_ss;
5510: lv_number varchar2(10);
5511: lv_exist VARCHAR2(10) DEFAULT 'N';