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 WF_ITEMS

Line 476: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,

472: -- This procedure will write the additional approvers added to the AME tables.
473: -- ----------------------------------------------------------------------------
474:
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,

Line 477: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,

473: -- ----------------------------------------------------------------------------
474:
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

Line 609: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,

605: -- This procedure will write the approvers and notifiers data to the
606: -- wf_item_attribute_values table and creates other item_attributes if not exist.
607: --
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,

Line 610: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,

606: -- wf_item_attribute_values table and creates other item_attributes if not exist.
607: --
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

Line 1452: p_item_type in wf_items.item_type%TYPE

1448:
1449:
1450:
1451: PROCEDURE get_wf_attributes (
1452: p_item_type in wf_items.item_type%TYPE
1453: ,p_item_key in wf_items.item_key%TYPE
1454: ,p_actid in number
1455: )
1456: AS

Line 1453: ,p_item_key in wf_items.item_key%TYPE

1449:
1450:
1451: PROCEDURE get_wf_attributes (
1452: p_item_type in wf_items.item_type%TYPE
1453: ,p_item_key in wf_items.item_key%TYPE
1454: ,p_actid in number
1455: )
1456: AS
1457: lv_dynamic_approval_mode VARCHAR2(100) DEFAULT 'HR_DYNA_APPROVAL_ATR';

Line 1537: p_item_type IN wf_items.item_type%TYPE,

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
1541:

Line 1538: p_item_key IN wf_items.item_key%TYPE)

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
1541:
1542: --local variables

Line 1675: p_item_type IN wf_items.item_type%TYPE,

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:
1679: AS

Line 1676: p_item_key IN wf_items.item_key%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:
1679: AS
1680:

Line 1852: p_item_type IN wf_items.item_type%TYPE,

1848: ||
1849: ||-----------------------------------------------------------------------*/
1850:
1851: PROCEDURE get_default_approvers_list(
1852: p_item_type IN wf_items.item_type%TYPE,
1853: p_item_key IN wf_items.item_key%TYPE,
1854: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss)
1855:
1856: AS

Line 1853: p_item_key IN wf_items.item_key%TYPE,

1849: ||-----------------------------------------------------------------------*/
1850:
1851: PROCEDURE get_default_approvers_list(
1852: p_item_type IN wf_items.item_type%TYPE,
1853: p_item_key IN wf_items.item_key%TYPE,
1854: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss)
1855:
1856: AS
1857:

Line 1921: p_item_type IN wf_items.item_type%TYPE,

1917:
1918:
1919:
1920: PROCEDURE get_default_approvers_list(
1921: p_item_type IN wf_items.item_type%TYPE,
1922: p_item_key IN wf_items.item_key%TYPE,
1923: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss,
1924: p_error_message OUT NOCOPY varchar)
1925:

Line 1922: p_item_key IN wf_items.item_key%TYPE,

1918:
1919:
1920: PROCEDURE get_default_approvers_list(
1921: p_item_type IN wf_items.item_type%TYPE,
1922: p_item_key IN wf_items.item_key%TYPE,
1923: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss,
1924: p_error_message OUT NOCOPY varchar)
1925:
1926: AS

Line 2003: p_item_type IN wf_items.item_type%TYPE,

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
2007:

Line 2004: p_item_key IN wf_items.item_key%TYPE)

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
2007:
2008: --local variables

Line 2224: p_item_type IN wf_items.item_type%TYPE,

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:
2228: AS

Line 2225: p_item_key IN wf_items.item_key%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:
2228: AS
2229:

Line 2475: p_item_type IN wf_items.item_type%TYPE,

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
2479: ,p_attributes IN VARCHAR2 DEFAULT NULL) RETURN LONG IS

Line 2476: p_item_key IN wf_items.item_key%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
2479: ,p_attributes IN VARCHAR2 DEFAULT NULL) RETURN LONG IS
2480:

Line 2570: p_item_type IN wf_items.item_type%TYPE,

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
2574: -- Local Variables

