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

Line 1031: cursor_select := DBMS_SQL.OPEN_CURSOR;

1027: END IF; -- If there are any items in subjects or Revised items only then get these roles
1028:
1029: l_index := 0;
1030: --dbms_output.put_line('** sameer ** trying to execute the dynamic SQL for fetching the Inherited roles ... starting l_index from : ' || l_index);
1031: cursor_select := DBMS_SQL.OPEN_CURSOR;
1032: --dbms_output.put_line('** sameer ** opened implicit cursor');
1033: --dbms_output.put_line('** sameer ** query is as follows ....');
1034:
1035: --dbms_output.put_line(query_to_exec);

Line 1038: DBMS_SQL.PARSE(cursor_select, query_to_exec, DBMS_SQL.NATIVE);

1034:
1035: --dbms_output.put_line(query_to_exec);
1036: --p(query_to_exec);
1037: --utl_file_test_write('/home/sdarbha/Enhancements/Sep12', 'querytolog.txt', query_to_exec );
1038: DBMS_SQL.PARSE(cursor_select, query_to_exec, DBMS_SQL.NATIVE);
1039: --dbms_output.put_line('** sameer ** parsed implicit cursor');
1040:
1041: --dbms_output.put_line('** sameer ** defining columns ......');
1042:

Line 1043: dbms_sql.DEFINE_COLUMN(cursor_select, 1, '', 30);

1039: --dbms_output.put_line('** sameer ** parsed implicit cursor');
1040:
1041: --dbms_output.put_line('** sameer ** defining columns ......');
1042:
1043: dbms_sql.DEFINE_COLUMN(cursor_select, 1, '', 30);
1044: dbms_sql.DEFINE_COLUMN(cursor_select, 2, '', 120);
1045: dbms_sql.DEFINE_COLUMN(cursor_select, 3, '', 30);
1046: dbms_sql.DEFINE_COLUMN(cursor_select, 4, '', 120);
1047: dbms_sql.DEFINE_COLUMN(cursor_select, 5, l_temp_menu_id);

Line 1044: dbms_sql.DEFINE_COLUMN(cursor_select, 2, '', 120);

1040:
1041: --dbms_output.put_line('** sameer ** defining columns ......');
1042:
1043: dbms_sql.DEFINE_COLUMN(cursor_select, 1, '', 30);
1044: dbms_sql.DEFINE_COLUMN(cursor_select, 2, '', 120);
1045: dbms_sql.DEFINE_COLUMN(cursor_select, 3, '', 30);
1046: dbms_sql.DEFINE_COLUMN(cursor_select, 4, '', 120);
1047: dbms_sql.DEFINE_COLUMN(cursor_select, 5, l_temp_menu_id);
1048:

Line 1045: dbms_sql.DEFINE_COLUMN(cursor_select, 3, '', 30);

1041: --dbms_output.put_line('** sameer ** defining columns ......');
1042:
1043: dbms_sql.DEFINE_COLUMN(cursor_select, 1, '', 30);
1044: dbms_sql.DEFINE_COLUMN(cursor_select, 2, '', 120);
1045: dbms_sql.DEFINE_COLUMN(cursor_select, 3, '', 30);
1046: dbms_sql.DEFINE_COLUMN(cursor_select, 4, '', 120);
1047: dbms_sql.DEFINE_COLUMN(cursor_select, 5, l_temp_menu_id);
1048:
1049: --dbms_output.put_line('** sameer ** defined columns ......');

Line 1046: dbms_sql.DEFINE_COLUMN(cursor_select, 4, '', 120);

1042:
1043: dbms_sql.DEFINE_COLUMN(cursor_select, 1, '', 30);
1044: dbms_sql.DEFINE_COLUMN(cursor_select, 2, '', 120);
1045: dbms_sql.DEFINE_COLUMN(cursor_select, 3, '', 30);
1046: dbms_sql.DEFINE_COLUMN(cursor_select, 4, '', 120);
1047: dbms_sql.DEFINE_COLUMN(cursor_select, 5, l_temp_menu_id);
1048:
1049: --dbms_output.put_line('** sameer ** defined columns ......');
1050:

