APPS.WIP_JDI_UTILS dependencies on DBMS_SQL

Line 91: x_cursor_id := dbms_sql.open_cursor ;

87: end if;
88:
89: -- Execute dynamic sql.
90:
91: x_cursor_id := dbms_sql.open_cursor ;
92: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
93: dbms_sql.define_column(x_cursor_id, 1, x_jdi_interface_id);
94: dbms_sql.bind_variable(x_cursor_id, ':x_group_id', p_group_id);
95: n_rows_fetched := dbms_sql.execute(x_cursor_id) ;

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

88:
89: -- Execute dynamic sql.
90:
91: x_cursor_id := dbms_sql.open_cursor ;
92: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
93: dbms_sql.define_column(x_cursor_id, 1, x_jdi_interface_id);
94: dbms_sql.bind_variable(x_cursor_id, ':x_group_id', p_group_id);
95: n_rows_fetched := dbms_sql.execute(x_cursor_id) ;
96:

Line 93: dbms_sql.define_column(x_cursor_id, 1, x_jdi_interface_id);

89: -- Execute dynamic sql.
90:
91: x_cursor_id := dbms_sql.open_cursor ;
92: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
93: dbms_sql.define_column(x_cursor_id, 1, x_jdi_interface_id);
94: dbms_sql.bind_variable(x_cursor_id, ':x_group_id', p_group_id);
95: n_rows_fetched := dbms_sql.execute(x_cursor_id) ;
96:
97: LOOP

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

90:
91: x_cursor_id := dbms_sql.open_cursor ;
92: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
93: dbms_sql.define_column(x_cursor_id, 1, x_jdi_interface_id);
94: dbms_sql.bind_variable(x_cursor_id, ':x_group_id', p_group_id);
95: n_rows_fetched := dbms_sql.execute(x_cursor_id) ;
96:
97: LOOP
98: n_rows_fetched := dbms_sql.fetch_rows(x_cursor_id) ;

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

91: x_cursor_id := dbms_sql.open_cursor ;
92: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
93: dbms_sql.define_column(x_cursor_id, 1, x_jdi_interface_id);
94: dbms_sql.bind_variable(x_cursor_id, ':x_group_id', p_group_id);
95: n_rows_fetched := dbms_sql.execute(x_cursor_id) ;
96:
97: LOOP
98: n_rows_fetched := dbms_sql.fetch_rows(x_cursor_id) ;
99:

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

94: dbms_sql.bind_variable(x_cursor_id, ':x_group_id', p_group_id);
95: n_rows_fetched := dbms_sql.execute(x_cursor_id) ;
96:
97: LOOP
98: n_rows_fetched := dbms_sql.fetch_rows(x_cursor_id) ;
99:
100: if (n_rows_fetched = 0) then
101: dbms_sql.close_cursor(x_cursor_id);
102: exit;

Line 101: dbms_sql.close_cursor(x_cursor_id);

97: LOOP
98: n_rows_fetched := dbms_sql.fetch_rows(x_cursor_id) ;
99:
100: if (n_rows_fetched = 0) then
101: dbms_sql.close_cursor(x_cursor_id);
102: exit;
103: end if;
104:
105: dbms_sql.column_value(x_cursor_id, 1,x_jdi_interface_id);

Line 105: dbms_sql.column_value(x_cursor_id, 1,x_jdi_interface_id);

101: dbms_sql.close_cursor(x_cursor_id);
102: exit;
103: end if;
104:
105: dbms_sql.column_value(x_cursor_id, 1,x_jdi_interface_id);
106:
107: -- Fetch the requested error message.
108:
109: fnd_message.set_name('WIP', p_error_msg) ;

Line 145: x_cursor_id := dbms_sql.open_cursor;

141: ','||WIP_CONSTANTS.WARNING ||')'||
142: ' AND ' || replace(p_where_clause, ' ',' ');
143:
144: begin
145: x_cursor_id := dbms_sql.open_cursor;
146: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
147: dbms_sql.bind_variable(x_cursor_id, ':x_Group_Id', P_Group_Id);
148: dbms_sql.bind_variable(x_cursor_id, ':x_New_Process_Status', P_New_Process_Status);
149: n_rows_fetched := dbms_sql.execute(x_cursor_id);

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

142: ' AND ' || replace(p_where_clause, ' ',' ');
143:
144: begin
145: x_cursor_id := dbms_sql.open_cursor;
146: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
147: dbms_sql.bind_variable(x_cursor_id, ':x_Group_Id', P_Group_Id);
148: dbms_sql.bind_variable(x_cursor_id, ':x_New_Process_Status', P_New_Process_Status);
149: n_rows_fetched := dbms_sql.execute(x_cursor_id);
150: dbms_sql.close_cursor(x_cursor_id);

Line 147: dbms_sql.bind_variable(x_cursor_id, ':x_Group_Id', P_Group_Id);

143:
144: begin
145: x_cursor_id := dbms_sql.open_cursor;
146: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
147: dbms_sql.bind_variable(x_cursor_id, ':x_Group_Id', P_Group_Id);
148: dbms_sql.bind_variable(x_cursor_id, ':x_New_Process_Status', P_New_Process_Status);
149: n_rows_fetched := dbms_sql.execute(x_cursor_id);
150: dbms_sql.close_cursor(x_cursor_id);
151: end;

Line 148: dbms_sql.bind_variable(x_cursor_id, ':x_New_Process_Status', P_New_Process_Status);

144: begin
145: x_cursor_id := dbms_sql.open_cursor;
146: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
147: dbms_sql.bind_variable(x_cursor_id, ':x_Group_Id', P_Group_Id);
148: dbms_sql.bind_variable(x_cursor_id, ':x_New_Process_Status', P_New_Process_Status);
149: n_rows_fetched := dbms_sql.execute(x_cursor_id);
150: dbms_sql.close_cursor(x_cursor_id);
151: end;
152:

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

145: x_cursor_id := dbms_sql.open_cursor;
146: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
147: dbms_sql.bind_variable(x_cursor_id, ':x_Group_Id', P_Group_Id);
148: dbms_sql.bind_variable(x_cursor_id, ':x_New_Process_Status', P_New_Process_Status);
149: n_rows_fetched := dbms_sql.execute(x_cursor_id);
150: dbms_sql.close_cursor(x_cursor_id);
151: end;
152:
153: END Error_If_Batch;

Line 150: dbms_sql.close_cursor(x_cursor_id);

146: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native);
147: dbms_sql.bind_variable(x_cursor_id, ':x_Group_Id', P_Group_Id);
148: dbms_sql.bind_variable(x_cursor_id, ':x_New_Process_Status', P_New_Process_Status);
149: n_rows_fetched := dbms_sql.execute(x_cursor_id);
150: dbms_sql.close_cursor(x_cursor_id);
151: end;
152:
153: END Error_If_Batch;
154: