DBA Data[Home] [Help]

APPS.GMD_CONC_REPLACE_PKG dependencies on FND_DATE

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

1338: l_routing_class, l_owner_id
1339: FROM dual;
1340: -- Bug# 5493773 Kapil M Pass the old End date
1341: IF NOT get_object_rec.replace_type = 'END_DATE' THEN
1342: l_end_date := FND_DATE.date_to_canonical(l_old_end_date);
1343: END IF;
1344:
1345: -- Call the insert API
1346: gmd_search_replace_vers.create_new_routing

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

1840: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
1841: (get_object_rec.replace_type like '%END_DATE%') ) THEN
1842: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1843: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1844: FND_DATE.canonical_to_date(get_object_rec.new_name) );
1845: -- 5532058 If replace_type is 'OWNER_ORGN_CODE', display orgn code
1846: ELSIF (get_object_rec.replace_type = 'OWNER_ORGN_CODE') THEN
1847: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1848: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',

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

1932: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
1933: (get_object_rec.replace_type like '%END_DATE%') ) THEN
1934: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1935: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1936: FND_DATE.canonical_to_date(get_object_rec.new_name) );
1937: ELSIF (get_object_rec.replace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
1938: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
1939: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1940: get_orgn_code(get_object_rec.new_name) );

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

2003: ELSIF ((get_object_rec.replace_type like '%START_DATE%') OR
2004: (get_object_rec.replace_type like '%END_DATE%') ) THEN
2005: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2006: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2007: FND_DATE.canonical_to_date(get_object_rec.new_name) );
2008: ELSIF (get_object_rec.replace_type IN ('ORGN_CODE', 'OWNER_ORGN_CODE')) THEN
2009: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',pReplace_type);
2010: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
2011: get_orgn_code(get_object_rec.new_name) );

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

2275: WHERE ORGANIZATION_ID = ');
2276: fnd_dsql.add_bind(pOld_name);
2277: fnd_dsql.add_text(' ))');
2278: ELSIF (pReplace_type IN ('START_DATE','END_DATE')) THEN
2279: fnd_dsql.add_bind(fnd_date.displaydt_to_date(pOld_name));
2280: fnd_dsql.add_text(' ))');
2281: ELSE
2282: fnd_dsql.add_bind(pOld_name);
2283: fnd_dsql.add_text(' ))');