DBA Data[Home] [Help]

APPS.GMD_VALIDITY_RULES_PVT dependencies on FND_DATE

Line 450: /* Changed the call from fnd_date.CHARDATE_TO_DATE to */

446: /* */
447: /* History : */
448: /* Shyam 07/29/2002 Initial implementation */
449: /* Kapil M 18-NOV-2005 Bug # 4134275 */
450: /* Changed the call from fnd_date.CHARDATE_TO_DATE to */
451: /* fnd_date.CANONICAL_TO_DATE
452: /* Michael Tou 25-Oct-2011 Bug# 6713805 Added ITEM_UM in order to re-calculate */
453: /* inv_min_qty, inv_max_qty whenever UOM updates */
454: /* =============================================================== */

Line 451: /* fnd_date.CANONICAL_TO_DATE

447: /* History : */
448: /* Shyam 07/29/2002 Initial implementation */
449: /* Kapil M 18-NOV-2005 Bug # 4134275 */
450: /* Changed the call from fnd_date.CHARDATE_TO_DATE to */
451: /* fnd_date.CANONICAL_TO_DATE
452: /* Michael Tou 25-Oct-2011 Bug# 6713805 Added ITEM_UM in order to re-calculate */
453: /* inv_min_qty, inv_max_qty whenever UOM updates */
454: /* =============================================================== */
455: PROCEDURE update_validity_rules

Line 605: l_old_vr_rec.START_DATE := FND_DATE.canonical_to_date(p_update_table(i).p_value);

601: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||
602: ' : Before conversion of Start date - '||
603: ' CharDT to Date Format ');
604: END IF;
605: l_old_vr_rec.START_DATE := FND_DATE.canonical_to_date(p_update_table(i).p_value);
606: IF (l_debug = 'Y') THEN
607: gmd_debug.put_line(m_pkg_name||'.'||l_api_name
608: ||' : After conversion of CharDT to Date '||
609: ' Start Date = '||l_old_vr_rec.START_DATE);

Line 617: l_old_vr_rec.END_DATE := FND_DATE.canonical_to_date(p_update_table(i).p_value);

613: gmd_debug.put_line(m_pkg_name||'.'||l_api_name
614: ||' : Before conversion of end date - '
615: ||' CharDT to Date Format '||p_update_table(i).p_value);
616: END IF;
617: l_old_vr_rec.END_DATE := FND_DATE.canonical_to_date(p_update_table(i).p_value);
618: IF (l_debug = 'Y') THEN
619: gmd_debug.put_line(m_pkg_name||'.'||l_api_name
620: ||' : After conversion of CharDT to Date '||
621: ' End Date = '||l_old_vr_rec.END_DATE);

Line 644: l_old_vr_rec.LAST_UPDATE_DATE := FND_DATE.canonical_to_date(p_update_table(i).p_value);

640: -- Bug #4134275 Kapil M
641: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATED_BY') THEN
642: l_old_vr_rec.LAST_UPDATED_BY := NVL(p_update_table(i).p_value, fnd_global.user_id);
643: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_DATE') THEN
644: l_old_vr_rec.LAST_UPDATE_DATE := FND_DATE.canonical_to_date(p_update_table(i).p_value);
645: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_LOGIN') THEN
646: l_old_vr_rec.LAST_UPDATE_LOGIN := NVL(p_update_table(i).p_value,gmd_api_grp.login_id);
647: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'ATTRIBUTE1') THEN
648: l_old_vr_rec.ATTRIBUTE1 := p_update_table(i).p_value;