1 PACKAGE JTF_RS_RESOURCE_WF_PUB AS
2 /* $Header: jtfrswrs.pls 120.0 2005/05/11 08:23:29 appldev ship $ */
3 /*#
4 * Resource Workflow API
5 * @rep:scope private
6 * @rep:product JTF
7 * @rep:displayname Resource Workflow API
8 * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE
9 */
10
11 /* Procedure to start the update resource workflow */
12
13 /*#
14 * Start Update Resource API
15 * @param p_api_version API version
16 * @param p_init_msg_list Initialization of the message list
17 * @param p_commit Commit
18 * @param p_resource_id Resource Identifier
19 * @param p_category Category of the Resource
20 * @param p_resource_number Resource Number
21 * @param p_resource_name Name of the Resource
22 * @param p_address_id Resource address
23 * @param p_source_email Source Email
24 * @param p_source_phone Source Phone
25 * @param p_source_office Source Office
26 * @param p_source_location Source Location
27 * @param p_source_mailstop Source Mailstop
28 * @param p_time_zone Time zone, this value must be a valid time zone as defined in table HZ_TIMEZONES.
29 * @param p_support_site_id Value used by the Service applications.
30 * @param p_primary_language The resource's primary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
31 * @param p_secondary_language The resource's secondary language. This value must be a valid NLS language as defined in table FND_LANGUAGES
32 * @param p_cost_per_hr The salary cost per hour for this resource.
33 * @param p_attribute_access_level Attribute access Level
34 * @param p_object_version_number The object version number of the resource derives from the jtf_rs_resource_extns table.
35 * @param p_wf_process Workflow Process
36 * @param p_wf_item_type Workflow Item Type
37 * @param p_source_mobile_phone Source Mobile Phone
38 * @param p_source_pager Source Pager
39 * @param x_return_status Output parameter for return status
40 * @param x_msg_count Output parameter for number of user messages from this procedure
41 * @param x_msg_data Output parameter containing last user message from this procedure
42 * @rep:scope private
43 * @rep:lifecycle active
44 * @rep:displayname Start Update Resource API
45 */
46 PROCEDURE start_update_resource_wf (
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
49 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
50 p_resource_id IN jtf_rs_resource_extns.resource_id%type,
51 p_category IN jtf_rs_resource_extns.category%type,
52 p_resource_number IN jtf_rs_resource_extns.resource_number%type,
53 p_resource_name IN jtf_rs_resource_extns_vl.resource_name%type default fnd_api.g_miss_char,
54 p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,
55 p_source_email IN jtf_rs_resource_extns.source_email%type default fnd_api.g_miss_char,
56 p_source_phone IN jtf_rs_resource_extns.source_phone%type default fnd_api.g_miss_char,
57 p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,
58 p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
59 p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
60 p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
61 p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
62 p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
63 p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
64 p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,
65 p_attribute_access_level IN jtf_rs_table_attributes_b.attribute_access_level%type,
66 p_object_version_number IN jtf_rs_resource_extns.object_version_number%type,
67 --p_wf_display_name IN VARCHAR2 DEFAULT NULL,
68 p_wf_process IN VARCHAR2 DEFAULT 'EMP_UPDATE_PROCESS',
69 p_wf_item_type IN VARCHAR2 DEFAULT 'EMP_TYPE',
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_source_mobile_phone IN jtf_rs_resource_extns.source_mobile_phone%type default fnd_api.g_miss_char,
74 p_source_pager IN jtf_rs_resource_extns.source_pager%type default fnd_api.g_miss_char
75 );
76
77 /*#
78 * Check Attribute access level API
79 * @param itemtype Item Type
80 * @param itemkey Item Key
81 * @param actid Activity Id
82 * @param funcmode Function Mode
83 * @param resultout Out Parameter for Result
84 * @rep:scope private
85 * @rep:lifecycle active
86 * @rep:displayname Check Attribute access level API
87 */
88 PROCEDURE check_attr_access_level (
89 itemtype IN VARCHAR2,
90 itemkey IN VARCHAR2,
91 actid IN NUMBER,
92 funcmode IN VARCHAR2,
93 resultout OUT NOCOPY VARCHAR2
94 );
95
96 /*#
97 * Call to Resource Update API
98 * @param itemtype Item Type
99 * @param itemkey Item Key
100 * @param actid Activity Id
101 * @param funcmode Function Mode
102 * @param resultout Out Parameter for Result
103 * @rep:scope private
104 * @rep:lifecycle active
105 * @rep:displayname Call Update Resource API
106 */
107 PROCEDURE call_update_resource_api (
108 itemtype IN VARCHAR2,
109 itemkey IN VARCHAR2,
110 actid IN NUMBER,
111 funcmode IN VARCHAR2,
112 resultout OUT NOCOPY VARCHAR2
113 );
114
115 /*#
116 * Check Error Flag API
117 * @param itemtype Item Type
118 * @param itemkey Item Key
119 * @param actid Activity Id
120 * @param funcmode Function Mode
121 * @param resultout Out Parameter for Result
122 * @rep:scope private
123 * @rep:lifecycle active
124 * @rep:displayname Check Error Flag API
125 */
126 PROCEDURE check_error_flag (
127 itemtype IN VARCHAR2,
128 itemkey IN VARCHAR2,
129 actid IN NUMBER,
130 funcmode IN VARCHAR2,
131 resultout OUT NOCOPY VARCHAR2
132 );
133
134 END JTF_RS_RESOURCE_WF_PUB;