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 645: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,

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

Line 646: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,

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

Line 1488: p_item_type in wf_items.item_type%TYPE

1484:
1485:
1486:
1487: PROCEDURE get_wf_attributes (
1488: p_item_type in wf_items.item_type%TYPE
1489: ,p_item_key in wf_items.item_key%TYPE
1490: ,p_actid in number
1491: )
1492: AS

Line 1489: ,p_item_key in wf_items.item_key%TYPE

1485:
1486:
1487: PROCEDURE get_wf_attributes (
1488: p_item_type in wf_items.item_type%TYPE
1489: ,p_item_key in wf_items.item_key%TYPE
1490: ,p_actid in number
1491: )
1492: AS
1493: lv_dynamic_approval_mode VARCHAR2(100) DEFAULT 'HR_DYNA_APPROVAL_ATR';

Line 1573: p_item_type IN wf_items.item_type%TYPE,

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

Line 1574: p_item_key IN wf_items.item_key%TYPE)

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
1577:
1578: --local variables

Line 1724: p_item_type IN wf_items.item_type%TYPE,

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

Line 1725: p_item_key IN wf_items.item_key%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:
1728: AS
1729:

Line 1913: p_item_type IN wf_items.item_type%TYPE,

1909: ||
1910: ||-----------------------------------------------------------------------*/
1911:
1912: PROCEDURE get_default_approvers_list(
1913: p_item_type IN wf_items.item_type%TYPE,
1914: p_item_key IN wf_items.item_key%TYPE,
1915: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss)
1916:
1917: AS

Line 1914: p_item_key IN wf_items.item_key%TYPE,

1910: ||-----------------------------------------------------------------------*/
1911:
1912: PROCEDURE get_default_approvers_list(
1913: p_item_type IN wf_items.item_type%TYPE,
1914: p_item_key IN wf_items.item_key%TYPE,
1915: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss)
1916:
1917: AS
1918:

Line 1982: p_item_type IN wf_items.item_type%TYPE,

1978:
1979:
1980:
1981: PROCEDURE get_default_approvers_list(
1982: p_item_type IN wf_items.item_type%TYPE,
1983: p_item_key IN wf_items.item_key%TYPE,
1984: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss,
1985: p_error_message OUT NOCOPY varchar)
1986:

Line 1983: p_item_key IN wf_items.item_key%TYPE,

1979:
1980:
1981: PROCEDURE get_default_approvers_list(
1982: p_item_type IN wf_items.item_type%TYPE,
1983: p_item_key IN wf_items.item_key%TYPE,
1984: p_default_approvers_list OUT NOCOPY hr_dynamic_approver_list_ss,
1985: p_error_message OUT NOCOPY varchar)
1986:
1987: AS

Line 2064: p_item_type IN wf_items.item_type%TYPE,

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

Line 2065: p_item_key IN wf_items.item_key%TYPE)

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
2068:
2069: --local variables

Line 2294: p_item_type IN wf_items.item_type%TYPE,

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

Line 2295: p_item_key IN wf_items.item_key%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:
2298: AS
2299:

Line 2545: p_item_type IN wf_items.item_type%TYPE,

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

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

Line 2640: p_item_type IN wf_items.item_type%TYPE,

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

Line 2641: p_item_key IN wf_items.item_key%TYPE,

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
2644: -- Local Variables
2645: ln_number_of_approvers NUMBER ;

Line 2717: p_item_type IN wf_items.item_type%TYPE,

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

Line 2718: p_item_key IN wf_items.item_key%TYPE,

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
2721: -- Local Variables
2722: ln_number_of_approvers NUMBER ;

Line 2907: p_item_type IN wf_items.item_type%TYPE,

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

Line 2908: p_item_key IN wf_items.item_key%TYPE,

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

Line 3041: p_item_type IN wf_items.item_type%TYPE

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

Line 3042: ,p_item_key IN wf_items.item_key%TYPE

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
3045: )
3046: AS

Line 3095: p_item_type IN wf_items.item_type%TYPE,

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

Line 3096: p_item_key IN wf_items.item_key%TYPE,

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: )
3099: AS
3100: -- Local Variables

Line 3309: p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,

3305: --
3306:
3307:
3308: PROCEDURE update_notifiers(
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

Line 3310: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,

3306:
3307:
3308: PROCEDURE update_notifiers(
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,

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

3392: -- Flag the invalid data as deleted for the additional approvers
3393: --
3394: --
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: )

Line 3397: p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,

3393: --
3394: --
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

Line 5393: p_item_type IN wf_items.item_type%TYPE,

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

Line 5394: p_item_key IN wf_items.item_key%TYPE,

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

Line 5510: p_item_type IN wf_items.item_type%TYPE,

5506: ||
5507: ||-----------------------------------------------------------------------*/
5508:
5509: PROCEDURE set_ame_approvers_list(
5510: p_item_type IN wf_items.item_type%TYPE,
5511: p_item_key IN wf_items.item_key%TYPE,
5512: p_default_approvers_list IN hr_dynamic_approver_list_ss)
5513:
5514: AS

Line 5511: p_item_key IN wf_items.item_key%TYPE,

5507: ||-----------------------------------------------------------------------*/
5508:
5509: PROCEDURE set_ame_approvers_list(
5510: p_item_type IN wf_items.item_type%TYPE,
5511: p_item_key IN wf_items.item_key%TYPE,
5512: p_default_approvers_list IN hr_dynamic_approver_list_ss)
5513:
5514: AS
5515:

Line 5643: p_item_type IN wf_items.item_type%TYPE,

5639: ||
5640: ||-----------------------------------------------------------------------*/
5641:
5642: PROCEDURE get_additional_notifiers_list(
5643: p_item_type IN wf_items.item_type%TYPE,
5644: p_item_key IN wf_items.item_key%TYPE,
5645: p_additional_notifiers_list OUT NOCOPY hr_dynamic_approver_list_ss)
5646:
5647: AS

Line 5644: p_item_key IN wf_items.item_key%TYPE,

5640: ||-----------------------------------------------------------------------*/
5641:
5642: PROCEDURE get_additional_notifiers_list(
5643: p_item_type IN wf_items.item_type%TYPE,
5644: p_item_key IN wf_items.item_key%TYPE,
5645: p_additional_notifiers_list OUT NOCOPY hr_dynamic_approver_list_ss)
5646:
5647: AS
5648: