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 DBMS_SQL

Line 200: x_plan_ids OUT NOCOPY dbms_sql.number_table,

196: FUNCTION get_descendants(
197: p_plan_id NUMBER,
198: p_collection_id NUMBER,
199: p_occurrence NUMBER,
200: x_plan_ids OUT NOCOPY dbms_sql.number_table,
201: x_collection_ids OUT NOCOPY dbms_sql.number_table,
202: x_occurrences OUT NOCOPY dbms_sql.number_table) RETURN VARCHAR2 IS
203:
204: ---

Line 201: x_collection_ids OUT NOCOPY dbms_sql.number_table,

197: p_plan_id NUMBER,
198: p_collection_id NUMBER,
199: p_occurrence NUMBER,
200: x_plan_ids OUT NOCOPY dbms_sql.number_table,
201: x_collection_ids OUT NOCOPY dbms_sql.number_table,
202: x_occurrences OUT NOCOPY dbms_sql.number_table) RETURN VARCHAR2 IS
203:
204: ---
205: --- Given a parent record (plan/collection/occurrence), this procedure finds all the child and

Line 202: x_occurrences OUT NOCOPY dbms_sql.number_table) RETURN VARCHAR2 IS

198: p_collection_id NUMBER,
199: p_occurrence NUMBER,
200: x_plan_ids OUT NOCOPY dbms_sql.number_table,
201: x_collection_ids OUT NOCOPY dbms_sql.number_table,
202: x_occurrences OUT NOCOPY dbms_sql.number_table) RETURN VARCHAR2 IS
203:
204: ---
205: --- Given a parent record (plan/collection/occurrence), this procedure finds all the child and
206: --- grandchildren records (therefore, descendants) of the record. These are returned in the

Line 1089: x_plan_ids OUT NOCOPY dbms_sql.number_table,

1085: FUNCTION get_disabled_descendants(p_plan_id NUMBER,
1086: p_collection_id NUMBER,
1087: p_occurrence NUMBER,
1088: --p_enabled NUMBER,
1089: x_plan_ids OUT NOCOPY dbms_sql.number_table,
1090: x_collection_ids OUT NOCOPY dbms_sql.number_table,
1091: x_occurrences OUT NOCOPY dbms_sql.number_table)
1092: RETURN VARCHAR2 IS
1093: ---

Line 1090: x_collection_ids OUT NOCOPY dbms_sql.number_table,

1086: p_collection_id NUMBER,
1087: p_occurrence NUMBER,
1088: --p_enabled NUMBER,
1089: x_plan_ids OUT NOCOPY dbms_sql.number_table,
1090: x_collection_ids OUT NOCOPY dbms_sql.number_table,
1091: x_occurrences OUT NOCOPY dbms_sql.number_table)
1092: RETURN VARCHAR2 IS
1093: ---
1094: --- This function is similar to get_descendants above with one difference

Line 1091: x_occurrences OUT NOCOPY dbms_sql.number_table)

1087: p_occurrence NUMBER,
1088: --p_enabled NUMBER,
1089: x_plan_ids OUT NOCOPY dbms_sql.number_table,
1090: x_collection_ids OUT NOCOPY dbms_sql.number_table,
1091: x_occurrences OUT NOCOPY dbms_sql.number_table)
1092: RETURN VARCHAR2 IS
1093: ---
1094: --- This function is similar to get_descendants above with one difference
1095: --- it looks for all disabled records .

Line 1129: PROCEDURE delete_child_rows(p_plan_ids IN dbms_sql.number_table,

1125: END IF;
1126:
1127: END;
1128:
1129: PROCEDURE delete_child_rows(p_plan_ids IN dbms_sql.number_table,
1130: p_collection_ids IN dbms_sql.number_table,
1131: p_occurrences IN dbms_sql.number_table,
1132: p_parent_plan_id NUMBER ,
1133: p_parent_collection_id NUMBER ,

Line 1130: p_collection_ids IN dbms_sql.number_table,

1126:
1127: END;
1128:
1129: PROCEDURE delete_child_rows(p_plan_ids IN dbms_sql.number_table,
1130: p_collection_ids IN dbms_sql.number_table,
1131: p_occurrences IN dbms_sql.number_table,
1132: p_parent_plan_id NUMBER ,
1133: p_parent_collection_id NUMBER ,
1134: p_parent_occurrence NUMBER ,

Line 1131: p_occurrences IN dbms_sql.number_table,

1127: END;
1128:
1129: PROCEDURE delete_child_rows(p_plan_ids IN dbms_sql.number_table,
1130: p_collection_ids IN dbms_sql.number_table,
1131: p_occurrences IN dbms_sql.number_table,
1132: p_parent_plan_id NUMBER ,
1133: p_parent_collection_id NUMBER ,
1134: p_parent_occurrence NUMBER ,
1135: p_enabled_flag VARCHAR2)

Line 1400: cursor_handle := dbms_sql.open_cursor;

1396: -- x_parent_collection_id, x_parent_occurrence;
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);

Line 1404: dbms_sql.parse(cursor_handle,query_clause,dbms_sql.NATIVE);

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);
1408: dbms_sql.define_column(cursor_handle,2,x_parent_plan_id);

Line 1407: dbms_sql.define_column(cursor_handle,1,l_temp_var);

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);
1410: dbms_sql.define_column(cursor_handle,4,x_parent_occurrence);
1411:

Line 1408: dbms_sql.define_column(cursor_handle,2,x_parent_plan_id);

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);
1410: dbms_sql.define_column(cursor_handle,4,x_parent_occurrence);
1411:
1412: no_of_rows := dbms_sql.execute(cursor_handle);

Line 1409: dbms_sql.define_column(cursor_handle,3,x_parent_collection_id);

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);
1410: dbms_sql.define_column(cursor_handle,4,x_parent_occurrence);
1411:
1412: no_of_rows := dbms_sql.execute(cursor_handle);
1413:

Line 1410: dbms_sql.define_column(cursor_handle,4,x_parent_occurrence);

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);
1410: dbms_sql.define_column(cursor_handle,4,x_parent_occurrence);
1411:
1412: no_of_rows := dbms_sql.execute(cursor_handle);
1413:
1414: no_of_rows := dbms_sql.fetch_rows(cursor_handle);

Line 1412: no_of_rows := dbms_sql.execute(cursor_handle);

1408: dbms_sql.define_column(cursor_handle,2,x_parent_plan_id);
1409: dbms_sql.define_column(cursor_handle,3,x_parent_collection_id);
1410: dbms_sql.define_column(cursor_handle,4,x_parent_occurrence);
1411:
1412: no_of_rows := dbms_sql.execute(cursor_handle);
1413:
1414: no_of_rows := dbms_sql.fetch_rows(cursor_handle);
1415:
1416: l_temp_var := 0;

Line 1414: no_of_rows := dbms_sql.fetch_rows(cursor_handle);

1410: dbms_sql.define_column(cursor_handle,4,x_parent_occurrence);
1411:
1412: no_of_rows := dbms_sql.execute(cursor_handle);
1413:
1414: no_of_rows := dbms_sql.fetch_rows(cursor_handle);
1415:
1416: l_temp_var := 0;
1417: IF (no_of_rows > 0) THEN
1418: dbms_sql.column_value(cursor_handle,1,l_temp_var);

Line 1418: dbms_sql.column_value(cursor_handle,1,l_temp_var);

1414: no_of_rows := dbms_sql.fetch_rows(cursor_handle);
1415:
1416: l_temp_var := 0;
1417: IF (no_of_rows > 0) THEN
1418: dbms_sql.column_value(cursor_handle,1,l_temp_var);
1419: dbms_sql.column_value(cursor_handle,2,x_parent_plan_id);
1420: dbms_sql.column_value(cursor_handle,3,x_parent_collection_id);
1421: dbms_sql.column_value(cursor_handle,4,x_parent_occurrence);
1422:

Line 1419: dbms_sql.column_value(cursor_handle,2,x_parent_plan_id);

1415:
1416: l_temp_var := 0;
1417: IF (no_of_rows > 0) THEN
1418: dbms_sql.column_value(cursor_handle,1,l_temp_var);
1419: dbms_sql.column_value(cursor_handle,2,x_parent_plan_id);
1420: dbms_sql.column_value(cursor_handle,3,x_parent_collection_id);
1421: dbms_sql.column_value(cursor_handle,4,x_parent_occurrence);
1422:
1423:

Line 1420: dbms_sql.column_value(cursor_handle,3,x_parent_collection_id);

1416: l_temp_var := 0;
1417: IF (no_of_rows > 0) THEN
1418: dbms_sql.column_value(cursor_handle,1,l_temp_var);
1419: dbms_sql.column_value(cursor_handle,2,x_parent_plan_id);
1420: dbms_sql.column_value(cursor_handle,3,x_parent_collection_id);
1421: dbms_sql.column_value(cursor_handle,4,x_parent_occurrence);
1422:
1423:
1424: END IF;

Line 1421: dbms_sql.column_value(cursor_handle,4,x_parent_occurrence);

1417: IF (no_of_rows > 0) THEN
1418: dbms_sql.column_value(cursor_handle,1,l_temp_var);
1419: dbms_sql.column_value(cursor_handle,2,x_parent_plan_id);
1420: dbms_sql.column_value(cursor_handle,3,x_parent_collection_id);
1421: dbms_sql.column_value(cursor_handle,4,x_parent_occurrence);
1422:
1423:
1424: END IF;
1425:

Line 1426: dbms_sql.close_cursor(cursor_handle);

1422:
1423:
1424: END IF;
1425:
1426: dbms_sql.close_cursor(cursor_handle);
1427:
1428: IF (l_temp_var = 1) THEN
1429: RETURN 'T';
1430: ELSE

Line 2485: -- and execute using DBMS_SQL.execute. kabalakr

2481: -- scenarios.
2482:
2483: -- Bug 2976810. Instead of the literal value concatenation and execution using
2484: -- EXECUTE IMMEDIATE, we'll pack these values into an array, bind them and
2485: -- and execute using DBMS_SQL.execute. kabalakr
2486:
2487: -- l_update_clause := l_update_clause || cur_rec.child_database_column ||
2488: -- ' = ' || ''''||qa_core_pkg.dequote(l_value) ||'''';
2489:

Line 2594: c1 := dbms_sql.open_cursor;

2590: || ' AND occurrence= :p_child_occurrence';
2591:
2592: BEGIN
2593:
2594: c1 := dbms_sql.open_cursor;
2595: dbms_sql.parse(c1, l_update_clause, dbms_sql.native);
2596:
2597: l_var := l_bind_var.FIRST;
2598:

Line 2595: dbms_sql.parse(c1, l_update_clause, dbms_sql.native);

2591:
2592: BEGIN
2593:
2594: c1 := dbms_sql.open_cursor;
2595: dbms_sql.parse(c1, l_update_clause, dbms_sql.native);
2596:
2597: l_var := l_bind_var.FIRST;
2598:
2599: WHILE (l_var IS NOT NULL) LOOP

Line 2608: -- dbms_sql.bind_variable(c1, ':' || to_char(l_var), l_bind_var(l_var));

2604: -- will have 2 fields and we are interested
2605: -- only in the value field.
2606: -- skolluku Sun Oct 14 03:26:31 PDT 2007
2607: --
2608: -- dbms_sql.bind_variable(c1, ':' || to_char(l_var), l_bind_var(l_var));
2609: dbms_sql.bind_variable(c1, ':' || to_char(l_var), l_bind_var(l_var).value);
2610: l_var := l_bind_var.NEXT(l_var);
2611: END LOOP;
2612:

Line 2609: dbms_sql.bind_variable(c1, ':' || to_char(l_var), l_bind_var(l_var).value);

2605: -- only in the value field.
2606: -- skolluku Sun Oct 14 03:26:31 PDT 2007
2607: --
2608: -- dbms_sql.bind_variable(c1, ':' || to_char(l_var), l_bind_var(l_var));
2609: dbms_sql.bind_variable(c1, ':' || to_char(l_var), l_bind_var(l_var).value);
2610: l_var := l_bind_var.NEXT(l_var);
2611: END LOOP;
2612:
2613: dbms_sql.bind_variable(c1, ':p_child_plan_id', p_child_plan_id);

Line 2613: dbms_sql.bind_variable(c1, ':p_child_plan_id', p_child_plan_id);

2609: dbms_sql.bind_variable(c1, ':' || to_char(l_var), l_bind_var(l_var).value);
2610: l_var := l_bind_var.NEXT(l_var);
2611: END LOOP;
2612:
2613: dbms_sql.bind_variable(c1, ':p_child_plan_id', p_child_plan_id);
2614: dbms_sql.bind_variable(c1, ':p_child_collection_id', p_child_collection_id);
2615: dbms_sql.bind_variable(c1, ':p_child_occurrence', p_child_occurrence);
2616:
2617: ignore := dbms_sql.execute(c1);

Line 2614: dbms_sql.bind_variable(c1, ':p_child_collection_id', p_child_collection_id);

2610: l_var := l_bind_var.NEXT(l_var);
2611: END LOOP;
2612:
2613: dbms_sql.bind_variable(c1, ':p_child_plan_id', p_child_plan_id);
2614: dbms_sql.bind_variable(c1, ':p_child_collection_id', p_child_collection_id);
2615: dbms_sql.bind_variable(c1, ':p_child_occurrence', p_child_occurrence);
2616:
2617: ignore := dbms_sql.execute(c1);
2618:

Line 2615: dbms_sql.bind_variable(c1, ':p_child_occurrence', p_child_occurrence);

2611: END LOOP;
2612:
2613: dbms_sql.bind_variable(c1, ':p_child_plan_id', p_child_plan_id);
2614: dbms_sql.bind_variable(c1, ':p_child_collection_id', p_child_collection_id);
2615: dbms_sql.bind_variable(c1, ':p_child_occurrence', p_child_occurrence);
2616:
2617: ignore := dbms_sql.execute(c1);
2618:
2619: --bug# 5510747 shkalyan. Added close cursor

Line 2617: ignore := dbms_sql.execute(c1);

2613: dbms_sql.bind_variable(c1, ':p_child_plan_id', p_child_plan_id);
2614: dbms_sql.bind_variable(c1, ':p_child_collection_id', p_child_collection_id);
2615: dbms_sql.bind_variable(c1, ':p_child_occurrence', p_child_occurrence);
2616:
2617: ignore := dbms_sql.execute(c1);
2618:
2619: --bug# 5510747 shkalyan. Added close cursor
2620: dbms_sql.close_cursor(c1);
2621:

Line 2620: dbms_sql.close_cursor(c1);

2616:
2617: ignore := dbms_sql.execute(c1);
2618:
2619: --bug# 5510747 shkalyan. Added close cursor
2620: dbms_sql.close_cursor(c1);
2621:
2622: EXCEPTION
2623: WHEN OTHERS THEN
2624: --

Line 2630: IF dbms_sql.is_open(c1)

2626: -- The cursor c1 was not being closed in case of error during processing the records. Doing
2627: -- that now.
2628: -- ntungare Sun Oct 16 21:38:29 PDT 2005
2629: --
2630: IF dbms_sql.is_open(c1)
2631: THEN
2632: dbms_sql.close_cursor(c1);
2633: END IF;
2634: RETURN 'F';

Line 2632: dbms_sql.close_cursor(c1);

2628: -- ntungare Sun Oct 16 21:38:29 PDT 2005
2629: --
2630: IF dbms_sql.is_open(c1)
2631: THEN
2632: dbms_sql.close_cursor(c1);
2633: END IF;
2634: RETURN 'F';
2635: END;
2636: Return 'T';

Line 4226: p_rc DBMS_SQL.VARCHAR2_TABLE;

4222: qprc.element_relationship_type = 1 and
4223: parent_enabled_flag = 1 and
4224: child_enabled_flag = 1;
4225:
4226: p_rc DBMS_SQL.VARCHAR2_TABLE;
4227: c_rc DBMS_SQL.VARCHAR2_TABLE;
4228:
4229:
4230: BEGIN

Line 4227: c_rc DBMS_SQL.VARCHAR2_TABLE;

4223: parent_enabled_flag = 1 and
4224: child_enabled_flag = 1;
4225:
4226: p_rc DBMS_SQL.VARCHAR2_TABLE;
4227: c_rc DBMS_SQL.VARCHAR2_TABLE;
4228:
4229:
4230: BEGIN
4231:

Line 4484: x_parent_plan_ids OUT NOCOPY dbms_sql.number_table,

4480: -- for a given child plan and does not retrun child itself.
4481: FUNCTION get_ancestors( p_child_plan_id IN NUMBER,
4482: p_child_occurrence IN NUMBER,
4483: p_child_collection_id IN NUMBER,
4484: x_parent_plan_ids OUT NOCOPY dbms_sql.number_table,
4485: x_parent_collection_ids OUT NOCOPY dbms_sql.number_table,
4486: x_parent_occurrences OUT NOCOPY dbms_sql.number_table)
4487: RETURN VARCHAR2
4488: IS

Line 4485: x_parent_collection_ids OUT NOCOPY dbms_sql.number_table,

4481: FUNCTION get_ancestors( p_child_plan_id IN NUMBER,
4482: p_child_occurrence IN NUMBER,
4483: p_child_collection_id IN NUMBER,
4484: x_parent_plan_ids OUT NOCOPY dbms_sql.number_table,
4485: x_parent_collection_ids OUT NOCOPY dbms_sql.number_table,
4486: x_parent_occurrences OUT NOCOPY dbms_sql.number_table)
4487: RETURN VARCHAR2
4488: IS
4489:

Line 4486: x_parent_occurrences OUT NOCOPY dbms_sql.number_table)

4482: p_child_occurrence IN NUMBER,
4483: p_child_collection_id IN NUMBER,
4484: x_parent_plan_ids OUT NOCOPY dbms_sql.number_table,
4485: x_parent_collection_ids OUT NOCOPY dbms_sql.number_table,
4486: x_parent_occurrences OUT NOCOPY dbms_sql.number_table)
4487: RETURN VARCHAR2
4488: IS
4489:
4490: BEGIN

Line 4531: l_parent_plan_id_tab DBMS_SQL.NUMBER_TABLE;

4527: PROCEDURE update_all_ancestors(p_parent_plan_id IN NUMBER,
4528: p_parent_collection_id IN NUMBER,
4529: p_parent_occurrence IN NUMBER) IS
4530:
4531: l_parent_plan_id_tab DBMS_SQL.NUMBER_TABLE;
4532: l_parent_collection_id_tab DBMS_SQL.NUMBER_TABLE;
4533: l_parent_occurrence_tab DBMS_SQL.NUMBER_TABLE;
4534:
4535: l_current_child_planid NUMBER;

Line 4532: l_parent_collection_id_tab DBMS_SQL.NUMBER_TABLE;

4528: p_parent_collection_id IN NUMBER,
4529: p_parent_occurrence IN NUMBER) IS
4530:
4531: l_parent_plan_id_tab DBMS_SQL.NUMBER_TABLE;
4532: l_parent_collection_id_tab DBMS_SQL.NUMBER_TABLE;
4533: l_parent_occurrence_tab DBMS_SQL.NUMBER_TABLE;
4534:
4535: l_current_child_planid NUMBER;
4536: l_current_child_collid NUMBER;

Line 4533: l_parent_occurrence_tab DBMS_SQL.NUMBER_TABLE;

4529: p_parent_occurrence IN NUMBER) IS
4530:
4531: l_parent_plan_id_tab DBMS_SQL.NUMBER_TABLE;
4532: l_parent_collection_id_tab DBMS_SQL.NUMBER_TABLE;
4533: l_parent_occurrence_tab DBMS_SQL.NUMBER_TABLE;
4534:
4535: l_current_child_planid NUMBER;
4536: l_current_child_collid NUMBER;
4537: l_current_child_occrid NUMBER;