1 PACKAGE hxc_timecard_search_pkg AS
2 /* $Header: hxcserch.pkh 120.0 2005/05/29 05:00:28 appldev noship $ */
3 -- get_search_attribute
4 --
5 -- procedure
6 --
7 --
8 -- description
9 -- Wrapper procedure the updates the status of an APPLICATION PERIOD
10 -- building block. Performs a validation to check if the correct
11 -- Time Building Block is being updated. Calls the Workflow to transisition
12 -- to HXC_APP_SET_PERIODS node.
13 -- parameters
14 -- p_flex_search_value - to be searched item
15 -- p_flex_segment - segment of flex
16 -- p_flex_context - context of flex
17 -- p_flex_name - name of flex
18 -- p_application_short_name - short name of application
19 --
20 /*
21 FUNCTION get_search_attribute(
22 p_flex_search_value IN VARCHAR2
23 ,p_flex_segment IN VARCHAR2
24 ,p_flex_context IN VARCHAR2
25 ,p_flex_name IN VARCHAR2
26 ,p_application_short_name IN VARCHAR2
27 ,p_operator IN VARCHAR2
28 ,p_resource_id IN VARCHAR2
29 ,p_field_name IN VARCHAR2
30 )
31 RETURN VARCHAR2;
32 */
33
34
35 PROCEDURE get_sql_where(
36 p_resource_id IN VARCHAR2
37 ,p_search_rows IN VARCHAR2
38 ,p_search_input_string IN VARCHAR2
39 ,p_where OUT NOCOPY VARCHAR2
40 );
41
42 --
43 -- function get_timecard_status_code
44 --
45 --
46 -- description Calculates the status of a timecard after looking
47 -- into the status of application periods within or
48 -- surrounding the timecard.
49 --
50 -- parameters
51 -- bb_id - Building block id of timecard
52 -- bb_ovn - Building block ovn of the timecard
53 --
54 -- returns Status of timecard
55 --
56
57 function get_timecard_status_code(bb_id number, bb_ovn number)
58 return varchar2;
59
60
61 --
62 -- overloaded function get_timecard_status_code
63 --
64 --
65 -- description Calculates the status (Meaning) of a timecard after looking
66 -- into the status of application periods within or
67 -- surrounding the timecard.
68 --
69 -- parameters
70 -- bb_id - Building block id of timecard
71 -- bb_ovn - Building block ovn of the timecard
72 -- p_mode - Migration mode or normal mode.
73 -- - in case of normal mode, the overloaded version
74 -- - given above will be used.
75 --
76 -- returns Status of timecard
77 --
78
79
80 function get_timecard_status_code(bb_id number, bb_ovn number, p_mode varchar2)
81 return varchar2;
82
83
84 --
85 -- function get_timecard_status_meaning
86 --
87 --
88 -- description Calculates the status of a timecard after looking
89 -- into the status of application periods within or
90 -- surrounding the timecard.
91 --
92 -- parameters
93 -- bb_id - Building block id of timecard
94 -- bb_ovn - Building block ovn of the timecard
95 --
96 -- returns Status of timecard
97 --
98
99 FUNCTION get_timecard_status_meaning(bb_id number, bb_ovn number)
100 return varchar2;
101
102
103 -- Start Changes 115.13
104 --
105 -- function get_timecard_cla_status
106 --
107 --
108 -- description Calculates the status of a timecard after looking
109 -- into the associated attributes to find if any
110 -- Change or Late Audit reasons are associated with
111 -- with the timecard.
112 --
113 -- parameters
114 -- bb_id - Building block id of timecard
115 -- bb_ovn - Building block ovn of the timecard
116 --
117 -- returns CLA Status of timecard
118 --
119
120 FUNCTION get_timecard_cla_status(bb_id number, bb_ovn number)
121 return varchar2;
122
123 -- End Changes 115.13
124 /*
125 ==========================================================================
126 This procedure builds a complete sql for advanced search. Java code
127 calls this routine to build the VO.
128 =========================================================================
129 */
130 PROCEDURE get_search_sql(
131 p_resource_id IN VARCHAR2
132 ,p_search_start_time IN VARCHAR2
133 ,p_search_stop_time IN VARCHAR2
134 ,p_search_rows IN VARCHAR2
135 ,p_search_input_string IN VARCHAR2
136 ,p_result OUT NOCOPY VARCHAR2
137 );
138
139 FUNCTION get_attributes(
140 p_search_by IN VARCHAR2
141 ,p_search_value IN VARCHAR2
142 ,p_flex_segment IN VARCHAR2
143 ,p_flex_context IN VARCHAR2
144 ,p_flex_name IN VARCHAR2
145 ,p_application_short_name IN VARCHAR2
146 ,p_operator IN VARCHAR2
147 ,p_resource_id IN VARCHAR2
148 ,p_field_name IN VARCHAR2
149 ,p_user_set IN VARCHAR2 DEFAULT 'Y'
150 ) RETURN VARCHAR2;
151
152 c_no_valueset_attached CONSTANT VARCHAR2(20):= 'NO_VALUESET_ATTACHED';
153
154
155 END hxc_timecard_search_pkg;