APPS.HXC_HXCMISTC_XMLP_PKG dependencies on HXC_TPD_END

Line 96: col_1 := 'hxc_tpd_end.get_org_name(asm.organization_id)';

92: P_SORT4_LABEL := L_SORT4_LABEL;
93:
94: if col_1 is null then
95: --Bug 10338208 Using get_org_name for organization name
96: col_1 := 'hxc_tpd_end.get_org_name(asm.organization_id)';
97: end if;
98:
99: if col_2 is null then
100: --Bug 10338208 Using get_locn_name method for location name

Line 101: col_2 := 'hxc_tpd_end.get_locn_name(asm.location_id)';

97: end if;
98:
99: if col_2 is null then
100: --Bug 10338208 Using get_locn_name method for location name
101: col_2 := 'hxc_tpd_end.get_locn_name(asm.location_id)';
102: end if;
103:
104: if col_3 is null then
105: --Bug 10338208 Using get_payroll_name method for payroll name

Line 106: col_3 := 'hxc_tpd_end.get_payroll_name(asm.payroll_id)';

102: end if;
103:
104: if col_3 is null then
105: --Bug 10338208 Using get_payroll_name method for payroll name
106: col_3 := 'hxc_tpd_end.get_payroll_name(asm.payroll_id)';
107: end if;
108: if col_4 is null then
109: --Bug 10338208 Using get_full_name method for full name of
110: -- employee

Line 111: col_4 := 'hxc_tpd_end.get_full_name(ppf.person_id,:p_date_to)';

107: end if;
108: if col_4 is null then
109: --Bug 10338208 Using get_full_name method for full name of
110: -- employee
111: col_4 := 'hxc_tpd_end.get_full_name(ppf.person_id,:p_date_to)';
112: end if;
113: if p_define_missing is not null then
114: select meaning into l_define_meaning
115: from hxc_lookups

Line 146: p_organization_label := hxc_tpd_end.get_org_name(p_organization);

142: close c_per_dtl;
143: end if;
144:
145: if p_organization is not null then
146: p_organization_label := hxc_tpd_end.get_org_name(p_organization);
147: org_condition := ' and asm.organization_id = :p_organization';
148: org_condition2 := ' and paf.organization_id = :p_organization';
149: opt_hint := ' INDEX(asm per_assignments_f_fk15) ';
150: else

Line 156: p_payroll_label := hxc_tpd_end.get_payroll_name(p_payroll);

152: org_condition2 := ' ';
153: end if;
154:
155: if p_payroll is not null then
156: p_payroll_label := hxc_tpd_end.get_payroll_name(p_payroll);
157:
158: payroll_condition := ' and asm.payroll_id = :p_payroll';
159: payroll_condition2 := ' and paf.payroll_id = :p_payroll';
160: opt_hint := ' INDEX(asm per_assignments_f_n7) ';

Line 167: p_location_label := hxc_tpd_end.get_locn_name(p_location);

163: payroll_condition2 := ' ';
164: end if;
165:
166: if p_location is not null then
167: p_location_label := hxc_tpd_end.get_locn_name(p_location);
168:
169: locn_condition := 'and asm.location_id = :p_location';
170: locn_condition2 := 'and paf.location_id = :p_location';
171: opt_hint := ' INDEX(asm per_assignments_f_fk8) ';

Line 297: --Bug 10338208 Modified procedure to use methods available in hxc_tpd_end

293: L_SCL_TCARD_REQ VARCHAR2(5);
294: BEGIN
295: RETURN L_PAYROLL_NAME;
296: END CF_APPLICATIONFORMULA;
297: --Bug 10338208 Modified procedure to use methods available in hxc_tpd_end
298: PROCEDURE SORT_OPTION(L_SORT_OPTION IN VARCHAR2
299: ,L_SORT_BY OUT NOCOPY VARCHAR2
300: ,L_SORT_LABEL OUT NOCOPY VARCHAR2) IS
301: BEGIN