Line 1047: dbms_sql.DEFINE_COLUMN(cursor_select, 5, l_temp_menu_id);

1043: dbms_sql.DEFINE_COLUMN(cursor_select, 1, '', 30);
1044: dbms_sql.DEFINE_COLUMN(cursor_select, 2, '', 120);
1045: dbms_sql.DEFINE_COLUMN(cursor_select, 3, '', 30);
1046: dbms_sql.DEFINE_COLUMN(cursor_select, 4, '', 120);
1047: dbms_sql.DEFINE_COLUMN(cursor_select, 5, l_temp_menu_id);
1048:
1049: --dbms_output.put_line('** sameer ** defined columns ......');
1050:
1051: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);

Line 1051: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);

1047: dbms_sql.DEFINE_COLUMN(cursor_select, 5, l_temp_menu_id);
1048:
1049: --dbms_output.put_line('** sameer ** defined columns ......');
1050:
1051: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);
1052:
1053: LOOP
1054: IF dbms_sql.fetch_rows(cursor_select) > 0 THEN
1055: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_grantee_list(l_index).role_name);

Line 1054: IF dbms_sql.fetch_rows(cursor_select) > 0 THEN

1050:
1051: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);
1052:
1053: LOOP
1054: IF dbms_sql.fetch_rows(cursor_select) > 0 THEN
1055: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_grantee_list(l_index).role_name);
1056: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_grantee_list(l_index).role_display_name);
1057: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_grantee_list(l_index).grantee_type);
1058: DBMS_SQL.COLUMN_VALUE(cursor_select, 4, l_grantee_list(l_index).grantee_name);

Line 1055: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_grantee_list(l_index).role_name);

1051: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);
1052:
1053: LOOP
1054: IF dbms_sql.fetch_rows(cursor_select) > 0 THEN
1055: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_grantee_list(l_index).role_name);
1056: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_grantee_list(l_index).role_display_name);
1057: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_grantee_list(l_index).grantee_type);
1058: DBMS_SQL.COLUMN_VALUE(cursor_select, 4, l_grantee_list(l_index).grantee_name);
1059: DBMS_SQL.COLUMN_VALUE(cursor_select, 5, l_temp_menu_id);

Line 1056: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_grantee_list(l_index).role_display_name);

1052:
1053: LOOP
1054: IF dbms_sql.fetch_rows(cursor_select) > 0 THEN
1055: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_grantee_list(l_index).role_name);
1056: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_grantee_list(l_index).role_display_name);
1057: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_grantee_list(l_index).grantee_type);
1058: DBMS_SQL.COLUMN_VALUE(cursor_select, 4, l_grantee_list(l_index).grantee_name);
1059: DBMS_SQL.COLUMN_VALUE(cursor_select, 5, l_temp_menu_id);
1060:

Line 1057: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_grantee_list(l_index).grantee_type);

