DBA Data[Home] [Help]

APPS.GMD_CONC_REPLACE_PKG dependencies on FND_DATE

Line 1189: l_end_date := FND_DATE.date_to_canonical(l_old_end_date);

1185: l_routing_class, l_owner_id
1186: FROM dual;
1187: -- Bug# 5493773 Kapil M Pass the old End date
1188: IF NOT get_object_rec.replace_type = 'END_DATE' THEN
1189: l_end_date := FND_DATE.date_to_canonical(l_old_end_date);
1190: END IF;
1191:
1192: -- Call the insert API
1193: gmd_search_replace_vers.create_new_routing

Line 1658: FND_DATE.canonical_to_date(get_object_rec.new_name) );

1654: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
1655: (get_object_rec.replace_type like '%END_DATE%') ) THEN
1656: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1657: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1658: FND_DATE.canonical_to_date(get_object_rec.new_name) );
1659: -- 5532058 If replace_type is 'OWNER_ORGN_CODE', display orgn code
1660: ELSIF (get_object_rec.replace_type = 'OWNER_ORGN_CODE') THEN
1661: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1662: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

Line 1750: FND_DATE.canonical_to_date(get_object_rec.new_name) );

1746: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
1747: (get_object_rec.replace_type like '%END_DATE%') ) THEN
1748: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1749: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1750: FND_DATE.canonical_to_date(get_object_rec.new_name) );
1751: ELSIF (get_object_rec.replace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
1752: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1753: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1754: get_orgn_code(get_object_rec.new_name) );

Line 1821: FND_DATE.canonical_to_date(get_object_rec.new_name) );

1817: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
1818: (get_object_rec.replace_type like '%END_DATE%') ) THEN
1819: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1820: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1821: FND_DATE.canonical_to_date(get_object_rec.new_name) );
1822: ELSIF (get_object_rec.replace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
1823: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1824: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1825: get_orgn_code(get_object_rec.new_name) );

Line 2093: fnd_dsql.add_bind(fnd_date.displaydt_to_date(pOld_name));

2089: WHERE ORGANIZATION_ID = ');
2090: fnd_dsql.add_bind(pOld_name);
2091: fnd_dsql.add_text(' ))');
2092: ELSIF (pReplace_type IN ('START_DATE','END_DATE')) THEN
2093: fnd_dsql.add_bind(fnd_date.displaydt_to_date(pOld_name));
2094: fnd_dsql.add_text(' ))');
2095: ELSE
2096: fnd_dsql.add_bind(pOld_name);
2097: fnd_dsql.add_text(' ))');