1 PACKAGE AP_WEB_CC_VALIDATION_WF_PKG AUTHID CURRENT_USER as
2 /* $Header: apwfvals.pls 115.2 2004/01/05 22:02:57 kmizuta noship $ */
3
4 --
5 -- Raises the Workflow business event
6 -- oracle.apps.ap.oie.creditcard.transaction.error
7 function raise_validation_event(p_request_id in number default null,
8 p_card_program_id in number default null,
9 p_start_date in date default null,
10 p_end_date in date default null) return number;
11
12 /*
13 --
14 -- Counts the number of invalid credit card transactions
15 -- for the give Request ID, Card Program ID, and start/end dates
16 procedure count_invalid(itemtype in varchar2,
17 itemkey in varchar2,
18 actid in number,
19 funcmode in varchar2,
20 resultout out nocopy varchar2);
21 */
22
23 --
24 -- Returns the URL for the Credit Card Transactions page
25 procedure get_search_page_url(itemtype in varchar2,
26 itemkey in varchar2,
27 actid in number,
28 funcmode in varchar2,
29 resultout out nocopy varchar2);
30
31 --
32 -- Raises the Workflow business event
33 -- oracle.apps.ap.oie.creditcard.account.create
34 function raise_new_cc_event(p_request_id in number default null,
35 p_card_program_id in number default null,
36 p_start_date in date default null,
37 p_end_date in date default null)
38 return number;
39
40 --
41 -- Find employee matches
42 procedure card_employee_match(itemtype in varchar2,
43 itemkey in varchar2,
44 actid in number,
45 funcmode in varchar2,
46 resultout out nocopy varchar2);
47
48 --
49 -- Assigns employees to credit cards if only one employee
50 -- candidate was found - thereby activating the credit card.
51 procedure assign_emp_if_unique(itemtype in varchar2,
52 itemkey in varchar2,
53 actid in number,
54 funcmode in varchar2,
55 resultout out nocopy varchar2);
56
57 --
58 -- Checks to see if new credit cards were created by
59 -- a given request id
60 procedure new_cards_exist(itemtype in varchar2,
61 itemkey in varchar2,
62 actid in number,
63 funcmode in varchar2,
64 resultout out nocopy varchar2);
65
66 --
67 -- Checks to see if inactive credit cards were created by
68 -- a given request id
69 procedure inactive_cards_exist(itemtype in varchar2,
70 itemkey in varchar2,
71 actid in number,
72 funcmode in varchar2,
73 resultout out nocopy varchar2);
74
75 --
76 -- Checks to see if invalid credit card trx were created by
77 -- a given request id
78 procedure invalid_cctrx_exist(itemtype in varchar2,
79 itemkey in varchar2,
80 actid in number,
81 funcmode in varchar2,
82 resultout out nocopy varchar2);
83
84 --
85 -- Counts the number of new credit cards that were created by
86 -- a given Request ID
87 procedure count_new_cards(itemtype in varchar2,
88 itemkey in varchar2,
89 actid in number,
90 funcmode in varchar2,
91 resultout out nocopy varchar2);
92
93 --
94 -- Returns the URL to the New Card Search page.
95 procedure get_new_card_page_url(itemtype in varchar2,
96 itemkey in varchar2,
97 actid in number,
98 funcmode in varchar2,
99 resultout out nocopy varchar2);
100
101 --
102 -- Returns the name of the user who initiated the workflow.
103 -- If the workflow is initiated through by a concurrent program,
104 -- the current user would be the user who initiated the
105 -- concurrent program.
106 procedure whoami(itemtype in varchar2,
107 itemkey in varchar2,
108 actid in number,
109 funcmode in varchar2,
110 resultout out nocopy varchar2);
111
112 --
113 -- Returns the name of the system administrator role for
114 -- the card program.
115 procedure get_card_sysadmin(itemtype in varchar2,
116 itemkey in varchar2,
117 actid in number,
118 funcmode in varchar2,
119 resultout out nocopy varchar2);
120
121 --
122 -- Returns the name of the Card Program
123 procedure get_card_program_name(itemtype in varchar2,
124 itemkey in varchar2,
125 actid in number,
126 funcmode in varchar2,
127 resultout out nocopy varchar2);
128
129 --
130 -- Returns the value of RETURN_ATTRIBUTE_NAME
131 procedure get_attribute_value(itemtype in varchar2,
132 itemkey in varchar2,
133 actid in number,
134 funcmode in varchar2,
135 resultout out nocopy varchar2);
136
137 --
138 -- Returns the activity value of RETURN_ATTRIBUTE_NAME
139 procedure get_act_attribute_value(itemtype in varchar2,
140 itemkey in varchar2,
141 actid in number,
142 funcmode in varchar2,
143 resultout out nocopy varchar2);
144
145
146 PROCEDURE get_instructions(itemtype in varchar2,
147 itemkey in varchar2,
148 actid in number,
149 funcmode in varchar2,
150 resultout out nocopy varchar2);
151 end ap_web_cc_validation_wf_pkg;