1053: LOOP
1054: IF dbms_sql.fetch_rows(cursor_select) > 0 THEN
1055: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_grantee_list(l_index).role_name);
1056: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_grantee_list(l_index).role_display_name);
1057: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_grantee_list(l_index).grantee_type);
1058: DBMS_SQL.COLUMN_VALUE(cursor_select, 4, l_grantee_list(l_index).grantee_name);
1059: DBMS_SQL.COLUMN_VALUE(cursor_select, 5, l_temp_menu_id);
1060:
1061: Get_Default_Access(p_menu_id => l_temp_menu_id,

Line 1058: DBMS_SQL.COLUMN_VALUE(cursor_select, 4, l_grantee_list(l_index).grantee_name);

1054: IF dbms_sql.fetch_rows(cursor_select) > 0 THEN
1055: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_grantee_list(l_index).role_name);
1056: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_grantee_list(l_index).role_display_name);
1057: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_grantee_list(l_index).grantee_type);
1058: DBMS_SQL.COLUMN_VALUE(cursor_select, 4, l_grantee_list(l_index).grantee_name);
1059: DBMS_SQL.COLUMN_VALUE(cursor_select, 5, l_temp_menu_id);
1060:
1061: Get_Default_Access(p_menu_id => l_temp_menu_id,
1062: p_default_access => l_default_access

Line 1059: DBMS_SQL.COLUMN_VALUE(cursor_select, 5, l_temp_menu_id);

1055: DBMS_SQL.COLUMN_VALUE(cursor_select, 1, l_grantee_list(l_index).role_name);
1056: DBMS_SQL.COLUMN_VALUE(cursor_select, 2, l_grantee_list(l_index).role_display_name);
1057: DBMS_SQL.COLUMN_VALUE(cursor_select, 3, l_grantee_list(l_index).grantee_type);
1058: DBMS_SQL.COLUMN_VALUE(cursor_select, 4, l_grantee_list(l_index).grantee_name);
1059: DBMS_SQL.COLUMN_VALUE(cursor_select, 5, l_temp_menu_id);
1060:
1061: Get_Default_Access(p_menu_id => l_temp_menu_id,
1062: p_default_access => l_default_access
1063: );

Line 1094: DBMS_SQL.CLOSE_CURSOR(cursor_select);

1090: x_default_access(all_roles_count):=l_grantee_list(i).default_access;
1091: END LOOP;
1092: END IF;
1093:
1094: DBMS_SQL.CLOSE_CURSOR(cursor_select);
1095:
1096: --dbms_output.put_line('** sameer ** completed successfully all inherited and direct roles on change.' );
1097:
1098: END Get_Change_Users;

Line 1189: cursor_select := DBMS_SQL.OPEN_CURSOR;

1185: query_to_exec := query_to_exec || prim_key_str || ') IN (' || p_parent_obj_sql || '))';
1186: END IF;
1187: --dbms_output.put_line('** sameer ** end if ...>>>>: ');
1188: --p(query_to_exec);
1189: cursor_select := DBMS_SQL.OPEN_CURSOR;
1190: --dbms_output.put_line('** sameer ** DBMS_SQL.OPEN_CURSOR ');
1191: DBMS_SQL.PARSE(cursor_select, query_to_exec, DBMS_SQL.NATIVE);
1192: --dbms_output.put_line('** sameer ** Get_Valid_Instance_Set_Ids ... parsed .: ');
1193: IF p_bind1 IS NOT NULL THEN

Line 1190: --dbms_output.put_line(' sameer DBMS_SQL.OPEN_CURSOR ');

1186: END IF;
1187: --dbms_output.put_line('** sameer ** end if ...>>>>: ');
1188: --p(query_to_exec);
1189: cursor_select := DBMS_SQL.OPEN_CURSOR;
1190: --dbms_output.put_line('** sameer ** DBMS_SQL.OPEN_CURSOR ');
1191: DBMS_SQL.PARSE(cursor_select, query_to_exec, DBMS_SQL.NATIVE);
1192: --dbms_output.put_line('** sameer ** Get_Valid_Instance_Set_Ids ... parsed .: ');
1193: IF p_bind1 IS NOT NULL THEN
1194: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id1', p_bind1);

Line 1191: DBMS_SQL.PARSE(cursor_select, query_to_exec, DBMS_SQL.NATIVE);

1187: --dbms_output.put_line('** sameer ** end if ...>>>>: ');
1188: --p(query_to_exec);
1189: cursor_select := DBMS_SQL.OPEN_CURSOR;
1190: --dbms_output.put_line('** sameer ** DBMS_SQL.OPEN_CURSOR ');
1191: DBMS_SQL.PARSE(cursor_select, query_to_exec, DBMS_SQL.NATIVE);
1192: --dbms_output.put_line('** sameer ** Get_Valid_Instance_Set_Ids ... parsed .: ');
1193: IF p_bind1 IS NOT NULL THEN
1194: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id1', p_bind1);
1195: --dbms_output.put_line('** sameer ** binded id1 ... ');

Line 1194: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id1', p_bind1);

1190: --dbms_output.put_line('** sameer ** DBMS_SQL.OPEN_CURSOR ');
1191: DBMS_SQL.PARSE(cursor_select, query_to_exec, DBMS_SQL.NATIVE);
1192: --dbms_output.put_line('** sameer ** Get_Valid_Instance_Set_Ids ... parsed .: ');
1193: IF p_bind1 IS NOT NULL THEN
1194: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id1', p_bind1);
1195: --dbms_output.put_line('** sameer ** binded id1 ... ');
1196: END IF;
1197: IF p_bind2 IS NOT NULL THEN
1198: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id2', p_bind2);

Line 1198: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id2', p_bind2);

1194: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id1', p_bind1);
1195: --dbms_output.put_line('** sameer ** binded id1 ... ');
1196: END IF;
1197: IF p_bind2 IS NOT NULL THEN
1198: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id2', p_bind2);
1199: END IF;
1200: IF p_bind3 IS NOT NULL THEN
1201: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id3', p_bind3);
1202: END IF;

Line 1201: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id3', p_bind3);

1197: IF p_bind2 IS NOT NULL THEN
1198: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id2', p_bind2);
1199: END IF;
1200: IF p_bind3 IS NOT NULL THEN
1201: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id3', p_bind3);
1202: END IF;
1203: IF p_bind4 IS NOT NULL THEN
1204: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id4', p_bind4);
1205: END IF;

Line 1204: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id4', p_bind4);

1200: IF p_bind3 IS NOT NULL THEN
1201: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id3', p_bind3);
1202: END IF;
1203: IF p_bind4 IS NOT NULL THEN
1204: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id4', p_bind4);
1205: END IF;
1206: IF p_bind5 IS NOT NULL THEN
1207: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id5', p_bind5);
1208: END IF;

Line 1207: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id5', p_bind5);

1203: IF p_bind4 IS NOT NULL THEN
1204: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id4', p_bind4);
1205: END IF;
1206: IF p_bind5 IS NOT NULL THEN
1207: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id5', p_bind5);
1208: END IF;
1209:
1210: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);
1211: IF DBMS_SQL.FETCH_ROWS(cursor_select) > 0 THEN

Line 1210: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);

1206: IF p_bind5 IS NOT NULL THEN
1207: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id5', p_bind5);
1208: END IF;
1209:
1210: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);
1211: IF DBMS_SQL.FETCH_ROWS(cursor_select) > 0 THEN
1212: IF i = 1 THEN
1213: inst_set_ids := to_char(inst_set_preds_rec.instance_set_id);
1214: i := 2;

Line 1211: IF DBMS_SQL.FETCH_ROWS(cursor_select) > 0 THEN

1207: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id5', p_bind5);
1208: END IF;
1209:
1210: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);
1211: IF DBMS_SQL.FETCH_ROWS(cursor_select) > 0 THEN
1212: IF i = 1 THEN
1213: inst_set_ids := to_char(inst_set_preds_rec.instance_set_id);
1214: i := 2;
1215: ELSE

Line 1219: DBMS_SQL.CLOSE_CURSOR(cursor_select);

1215: ELSE
1216: inst_set_ids := inst_set_ids || ',' || inst_set_preds_rec.instance_set_id;
1217: END IF;
1218: END IF;
1219: DBMS_SQL.CLOSE_CURSOR(cursor_select);
1220: END LOOP;
1221: IF inst_set_ids IS NOT NULL THEN
1222: x_inst_set_ids := inst_set_ids; /**** list of valid inst_set_ids ****/
1223: ELSE