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: 14-NOV-08 Nagabushan 7563477 Changed the fnd_date.canonical_to_date function to
45: fnd_date.chardate_to_date function in the cursor csr_existing_entries.
46: */

Line 44: 14-NOV-08 Nagabushan 7563477 Changed the fnd_date.canonical_to_date function to

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: 14-NOV-08 Nagabushan 7563477 Changed the fnd_date.canonical_to_date function to
45: fnd_date.chardate_to_date function in the cursor csr_existing_entries.
46: */
47: --------------------------------------------------------------------------------
48: g_package varchar2(33) := ' ssp_sap_pkg.'; -- Global package name

Line 45: fnd_date.chardate_to_date function in the cursor csr_existing_entries.

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: 14-NOV-08 Nagabushan 7563477 Changed the fnd_date.canonical_to_date function to
45: fnd_date.chardate_to_date function in the cursor csr_existing_entries.
46: */
47: --------------------------------------------------------------------------------
48: g_package varchar2(33) := ' ssp_sap_pkg.'; -- Global package name
49: --

Line 1167: /* fnd_date.canonical_to_date(ssp_smp_support_pkg.value

1163: (entry.element_entry_id,
1164: ssp_sap_pkg.c_week_commencing_name),
1165: 'DD-MON-YYYY') WEEK_COMMENCING,*/
1166: --BUG 7563477 begin
1167: /* fnd_date.canonical_to_date(ssp_smp_support_pkg.value
1168: (entry.element_entry_id,
1169: ssp_sap_pkg.c_week_commencing_name)) WEEK_COMMENCING,*/
1170: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1171: (entry.element_entry_id,

Line 1170: fnd_date.chardate_to_date(ssp_smp_support_pkg.value

1166: --BUG 7563477 begin
1167: /* fnd_date.canonical_to_date(ssp_smp_support_pkg.value
1168: (entry.element_entry_id,
1169: ssp_sap_pkg.c_week_commencing_name)) WEEK_COMMENCING,*/
1170: fnd_date.chardate_to_date(ssp_smp_support_pkg.value
1171: (entry.element_entry_id,
1172: ssp_sap_pkg.c_week_commencing_name)) WEEK_COMMENCING,
1173: --BUG 7563477 end
1174: --BUG 6271407 end