DBA Data[Home] [Help]

APPS.GMD_QM_CONC_REPLACE_PKG dependencies on FND_DATE

Line 547: default_log (' Old Start Date : ' || fnd_date.canonical_to_date (pold_name));

543: IF preplace_type = 'REPSTATUS' THEN
544: default_log (' Old Status: ' || pold_name);
545: default_log (' New Status: ' || pnew_name);
546: ELSIF preplace_type = 'REPSTART' THEN
547: default_log (' Old Start Date : ' || fnd_date.canonical_to_date (pold_name));
548: default_log (' New Start Date : ' || fnd_date.canonical_to_date (pnew_name));
549: ELSIF preplace_type = 'REPEND' THEN
550: default_log (' Old End Date : ' || fnd_date.canonical_to_date (pold_name));
551: default_log (' New End Date : ' || fnd_date.canonical_to_date (pnew_name));

Line 548: default_log (' New Start Date : ' || fnd_date.canonical_to_date (pnew_name));

544: default_log (' Old Status: ' || pold_name);
545: default_log (' New Status: ' || pnew_name);
546: ELSIF preplace_type = 'REPSTART' THEN
547: default_log (' Old Start Date : ' || fnd_date.canonical_to_date (pold_name));
548: default_log (' New Start Date : ' || fnd_date.canonical_to_date (pnew_name));
549: ELSIF preplace_type = 'REPEND' THEN
550: default_log (' Old End Date : ' || fnd_date.canonical_to_date (pold_name));
551: default_log (' New End Date : ' || fnd_date.canonical_to_date (pnew_name));
552: END IF;

Line 550: default_log (' Old End Date : ' || fnd_date.canonical_to_date (pold_name));

546: ELSIF preplace_type = 'REPSTART' THEN
547: default_log (' Old Start Date : ' || fnd_date.canonical_to_date (pold_name));
548: default_log (' New Start Date : ' || fnd_date.canonical_to_date (pnew_name));
549: ELSIF preplace_type = 'REPEND' THEN
550: default_log (' Old End Date : ' || fnd_date.canonical_to_date (pold_name));
551: default_log (' New End Date : ' || fnd_date.canonical_to_date (pnew_name));
552: END IF;
553: END IF;
554:

Line 551: default_log (' New End Date : ' || fnd_date.canonical_to_date (pnew_name));

547: default_log (' Old Start Date : ' || fnd_date.canonical_to_date (pold_name));
548: default_log (' New Start Date : ' || fnd_date.canonical_to_date (pnew_name));
549: ELSIF preplace_type = 'REPEND' THEN
550: default_log (' Old End Date : ' || fnd_date.canonical_to_date (pold_name));
551: default_log (' New End Date : ' || fnd_date.canonical_to_date (pnew_name));
552: END IF;
553: END IF;
554:
555: -- Using concurrent_id/request_id we get the details on the object and column that

Line 1478: l_start_date := fnd_date.canonical_to_date (pnew_name);

1474: l_new_status := NULL;
1475:
1476: IF get_object_rec.replace_type = 'REPSTART'
1477: AND get_object_rec.object_status_code NOT IN (200,500,800,1000) Then /* Added AND condition in bug#6056493 */
1478: l_start_date := fnd_date.canonical_to_date (pnew_name);
1479: ELSIF get_object_rec.replace_type = 'REPEND'
1480: AND get_object_rec.object_status_code NOT IN (200,500,800,1000) Then /* Added AND condition in bug#6056493 */
1481: l_end_date := fnd_date.canonical_to_date (pnew_name);
1482: ELSIF get_object_rec.replace_type = 'REPSTATUS' THEN

Line 1481: l_end_date := fnd_date.canonical_to_date (pnew_name);

1477: AND get_object_rec.object_status_code NOT IN (200,500,800,1000) Then /* Added AND condition in bug#6056493 */
1478: l_start_date := fnd_date.canonical_to_date (pnew_name);
1479: ELSIF get_object_rec.replace_type = 'REPEND'
1480: AND get_object_rec.object_status_code NOT IN (200,500,800,1000) Then /* Added AND condition in bug#6056493 */
1481: l_end_date := fnd_date.canonical_to_date (pnew_name);
1482: ELSIF get_object_rec.replace_type = 'REPSTATUS' THEN
1483: l_new_status := TO_NUMBER (pnew_name);
1484: END IF;
1485: