DBA Data[Home] [Help]

APPS.SSP_SAP_PKG dependencies on FND_DATE

Line 42: 02-AUG-07 P Balu 6271407 Changed the To_Date function to fnd_date.canonical_to_date

38: check for employee date of death before creating
39: 'Some work was done' stoppage.
40: Also update check_death to create stoppage based
41: on the 'rolling 7-day week' not the next Sunday.
42: 02-AUG-07 P Balu 6271407 Changed the To_Date function to fnd_date.canonical_to_date
43: function in the cursor csr_existing_entries.
44: */
45: --------------------------------------------------------------------------------
46: g_package varchar2(33) := ' ssp_sap_pkg.'; -- Global package name

Line 1164: fnd_date.canonical_to_date(ssp_smp_support_pkg.value

1160: /* to_date (ssp_smp_support_pkg.value
1161: (entry.element_entry_id,
1162: ssp_sap_pkg.c_week_commencing_name),
1163: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1164: fnd_date.canonical_to_date(ssp_smp_support_pkg.value
1165: (entry.element_entry_id,
1166: ssp_sap_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1167: --BUG 6271407 end
1168: to_number(ssp_smp_support_pkg.value (entry.element_entry_id,