1 PACKAGE PAY_US_WORKFLOW_API_PKG AUTHID CURRENT_USER AS
2 /* $Header: payuswfapipkg.pkh 120.1 2011/07/15 10:16:32 rgottipa ship $ */
3 --
4 /*
5 ******************************************************************
6 * *
7 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
8 * Chertsey, England. *
9 * *
10 * All rights reserved. *
11 * *
12 * This material has been provided pursuant to an agreement *
13 * containing restrictions on its use. The material is also *
14 * protected by copyright law. No part of this material may *
15 * be copied or distributed, transmitted or transcribed, in *
16 * any form or by any means, electronic, mechanical, magnetic, *
17 * manual, or otherwise, or disclosed to third parties without *
18 * the express written permission of Oracle Corporation UK Ltd, *
19 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
20 * England. *
21 * *
22 ******************************************************************
23
24 Package Name : PAY_US_WORKFLOW_API_PKG
25 Package File Name : payuswfapipkg.pkh
26 Description : This package is used by Payroll Process Workflow
27
28
29 Change List
30 -----------
31 Date Name Vers Bug No Description
32 ----------- ---------- ----- ------- -----------------------------------
33 08-JUN-2003 jgoswami 115.0 Created.
34 19-JUN-2003 jgoswami 115.1 3006871 Added procedure ExecuteConcProgram,
35 CheckProcessInputs
36 12-APR-2004 JGoswami 115.3 3316422 Added procedure IsResponseRequired
37 15-JUL-2011 rgottipa 115.4 12704242 Added procedure GetRetroEnhancedInfo
38
39 */
40 --
41
42 TYPE attribute_data_rec IS RECORD (
43 wf_item_type wf_items.item_type%TYPE,
44 wf_item_key wf_items.item_key%TYPE,
45 attr_name VARCHAR2(30),
46 attr_value varchar2(30)
47 );
48
49 TYPE cp_rqid_data_rec IS RECORD (
50 wf_item_type wf_items.item_type%TYPE,
51 wf_item_key wf_items.item_key%TYPE,
52 cp_short_name VARCHAR2(30),
53 request_id varchar2(30)
54 );
55
56 TYPE attribute_data_tab IS TABLE OF attribute_data_rec
57 INDEX BY BINARY_INTEGER;
58
59 TYPE cp_rqid_data_tab IS TABLE OF cp_rqid_data_rec
60 INDEX BY BINARY_INTEGER;
61
62 attribute_data_val attribute_data_tab;
63
64 cp_rqid_data_val cp_rqid_data_tab;
65
66 TYPE pay_info_rec IS RECORD
67 ( pay_request_id Varchar2(30) := ' '
68 ,pay_business_group_id varchar2(30) := ' '
69 ,pay_payroll_id varchar2(30) := ' '
70 ,pay_payroll_date_paid varchar2(30) := ' '
71 );
72
73 TYPE pay_info_tab IS TABLE OF pay_info_rec
74 INDEX BY BINARY_INTEGER;
75
76
77 pay_info_val pay_info_tab;
78
79 procedure Get_Assignment_Info(document_id IN Varchar2,
80 display_type IN Varchar2,
81 document IN OUT nocopy Varchar2,
82 document_type IN OUT nocopy Varchar2);
83
84 procedure Get_message_details(document_id IN Varchar2,
85 display_type IN Varchar2,
86 document IN OUT nocopy Varchar2,
87 document_type IN OUT nocopy Varchar2);
88 procedure GetRetroInformation(itemtype in varchar2,
89 itemkey in varchar2,
90 actid in number,
91 funcmode in varchar2,
92 resultout out nocopy varchar2);
93 --bug 12704242
94 procedure GetRetroEnhancedInfo(itemtype in varchar2,
95 itemkey in varchar2,
96 actid in number,
97 funcmode in varchar2,
98 resultout out nocopy varchar2);
99
100 procedure post_notification_set_attr(itemtype in varchar2,
101 itemkey in varchar2,
102 actid in number,
103 funcmode in varchar2,
104 resultout out nocopy varchar2);
105
106 /*
107 ------------------------------ get_parameter -------------------------------
108 function get_parameter(name in varchar2,
109 parameter_list varchar2) return varchar2;
110 procedure set_attr_value(itemtype in varchar2,
111 itemkey in varchar2,
112 actid in number,
113 funcmode in varchar2,
114 resultout out nocopy varchar2);
115 procedure get_attr_value(itemtype in varchar2,
116 itemkey in varchar2,
117 actid in number,
118 funcmode in varchar2,
119 resultout out nocopy varchar2);
120 */
121
122 /*
123 -- Later Use
124 FUNCTION get_value(
125 wf_item_type in varchar2,
126 wf_item_key in varchar2,
127 attr_name in varchar2
128 ) RETURN VARCHAR2;
129
130 FUNCTION set_value(
131 wf_item_type in varchar2 default 'NO_WF_ITEM',
132 wf_item_key in varchar2,
133 wf_actid in number
134 ) RETURN VARCHAR2;
135 */
136
137 /*
138 Function Get_Batch_Details( arg1 in Varchar2) return Varchar2;
139 */
140
141 PROCEDURE ExecuteConcProgram
142 ( p_itemtype in varchar2
143 , p_itemkey in varchar2
144 , p_actid in number
145 , p_funcmode in varchar2
146 , p_result in out nocopy varchar2
147 );
148
149 PROCEDURE CheckProcessInputs
150 ( p_itemtype in varchar2
151 , p_itemkey in varchar2
152 , p_actid in number
153 , p_funcmode in varchar2
154 , p_result in out nocopy varchar2
155 );
156
157 PROCEDURE IsResponseRequired
158 ( p_itemtype in varchar2
159 , p_itemkey in varchar2
160 , p_actid in number
161 , p_funcmode in varchar2
162 , p_result in out nocopy varchar2
163 );
164
165 end PAY_US_WORKFLOW_API_PKG;
166