1065: ,p_location_to_code IN VARCHAR2
1066: ,p_responsible_user IN NUMBER) IS
1067:
1068: /* convert the dates cannonical to date */
1069: l_sch_from_dt DATE := fnd_date.canonical_to_date(p_schedule_from_date);
1070: l_sch_to_dt DATE := fnd_date.canonical_to_date(p_schedule_to_date);
1071: l_trx_from_dt DATE := fnd_date.canonical_to_date(p_trx_from_date);
1072: l_trx_to_dt DATE := fnd_date.canonical_to_date(p_trx_to_date);
1073:
1066: ,p_responsible_user IN NUMBER) IS
1067:
1068: /* convert the dates cannonical to date */
1069: l_sch_from_dt DATE := fnd_date.canonical_to_date(p_schedule_from_date);
1070: l_sch_to_dt DATE := fnd_date.canonical_to_date(p_schedule_to_date);
1071: l_trx_from_dt DATE := fnd_date.canonical_to_date(p_trx_from_date);
1072: l_trx_to_dt DATE := fnd_date.canonical_to_date(p_trx_to_date);
1073:
1074: BEGIN
1067:
1068: /* convert the dates cannonical to date */
1069: l_sch_from_dt DATE := fnd_date.canonical_to_date(p_schedule_from_date);
1070: l_sch_to_dt DATE := fnd_date.canonical_to_date(p_schedule_to_date);
1071: l_trx_from_dt DATE := fnd_date.canonical_to_date(p_trx_from_date);
1072: l_trx_to_dt DATE := fnd_date.canonical_to_date(p_trx_to_date);
1073:
1074: BEGIN
1075:
1068: /* convert the dates cannonical to date */
1069: l_sch_from_dt DATE := fnd_date.canonical_to_date(p_schedule_from_date);
1070: l_sch_to_dt DATE := fnd_date.canonical_to_date(p_schedule_to_date);
1071: l_trx_from_dt DATE := fnd_date.canonical_to_date(p_trx_from_date);
1072: l_trx_to_dt DATE := fnd_date.canonical_to_date(p_trx_to_date);
1073:
1074: BEGIN
1075:
1076: PNP_DEBUG_PKG.debug('pn_mass_appr_pkg.pn_mass_app (+)');