Line 2571: p_item_key IN wf_items.item_key%TYPE,

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
2574: -- Local Variables
2575: ln_number_of_approvers NUMBER ;

Line 2647: p_item_type IN wf_items.item_type%TYPE,

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
2651: -- Local Variables

Line 2648: p_item_key IN wf_items.item_key%TYPE,

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
2651: -- Local Variables
2652: ln_number_of_approvers NUMBER ;

Line 2837: p_item_type IN wf_items.item_type%TYPE,

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
2841: -- Local Variables

Line 2838: p_item_key IN wf_items.item_key%TYPE,

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
2841: -- Local Variables
2842: lv_notifier_name hr_util_misc_web.g_varchar2_tab_type;

Line 2971: p_item_type IN wf_items.item_type%TYPE

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
2975: )

Line 2972: ,p_item_key IN wf_items.item_key%TYPE

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
2975: )
2976: AS

Line 3025: p_item_type IN wf_items.item_type%TYPE,

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: )
3029: AS

Line 3026: p_item_key IN wf_items.item_key%TYPE,

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

Line 3239: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,

3235: --
3236:
3237:
3238: PROCEDURE update_notifiers(
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

Line 3240: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,

3236:
3237:
3238: PROCEDURE update_notifiers(
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,

Line 3326: PROCEDURE clean_invalid_data( p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,

3322: -- Flag the invalid data as deleted for the additional approvers
3323: --
3324: --
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: )

Line 3327: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,

3323: --
3324: --
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

Line 5277: p_item_type IN wf_items.item_type%TYPE,

5273: ||
5274: ||-----------------------------------------------------------------------*/
5275:
5276: PROCEDURE get_ame_approvers_list(
5277: p_item_type IN wf_items.item_type%TYPE,
5278: p_item_key IN wf_items.item_key%TYPE,
5279: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss)
5280:
5281: AS

Line 5278: p_item_key IN wf_items.item_key%TYPE,

5274: ||-----------------------------------------------------------------------*/
5275:
5276: PROCEDURE get_ame_approvers_list(
5277: p_item_type IN wf_items.item_type%TYPE,
5278: p_item_key IN wf_items.item_key%TYPE,
5279: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss)
5280:
5281: AS
5282:

Line 5394: p_item_type IN wf_items.item_type%TYPE,

5390: ||
5391: ||-----------------------------------------------------------------------*/
5392:
5393: PROCEDURE set_ame_approvers_list(
5394: p_item_type IN wf_items.item_type%TYPE,
5395: p_item_key IN wf_items.item_key%TYPE,
5396: p_default_approvers_list IN hr_dynamic_approver_list_ss)
5397:
5398: AS

Line 5395: p_item_key IN wf_items.item_key%TYPE,

5391: ||-----------------------------------------------------------------------*/
5392:
5393: PROCEDURE set_ame_approvers_list(
5394: p_item_type IN wf_items.item_type%TYPE,
5395: p_item_key IN wf_items.item_key%TYPE,
5396: p_default_approvers_list IN hr_dynamic_approver_list_ss)
5397:
5398: AS
5399:

Line 5499: p_item_type IN wf_items.item_type%TYPE,

5495: ||
5496: ||-----------------------------------------------------------------------*/
5497:
5498: PROCEDURE get_additional_notifiers_list(
5499: p_item_type IN wf_items.item_type%TYPE,
5500: p_item_key IN wf_items.item_key%TYPE,
5501: p_additional_notifiers_list OUT NOCOPY hr_dynamic_approver_list_ss)
5502:
5503: AS

Line 5500: p_item_key IN wf_items.item_key%TYPE,

5496: ||-----------------------------------------------------------------------*/
5497:
5498: PROCEDURE get_additional_notifiers_list(
5499: p_item_type IN wf_items.item_type%TYPE,
5500: p_item_key IN wf_items.item_key%TYPE,
5501: p_additional_notifiers_list OUT NOCOPY hr_dynamic_approver_list_ss)
5502:
5503: AS
5504: