1 PACKAGE PAY_US_WORKFLOW_API_PKG AUTHID CURRENT_USER AS
2 /* $Header: payuswfapipkg.pkh 115.3 2004/05/03 11:48:02 jgoswami noship $ */
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
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
94 procedure post_notification_set_attr(itemtype in varchar2,
95 itemkey in varchar2,
96 actid in number,
97 funcmode in varchar2,
98 resultout out nocopy varchar2);
99
100 /*
101 ------------------------------ get_parameter -------------------------------
102 function get_parameter(name in varchar2,
103 parameter_list varchar2) return varchar2;
104 procedure set_attr_value(itemtype in varchar2,
105 itemkey in varchar2,
106 actid in number,
107 funcmode in varchar2,
108 resultout out nocopy varchar2);
109 procedure get_attr_value(itemtype in varchar2,
110 itemkey in varchar2,
111 actid in number,
112 funcmode in varchar2,
113 resultout out nocopy varchar2);
114 */
115
116 /*
117 -- Later Use
118 FUNCTION get_value(
119 wf_item_type in varchar2,
120 wf_item_key in varchar2,
121 attr_name in varchar2
122 ) RETURN VARCHAR2;
123
124 FUNCTION set_value(
125 wf_item_type in varchar2 default 'NO_WF_ITEM',
126 wf_item_key in varchar2,
127 wf_actid in number
128 ) RETURN VARCHAR2;
129 */
130
131 /*
132 Function Get_Batch_Details( arg1 in Varchar2) return Varchar2;
133 */
134
135 PROCEDURE ExecuteConcProgram
136 ( p_itemtype in varchar2
137 , p_itemkey in varchar2
138 , p_actid in number
139 , p_funcmode in varchar2
140 , p_result in out nocopy varchar2
141 );
142
143 PROCEDURE CheckProcessInputs
144 ( p_itemtype in varchar2
145 , p_itemkey in varchar2
146 , p_actid in number
147 , p_funcmode in varchar2
148 , p_result in out nocopy varchar2
149 );
150
151 PROCEDURE IsResponseRequired
152 ( p_itemtype in varchar2
153 , p_itemkey in varchar2
154 , p_actid in number
155 , p_funcmode in varchar2
156 , p_result in out nocopy varchar2
157 );
158
159 end PAY_US_WORKFLOW_API_PKG;
160