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.AHL_PRD_WO_PUB dependencies on DBMS_SQL

Line 1294: source_cursor := DBMS_sql.open_cursor;

1290: IF(l_plan_id IS NOT NULL AND l_collection_id IS NOT NULL)THEN
1291: x_QaResults.PlanId := l_plan_id;
1292: x_QaResults.CollectionId := l_collection_id;
1293: l_results_sql_str := get_qa_sql_str(l_plan_id);
1294: source_cursor := DBMS_sql.open_cursor;
1295: DBMS_SQL.parse(source_cursor,l_results_sql_str,DBMS_SQL.native);
1296: DBMS_SQL.BIND_VARIABLE(source_cursor, ':1', l_collection_id);
1297: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_occurence);
1298:

Line 1295: DBMS_SQL.parse(source_cursor,l_results_sql_str,DBMS_SQL.native);

1291: x_QaResults.PlanId := l_plan_id;
1292: x_QaResults.CollectionId := l_collection_id;
1293: l_results_sql_str := get_qa_sql_str(l_plan_id);
1294: source_cursor := DBMS_sql.open_cursor;
1295: DBMS_SQL.parse(source_cursor,l_results_sql_str,DBMS_SQL.native);
1296: DBMS_SQL.BIND_VARIABLE(source_cursor, ':1', l_collection_id);
1297: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_occurence);
1298:
1299: FOR i IN x_QaPlan.QA_PLAN_ATR_TBL.FIRST..x_QaPlan.QA_PLAN_ATR_TBL.LAST LOOP

Line 1296: DBMS_SQL.BIND_VARIABLE(source_cursor, ':1', l_collection_id);

1292: x_QaResults.CollectionId := l_collection_id;
1293: l_results_sql_str := get_qa_sql_str(l_plan_id);
1294: source_cursor := DBMS_sql.open_cursor;
1295: DBMS_SQL.parse(source_cursor,l_results_sql_str,DBMS_SQL.native);
1296: DBMS_SQL.BIND_VARIABLE(source_cursor, ':1', l_collection_id);
1297: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_occurence);
1298:
1299: FOR i IN x_QaPlan.QA_PLAN_ATR_TBL.FIRST..x_QaPlan.QA_PLAN_ATR_TBL.LAST LOOP
1300: DBMS_SQL.DEFINE_COLUMN(source_cursor, i+2, l_temp,4000);

Line 1297: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_occurence);

1293: l_results_sql_str := get_qa_sql_str(l_plan_id);
1294: source_cursor := DBMS_sql.open_cursor;
1295: DBMS_SQL.parse(source_cursor,l_results_sql_str,DBMS_SQL.native);
1296: DBMS_SQL.BIND_VARIABLE(source_cursor, ':1', l_collection_id);
1297: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_occurence);
1298:
1299: FOR i IN x_QaPlan.QA_PLAN_ATR_TBL.FIRST..x_QaPlan.QA_PLAN_ATR_TBL.LAST LOOP
1300: DBMS_SQL.DEFINE_COLUMN(source_cursor, i+2, l_temp,4000);
1301: END LOOP;

Line 1300: DBMS_SQL.DEFINE_COLUMN(source_cursor, i+2, l_temp,4000);

1296: DBMS_SQL.BIND_VARIABLE(source_cursor, ':1', l_collection_id);
1297: DBMS_SQL.DEFINE_COLUMN(source_cursor, 1, l_occurence);
1298:
1299: FOR i IN x_QaPlan.QA_PLAN_ATR_TBL.FIRST..x_QaPlan.QA_PLAN_ATR_TBL.LAST LOOP
1300: DBMS_SQL.DEFINE_COLUMN(source_cursor, i+2, l_temp,4000);
1301: END LOOP;
1302: dummy := DBMS_SQL.EXECUTE(source_cursor);
1303: l_result_row_index := 0;
1304: LOOP

Line 1302: dummy := DBMS_SQL.EXECUTE(source_cursor);

1298:
1299: FOR i IN x_QaPlan.QA_PLAN_ATR_TBL.FIRST..x_QaPlan.QA_PLAN_ATR_TBL.LAST LOOP
1300: DBMS_SQL.DEFINE_COLUMN(source_cursor, i+2, l_temp,4000);
1301: END LOOP;
1302: dummy := DBMS_SQL.EXECUTE(source_cursor);
1303: l_result_row_index := 0;
1304: LOOP
1305: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
1306:

Line 1305: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN

1301: END LOOP;
1302: dummy := DBMS_SQL.EXECUTE(source_cursor);
1303: l_result_row_index := 0;
1304: LOOP
1305: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
1306:
1307: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_occurence);
1308: x_QaResults.QA_RESULT_TBL(l_result_row_index).Occurence := l_occurence;
1309:

Line 1307: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_occurence);

1303: l_result_row_index := 0;
1304: LOOP
1305: IF DBMS_SQL.FETCH_ROWS(source_cursor)>0 THEN
1306:
1307: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_occurence);
1308: x_QaResults.QA_RESULT_TBL(l_result_row_index).Occurence := l_occurence;
1309:
1310: FOR i IN x_QaPlan.QA_PLAN_ATR_TBL.FIRST..x_QaPlan.QA_PLAN_ATR_TBL.LAST LOOP
1311: DBMS_SQL.COLUMN_VALUE(source_cursor, i+2, l_temp);

Line 1311: DBMS_SQL.COLUMN_VALUE(source_cursor, i+2, l_temp);

1307: DBMS_SQL.COLUMN_VALUE(source_cursor, 1, l_occurence);
1308: x_QaResults.QA_RESULT_TBL(l_result_row_index).Occurence := l_occurence;
1309:
1310: FOR i IN x_QaPlan.QA_PLAN_ATR_TBL.FIRST..x_QaPlan.QA_PLAN_ATR_TBL.LAST LOOP
1311: DBMS_SQL.COLUMN_VALUE(source_cursor, i+2, l_temp);
1312: x_QaResults.QA_RESULT_TBL(l_result_row_index).QA_PLAN_ATRVAL_TBL(i).CharId
1313: := x_QaPlan.QA_PLAN_ATR_TBL(i).CharId;
1314: x_QaResults.QA_RESULT_TBL(l_result_row_index).QA_PLAN_ATRVAL_TBL(i).AttributeValue
1315: := l_temp;