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: /* =============================================================== */
453: PROCEDURE update_validity_rules
454: ( p_validity_rule_id IN gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE

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: /* =============================================================== */
453: PROCEDURE update_validity_rules
454: ( p_validity_rule_id IN gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE
455: , p_update_table IN gmd_validity_rules_pvt.update_tbl_type

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

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

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

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

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

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