1233: -- ff_archive_api validates the value
1234: -----------------------------------------------------------------------------------------------+
1235:
1236: if (v_data_type = 'D') then
1237: p_value:= to_char(to_date(p_value,'DDMMYYYY'),fnd_date.canonical_mask);
1238: end if;
1239:
1240:
1241: if get_user_entity_id%found then
1266: OPEN get_user_entity_id (p_user_entity_name);
1267: FETCH get_user_entity_id INTO v_user_Entity_id,
1268: v_data_type;
1269: IF (v_data_type = 'D') THEN
1270: p_value:= to_char(to_date(p_value,'DDMMYYYY'),fnd_date.canonical_mask);
1271: END IF;
1272:
1273: IF get_user_entity_id%FOUND
1274: THEN