Line 315: l_sort_by := 'hxc_tpd_end.get_full_name(ppf.person_id,:p_date_to)';

311: l_sort_by := 'hapd.timecard_stop_time';
312: l_sort_label := 'Date To';
313: elsif
314: l_sort_option = 'FULL_NAME' then
315: l_sort_by := 'hxc_tpd_end.get_full_name(ppf.person_id,:p_date_to)';
316: -- CWK parameter changes
317: -- l_sort_label := 'Employee Name';
318: l_sort_label := 'Person Name';
319: elsif

Line 328: l_sort_by := 'hxc_tpd_end.get_locn_name(asm.location_id)';

324: l_sort_label := 'Person Number';
325:
326: elsif
327: l_sort_option = 'LOCATION' then
328: l_sort_by := 'hxc_tpd_end.get_locn_name(asm.location_id)';
329: l_sort_label := 'Location';
330: elsif
331: l_sort_option = 'ORGANIZATION' then
332: l_sort_by := 'hxc_tpd_end.get_org_name(asm.organization_id)';

Line 332: l_sort_by := 'hxc_tpd_end.get_org_name(asm.organization_id)';

328: l_sort_by := 'hxc_tpd_end.get_locn_name(asm.location_id)';
329: l_sort_label := 'Location';
330: elsif
331: l_sort_option = 'ORGANIZATION' then
332: l_sort_by := 'hxc_tpd_end.get_org_name(asm.organization_id)';
333: l_sort_label := 'Organization';
334: elsif
335: l_sort_option = 'PAYROLL_NAME' then
336: l_sort_by := 'hxc_tpd_end.get_payroll_name(asm.payroll_id) ';

Line 336: l_sort_by := 'hxc_tpd_end.get_payroll_name(asm.payroll_id) ';

332: l_sort_by := 'hxc_tpd_end.get_org_name(asm.organization_id)';
333: l_sort_label := 'Organization';
334: elsif
335: l_sort_option = 'PAYROLL_NAME' then
336: l_sort_by := 'hxc_tpd_end.get_payroll_name(asm.payroll_id) ';
337: l_sort_label := 'Payroll Name';
338: elsif
339: l_sort_option = 'SUPERVISOR' then
340:

Line 341: -- l_sort_by := 'hxc_tpd_end.get_supervisor_name(paf.supervisor_id,paf.effective_start_date)';

337: l_sort_label := 'Payroll Name';
338: elsif
339: l_sort_option = 'SUPERVISOR' then
340:
341: -- l_sort_by := 'hxc_tpd_end.get_supervisor_name(paf.supervisor_id,paf.effective_start_date)';
342: l_sort_by := 'hxc_tpd_end.get_supervisor_name(asm.supervisor_id,asm.effective_start_date)';
343:
344:
345: l_sort_label := 'Supervisor Name';

Line 342: l_sort_by := 'hxc_tpd_end.get_supervisor_name(asm.supervisor_id,asm.effective_start_date)';

338: elsif
339: l_sort_option = 'SUPERVISOR' then
340:
341: -- l_sort_by := 'hxc_tpd_end.get_supervisor_name(paf.supervisor_id,paf.effective_start_date)';
342: l_sort_by := 'hxc_tpd_end.get_supervisor_name(asm.supervisor_id,asm.effective_start_date)';
343:
344:
345: l_sort_label := 'Supervisor Name';
346:

Line 353: l_sort_by := 'hxc_tpd_end.person_type(asm.effective_start_date,ppf.person_id)';

349: elsif
350: l_sort_option = 'PERSON_TYPE' then
351: -- l_sort_by := 'ppt.user_person_type';
352: l_sort_label := 'Person Type';
353: l_sort_by := 'hxc_tpd_end.person_type(asm.effective_start_date,ppf.person_id)';
354: elsif
355: l_sort_option = 'SUPPLIER_ID' then
356: l_sort_by := 'hxc_missing_tcard_report.get_vendor_name(:p_date_from,:p_date_to,asm.person_id)';
357: l_sort_label := 'Supplier';