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.QA_PARENT_CHILD_PKG dependencies on FND_DSQL

Line 1177: -- Uses FND_DSQL package for the case of unknown number of binds.

1173: END enable_fire_for_coll_id;
1174:
1175:
1176: -- Bug 4270911. CU2 SQL Literal fix. TD #18
1177: -- Uses FND_DSQL package for the case of unknown number of binds.
1178: -- srhariha. Fri Apr 15 06:40:15 PDT 2005.
1179:
1180: FUNCTION find_parent(p_child_plan_id IN NUMBER,
1181: p_child_collection_id IN NUMBER,

Line 1268: -- Use fnd_dsql package.

1264:
1265: CLOSE plan_cursor;
1266:
1267: -- Bug 4270911. CU2 SQL Literal fix.
1268: -- Use fnd_dsql package.
1269: -- srhariha. Fri Apr 15 06:22:04 PDT 2005.
1270:
1271: select_clause := ' SELECT 1, plan_id, collection_id, occurrence ';
1272: fnd_dsql.init;

Line 1272: fnd_dsql.init;

1268: -- Use fnd_dsql package.
1269: -- srhariha. Fri Apr 15 06:22:04 PDT 2005.
1270:
1271: select_clause := ' SELECT 1, plan_id, collection_id, occurrence ';
1272: fnd_dsql.init;
1273: fnd_dsql.add_text(select_clause || from_clause || ' ');
1274: fnd_dsql.add_text(' WHERE plan_id =');
1275: fnd_dsql.add_bind(l_parent_plan_id);
1276: fnd_dsql.add_text(' ');

Line 1273: fnd_dsql.add_text(select_clause || from_clause || ' ');

1269: -- srhariha. Fri Apr 15 06:22:04 PDT 2005.
1270:
1271: select_clause := ' SELECT 1, plan_id, collection_id, occurrence ';
1272: fnd_dsql.init;
1273: fnd_dsql.add_text(select_clause || from_clause || ' ');
1274: fnd_dsql.add_text(' WHERE plan_id =');
1275: fnd_dsql.add_bind(l_parent_plan_id);
1276: fnd_dsql.add_text(' ');
1277:

Line 1274: fnd_dsql.add_text(' WHERE plan_id =');

1270:
1271: select_clause := ' SELECT 1, plan_id, collection_id, occurrence ';
1272: fnd_dsql.init;
1273: fnd_dsql.add_text(select_clause || from_clause || ' ');
1274: fnd_dsql.add_text(' WHERE plan_id =');
1275: fnd_dsql.add_bind(l_parent_plan_id);
1276: fnd_dsql.add_text(' ');
1277:
1278: -- parent_where_clause := ' WHERE plan_id = ' || parent_plan_id ;

Line 1275: fnd_dsql.add_bind(l_parent_plan_id);

1271: select_clause := ' SELECT 1, plan_id, collection_id, occurrence ';
1272: fnd_dsql.init;
1273: fnd_dsql.add_text(select_clause || from_clause || ' ');
1274: fnd_dsql.add_text(' WHERE plan_id =');
1275: fnd_dsql.add_bind(l_parent_plan_id);
1276: fnd_dsql.add_text(' ');
1277:
1278: -- parent_where_clause := ' WHERE plan_id = ' || parent_plan_id ;
1279:

Line 1276: fnd_dsql.add_text(' ');

1272: fnd_dsql.init;
1273: fnd_dsql.add_text(select_clause || from_clause || ' ');
1274: fnd_dsql.add_text(' WHERE plan_id =');
1275: fnd_dsql.add_bind(l_parent_plan_id);
1276: fnd_dsql.add_text(' ');
1277:
1278: -- parent_where_clause := ' WHERE plan_id = ' || parent_plan_id ;
1279:
1280: -- get all the child plan elements which has relationship

Line 1302: fnd_dsql.add_text(' AND ' || ele_rec.parent_database_column || ' IS NULL ');

1298:
1299: IF l_res_value IS NULL THEN
1300: --parent_where_clause := parent_where_clause || ' AND ' ||
1301: -- ele_rec.parent_database_column || ' IS NULL';
1302: fnd_dsql.add_text(' AND ' || ele_rec.parent_database_column || ' IS NULL ');
1303: ELSE
1304: /* rkaza 06/04/2002. Bug 2302554. Enclosing l_res_value with single quotes. */
1305: -- parent_where_clause := parent_where_clause || ' AND ' ||
1306: -- ele_rec.parent_database_column || ' = ' || '''' || qa_core_pkg.dequote(l_res_value) || '''';

Line 1308: fnd_dsql.add_text(' AND ' || ele_rec.parent_database_column || ' = ');

1304: /* rkaza 06/04/2002. Bug 2302554. Enclosing l_res_value with single quotes. */
1305: -- parent_where_clause := parent_where_clause || ' AND ' ||
1306: -- ele_rec.parent_database_column || ' = ' || '''' || qa_core_pkg.dequote(l_res_value) || '''';
1307:
1308: fnd_dsql.add_text(' AND ' || ele_rec.parent_database_column || ' = ');
1309: fnd_dsql.add_bind(l_res_value);
1310: fnd_dsql.add_text(' ');
1311: END IF;
1312:

Line 1309: fnd_dsql.add_bind(l_res_value);

1305: -- parent_where_clause := parent_where_clause || ' AND ' ||
1306: -- ele_rec.parent_database_column || ' = ' || '''' || qa_core_pkg.dequote(l_res_value) || '''';
1307:
1308: fnd_dsql.add_text(' AND ' || ele_rec.parent_database_column || ' = ');
1309: fnd_dsql.add_bind(l_res_value);
1310: fnd_dsql.add_text(' ');
1311: END IF;
1312:
1313: END LOOP;

Line 1310: fnd_dsql.add_text(' ');

1306: -- ele_rec.parent_database_column || ' = ' || '''' || qa_core_pkg.dequote(l_res_value) || '''';
1307:
1308: fnd_dsql.add_text(' AND ' || ele_rec.parent_database_column || ' = ');
1309: fnd_dsql.add_bind(l_res_value);
1310: fnd_dsql.add_text(' ');
1311: END IF;
1312:
1313: END LOOP;
1314:

Line 1317: fnd_dsql.add_text(' AND ROWNUM = 1 ');

1313: END LOOP;
1314:
1315: --Necessary to say rownum=1 to avoid multiple rows
1316: -- parent_where_clause := parent_where_clause || ' AND ROWNUM = 1 ';
1317: fnd_dsql.add_text(' AND ROWNUM = 1 ');
1318:
1319: -- query_clause := select_clause || from_clause || parent_where_clause;
1320:
1321: -- OPEN res_cur FOR query_clause USING l_parent_plan_id;

Line 1328: fnd_dsql.set_cursor(cursor_handle);

1324: -- CLOSE res_cur;
1325:
1326:
1327: cursor_handle := dbms_sql.open_cursor;
1328: fnd_dsql.set_cursor(cursor_handle);
1329:
1330: query_clause := fnd_dsql.get_text;
1331: dbms_sql.parse(cursor_handle,query_clause,dbms_sql.NATIVE);
1332: fnd_dsql.do_binds;

Line 1330: query_clause := fnd_dsql.get_text;

1326:
1327: cursor_handle := dbms_sql.open_cursor;
1328: fnd_dsql.set_cursor(cursor_handle);
1329:
1330: query_clause := fnd_dsql.get_text;
1331: dbms_sql.parse(cursor_handle,query_clause,dbms_sql.NATIVE);
1332: fnd_dsql.do_binds;
1333:
1334: dbms_sql.define_column(cursor_handle,1,l_temp_var);

Line 1332: fnd_dsql.do_binds;

1328: fnd_dsql.set_cursor(cursor_handle);
1329:
1330: query_clause := fnd_dsql.get_text;
1331: dbms_sql.parse(cursor_handle,query_clause,dbms_sql.NATIVE);
1332: fnd_dsql.do_binds;
1333:
1334: dbms_sql.define_column(cursor_handle,1,l_temp_var);
1335: dbms_sql.define_column(cursor_handle,2,x_parent_plan_id);
1336: dbms_sql.define_column(cursor_handle,3,x_parent_collection_id);