APPS.EAM_MRI_UTILS dependencies on DBMS_SQL

Line 51: x_cursor_id := dbms_sql.open_cursor ;

47: end if;
48:
49: -- Execute dynamic sql.
50:
51: x_cursor_id := dbms_sql.open_cursor ;
52: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
53: dbms_sql.define_column(x_cursor_id, 1, x_interface_id);
54: dbms_sql.bind_variable(x_cursor_id, ':x_group_id', p_group_id);
55: n_rows_fetched := dbms_sql.execute(x_cursor_id) ;

Line 52: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;

48:
49: -- Execute dynamic sql.
50:
51: x_cursor_id := dbms_sql.open_cursor ;
52: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
53: dbms_sql.define_column(x_cursor_id, 1, x_interface_id);
54: dbms_sql.bind_variable(x_cursor_id, ':x_group_id', p_group_id);
55: n_rows_fetched := dbms_sql.execute(x_cursor_id) ;
56:

Line 53: dbms_sql.define_column(x_cursor_id, 1, x_interface_id);

49: -- Execute dynamic sql.
50:
51: x_cursor_id := dbms_sql.open_cursor ;
52: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
53: dbms_sql.define_column(x_cursor_id, 1, x_interface_id);
54: dbms_sql.bind_variable(x_cursor_id, ':x_group_id', p_group_id);
55: n_rows_fetched := dbms_sql.execute(x_cursor_id) ;
56:
57: LOOP

Line 54: dbms_sql.bind_variable(x_cursor_id, ':x_group_id', p_group_id);

50:
51: x_cursor_id := dbms_sql.open_cursor ;
52: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
53: dbms_sql.define_column(x_cursor_id, 1, x_interface_id);
54: dbms_sql.bind_variable(x_cursor_id, ':x_group_id', p_group_id);
55: n_rows_fetched := dbms_sql.execute(x_cursor_id) ;
56:
57: LOOP
58: n_rows_fetched := dbms_sql.fetch_rows(x_cursor_id) ;

Line 55: n_rows_fetched := dbms_sql.execute(x_cursor_id) ;

51: x_cursor_id := dbms_sql.open_cursor ;
52: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
53: dbms_sql.define_column(x_cursor_id, 1, x_interface_id);
54: dbms_sql.bind_variable(x_cursor_id, ':x_group_id', p_group_id);
55: n_rows_fetched := dbms_sql.execute(x_cursor_id) ;
56:
57: LOOP
58: n_rows_fetched := dbms_sql.fetch_rows(x_cursor_id) ;
59:

Line 58: n_rows_fetched := dbms_sql.fetch_rows(x_cursor_id) ;

54: dbms_sql.bind_variable(x_cursor_id, ':x_group_id', p_group_id);
55: n_rows_fetched := dbms_sql.execute(x_cursor_id) ;
56:
57: LOOP
58: n_rows_fetched := dbms_sql.fetch_rows(x_cursor_id) ;
59:
60: if (n_rows_fetched = 0) then
61: dbms_sql.close_cursor(x_cursor_id);
62: exit;

Line 61: dbms_sql.close_cursor(x_cursor_id);

57: LOOP
58: n_rows_fetched := dbms_sql.fetch_rows(x_cursor_id) ;
59:
60: if (n_rows_fetched = 0) then
61: dbms_sql.close_cursor(x_cursor_id);
62: exit;
63: end if;
64:
65: dbms_sql.column_value(x_cursor_id, 1, x_interface_id);

Line 65: dbms_sql.column_value(x_cursor_id, 1, x_interface_id);

61: dbms_sql.close_cursor(x_cursor_id);
62: exit;
63: end if;
64:
65: dbms_sql.column_value(x_cursor_id, 1, x_interface_id);
66:
67: -- Fetch the requested error message.
68:
69: fnd_message.set_name('EAM', p_error_msg) ;

Line 104: x_cursor_id := dbms_sql.open_cursor;

100: AND ' || replace(p_where_clause, ' ',' ');
101:
102:
103: begin
104: x_cursor_id := dbms_sql.open_cursor;
105: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.v7);
106: dbms_sql.bind_variable(x_cursor_id, ':process_status', P_New_Process_Status);
107: dbms_sql.bind_variable(x_cursor_id, ':group_id', P_Group_Id);
108: n_rows_fetched := dbms_sql.execute(x_cursor_id);

Line 105: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.v7);

101:
102:
103: begin
104: x_cursor_id := dbms_sql.open_cursor;
105: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.v7);
106: dbms_sql.bind_variable(x_cursor_id, ':process_status', P_New_Process_Status);
107: dbms_sql.bind_variable(x_cursor_id, ':group_id', P_Group_Id);
108: n_rows_fetched := dbms_sql.execute(x_cursor_id);
109: dbms_sql.close_cursor(x_cursor_id);

Line 106: dbms_sql.bind_variable(x_cursor_id, ':process_status', P_New_Process_Status);

102:
103: begin
104: x_cursor_id := dbms_sql.open_cursor;
105: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.v7);
106: dbms_sql.bind_variable(x_cursor_id, ':process_status', P_New_Process_Status);
107: dbms_sql.bind_variable(x_cursor_id, ':group_id', P_Group_Id);
108: n_rows_fetched := dbms_sql.execute(x_cursor_id);
109: dbms_sql.close_cursor(x_cursor_id);
110: end;

Line 107: dbms_sql.bind_variable(x_cursor_id, ':group_id', P_Group_Id);

103: begin
104: x_cursor_id := dbms_sql.open_cursor;
105: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.v7);
106: dbms_sql.bind_variable(x_cursor_id, ':process_status', P_New_Process_Status);
107: dbms_sql.bind_variable(x_cursor_id, ':group_id', P_Group_Id);
108: n_rows_fetched := dbms_sql.execute(x_cursor_id);
109: dbms_sql.close_cursor(x_cursor_id);
110: end;
111:

Line 108: n_rows_fetched := dbms_sql.execute(x_cursor_id);

104: x_cursor_id := dbms_sql.open_cursor;
105: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.v7);
106: dbms_sql.bind_variable(x_cursor_id, ':process_status', P_New_Process_Status);
107: dbms_sql.bind_variable(x_cursor_id, ':group_id', P_Group_Id);
108: n_rows_fetched := dbms_sql.execute(x_cursor_id);
109: dbms_sql.close_cursor(x_cursor_id);
110: end;
111:
112: end error_if_batch;

Line 109: dbms_sql.close_cursor(x_cursor_id);

105: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.v7);
106: dbms_sql.bind_variable(x_cursor_id, ':process_status', P_New_Process_Status);
107: dbms_sql.bind_variable(x_cursor_id, ':group_id', P_Group_Id);
108: n_rows_fetched := dbms_sql.execute(x_cursor_id);
109: dbms_sql.close_cursor(x_cursor_id);
110: end;
111:
112: end error_if_batch;
113: