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 1250: -- Uses FND_DSQL package for the case of unknown number of binds.

1246: END enable_fire_for_coll_id;
1247:
1248:
1249: -- Bug 4270911. CU2 SQL Literal fix. TD #18
1250: -- Uses FND_DSQL package for the case of unknown number of binds.
1251: -- srhariha. Fri Apr 15 06:40:15 PDT 2005.
1252:
1253: FUNCTION find_parent(p_child_plan_id IN NUMBER,
1254: p_child_collection_id IN NUMBER,

Line 1341: -- Use fnd_dsql package.

1337:
1338: CLOSE plan_cursor;
1339:
1340: -- Bug 4270911. CU2 SQL Literal fix.
1341: -- Use fnd_dsql package.
1342: -- srhariha. Fri Apr 15 06:22:04 PDT 2005.
1343:
1344: select_clause := ' SELECT 1, plan_id, collection_id, occurrence ';
1345: fnd_dsql.init;

Line 1345: fnd_dsql.init;

1341: -- Use fnd_dsql package.
1342: -- srhariha. Fri Apr 15 06:22:04 PDT 2005.
1343:
1344: select_clause := ' SELECT 1, plan_id, collection_id, occurrence ';
1345: fnd_dsql.init;
1346: fnd_dsql.add_text(select_clause || from_clause || ' ');
1347: fnd_dsql.add_text(' WHERE plan_id =');
1348: fnd_dsql.add_bind(l_parent_plan_id);
1349: fnd_dsql.add_text(' ');

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

1342: -- srhariha. Fri Apr 15 06:22:04 PDT 2005.
1343:
1344: select_clause := ' SELECT 1, plan_id, collection_id, occurrence ';
1345: fnd_dsql.init;
1346: fnd_dsql.add_text(select_clause || from_clause || ' ');
1347: fnd_dsql.add_text(' WHERE plan_id =');
1348: fnd_dsql.add_bind(l_parent_plan_id);
1349: fnd_dsql.add_text(' ');
1350:

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

1343:
1344: select_clause := ' SELECT 1, plan_id, collection_id, occurrence ';
1345: fnd_dsql.init;
1346: fnd_dsql.add_text(select_clause || from_clause || ' ');
1347: fnd_dsql.add_text(' WHERE plan_id =');
1348: fnd_dsql.add_bind(l_parent_plan_id);
1349: fnd_dsql.add_text(' ');
1350:
1351: -- parent_where_clause := ' WHERE plan_id = ' || parent_plan_id ;

Line 1348: fnd_dsql.add_bind(l_parent_plan_id);

1344: select_clause := ' SELECT 1, plan_id, collection_id, occurrence ';
1345: fnd_dsql.init;
1346: fnd_dsql.add_text(select_clause || from_clause || ' ');
1347: fnd_dsql.add_text(' WHERE plan_id =');
1348: fnd_dsql.add_bind(l_parent_plan_id);
1349: fnd_dsql.add_text(' ');
1350:
1351: -- parent_where_clause := ' WHERE plan_id = ' || parent_plan_id ;
1352:

Line 1349: fnd_dsql.add_text(' ');

1345: fnd_dsql.init;
1346: fnd_dsql.add_text(select_clause || from_clause || ' ');
1347: fnd_dsql.add_text(' WHERE plan_id =');
1348: fnd_dsql.add_bind(l_parent_plan_id);
1349: fnd_dsql.add_text(' ');
1350:
1351: -- parent_where_clause := ' WHERE plan_id = ' || parent_plan_id ;
1352:
1353: -- get all the child plan elements which has relationship

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

1371:
1372: IF l_res_value IS NULL THEN
1373: --parent_where_clause := parent_where_clause || ' AND ' ||
1374: -- ele_rec.parent_database_column || ' IS NULL';
1375: fnd_dsql.add_text(' AND ' || ele_rec.parent_database_column || ' IS NULL ');
1376: ELSE
1377: /* rkaza 06/04/2002. Bug 2302554. Enclosing l_res_value with single quotes. */
1378: -- parent_where_clause := parent_where_clause || ' AND ' ||
1379: -- ele_rec.parent_database_column || ' = ' || '''' || qa_core_pkg.dequote(l_res_value) || '''';

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

1377: /* rkaza 06/04/2002. Bug 2302554. Enclosing l_res_value with single quotes. */
1378: -- parent_where_clause := parent_where_clause || ' AND ' ||
1379: -- ele_rec.parent_database_column || ' = ' || '''' || qa_core_pkg.dequote(l_res_value) || '''';
1380:
1381: fnd_dsql.add_text(' AND ' || ele_rec.parent_database_column || ' = ');
1382: fnd_dsql.add_bind(l_res_value);
1383: fnd_dsql.add_text(' ');
1384: END IF;
1385:

Line 1382: fnd_dsql.add_bind(l_res_value);

1378: -- parent_where_clause := parent_where_clause || ' AND ' ||
1379: -- ele_rec.parent_database_column || ' = ' || '''' || qa_core_pkg.dequote(l_res_value) || '''';
1380:
1381: fnd_dsql.add_text(' AND ' || ele_rec.parent_database_column || ' = ');
1382: fnd_dsql.add_bind(l_res_value);
1383: fnd_dsql.add_text(' ');
1384: END IF;
1385:
1386: END LOOP;

Line 1383: fnd_dsql.add_text(' ');

1379: -- ele_rec.parent_database_column || ' = ' || '''' || qa_core_pkg.dequote(l_res_value) || '''';
1380:
1381: fnd_dsql.add_text(' AND ' || ele_rec.parent_database_column || ' = ');
1382: fnd_dsql.add_bind(l_res_value);
1383: fnd_dsql.add_text(' ');
1384: END IF;
1385:
1386: END LOOP;
1387:

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

1386: END LOOP;
1387:
1388: --Necessary to say rownum=1 to avoid multiple rows
1389: -- parent_where_clause := parent_where_clause || ' AND ROWNUM = 1 ';
1390: fnd_dsql.add_text(' AND ROWNUM = 1 ');
1391:
1392: -- query_clause := select_clause || from_clause || parent_where_clause;
1393:
1394: -- OPEN res_cur FOR query_clause USING l_parent_plan_id;

Line 1401: fnd_dsql.set_cursor(cursor_handle);

1397: -- CLOSE res_cur;
1398:
1399:
1400: cursor_handle := dbms_sql.open_cursor;
1401: fnd_dsql.set_cursor(cursor_handle);
1402:
1403: query_clause := fnd_dsql.get_text;
1404: dbms_sql.parse(cursor_handle,query_clause,dbms_sql.NATIVE);
1405: fnd_dsql.do_binds;

Line 1403: query_clause := fnd_dsql.get_text;

1399:
1400: cursor_handle := dbms_sql.open_cursor;
1401: fnd_dsql.set_cursor(cursor_handle);
1402:
1403: query_clause := fnd_dsql.get_text;
1404: dbms_sql.parse(cursor_handle,query_clause,dbms_sql.NATIVE);
1405: fnd_dsql.do_binds;
1406:
1407: dbms_sql.define_column(cursor_handle,1,l_temp_var);

Line 1405: fnd_dsql.do_binds;

1401: fnd_dsql.set_cursor(cursor_handle);
1402:
1403: query_clause := fnd_dsql.get_text;
1404: dbms_sql.parse(cursor_handle,query_clause,dbms_sql.NATIVE);
1405: fnd_dsql.do_binds;
1406:
1407: dbms_sql.define_column(cursor_handle,1,l_temp_var);
1408: dbms_sql.define_column(cursor_handle,2,x_parent_plan_id);
1409: dbms_sql.define_column(cursor_handle,3,x_parent_collection_id);