eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_CONC_REPLACE_PKG dependencies on FND_DSQL

Line 126: l_text := fnd_dsql.get_text(TRUE); --GET THE SQL WITH BIND VALUE INFORMATION.

122: g_bind_vtbl.EXTEND(100);
123: g_bind_dtbl.EXTEND(100);
124: g_bind_ntbl.EXTEND(100);
125:
126: l_text := fnd_dsql.get_text(TRUE); --GET THE SQL WITH BIND VALUE INFORMATION.
127: bind_count := (length(l_text) - length(replace(l_text, 'FND_BIND', ''))) / 8 / 2;
128: v_start_pos := instr(l_text, 'FND_BIND1', 1, 2);
129: l_short_text := substr(l_text,
130: v_start_pos - 2,

Line 156: l_dsql_text := fnd_dsql.get_text(FALSE);

152: length(l_short_text)));
153: dbms_output.put_line('Left:' || l_short_text);
154:
155: end loop;
156: l_dsql_text := fnd_dsql.get_text(FALSE);
157: FOR i IN 1 .. bind_count LOOP
158: IF (g_bind_ttbl(i) = 'D') THEN
159:
160: l_dsql_text := replace(l_dsql_text,

Line 236: fnd_dsql.set_cursor(l_cursor_id);

232: -- Delete rows from previous searches
233: DELETE FROM gmd_msnr_results WHERE concurrent_id IS NULL;
234: /*
235: l_cursor_id := dbms_sql.open_cursor;
236: fnd_dsql.set_cursor(l_cursor_id);
237: l_dsql_text := fnd_dsql.get_text(FALSE);
238:
239: l_debug_text := fnd_dsql.get_text(TRUE);
240: --insert into shy_text values (l_debug_text); commit;

Line 237: l_dsql_text := fnd_dsql.get_text(FALSE);

233: DELETE FROM gmd_msnr_results WHERE concurrent_id IS NULL;
234: /*
235: l_cursor_id := dbms_sql.open_cursor;
236: fnd_dsql.set_cursor(l_cursor_id);
237: l_dsql_text := fnd_dsql.get_text(FALSE);
238:
239: l_debug_text := fnd_dsql.get_text(TRUE);
240: --insert into shy_text values (l_debug_text); commit;
241:

Line 239: l_debug_text := fnd_dsql.get_text(TRUE);

235: l_cursor_id := dbms_sql.open_cursor;
236: fnd_dsql.set_cursor(l_cursor_id);
237: l_dsql_text := fnd_dsql.get_text(FALSE);
238:
239: l_debug_text := fnd_dsql.get_text(TRUE);
240: --insert into shy_text values (l_debug_text); commit;
241:
242: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
243: fnd_dsql.do_binds;

Line 243: fnd_dsql.do_binds;

239: l_debug_text := fnd_dsql.get_text(TRUE);
240: --insert into shy_text values (l_debug_text); commit;
241:
242: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
243: fnd_dsql.do_binds;
244:
245: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
246: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
247: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );

Line 2212: fnd_dsql.init;

2208: END IF;
2209:
2210: END IF;
2211:
2212: fnd_dsql.init;
2213: fnd_dsql.add_text( ' Update Gmd_MSNR_Results '||
2214: ' Set Object_select_ind = 0 '||
2215: ' Where concurrent_id IS NULL '||
2216: ' And Object_select_ind = 1 '||

Line 2213: fnd_dsql.add_text( ' Update Gmd_MSNR_Results '||

2209:
2210: END IF;
2211:
2212: fnd_dsql.init;
2213: fnd_dsql.add_text( ' Update Gmd_MSNR_Results '||
2214: ' Set Object_select_ind = 0 '||
2215: ' Where concurrent_id IS NULL '||
2216: ' And Object_select_ind = 1 '||
2217: ' And object_id NOT IN ( Select object_id '||

Line 2232: fnd_dsql.add_text( ' And '||l_replace_type||' IS NULL )');

2228: ,'OPRN_CLASS'
2229: ,'ROUTING_CLASS'
2230: ,'ROUTING_ID'
2231: ,'FORMULA_CLASS') THEN
2232: fnd_dsql.add_text( ' And '||l_replace_type||' IS NULL )');
2233: ELSE
2234: -- pOld_Name cannot be null
2235: FND_MESSAGE.SET_NAME('GMD','GMD_NO_ASSIGN_VALUE_EXCEPTION');
2236: FND_MSG_PUB.ADD;

Line 2240: fnd_dsql.add_text( ' And '||l_replace_type||' IN (');

2236: FND_MSG_PUB.ADD;
2237: RAISE VALIDATION_FAILED_EXCEPTION;
2238: END IF;
2239: ELSE
2240: fnd_dsql.add_text( ' And '||l_replace_type||' IN (');
2241:
2242: IF (pReplace_type = 'INGREDIENT') THEN
2243: fnd_dsql.add_text(' SELECT FORMULA_ID FROM FM_MATL_DTL
2244: WHERE LINE_TYPE = -1

Line 2243: fnd_dsql.add_text(' SELECT FORMULA_ID FROM FM_MATL_DTL

2239: ELSE
2240: fnd_dsql.add_text( ' And '||l_replace_type||' IN (');
2241:
2242: IF (pReplace_type = 'INGREDIENT') THEN
2243: fnd_dsql.add_text(' SELECT FORMULA_ID FROM FM_MATL_DTL
2244: WHERE LINE_TYPE = -1
2245: AND INVENTORY_ITEM_ID = ');
2246: fnd_dsql.add_bind(pOld_name);
2247: fnd_dsql.add_text(' ))');

Line 2246: fnd_dsql.add_bind(pOld_name);

2242: IF (pReplace_type = 'INGREDIENT') THEN
2243: fnd_dsql.add_text(' SELECT FORMULA_ID FROM FM_MATL_DTL
2244: WHERE LINE_TYPE = -1
2245: AND INVENTORY_ITEM_ID = ');
2246: fnd_dsql.add_bind(pOld_name);
2247: fnd_dsql.add_text(' ))');
2248: ELSIF (pReplace_type = 'ACTIVITY') THEN
2249: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES
2250: WHERE ACTIVITY = ');

Line 2247: fnd_dsql.add_text(' ))');

2243: fnd_dsql.add_text(' SELECT FORMULA_ID FROM FM_MATL_DTL
2244: WHERE LINE_TYPE = -1
2245: AND INVENTORY_ITEM_ID = ');
2246: fnd_dsql.add_bind(pOld_name);
2247: fnd_dsql.add_text(' ))');
2248: ELSIF (pReplace_type = 'ACTIVITY') THEN
2249: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES
2250: WHERE ACTIVITY = ');
2251: fnd_dsql.add_bind(pOld_name);

Line 2249: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES

2245: AND INVENTORY_ITEM_ID = ');
2246: fnd_dsql.add_bind(pOld_name);
2247: fnd_dsql.add_text(' ))');
2248: ELSIF (pReplace_type = 'ACTIVITY') THEN
2249: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES
2250: WHERE ACTIVITY = ');
2251: fnd_dsql.add_bind(pOld_name);
2252: fnd_dsql.add_text(' ))');
2253: ELSIF (pReplace_type = 'RESOURCES') THEN

Line 2251: fnd_dsql.add_bind(pOld_name);

2247: fnd_dsql.add_text(' ))');
2248: ELSIF (pReplace_type = 'ACTIVITY') THEN
2249: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES
2250: WHERE ACTIVITY = ');
2251: fnd_dsql.add_bind(pOld_name);
2252: fnd_dsql.add_text(' ))');
2253: ELSIF (pReplace_type = 'RESOURCES') THEN
2254: fnd_dsql.add_text(' SELECT OPRN_ID
2255: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r

Line 2252: fnd_dsql.add_text(' ))');

2248: ELSIF (pReplace_type = 'ACTIVITY') THEN
2249: fnd_dsql.add_text(' SELECT OPRN_ID FROM GMD_OPERATION_ACTIVITIES
2250: WHERE ACTIVITY = ');
2251: fnd_dsql.add_bind(pOld_name);
2252: fnd_dsql.add_text(' ))');
2253: ELSIF (pReplace_type = 'RESOURCES') THEN
2254: fnd_dsql.add_text(' SELECT OPRN_ID
2255: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r
2256: WHERE a.OPRN_LINE_ID = r.OPRN_LINE_ID

Line 2254: fnd_dsql.add_text(' SELECT OPRN_ID

2250: WHERE ACTIVITY = ');
2251: fnd_dsql.add_bind(pOld_name);
2252: fnd_dsql.add_text(' ))');
2253: ELSIF (pReplace_type = 'RESOURCES') THEN
2254: fnd_dsql.add_text(' SELECT OPRN_ID
2255: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r
2256: WHERE a.OPRN_LINE_ID = r.OPRN_LINE_ID
2257: AND r.RESOURCES = ');
2258: fnd_dsql.add_bind(pOld_name);

Line 2258: fnd_dsql.add_bind(pOld_name);

2254: fnd_dsql.add_text(' SELECT OPRN_ID
2255: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r
2256: WHERE a.OPRN_LINE_ID = r.OPRN_LINE_ID
2257: AND r.RESOURCES = ');
2258: fnd_dsql.add_bind(pOld_name);
2259: fnd_dsql.add_text(' ))');
2260: ELSIF ((pObject_type = 'ROUTING') AND (pReplace_type = 'OPRN_ID'))THEN
2261: fnd_dsql.add_text(' SELECT ROUTING_ID
2262: FROM FM_ROUT_DTL

Line 2259: fnd_dsql.add_text(' ))');

2255: FROM GMD_OPERATION_ACTIVITIES a, GMD_OPERATION_RESOURCES r
2256: WHERE a.OPRN_LINE_ID = r.OPRN_LINE_ID
2257: AND r.RESOURCES = ');
2258: fnd_dsql.add_bind(pOld_name);
2259: fnd_dsql.add_text(' ))');
2260: ELSIF ((pObject_type = 'ROUTING') AND (pReplace_type = 'OPRN_ID'))THEN
2261: fnd_dsql.add_text(' SELECT ROUTING_ID
2262: FROM FM_ROUT_DTL
2263: WHERE OPRN_ID = ');

Line 2261: fnd_dsql.add_text(' SELECT ROUTING_ID

2257: AND r.RESOURCES = ');
2258: fnd_dsql.add_bind(pOld_name);
2259: fnd_dsql.add_text(' ))');
2260: ELSIF ((pObject_type = 'ROUTING') AND (pReplace_type = 'OPRN_ID'))THEN
2261: fnd_dsql.add_text(' SELECT ROUTING_ID
2262: FROM FM_ROUT_DTL
2263: WHERE OPRN_ID = ');
2264: fnd_dsql.add_bind(pOld_name);
2265: fnd_dsql.add_text(' ))');

Line 2264: fnd_dsql.add_bind(pOld_name);

2260: ELSIF ((pObject_type = 'ROUTING') AND (pReplace_type = 'OPRN_ID'))THEN
2261: fnd_dsql.add_text(' SELECT ROUTING_ID
2262: FROM FM_ROUT_DTL
2263: WHERE OPRN_ID = ');
2264: fnd_dsql.add_bind(pOld_name);
2265: fnd_dsql.add_text(' ))');
2266: ELSIF ((pObject_type = 'RECIPE') AND (pReplace_type = 'OWNER_ORGANIZATION_ID'))THEN
2267: fnd_dsql.add_text(' SELECT RECIPE_ID
2268: FROM GMD_RECIPES_B

Line 2265: fnd_dsql.add_text(' ))');

2261: fnd_dsql.add_text(' SELECT ROUTING_ID
2262: FROM FM_ROUT_DTL
2263: WHERE OPRN_ID = ');
2264: fnd_dsql.add_bind(pOld_name);
2265: fnd_dsql.add_text(' ))');
2266: ELSIF ((pObject_type = 'RECIPE') AND (pReplace_type = 'OWNER_ORGANIZATION_ID'))THEN
2267: fnd_dsql.add_text(' SELECT RECIPE_ID
2268: FROM GMD_RECIPES_B
2269: WHERE OWNER_ORGANIZATION_ID = ');

Line 2267: fnd_dsql.add_text(' SELECT RECIPE_ID

2263: WHERE OPRN_ID = ');
2264: fnd_dsql.add_bind(pOld_name);
2265: fnd_dsql.add_text(' ))');
2266: ELSIF ((pObject_type = 'RECIPE') AND (pReplace_type = 'OWNER_ORGANIZATION_ID'))THEN
2267: fnd_dsql.add_text(' SELECT RECIPE_ID
2268: FROM GMD_RECIPES_B
2269: WHERE OWNER_ORGANIZATION_ID = ');
2270: fnd_dsql.add_bind(pOld_name);
2271: fnd_dsql.add_text(' ))');

Line 2270: fnd_dsql.add_bind(pOld_name);

2266: ELSIF ((pObject_type = 'RECIPE') AND (pReplace_type = 'OWNER_ORGANIZATION_ID'))THEN
2267: fnd_dsql.add_text(' SELECT RECIPE_ID
2268: FROM GMD_RECIPES_B
2269: WHERE OWNER_ORGANIZATION_ID = ');
2270: fnd_dsql.add_bind(pOld_name);
2271: fnd_dsql.add_text(' ))');
2272: ELSIF ((pObject_type = 'VALIDITY') AND (pReplace_type = 'ORGANIZATION_ID'))THEN
2273: fnd_dsql.add_text(' SELECT recipe_validity_rule_id
2274: FROM GMD_RECIPE_VALIDITY_RULES

Line 2271: fnd_dsql.add_text(' ))');

2267: fnd_dsql.add_text(' SELECT RECIPE_ID
2268: FROM GMD_RECIPES_B
2269: WHERE OWNER_ORGANIZATION_ID = ');
2270: fnd_dsql.add_bind(pOld_name);
2271: fnd_dsql.add_text(' ))');
2272: ELSIF ((pObject_type = 'VALIDITY') AND (pReplace_type = 'ORGANIZATION_ID'))THEN
2273: fnd_dsql.add_text(' SELECT recipe_validity_rule_id
2274: FROM GMD_RECIPE_VALIDITY_RULES
2275: WHERE ORGANIZATION_ID = ');

Line 2273: fnd_dsql.add_text(' SELECT recipe_validity_rule_id

2269: WHERE OWNER_ORGANIZATION_ID = ');
2270: fnd_dsql.add_bind(pOld_name);
2271: fnd_dsql.add_text(' ))');
2272: ELSIF ((pObject_type = 'VALIDITY') AND (pReplace_type = 'ORGANIZATION_ID'))THEN
2273: fnd_dsql.add_text(' SELECT recipe_validity_rule_id
2274: FROM GMD_RECIPE_VALIDITY_RULES
2275: WHERE ORGANIZATION_ID = ');
2276: fnd_dsql.add_bind(pOld_name);
2277: fnd_dsql.add_text(' ))');

Line 2276: fnd_dsql.add_bind(pOld_name);

2272: ELSIF ((pObject_type = 'VALIDITY') AND (pReplace_type = 'ORGANIZATION_ID'))THEN
2273: fnd_dsql.add_text(' SELECT recipe_validity_rule_id
2274: FROM GMD_RECIPE_VALIDITY_RULES
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(' ))');

Line 2277: fnd_dsql.add_text(' ))');

2273: fnd_dsql.add_text(' SELECT recipe_validity_rule_id
2274: FROM GMD_RECIPE_VALIDITY_RULES
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

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(' ))');

Line 2280: fnd_dsql.add_text(' ))');

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(' ))');
2284: END IF;

Line 2282: fnd_dsql.add_bind(pOld_name);

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(' ))');
2284: END IF;
2285:
2286: END IF;

Line 2283: fnd_dsql.add_text(' ))');

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(' ))');
2284: END IF;
2285:
2286: END IF;
2287:

Line 2289: fnd_dsql.set_cursor(l_cursor_id);

2285:
2286: END IF;
2287:
2288: l_cursor_id := dbms_sql.open_cursor;
2289: fnd_dsql.set_cursor(l_cursor_id);
2290: l_dynamic_select := fnd_dsql.get_text(FALSE);
2291:
2292: l_dsql_debug := fnd_dsql.get_text(TRUE);
2293: IF (l_debug = 'Y') THEN

Line 2290: l_dynamic_select := fnd_dsql.get_text(FALSE);

2286: END IF;
2287:
2288: l_cursor_id := dbms_sql.open_cursor;
2289: fnd_dsql.set_cursor(l_cursor_id);
2290: l_dynamic_select := fnd_dsql.get_text(FALSE);
2291:
2292: l_dsql_debug := fnd_dsql.get_text(TRUE);
2293: IF (l_debug = 'Y') THEN
2294: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : l_dsql_debug = '||l_dsql_debug);

Line 2292: l_dsql_debug := fnd_dsql.get_text(TRUE);

2288: l_cursor_id := dbms_sql.open_cursor;
2289: fnd_dsql.set_cursor(l_cursor_id);
2290: l_dynamic_select := fnd_dsql.get_text(FALSE);
2291:
2292: l_dsql_debug := fnd_dsql.get_text(TRUE);
2293: IF (l_debug = 'Y') THEN
2294: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : l_dsql_debug = '||l_dsql_debug);
2295: END IF;
2296:

Line 2298: fnd_dsql.do_binds;

2294: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : l_dsql_debug = '||l_dsql_debug);
2295: END IF;
2296:
2297: dbms_sql.parse(l_cursor_id, l_dynamic_select, dbms_sql.native);
2298: fnd_dsql.do_binds;
2299:
2300: pRows_Processed := dbms_sql.execute(l_cursor_id);
2301:
2302: IF (l_debug = 'Y') THEN