APPS.HR_UTIL_MISC_SS dependencies on WF_ACTIVITY_ATTR_VALUES

Line 420: WF_ACTIVITIES a1, WF_ACTIVITIES a2, WF_ACTIVITY_ATTR_VALUES aav

416:
417: CURSOR csr_wf_process (p_wfpname VARCHAR2, p_item_type VARCHAR2) IS
418: SELECT 'N' status
419: FROM WF_PROCESS_ACTIVITIES pa1, WF_PROCESS_ACTIVITIES pa2,
420: WF_ACTIVITIES a1, WF_ACTIVITIES a2, WF_ACTIVITY_ATTR_VALUES aav
421: WHERE pa1.process_item_type = p_item_type
422: and pa1.process_name = p_wfpname
423: and pa1.activity_name = pa2.process_name
424: and a1.name = pa1.process_name

Line 439: WF_ACTIVITY_ATTR_VALUES aav

435: and aav.text_value IN ('HR_TERMINATION_TOP_SS','HR_CWK_TERMINATION_PAGE_SS')
436: UNION
437: SELECT 'N' status
438: FROM WF_ACTIVITIES a, WF_PROCESS_ACTIVITIES pa,
439: WF_ACTIVITY_ATTR_VALUES aav
440: where a.item_type = p_item_type
441: and a.name = p_wfpname
442: and sysdate between a.begin_date and nvl(a.end_date,sysdate)
443: and pa.process_item_type = a.item_type

Line 648: WF_ACTIVITY_ATTR_VALUES aav

644:
645: CURSOR csr_wf_process (p_wfpname VARCHAR2, p_item_type VARCHAR2) IS
646: SELECT 'C' status
647: FROM WF_ACTIVITIES a, WF_PROCESS_ACTIVITIES pa,
648: WF_ACTIVITY_ATTR_VALUES aav
649: where a.item_type = p_item_type
650: and a.name = p_wfpname
651: and sysdate between a.begin_date and nvl(a.end_date,sysdate)
652: and pa.process_item_type = a.item_type

Line 884: l_number_value wf_activity_attr_values.number_value%type;

880: funcmode in varchar2,
881: resultout out nocopy varchar2
882: )
883: IS
884: l_number_value wf_activity_attr_values.number_value%type;
885: l_proc constant varchar2(100) := g_package || ' is_voluntary_termination';
886: dummy varchar2(2) := 'N';
887: l_vol_term varchar2(2) := 'N';
888:

Line 891: FROM WF_ACTIVITY_ATTR_VALUES WAAV

887: l_vol_term varchar2(2) := 'N';
888:
889: cursor csr_attr_value(actid in number, name in varchar2) is
890: SELECT WAAV.TEXT_VALUE Value
891: FROM WF_ACTIVITY_ATTR_VALUES WAAV
892: WHERE WAAV.PROCESS_ACTIVITY_ID = actid
893: AND WAAV.NAME = name;
894:
895: BEGIN

Line 953: l_number_value wf_activity_attr_values.number_value%type;

949: funcmode in varchar2,
950: resultout out nocopy varchar2
951: )
952: IS
953: l_number_value wf_activity_attr_values.number_value%type;
954: l_date_value wf_activity_attr_values.date_value%type;
955: l_proc constant varchar2(100) := g_package || ' is_primary_assign';
956: dummy varchar2(2);
957:

Line 954: l_date_value wf_activity_attr_values.date_value%type;

950: resultout out nocopy varchar2
951: )
952: IS
953: l_number_value wf_activity_attr_values.number_value%type;
954: l_date_value wf_activity_attr_values.date_value%type;
955: l_proc constant varchar2(100) := g_package || ' is_primary_assign';
956: dummy varchar2(2);
957:
958: BEGIN

Line 1037: l_text_value wf_activity_attr_values.text_value%type;

1033: funcmode in varchar2,
1034: resultout out nocopy varchar2
1035: )
1036: IS
1037: l_text_value wf_activity_attr_values.text_value%type;
1038: --local variable
1039: l_proc constant varchar2(100) := g_package || ' is_employee_check';
1040: BEGIN
1041: hr_utility.set_location('Entering: '|| l_proc,5);

Line 2233: l_person_id wf_activity_attr_values.number_value%type;

2229: funcmode in varchar2,
2230: resultout out nocopy varchar2
2231: )
2232: IS
2233: l_person_id wf_activity_attr_values.number_value%type;
2234: l_business_grp_id wf_activity_attr_values.number_value%type;
2235: l_leg_code varchar2(100) := null;
2236: l_transaction_step_id number;
2237:

Line 2234: l_business_grp_id wf_activity_attr_values.number_value%type;

2230: resultout out nocopy varchar2
2231: )
2232: IS
2233: l_person_id wf_activity_attr_values.number_value%type;
2234: l_business_grp_id wf_activity_attr_values.number_value%type;
2235: l_leg_code varchar2(100) := null;
2236: l_transaction_step_id number;
2237:
2238: l_proc constant varchar2(100) := g_package || ' is_us_emp_check';