APPS.PN_CC_SYNC_PKG dependencies on FND_DATE

Line 122: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_as_of_date),'mm/dd/yyyy'));

118:
119: --Print all input parameters
120:
121: fnd_message.set_name ('PN','PN_HRSYNC_INP_PARAMS');
122: fnd_message.set_token ('DATE', to_char(fnd_date.canonical_to_date(p_as_of_date),'mm/dd/yyyy'));
123: fnd_message.set_token ('LOC_TYPE', p_locn_type);
124: fnd_message.set_token ('LOC_CODE_FROM', p_locn_code_from);
125: fnd_message.set_token ('LOC_CODE_TO', p_locn_code_to);
126: fnd_message.set_token ('COST_CENTER', p_emp_cost_center);

Line 130: l_as_of_date := trunc(fnd_date.canonical_to_date(p_as_of_date));

126: fnd_message.set_token ('COST_CENTER', p_emp_cost_center);
127: pnp_debug_pkg.put_log_msg(fnd_message.get);
128:
129: l_log_context := ' Getting as of Date..';
130: l_as_of_date := trunc(fnd_date.canonical_to_date(p_as_of_date));
131:
132: l_log_context := 'Initializing WHO variables..';
133: l_last_updated_by := nvl(fnd_profile.VALUE ('USER_ID'), 0);
134: l_last_update_login := nvl(fnd_profile.value('LOGIN_ID'),0);

Line 391: pn_cc_sync_pkg.get_cc_as_of_date(asg_rec.person_id, l_column_name, fnd_date.canonical_to_date(p_as_of_date), l_emp_name, l_cost_center);

387:
388:
389: /* Get cost center from HR */
390: IF l_person_id <> asg_rec.person_id THEN
391: pn_cc_sync_pkg.get_cc_as_of_date(asg_rec.person_id, l_column_name, fnd_date.canonical_to_date(p_as_of_date), l_emp_name, l_cost_center);
392:
393: /* Get employee name if any issues with finding cost center */
394: IF l_emp_name IS NULL THEN
395: OPEN get_emp_name(asg_rec.person_id, l_as_of_date);