DBA Data[Home] [Help]

APPS.GMD_CONC_REPLACE_PKG dependencies on DUAL

Line 883: FROM dual;

879: DECODE(get_object_rec.replace_type,'OWNER_ID'
880: ,get_object_rec.new_name
881: ,NULL)
882: INTO l_formula_class, l_new_ingredient, l_old_ingredient, l_owner_id
883: FROM dual;
884:
885: IF (l_debug = 'Y') THEN
886: gmd_debug.put_line
887: ('In MSNR replace : In Insert mode '

Line 1100: FROM dual;

1096: DECODE(get_object_rec.replace_type,'OWNER_ID'
1097: ,get_object_rec.new_name
1098: ,NULL)
1099: INTO l_formula_id, l_routing_id, l_organization_id, l_recipe_type, l_owner_id
1100: FROM dual;
1101:
1102: -- NPD Conv
1103: IF (get_object_rec.replace_type = 'OWNER_ORGN_CODE') THEN
1104:

Line 1339: FROM dual;

1335: ,get_object_rec.new_name
1336: ,NULL)
1337: INTO l_start_date, l_end_date, l_old_oprn, l_new_oprn,
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;

Line 1561: FROM dual;

1557: ,get_object_rec.new_name
1558: ,NULL)
1559: INTO l_start_date, l_end_date, l_old_actv, l_new_actv,
1560: l_oprn_class, l_old_resource, l_new_resource, l_organization_id
1561: FROM dual;
1562:
1563: IF (l_debug = 'Y') THEN
1564: gmd_debug.put_line(g_pkg_name||'.'||l_api_name
1565: ||' : About to call create_new_operation - End Date = '

Line 2156: FROM sys.dual;

2152: 'OPERATION','OPRN_ID',
2153: 'ROUTING','ROUTING_ID',
2154: 'VALIDITY','RECIPE_VALIDITY_RULE_ID')
2155: INTO l_table_name, l_primary_key
2156: FROM sys.dual;
2157:
2158: l_replace_type := pReplace_type;
2159:
2160: IF (l_debug = 'Y') THEN