1 PACKAGE PAY_RECORDED_REQUESTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: pyrecreq.pkh 115.3 2004/08/05 08:25:26 jford noship $ */
3
4 -- ----------------------------------------------------------------------------
5 -- Name: get_recorded_date
6 --
7 -- Description:
8 -- This procedure returns the date that has been recorded against the request
9 -- identified by the attributes.
10 -- If no record exists (no row in table) then a row is created and the default
11 -- hr_api.g_sot is returned.
12 --
13 -- Prerequisites:
14 -- This is a public procedure which allows code as part of the request to access
15 -- a single recorded date which may be required for future processing.
16 --
17 -- In Parameters:
18 -- All column values that identify the row explicitly, eg request type and parameter
19 -- values. The only out parameter is the current date stored against this row.
20 --
21 -- Post Success:
22 -- The specified row's recorded date will be returned.
23 --
24 -- Post Failure:
25 -- Errors are propogated using usual SQL behaviour.
26 -- ----------------------------------------------------------------------------
27
28 procedure get_recorded_date( p_process in varchar2,
29 p_recorded_date out nocopy date,
30 p_attribute1 in varchar2 default null,
31 p_attribute2 in varchar2 default null,
32 p_attribute3 in varchar2 default null,
33 p_attribute4 in varchar2 default null,
34 p_attribute5 in varchar2 default null,
35 p_attribute6 in varchar2 default null,
36 p_attribute7 in varchar2 default null,
37 p_attribute8 in varchar2 default null,
38 p_attribute9 in varchar2 default null,
39 p_attribute10 in varchar2 default null,
40 p_attribute11 in varchar2 default null,
41 p_attribute12 in varchar2 default null,
42 p_attribute13 in varchar2 default null,
43 p_attribute14 in varchar2 default null,
44 p_attribute15 in varchar2 default null,
45 p_attribute16 in varchar2 default null,
46 p_attribute17 in varchar2 default null,
47 p_attribute18 in varchar2 default null,
48 p_attribute19 in varchar2 default null,
49 p_attribute20 in varchar2 default null);
50 -- Variation of above procedure
51 -- pyccutl.pkb has function to get asg_act_status and this needs
52 -- to retrieve a date but without any dml because function is called
53 -- within a view. This is fine because when a true date needs to be
54 -- inserted, set_recorded_date can be called at a suitable juncture
55 --
56 procedure get_recorded_date_no_ins( p_process in varchar2,
57 p_recorded_date out nocopy date ,
58 p_attribute1 in varchar2 default null ,
59 p_attribute2 in varchar2 default null ,
60 p_attribute3 in varchar2 default null ,
61 p_attribute4 in varchar2 default null ,
62 p_attribute5 in varchar2 default null ,
63 p_attribute6 in varchar2 default null ,
64 p_attribute7 in varchar2 default null ,
65 p_attribute8 in varchar2 default null ,
66 p_attribute9 in varchar2 default null ,
67 p_attribute10 in varchar2 default null ,
68 p_attribute11 in varchar2 default null ,
69 p_attribute12 in varchar2 default null ,
70 p_attribute13 in varchar2 default null ,
71 p_attribute14 in varchar2 default null ,
72 p_attribute15 in varchar2 default null ,
73 p_attribute16 in varchar2 default null ,
74 p_attribute17 in varchar2 default null ,
75 p_attribute18 in varchar2 default null ,
76 p_attribute19 in varchar2 default null ,
77 p_attribute20 in varchar2 default null );
78
79 -- ----------------------------------------------------------------------------
80 -- Name: set_recorded_date
81 --
82 -- Description:
83 -- This procedure sets the recorded date against the request
84 -- identified by the attributes.
85 -- If no record exists (no row in table) then a row is created and this new date
86 -- is used.
87 --
88 -- Prerequisites:
89 -- This is a public procedure which allows code as part of the request to set
90 -- a single recorded date which may be required for future processing.
91 --
92 -- In Parameters:
93 -- All column values that identify the row explicitly, eg request type and parameter
94 -- values. Both the old date held for this row, and the new set date are returned.
95 --
96 -- Post Success:
97 -- The specified row's new recorded dates will be returned.
98 --
99 -- Post Failure:
100 -- Errors are propogated using usual SQL behaviour.
101 -- ----------------------------------------------------------------------------
102
103 procedure set_recorded_date(
104 p_process in varchar2,
105 p_recorded_date in date,
106 p_recorded_date_o out nocopy date,
107 p_attribute1 in varchar2 default null,
108 p_attribute2 in varchar2 default null,
109 p_attribute3 in varchar2 default null,
110 p_attribute4 in varchar2 default null,
111 p_attribute5 in varchar2 default null,
112 p_attribute6 in varchar2 default null,
113 p_attribute7 in varchar2 default null,
114 p_attribute8 in varchar2 default null,
115 p_attribute9 in varchar2 default null,
116 p_attribute10 in varchar2 default null,
117 p_attribute11 in varchar2 default null,
118 p_attribute12 in varchar2 default null,
119 p_attribute13 in varchar2 default null,
120 p_attribute14 in varchar2 default null,
121 p_attribute15 in varchar2 default null,
122 p_attribute16 in varchar2 default null,
123 p_attribute17 in varchar2 default null,
124 p_attribute18 in varchar2 default null,
125 p_attribute19 in varchar2 default null,
126 p_attribute20 in varchar2 default null);
127
128 END PAY_RECORDED_REQUESTS_PKG;