eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_EXT_TIMECARD dependencies on HXC_EXT_TIMECARD

Line 1: Package Body hxc_ext_timecard as

1: Package Body hxc_ext_timecard as
2: /* $Header: hxcxtime.pkb 120.3 2005/10/05 16:52 jdupont noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Public Global Definitions |

Line 130: hxc_ext_timecard.OTL_TC_START_DATE := NULL;

126: l_proc := g_package||'summary_globals';
127: hr_utility.set_location('Entering '||l_proc, 10);
128: end if;
129:
130: hxc_ext_timecard.OTL_TC_START_DATE := NULL;
131: hxc_ext_timecard.OTL_TC_END_DATE := NULL;
132: hxc_ext_timecard.OTL_TC_STATUS := NULL;
133: hxc_ext_timecard.OTL_TC_COMMENTS := NULL;
134: hxc_ext_timecard.OTL_TC_DELTED := NULL;

Line 131: hxc_ext_timecard.OTL_TC_END_DATE := NULL;

127: hr_utility.set_location('Entering '||l_proc, 10);
128: end if;
129:
130: hxc_ext_timecard.OTL_TC_START_DATE := NULL;
131: hxc_ext_timecard.OTL_TC_END_DATE := NULL;
132: hxc_ext_timecard.OTL_TC_STATUS := NULL;
133: hxc_ext_timecard.OTL_TC_COMMENTS := NULL;
134: hxc_ext_timecard.OTL_TC_DELTED := NULL;
135:

Line 132: hxc_ext_timecard.OTL_TC_STATUS := NULL;

128: end if;
129:
130: hxc_ext_timecard.OTL_TC_START_DATE := NULL;
131: hxc_ext_timecard.OTL_TC_END_DATE := NULL;
132: hxc_ext_timecard.OTL_TC_STATUS := NULL;
133: hxc_ext_timecard.OTL_TC_COMMENTS := NULL;
134: hxc_ext_timecard.OTL_TC_DELTED := NULL;
135:
136: if g_debug then

Line 133: hxc_ext_timecard.OTL_TC_COMMENTS := NULL;

129:
130: hxc_ext_timecard.OTL_TC_START_DATE := NULL;
131: hxc_ext_timecard.OTL_TC_END_DATE := NULL;
132: hxc_ext_timecard.OTL_TC_STATUS := NULL;
133: hxc_ext_timecard.OTL_TC_COMMENTS := NULL;
134: hxc_ext_timecard.OTL_TC_DELTED := NULL;
135:
136: if g_debug then
137: hr_utility.set_location('Leaving '||l_proc, 20);

Line 134: hxc_ext_timecard.OTL_TC_DELTED := NULL;

130: hxc_ext_timecard.OTL_TC_START_DATE := NULL;
131: hxc_ext_timecard.OTL_TC_END_DATE := NULL;
132: hxc_ext_timecard.OTL_TC_STATUS := NULL;
133: hxc_ext_timecard.OTL_TC_COMMENTS := NULL;
134: hxc_ext_timecard.OTL_TC_DELTED := NULL;
135:
136: if g_debug then
137: hr_utility.set_location('Leaving '||l_proc, 20);
138: end if;

Line 153: hxc_ext_timecard.OTL_TC_START_DATE := p_summary_rec.start_time;

149: l_proc := g_package||'populate_summary';
150: hr_utility.set_location('Entering '||l_proc, 10);
151: end if;
152:
153: hxc_ext_timecard.OTL_TC_START_DATE := p_summary_rec.start_time;
154: hxc_ext_timecard.OTL_TC_END_DATE := p_summary_rec.stop_time;
155: hxc_ext_timecard.OTL_TC_STATUS := p_summary_rec.approval_status;
156: hxc_ext_timecard.OTL_TC_COMMENTS := p_summary_rec.comments;
157: hxc_ext_timecard.OTL_TC_DELTED := p_summary_rec.deleted;

Line 154: hxc_ext_timecard.OTL_TC_END_DATE := p_summary_rec.stop_time;

150: hr_utility.set_location('Entering '||l_proc, 10);
151: end if;
152:
153: hxc_ext_timecard.OTL_TC_START_DATE := p_summary_rec.start_time;
154: hxc_ext_timecard.OTL_TC_END_DATE := p_summary_rec.stop_time;
155: hxc_ext_timecard.OTL_TC_STATUS := p_summary_rec.approval_status;
156: hxc_ext_timecard.OTL_TC_COMMENTS := p_summary_rec.comments;
157: hxc_ext_timecard.OTL_TC_DELTED := p_summary_rec.deleted;
158:

Line 155: hxc_ext_timecard.OTL_TC_STATUS := p_summary_rec.approval_status;

151: end if;
152:
153: hxc_ext_timecard.OTL_TC_START_DATE := p_summary_rec.start_time;
154: hxc_ext_timecard.OTL_TC_END_DATE := p_summary_rec.stop_time;
155: hxc_ext_timecard.OTL_TC_STATUS := p_summary_rec.approval_status;
156: hxc_ext_timecard.OTL_TC_COMMENTS := p_summary_rec.comments;
157: hxc_ext_timecard.OTL_TC_DELTED := p_summary_rec.deleted;
158:
159: if g_debug then

Line 156: hxc_ext_timecard.OTL_TC_COMMENTS := p_summary_rec.comments;

152:
153: hxc_ext_timecard.OTL_TC_START_DATE := p_summary_rec.start_time;
154: hxc_ext_timecard.OTL_TC_END_DATE := p_summary_rec.stop_time;
155: hxc_ext_timecard.OTL_TC_STATUS := p_summary_rec.approval_status;
156: hxc_ext_timecard.OTL_TC_COMMENTS := p_summary_rec.comments;
157: hxc_ext_timecard.OTL_TC_DELTED := p_summary_rec.deleted;
158:
159: if g_debug then
160: hr_utility.set_location('Leaving '||l_proc, 20);

Line 157: hxc_ext_timecard.OTL_TC_DELTED := p_summary_rec.deleted;

153: hxc_ext_timecard.OTL_TC_START_DATE := p_summary_rec.start_time;
154: hxc_ext_timecard.OTL_TC_END_DATE := p_summary_rec.stop_time;
155: hxc_ext_timecard.OTL_TC_STATUS := p_summary_rec.approval_status;
156: hxc_ext_timecard.OTL_TC_COMMENTS := p_summary_rec.comments;
157: hxc_ext_timecard.OTL_TC_DELTED := p_summary_rec.deleted;
158:
159: if g_debug then
160: hr_utility.set_location('Leaving '||l_proc, 20);
161: end if;

Line 182: hxc_ext_timecard.OTL_DAY := NULL;

178: l_exp_typ_id := NULL;
179: l_element_type_id := NULL;
180: l_po_num := NULL;
181:
182: hxc_ext_timecard.OTL_DAY := NULL;
183: hxc_ext_timecard.OTL_DAY_COMMENTS := NULL;
184:
185: hxc_ext_timecard.OTL_MEASURE := NULL;
186: hxc_ext_timecard.OTL_DAY_START := NULL;

Line 183: hxc_ext_timecard.OTL_DAY_COMMENTS := NULL;

179: l_element_type_id := NULL;
180: l_po_num := NULL;
181:
182: hxc_ext_timecard.OTL_DAY := NULL;
183: hxc_ext_timecard.OTL_DAY_COMMENTS := NULL;
184:
185: hxc_ext_timecard.OTL_MEASURE := NULL;
186: hxc_ext_timecard.OTL_DAY_START := NULL;
187: hxc_ext_timecard.OTL_DAY_STOP := NULL;

Line 185: hxc_ext_timecard.OTL_MEASURE := NULL;

181:
182: hxc_ext_timecard.OTL_DAY := NULL;
183: hxc_ext_timecard.OTL_DAY_COMMENTS := NULL;
184:
185: hxc_ext_timecard.OTL_MEASURE := NULL;
186: hxc_ext_timecard.OTL_DAY_START := NULL;
187: hxc_ext_timecard.OTL_DAY_STOP := NULL;
188: hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN := NULL;
189: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := NULL;

Line 186: hxc_ext_timecard.OTL_DAY_START := NULL;

182: hxc_ext_timecard.OTL_DAY := NULL;
183: hxc_ext_timecard.OTL_DAY_COMMENTS := NULL;
184:
185: hxc_ext_timecard.OTL_MEASURE := NULL;
186: hxc_ext_timecard.OTL_DAY_START := NULL;
187: hxc_ext_timecard.OTL_DAY_STOP := NULL;
188: hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN := NULL;
189: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := NULL;
190: hxc_ext_timecard.OTL_PA_TASK := NULL;

Line 187: hxc_ext_timecard.OTL_DAY_STOP := NULL;

183: hxc_ext_timecard.OTL_DAY_COMMENTS := NULL;
184:
185: hxc_ext_timecard.OTL_MEASURE := NULL;
186: hxc_ext_timecard.OTL_DAY_START := NULL;
187: hxc_ext_timecard.OTL_DAY_STOP := NULL;
188: hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN := NULL;
189: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := NULL;
190: hxc_ext_timecard.OTL_PA_TASK := NULL;
191: hxc_ext_timecard.OTL_PA_PROJECT := NULL;

Line 188: hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN := NULL;

184:
185: hxc_ext_timecard.OTL_MEASURE := NULL;
186: hxc_ext_timecard.OTL_DAY_START := NULL;
187: hxc_ext_timecard.OTL_DAY_STOP := NULL;
188: hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN := NULL;
189: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := NULL;
190: hxc_ext_timecard.OTL_PA_TASK := NULL;
191: hxc_ext_timecard.OTL_PA_PROJECT := NULL;
192: hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE := NULL;

Line 189: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := NULL;

185: hxc_ext_timecard.OTL_MEASURE := NULL;
186: hxc_ext_timecard.OTL_DAY_START := NULL;
187: hxc_ext_timecard.OTL_DAY_STOP := NULL;
188: hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN := NULL;
189: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := NULL;
190: hxc_ext_timecard.OTL_PA_TASK := NULL;
191: hxc_ext_timecard.OTL_PA_PROJECT := NULL;
192: hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE := NULL;
193: hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT:= NULL;

Line 190: hxc_ext_timecard.OTL_PA_TASK := NULL;

186: hxc_ext_timecard.OTL_DAY_START := NULL;
187: hxc_ext_timecard.OTL_DAY_STOP := NULL;
188: hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN := NULL;
189: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := NULL;
190: hxc_ext_timecard.OTL_PA_TASK := NULL;
191: hxc_ext_timecard.OTL_PA_PROJECT := NULL;
192: hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE := NULL;
193: hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT:= NULL;
194: hxc_ext_timecard.OTL_PAY_ELEMENT_NAME := NULL;

Line 191: hxc_ext_timecard.OTL_PA_PROJECT := NULL;

187: hxc_ext_timecard.OTL_DAY_STOP := NULL;
188: hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN := NULL;
189: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := NULL;
190: hxc_ext_timecard.OTL_PA_TASK := NULL;
191: hxc_ext_timecard.OTL_PA_PROJECT := NULL;
192: hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE := NULL;
193: hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT:= NULL;
194: hxc_ext_timecard.OTL_PAY_ELEMENT_NAME := NULL;
195: hxc_ext_timecard.OTL_PAY_COST_CENTRE := NULL;

Line 192: hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE := NULL;

188: hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN := NULL;
189: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := NULL;
190: hxc_ext_timecard.OTL_PA_TASK := NULL;
191: hxc_ext_timecard.OTL_PA_PROJECT := NULL;
192: hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE := NULL;
193: hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT:= NULL;
194: hxc_ext_timecard.OTL_PAY_ELEMENT_NAME := NULL;
195: hxc_ext_timecard.OTL_PAY_COST_CENTRE := NULL;
196: hxc_ext_timecard.OTL_PO_NUMBER := NULL;

Line 193: hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT:= NULL;

189: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := NULL;
190: hxc_ext_timecard.OTL_PA_TASK := NULL;
191: hxc_ext_timecard.OTL_PA_PROJECT := NULL;
192: hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE := NULL;
193: hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT:= NULL;
194: hxc_ext_timecard.OTL_PAY_ELEMENT_NAME := NULL;
195: hxc_ext_timecard.OTL_PAY_COST_CENTRE := NULL;
196: hxc_ext_timecard.OTL_PO_NUMBER := NULL;
197: hxc_ext_timecard.OTL_PO_LINE_ID := NULL;

Line 194: hxc_ext_timecard.OTL_PAY_ELEMENT_NAME := NULL;

190: hxc_ext_timecard.OTL_PA_TASK := NULL;
191: hxc_ext_timecard.OTL_PA_PROJECT := NULL;
192: hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE := NULL;
193: hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT:= NULL;
194: hxc_ext_timecard.OTL_PAY_ELEMENT_NAME := NULL;
195: hxc_ext_timecard.OTL_PAY_COST_CENTRE := NULL;
196: hxc_ext_timecard.OTL_PO_NUMBER := NULL;
197: hxc_ext_timecard.OTL_PO_LINE_ID := NULL;
198: hxc_ext_timecard.OTL_PO_PRICE_TYPE := NULL;

Line 195: hxc_ext_timecard.OTL_PAY_COST_CENTRE := NULL;

191: hxc_ext_timecard.OTL_PA_PROJECT := NULL;
192: hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE := NULL;
193: hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT:= NULL;
194: hxc_ext_timecard.OTL_PAY_ELEMENT_NAME := NULL;
195: hxc_ext_timecard.OTL_PAY_COST_CENTRE := NULL;
196: hxc_ext_timecard.OTL_PO_NUMBER := NULL;
197: hxc_ext_timecard.OTL_PO_LINE_ID := NULL;
198: hxc_ext_timecard.OTL_PO_PRICE_TYPE := NULL;
199: hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF := NULL;

Line 196: hxc_ext_timecard.OTL_PO_NUMBER := NULL;

192: hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE := NULL;
193: hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT:= NULL;
194: hxc_ext_timecard.OTL_PAY_ELEMENT_NAME := NULL;
195: hxc_ext_timecard.OTL_PAY_COST_CENTRE := NULL;
196: hxc_ext_timecard.OTL_PO_NUMBER := NULL;
197: hxc_ext_timecard.OTL_PO_LINE_ID := NULL;
198: hxc_ext_timecard.OTL_PO_PRICE_TYPE := NULL;
199: hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF := NULL;
200: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS := NULL;

Line 197: hxc_ext_timecard.OTL_PO_LINE_ID := NULL;

193: hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT:= NULL;
194: hxc_ext_timecard.OTL_PAY_ELEMENT_NAME := NULL;
195: hxc_ext_timecard.OTL_PAY_COST_CENTRE := NULL;
196: hxc_ext_timecard.OTL_PO_NUMBER := NULL;
197: hxc_ext_timecard.OTL_PO_LINE_ID := NULL;
198: hxc_ext_timecard.OTL_PO_PRICE_TYPE := NULL;
199: hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF := NULL;
200: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS := NULL;
201: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES := NULL;

Line 198: hxc_ext_timecard.OTL_PO_PRICE_TYPE := NULL;

194: hxc_ext_timecard.OTL_PAY_ELEMENT_NAME := NULL;
195: hxc_ext_timecard.OTL_PAY_COST_CENTRE := NULL;
196: hxc_ext_timecard.OTL_PO_NUMBER := NULL;
197: hxc_ext_timecard.OTL_PO_LINE_ID := NULL;
198: hxc_ext_timecard.OTL_PO_PRICE_TYPE := NULL;
199: hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF := NULL;
200: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS := NULL;
201: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES := NULL;
202: hxc_ext_timecard.OTL_ALIAS_LOCATIONS := NULL;

Line 199: hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF := NULL;

195: hxc_ext_timecard.OTL_PAY_COST_CENTRE := NULL;
196: hxc_ext_timecard.OTL_PO_NUMBER := NULL;
197: hxc_ext_timecard.OTL_PO_LINE_ID := NULL;
198: hxc_ext_timecard.OTL_PO_PRICE_TYPE := NULL;
199: hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF := NULL;
200: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS := NULL;
201: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES := NULL;
202: hxc_ext_timecard.OTL_ALIAS_LOCATIONS := NULL;
203: hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS := NULL;

Line 200: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS := NULL;

196: hxc_ext_timecard.OTL_PO_NUMBER := NULL;
197: hxc_ext_timecard.OTL_PO_LINE_ID := NULL;
198: hxc_ext_timecard.OTL_PO_PRICE_TYPE := NULL;
199: hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF := NULL;
200: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS := NULL;
201: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES := NULL;
202: hxc_ext_timecard.OTL_ALIAS_LOCATIONS := NULL;
203: hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS := NULL;
204: hxc_ext_timecard.OTL_ALIAS_PROJECTS := NULL;

Line 201: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES := NULL;

197: hxc_ext_timecard.OTL_PO_LINE_ID := NULL;
198: hxc_ext_timecard.OTL_PO_PRICE_TYPE := NULL;
199: hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF := NULL;
200: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS := NULL;
201: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES := NULL;
202: hxc_ext_timecard.OTL_ALIAS_LOCATIONS := NULL;
203: hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS := NULL;
204: hxc_ext_timecard.OTL_ALIAS_PROJECTS := NULL;
205: hxc_ext_timecard.OTL_ALIAS_TASKS := NULL;

Line 202: hxc_ext_timecard.OTL_ALIAS_LOCATIONS := NULL;

198: hxc_ext_timecard.OTL_PO_PRICE_TYPE := NULL;
199: hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF := NULL;
200: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS := NULL;
201: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES := NULL;
202: hxc_ext_timecard.OTL_ALIAS_LOCATIONS := NULL;
203: hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS := NULL;
204: hxc_ext_timecard.OTL_ALIAS_PROJECTS := NULL;
205: hxc_ext_timecard.OTL_ALIAS_TASKS := NULL;
206: hxc_ext_timecard.OTL_ALIAS_RATE_TYPE_EXP_SLF := NULL;

Line 203: hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS := NULL;

199: hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF := NULL;
200: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS := NULL;
201: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES := NULL;
202: hxc_ext_timecard.OTL_ALIAS_LOCATIONS := NULL;
203: hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS := NULL;
204: hxc_ext_timecard.OTL_ALIAS_PROJECTS := NULL;
205: hxc_ext_timecard.OTL_ALIAS_TASKS := NULL;
206: hxc_ext_timecard.OTL_ALIAS_RATE_TYPE_EXP_SLF := NULL;
207:

Line 204: hxc_ext_timecard.OTL_ALIAS_PROJECTS := NULL;

200: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS := NULL;
201: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES := NULL;
202: hxc_ext_timecard.OTL_ALIAS_LOCATIONS := NULL;
203: hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS := NULL;
204: hxc_ext_timecard.OTL_ALIAS_PROJECTS := NULL;
205: hxc_ext_timecard.OTL_ALIAS_TASKS := NULL;
206: hxc_ext_timecard.OTL_ALIAS_RATE_TYPE_EXP_SLF := NULL;
207:
208: if g_debug then

Line 205: hxc_ext_timecard.OTL_ALIAS_TASKS := NULL;

201: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES := NULL;
202: hxc_ext_timecard.OTL_ALIAS_LOCATIONS := NULL;
203: hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS := NULL;
204: hxc_ext_timecard.OTL_ALIAS_PROJECTS := NULL;
205: hxc_ext_timecard.OTL_ALIAS_TASKS := NULL;
206: hxc_ext_timecard.OTL_ALIAS_RATE_TYPE_EXP_SLF := NULL;
207:
208: if g_debug then
209: hr_utility.set_location('Leaving '||l_proc, 20);

Line 206: hxc_ext_timecard.OTL_ALIAS_RATE_TYPE_EXP_SLF := NULL;

202: hxc_ext_timecard.OTL_ALIAS_LOCATIONS := NULL;
203: hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS := NULL;
204: hxc_ext_timecard.OTL_ALIAS_PROJECTS := NULL;
205: hxc_ext_timecard.OTL_ALIAS_TASKS := NULL;
206: hxc_ext_timecard.OTL_ALIAS_RATE_TYPE_EXP_SLF := NULL;
207:
208: if g_debug then
209: hr_utility.set_location('Leaving '||l_proc, 20);
210: end if;

Line 255: hxc_ext_timecard.OTL_DAY := p_detail_rec.day_start_time;

251: l_proc := g_package||'populate_details';
252: hr_utility.set_location('Entering '||l_proc, 10);
253: end if;
254:
255: hxc_ext_timecard.OTL_DAY := p_detail_rec.day_start_time;
256: hxc_ext_timecard.OTL_DAY_COMMENTS := p_detail_rec.comments;
257:
258: hxc_ext_timecard.OTL_MEASURE := p_detail_rec.measure;
259: hxc_ext_timecard.OTL_DAY_START := p_detail_rec.start_time;

Line 256: hxc_ext_timecard.OTL_DAY_COMMENTS := p_detail_rec.comments;

252: hr_utility.set_location('Entering '||l_proc, 10);
253: end if;
254:
255: hxc_ext_timecard.OTL_DAY := p_detail_rec.day_start_time;
256: hxc_ext_timecard.OTL_DAY_COMMENTS := p_detail_rec.comments;
257:
258: hxc_ext_timecard.OTL_MEASURE := p_detail_rec.measure;
259: hxc_ext_timecard.OTL_DAY_START := p_detail_rec.start_time;
260: hxc_ext_timecard.OTL_DAY_STOP := p_detail_rec.stop_time;

Line 258: hxc_ext_timecard.OTL_MEASURE := p_detail_rec.measure;

254:
255: hxc_ext_timecard.OTL_DAY := p_detail_rec.day_start_time;
256: hxc_ext_timecard.OTL_DAY_COMMENTS := p_detail_rec.comments;
257:
258: hxc_ext_timecard.OTL_MEASURE := p_detail_rec.measure;
259: hxc_ext_timecard.OTL_DAY_START := p_detail_rec.start_time;
260: hxc_ext_timecard.OTL_DAY_STOP := p_detail_rec.stop_time;
261:
262: IF ( p_detail_rec.attribute_category = 'PROJECTS' )

Line 259: hxc_ext_timecard.OTL_DAY_START := p_detail_rec.start_time;

255: hxc_ext_timecard.OTL_DAY := p_detail_rec.day_start_time;
256: hxc_ext_timecard.OTL_DAY_COMMENTS := p_detail_rec.comments;
257:
258: hxc_ext_timecard.OTL_MEASURE := p_detail_rec.measure;
259: hxc_ext_timecard.OTL_DAY_START := p_detail_rec.start_time;
260: hxc_ext_timecard.OTL_DAY_STOP := p_detail_rec.stop_time;
261:
262: IF ( p_detail_rec.attribute_category = 'PROJECTS' )
263: THEN

Line 260: hxc_ext_timecard.OTL_DAY_STOP := p_detail_rec.stop_time;

256: hxc_ext_timecard.OTL_DAY_COMMENTS := p_detail_rec.comments;
257:
258: hxc_ext_timecard.OTL_MEASURE := p_detail_rec.measure;
259: hxc_ext_timecard.OTL_DAY_START := p_detail_rec.start_time;
260: hxc_ext_timecard.OTL_DAY_STOP := p_detail_rec.stop_time;
261:
262: IF ( p_detail_rec.attribute_category = 'PROJECTS' )
263: THEN
264:

Line 269: hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN := p_detail_rec.attribute5;

265: if g_debug then
266: hr_utility.set_location('Processing '||l_proc, 20);
267: end if;
268:
269: hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN := p_detail_rec.attribute5;
270: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := p_detail_rec.attribute7;
271:
272: OPEN csr_get_pa_task ( p_detail_rec.attribute2 );
273: FETCH csr_get_pa_task INTO hxc_ext_timecard.OTL_PA_TASK;

Line 270: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := p_detail_rec.attribute7;

266: hr_utility.set_location('Processing '||l_proc, 20);
267: end if;
268:
269: hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN := p_detail_rec.attribute5;
270: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := p_detail_rec.attribute7;
271:
272: OPEN csr_get_pa_task ( p_detail_rec.attribute2 );
273: FETCH csr_get_pa_task INTO hxc_ext_timecard.OTL_PA_TASK;
274: CLOSE csr_get_pa_task;

Line 273: FETCH csr_get_pa_task INTO hxc_ext_timecard.OTL_PA_TASK;

269: hxc_ext_timecard.OTL_PA_SYS_LINK_FUNCN := p_detail_rec.attribute5;
270: hxc_ext_timecard.OTL_PA_BILLABLE_FLAG := p_detail_rec.attribute7;
271:
272: OPEN csr_get_pa_task ( p_detail_rec.attribute2 );
273: FETCH csr_get_pa_task INTO hxc_ext_timecard.OTL_PA_TASK;
274: CLOSE csr_get_pa_task;
275:
276: if g_debug then
277: hr_utility.set_location('Processing '||l_proc, 30);

Line 283: FETCH csr_get_pa_project INTO hxc_ext_timecard.OTL_PA_PROJECT;

279:
280: l_task_id := p_detail_rec.attribute2;
281:
282: OPEN csr_get_pa_project ( p_detail_rec.attribute1 );
283: FETCH csr_get_pa_project INTO hxc_ext_timecard.OTL_PA_PROJECT;
284: CLOSE csr_get_pa_project;
285:
286: if g_debug then
287: hr_utility.set_location('Processing '||l_proc, 40);

Line 294: hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE := p_detail_rec.attribute3;

290: l_project_id := p_detail_rec.attribute1;
291:
292: l_exp_typ_id := p_detail_rec.attribute3;
293:
294: hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE := p_detail_rec.attribute3;
295: hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT:= p_detail_rec.attribute4;
296:
297: if g_debug then
298: hr_utility.set_location('Processing '||l_proc, 50);

Line 295: hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT:= p_detail_rec.attribute4;

291:
292: l_exp_typ_id := p_detail_rec.attribute3;
293:
294: hxc_ext_timecard.OTL_PA_EXPENDITURE_TYPE := p_detail_rec.attribute3;
295: hxc_ext_timecard.OTL_PA_EXPENDITURE_COMMENT:= p_detail_rec.attribute4;
296:
297: if g_debug then
298: hr_utility.set_location('Processing '||l_proc, 50);
299: end if;

Line 316: FETCH csr_get_element_name INTO hxc_ext_timecard.OTL_PAY_ELEMENT_NAME;

312: hr_utility.set_location('Processing '||l_proc, 70);
313: end if;
314:
315: OPEN csr_get_element_name ( l_element_type_id );
316: FETCH csr_get_element_name INTO hxc_ext_timecard.OTL_PAY_ELEMENT_NAME;
317: CLOSE csr_get_element_name;
318:
319: if g_debug then
320: hr_utility.set_location('Processing '||l_proc, 80);

Line 326: hxc_ext_timecard.OTL_PAY_COST_CENTRE := 'Not Currently Supported';

322:
323: ELSIF ( p_detail_rec.attribute_category like 'COST%' )
324: THEN
325:
326: hxc_ext_timecard.OTL_PAY_COST_CENTRE := 'Not Currently Supported';
327:
328: ELSIF ( p_detail_rec.attribute_category = 'PURCHASING' )
329: THEN
330:

Line 336: FETCH csr_get_po_line INTO hxc_ext_timecard.OTL_PO_LINE_ID;

332: hr_utility.set_location('Processing '||l_proc, 90);
333: end if;
334:
335: OPEN csr_get_po_line ( p_detail_rec.attribute2 );
336: FETCH csr_get_po_line INTO hxc_ext_timecard.OTL_PO_LINE_ID;
337: CLOSE csr_get_po_line;
338:
339: if g_debug then
340: hr_utility.set_location('Processing '||l_proc, 100);

Line 344: FETCH csr_get_po_price_type INTO hxc_ext_timecard.OTL_PO_PRICE_TYPE;

340: hr_utility.set_location('Processing '||l_proc, 100);
341: end if;
342:
343: OPEN csr_get_po_price_type ( p_detail_rec.attribute3 );
344: FETCH csr_get_po_price_type INTO hxc_ext_timecard.OTL_PO_PRICE_TYPE;
345: CLOSE csr_get_po_price_type;
346:
347: hxc_ext_timecard.OTL_PO_NUMBER := p_detail_rec.attribute1;
348:

Line 347: hxc_ext_timecard.OTL_PO_NUMBER := p_detail_rec.attribute1;

343: OPEN csr_get_po_price_type ( p_detail_rec.attribute3 );
344: FETCH csr_get_po_price_type INTO hxc_ext_timecard.OTL_PO_PRICE_TYPE;
345: CLOSE csr_get_po_price_type;
346:
347: hxc_ext_timecard.OTL_PO_NUMBER := p_detail_rec.attribute1;
348:
349: l_po_num := p_detail_rec.attribute1;
350:
351: if g_debug then

Line 408: hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF

404: if g_debug then
405: hr_utility.set_location('Processing '||l_proc, 40);
406: end if;
407:
408: hxc_ext_timecard.OTL_ALIAS_ELEMENTS_EXP_SLF
409: := l_alias_att(l_index).attribute30;
410:
411: ELSIF ( l_alias_att(l_index).attribute29 = 'EXPENDITURE_ELEMENTS' )
412: THEN

Line 418: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS

414: if g_debug then
415: hr_utility.set_location('Processing '||l_proc, 50);
416: end if;
417:
418: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_ELEMENTS
419: := l_alias_att(l_index).attribute30;
420:
421: ELSIF ( l_alias_att(l_index).attribute29 = 'EXPENDITURE_TYPES' )
422: THEN

Line 428: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES

424: if g_debug then
425: hr_utility.set_location('Processing '||l_proc, 60);
426: end if;
427:
428: hxc_ext_timecard.OTL_ALIAS_EXPENDITURE_TYPES
429: := l_alias_att(l_index).attribute30;
430:
431: ELSIF ( l_alias_att(l_index).attribute29 = 'LOCATIONS' )
432: THEN

Line 438: hxc_ext_timecard.OTL_ALIAS_LOCATIONS

434: if g_debug then
435: hr_utility.set_location('Processing '||l_proc, 70);
436: end if;
437:
438: hxc_ext_timecard.OTL_ALIAS_LOCATIONS
439: := l_alias_att(l_index).attribute30;
440:
441: ELSIF ( l_alias_att(l_index).attribute29 = 'PAYROLL_ELEMENTS' )
442: THEN

Line 448: hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS

444: if g_debug then
445: hr_utility.set_location('Processing '||l_proc, 80);
446: end if;
447:
448: hxc_ext_timecard.OTL_ALIAS_PAYROLL_ELEMENTS
449: := l_alias_att(l_index).attribute30;
450:
451: ELSIF ( l_alias_att(l_index).attribute29 = 'PROJECTS' )
452: THEN

Line 458: hxc_ext_timecard.OTL_ALIAS_PROJECTS

454: if g_debug then
455: hr_utility.set_location('Processing '||l_proc, 90);
456: end if;
457:
458: hxc_ext_timecard.OTL_ALIAS_PROJECTS
459: := l_alias_att(l_index).attribute30;
460:
461: ELSIF ( l_alias_att(l_index).attribute29 = 'TASKS' )
462: THEN

Line 468: hxc_ext_timecard.OTL_ALIAS_TASKS

464: if g_debug then
465: hr_utility.set_location('Processing '||l_proc, 100);
466: end if;
467:
468: hxc_ext_timecard.OTL_ALIAS_TASKS
469: := l_alias_att(l_index).attribute30;
470:
471: ELSIF ( l_alias_att(l_index).attribute29 = 'RATE_TYPE_EXPENDITURE_SLF' )
472: THEN

Line 478: hxc_ext_timecard.OTL_ALIAS_RATE_TYPE_EXP_SLF

474: if g_debug then
475: hr_utility.set_location('Processing '||l_proc, 110);
476: end if;
477:
478: hxc_ext_timecard.OTL_ALIAS_RATE_TYPE_EXP_SLF
479: := l_alias_att(l_index).attribute30;
480:
481: ENd IF;
482:

Line 544: hr_utility.trace('p bg id is '||to_char(hxc_ext_timecard.g_params.p_business_group_id));

540: g_debug :=hr_utility.debug_enabled;
541: if g_debug then
542: l_proc := g_package||'process_summary';
543: hr_utility.trace('p person id is '||to_char(p_person_id));
544: hr_utility.trace('p bg id is '||to_char(hxc_ext_timecard.g_params.p_business_group_id));
545: hr_utility.set_location('Entering '||l_proc, 10);
546: end if;
547:
548: clear_all_globals;

Line 550: IF ( hxc_ext_timecard.g_params.retrieval_process = 'Purchasing Retrieval Process' AND

546: end if;
547:
548: clear_all_globals;
549:
550: IF ( hxc_ext_timecard.g_params.retrieval_process = 'Purchasing Retrieval Process' AND
551: p_person_id = NVL( hxc_ext_timecard.g_params.p_person_id, p_person_id ) )
552: THEN
553:
554: if g_debug then

Line 551: p_person_id = NVL( hxc_ext_timecard.g_params.p_person_id, p_person_id ) )

547:
548: clear_all_globals;
549:
550: IF ( hxc_ext_timecard.g_params.retrieval_process = 'Purchasing Retrieval Process' AND
551: p_person_id = NVL( hxc_ext_timecard.g_params.p_person_id, p_person_id ) )
552: THEN
553:
554: if g_debug then
555: hr_utility.set_location('Processing '||l_proc, 20);

Line 558: l_tc_status := hxc_ext_timecard.g_params.status;

554: if g_debug then
555: hr_utility.set_location('Processing '||l_proc, 20);
556: end if;
557:
558: l_tc_status := hxc_ext_timecard.g_params.status;
559: l_start_date := TRUNC(hxc_ext_timecard.g_params.start_date);
560: l_end_date := TRUNC(hxc_ext_timecard.g_params.end_date);
561:
562: if g_debug then

Line 559: l_start_date := TRUNC(hxc_ext_timecard.g_params.start_date);

555: hr_utility.set_location('Processing '||l_proc, 20);
556: end if;
557:
558: l_tc_status := hxc_ext_timecard.g_params.status;
559: l_start_date := TRUNC(hxc_ext_timecard.g_params.start_date);
560: l_end_date := TRUNC(hxc_ext_timecard.g_params.end_date);
561:
562: if g_debug then
563: hr_utility.trace('start date is '||to_char(l_start_date,'hh24:mi:ss dd/mm/yyyy'));

Line 560: l_end_date := TRUNC(hxc_ext_timecard.g_params.end_date);

556: end if;
557:
558: l_tc_status := hxc_ext_timecard.g_params.status;
559: l_start_date := TRUNC(hxc_ext_timecard.g_params.start_date);
560: l_end_date := TRUNC(hxc_ext_timecard.g_params.end_date);
561:
562: if g_debug then
563: hr_utility.trace('start date is '||to_char(l_start_date,'hh24:mi:ss dd/mm/yyyy'));
564: hr_utility.trace('end date is '||to_char(l_end_date,'hh24:mi:ss dd/mm/yyyy'));

Line 665: END IF; -- ( hxc_ext_timecard.g_params.retrieval_process = 'Purchasing Retrieval Process' )

661: end if;
662:
663: CLOSE csr_get_po_tc;
664:
665: END IF; -- ( hxc_ext_timecard.g_params.retrieval_process = 'Purchasing Retrieval Process' )
666:
667: if g_debug then
668: hr_utility.set_location('Leaving '||l_proc, 130);
669: end if;

Line 755: p_business_group_id=> hxc_ext_timecard.g_params.p_business_group_id,

751: p_rcd_typ_cd => 'D',
752: p_low_lvl_cd => 'T',
753: p_person_id => p_person_id,
754: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,
755: p_business_group_id=> hxc_ext_timecard.g_params.p_business_group_id,
756: p_effective_date => p_effective_date );
757:
758: l_summary_written := TRUE;
759: --END IF;

Line 808: p_business_group_id=> hxc_ext_timecard.g_params.p_business_group_id,

804: p_rcd_typ_cd => 'D',
805: p_low_lvl_cd => 'TS',
806: p_person_id => p_person_id,
807: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,
808: p_business_group_id=> hxc_ext_timecard.g_params.p_business_group_id,
809: p_effective_date => p_effective_date );
810:
811: --END IF;
812:

Line 846: IF ( hxc_ext_timecard.g_params.buyer_supplier = 'SUPPLIER' AND

842:
843: -- check whether or not the PO assocaited with this line
844: -- is permitted to be shown thos this Supplier
845:
846: IF ( hxc_ext_timecard.g_params.buyer_supplier = 'SUPPLIER' AND
847: l_day_rec.attribute_category = 'PURCHASING' AND
848: NOT l_already_called_PO )
849: THEN
850:

Line 874: END IF; -- ( hxc_ext_timecard.g_params.buyer_supplier = 'SUPPLIER' )

870: end if;
871:
872: l_already_called_PO := TRUE;
873:
874: END IF; -- ( hxc_ext_timecard.g_params.buyer_supplier = 'SUPPLIER' )
875:
876: if g_debug then
877: hr_utility.set_location('Processing '||l_proc, 160);
878: end if;

Line 919: p_business_group_id=> hxc_ext_timecard.g_params.p_business_group_id,

915: p_rcd_typ_cd => 'D',
916: p_low_lvl_cd => 'T',
917: p_person_id => p_person_id,
918: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,
919: p_business_group_id=> hxc_ext_timecard.g_params.p_business_group_id,
920: p_effective_date => p_effective_date );
921:
922: l_summary_written := TRUE;
923: END IF;

Line 971: p_business_group_id=> hxc_ext_timecard.g_params.p_business_group_id,

967: p_rcd_typ_cd => 'D',
968: p_low_lvl_cd => 'TS',
969: p_person_id => p_person_id,
970: p_chg_evt_cd => ben_ext_person.g_chg_evt_cd,
971: p_business_group_id=> hxc_ext_timecard.g_params.p_business_group_id,
972: p_effective_date => p_effective_date );
973:
974: --END IF;
975:

Line 1028: hxc_ext_timecard.g_params.start_date := TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS');

1024: hr_utility.trace('po_otl_extract : 1');
1025: hr_utility.trace('date is '||p_start_date);
1026: end if;
1027:
1028: hxc_ext_timecard.g_params.start_date := TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS');
1029: hxc_ext_timecard.g_params.end_date := TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1030: hxc_ext_timecard.g_params.status := p_timecard_status;
1031: hxc_ext_timecard.g_params.vendor_id := p_vendor_id;
1032: hxc_ext_timecard.g_params.retrieval_process := p_retrieval_process;

Line 1029: hxc_ext_timecard.g_params.end_date := TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS');

1025: hr_utility.trace('date is '||p_start_date);
1026: end if;
1027:
1028: hxc_ext_timecard.g_params.start_date := TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS');
1029: hxc_ext_timecard.g_params.end_date := TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1030: hxc_ext_timecard.g_params.status := p_timecard_status;
1031: hxc_ext_timecard.g_params.vendor_id := p_vendor_id;
1032: hxc_ext_timecard.g_params.retrieval_process := p_retrieval_process;
1033: hxc_ext_timecard.g_params.retrieval_process := 'Purchasing Retrieval Process';

Line 1030: hxc_ext_timecard.g_params.status := p_timecard_status;

1026: end if;
1027:
1028: hxc_ext_timecard.g_params.start_date := TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS');
1029: hxc_ext_timecard.g_params.end_date := TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1030: hxc_ext_timecard.g_params.status := p_timecard_status;
1031: hxc_ext_timecard.g_params.vendor_id := p_vendor_id;
1032: hxc_ext_timecard.g_params.retrieval_process := p_retrieval_process;
1033: hxc_ext_timecard.g_params.retrieval_process := 'Purchasing Retrieval Process';
1034: hxc_ext_timecard.g_params.buyer_supplier := p_buyer_supplier;

Line 1031: hxc_ext_timecard.g_params.vendor_id := p_vendor_id;

1027:
1028: hxc_ext_timecard.g_params.start_date := TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS');
1029: hxc_ext_timecard.g_params.end_date := TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1030: hxc_ext_timecard.g_params.status := p_timecard_status;
1031: hxc_ext_timecard.g_params.vendor_id := p_vendor_id;
1032: hxc_ext_timecard.g_params.retrieval_process := p_retrieval_process;
1033: hxc_ext_timecard.g_params.retrieval_process := 'Purchasing Retrieval Process';
1034: hxc_ext_timecard.g_params.buyer_supplier := p_buyer_supplier;
1035: hxc_ext_timecard.g_params.p_business_group_id := p_business_group_id;

Line 1032: hxc_ext_timecard.g_params.retrieval_process := p_retrieval_process;

1028: hxc_ext_timecard.g_params.start_date := TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS');
1029: hxc_ext_timecard.g_params.end_date := TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1030: hxc_ext_timecard.g_params.status := p_timecard_status;
1031: hxc_ext_timecard.g_params.vendor_id := p_vendor_id;
1032: hxc_ext_timecard.g_params.retrieval_process := p_retrieval_process;
1033: hxc_ext_timecard.g_params.retrieval_process := 'Purchasing Retrieval Process';
1034: hxc_ext_timecard.g_params.buyer_supplier := p_buyer_supplier;
1035: hxc_ext_timecard.g_params.p_business_group_id := p_business_group_id;
1036: hxc_ext_timecard.g_params.p_person_id := p_person_id;

Line 1033: hxc_ext_timecard.g_params.retrieval_process := 'Purchasing Retrieval Process';

1029: hxc_ext_timecard.g_params.end_date := TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS');
1030: hxc_ext_timecard.g_params.status := p_timecard_status;
1031: hxc_ext_timecard.g_params.vendor_id := p_vendor_id;
1032: hxc_ext_timecard.g_params.retrieval_process := p_retrieval_process;
1033: hxc_ext_timecard.g_params.retrieval_process := 'Purchasing Retrieval Process';
1034: hxc_ext_timecard.g_params.buyer_supplier := p_buyer_supplier;
1035: hxc_ext_timecard.g_params.p_business_group_id := p_business_group_id;
1036: hxc_ext_timecard.g_params.p_person_id := p_person_id;
1037:

Line 1034: hxc_ext_timecard.g_params.buyer_supplier := p_buyer_supplier;

1030: hxc_ext_timecard.g_params.status := p_timecard_status;
1031: hxc_ext_timecard.g_params.vendor_id := p_vendor_id;
1032: hxc_ext_timecard.g_params.retrieval_process := p_retrieval_process;
1033: hxc_ext_timecard.g_params.retrieval_process := 'Purchasing Retrieval Process';
1034: hxc_ext_timecard.g_params.buyer_supplier := p_buyer_supplier;
1035: hxc_ext_timecard.g_params.p_business_group_id := p_business_group_id;
1036: hxc_ext_timecard.g_params.p_person_id := p_person_id;
1037:
1038: if g_debug then

Line 1035: hxc_ext_timecard.g_params.p_business_group_id := p_business_group_id;

1031: hxc_ext_timecard.g_params.vendor_id := p_vendor_id;
1032: hxc_ext_timecard.g_params.retrieval_process := p_retrieval_process;
1033: hxc_ext_timecard.g_params.retrieval_process := 'Purchasing Retrieval Process';
1034: hxc_ext_timecard.g_params.buyer_supplier := p_buyer_supplier;
1035: hxc_ext_timecard.g_params.p_business_group_id := p_business_group_id;
1036: hxc_ext_timecard.g_params.p_person_id := p_person_id;
1037:
1038: if g_debug then
1039: hr_utility.trace('po_otl_extract : 2');

Line 1036: hxc_ext_timecard.g_params.p_person_id := p_person_id;

1032: hxc_ext_timecard.g_params.retrieval_process := p_retrieval_process;
1033: hxc_ext_timecard.g_params.retrieval_process := 'Purchasing Retrieval Process';
1034: hxc_ext_timecard.g_params.buyer_supplier := p_buyer_supplier;
1035: hxc_ext_timecard.g_params.p_business_group_id := p_business_group_id;
1036: hxc_ext_timecard.g_params.p_person_id := p_person_id;
1037:
1038: if g_debug then
1039: hr_utility.trace('po_otl_extract : 2');
1040: end if;

Line 1067: end hxc_ext_timecard;

1063: */
1064: null;
1065: END po_otl_extract;
1066:
1067: end hxc_ext_timecard;