[Home] [Help]
PACKAGE: APPS.HR_MEE_WORKFLOW_SERVICE
Source
1 PACKAGE hr_mee_workflow_service AUTHID CURRENT_USER as
2 /* $Header: hrmeewfw.pkh 120.1 2005/09/23 15:02:20 svittal noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< get_activity_name >-----------------------------|
6 -- ----------------------------------------------------------------------------
7 procedure get_activity_name
8 (p_item_type in wf_items.item_type%type
9 ,p_item_key in wf_items.item_key%type
10 ,p_actid in number
11 ,p_activity_name out nocopy varchar2
12 ,p_activity_display_name out nocopy varchar2);
13 --
14
15 -- ----------------------------------------------------------------------------
16 -- |-----------------------------< get_web_page_code >------------------------|
17 -- ----------------------------------------------------------------------------
18 function get_web_page_code
19 (p_item_type in wf_items.item_type%type
20 ,p_item_key in wf_items.item_key%type
21 ,p_actid in wf_activity_attr_values.process_activity_id%type
22 ,p_web_page_section_code in wf_activity_attributes.name%type)
23 return varchar2;
24
25
26 -- ----------------------------------------------------------------------------
27 -- |-------------------------< check_web_page_code >--------------------------|
28 -- ----------------------------------------------------------------------------
29 function check_web_page_code
30 (p_item_type in wf_items.item_type%type
31 ,p_item_key in wf_items.item_key%type
32 ,p_actid in wf_activity_attr_values.process_activity_id%type
33 ,p_web_page_section_code in wf_activity_attributes.name%type)
34 return boolean;
35 -- ---------------------------------------------------------------------------
36 -- |----------------------< get_assignment_details >------------------------|
37 -- --------------------------------------------------------------------------
38 -- This procedure returns assignment and effective date from the wf attribute
39 --
40 PROCEDURE get_assignment_details(
41 p_item_type IN wf_items.item_type%type
42 ,p_item_key IN wf_items.item_key%type
43 ,p_assignment_id OUT NOCOPY NUMBER
44 ,p_effective_date OUT NOCOPY DATE) ;
45
46 -- ----------------------------------------------------------------------------
47 -- |-------------------------< get_act_attr_expanded_info >------------------|
48 -- ----------------------------------------------------------------------------
49 procedure get_act_attr_expanded_info
50 (p_item_type in wf_items.item_type%type
51 ,p_item_key in wf_items.item_key%type
52 ,p_actid in wf_activity_attr_values.process_activity_id%type
53 ,p_name in wf_activity_attributes.name%type
54 ,p_exists out nocopy boolean
55 ,p_subtype out nocopy wf_activity_attributes.subtype%type
56 ,p_type out nocopy wf_activity_attributes.type%type
57 ,p_format out nocopy wf_activity_attributes.format%type
58 ,p_date_value out nocopy wf_activity_attr_values.date_value%type
59 ,p_number_value out nocopy wf_activity_attr_values.number_value%type
60 ,p_text_value out nocopy wf_activity_attr_values.text_value%type);
61 END hr_mee_workflow_service;
62