DBA Data[Home] [Help]

APPS.GMD_ROUTINGS_PVT dependencies on FND_DATE

Line 343: := FND_DATE.canonical_to_date(p_update_table(i).p_value);

339: ||'The eff_start_date for Routing prior to update = '||
340: p_update_table(i).p_value);
341: END IF;
342: l_old_routing_rec.EFFECTIVE_START_DATE
343: := FND_DATE.canonical_to_date(p_update_table(i).p_value);
344: ELSIF (UPPER(p_update_table(i).p_col_to_update) like '%END_DATE%') THEN
345: IF (l_debug = 'Y') THEN
346: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
347: ||'The eff_end_date for Routing prior to update = '||

Line 352: := FND_DATE.canonical_to_date(p_update_table(i).p_value);

348: p_update_table(i).p_value);
349: END IF;
350:
351: l_old_routing_rec.EFFECTIVE_END_DATE
352: := FND_DATE.canonical_to_date(p_update_table(i).p_value);
353: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'PROCESS_LOSS') THEN
354: l_old_routing_rec.PROCESS_LOSS := p_update_table(i).p_value;
355: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'FIXED_PROCESS_LOSS') THEN --RLNAGARA B6997624
356: l_old_routing_rec.FIXED_PROCESS_LOSS := p_update_table(i).p_value;

Line 366: l_old_routing_rec.LAST_UPDATE_DATE := FND_DATE.canonical_to_date(p_update_table(i).p_value);

362: l_old_routing_rec.DELETE_MARK := p_update_table(i).p_value;
363: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATED_BY') THEN
364: l_old_routing_rec.LAST_UPDATED_BY := gmd_api_grp.user_id;
365: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_DATE') THEN
366: l_old_routing_rec.LAST_UPDATE_DATE := FND_DATE.canonical_to_date(p_update_table(i).p_value);
367: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_LOGIN') THEN
368: l_old_routing_rec.LAST_UPDATE_LOGIN := gmd_api_grp.user_id;
369: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'ATTRIBUTE1') THEN
370: l_old_routing_rec.ATTRIBUTE1 := p_update_table(i).p_value;