APPS.CN_COLLECT_WRITEOFFS dependencies on DBMS_SQL

Line 22: dbms_sql.close_cursor(cursor_id);

18: stmt_len integer;
19: loop_var integer;
20:
21: BEGIN
22: dbms_sql.close_cursor(cursor_id);
23:
24: dbms_output.put_line('--');
25: dbms_output.put_line('SQL statement that failed is:');
26:

Line 107: c := dbms_sql.open_cursor;

103: x_org_id NUMBER;
104:
105: begin
106:
107: c := dbms_sql.open_cursor;
108:
109: x_org_id := mo_global.get_current_org_id;
110:
111: get_org_append(x_org_id);

Line 116: dbms_sql.parse(c, statement, dbms_sql.native);

112:
113: statement := 'begin cn_collect_writeoffs'||cached_org_append||
114: '.collect(:err,:ret,:start,:end, :orgid); end;';
115:
116: dbms_sql.parse(c, statement, dbms_sql.native);
117:
118: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
119: dbms_sql.bind_variable(c,'ret', dummy_num);
120: dbms_sql.bind_variable(c,'start', x_start_period_name);

Line 118: dbms_sql.bind_variable(c,'err', dummy_vch, 30);

114: '.collect(:err,:ret,:start,:end, :orgid); end;';
115:
116: dbms_sql.parse(c, statement, dbms_sql.native);
117:
118: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
119: dbms_sql.bind_variable(c,'ret', dummy_num);
120: dbms_sql.bind_variable(c,'start', x_start_period_name);
121: dbms_sql.bind_variable(c,'end', x_end_period_name);
122: dbms_sql.bind_variable(c,'orgid', x_org_id);

Line 119: dbms_sql.bind_variable(c,'ret', dummy_num);

115:
116: dbms_sql.parse(c, statement, dbms_sql.native);
117:
118: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
119: dbms_sql.bind_variable(c,'ret', dummy_num);
120: dbms_sql.bind_variable(c,'start', x_start_period_name);
121: dbms_sql.bind_variable(c,'end', x_end_period_name);
122: dbms_sql.bind_variable(c,'orgid', x_org_id);
123:

Line 120: dbms_sql.bind_variable(c,'start', x_start_period_name);

116: dbms_sql.parse(c, statement, dbms_sql.native);
117:
118: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
119: dbms_sql.bind_variable(c,'ret', dummy_num);
120: dbms_sql.bind_variable(c,'start', x_start_period_name);
121: dbms_sql.bind_variable(c,'end', x_end_period_name);
122: dbms_sql.bind_variable(c,'orgid', x_org_id);
123:
124: rows_processed := dbms_sql.execute(c);

Line 121: dbms_sql.bind_variable(c,'end', x_end_period_name);

117:
118: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
119: dbms_sql.bind_variable(c,'ret', dummy_num);
120: dbms_sql.bind_variable(c,'start', x_start_period_name);
121: dbms_sql.bind_variable(c,'end', x_end_period_name);
122: dbms_sql.bind_variable(c,'orgid', x_org_id);
123:
124: rows_processed := dbms_sql.execute(c);
125:

Line 122: dbms_sql.bind_variable(c,'orgid', x_org_id);

118: dbms_sql.bind_variable(c,'err', dummy_vch, 30);
119: dbms_sql.bind_variable(c,'ret', dummy_num);
120: dbms_sql.bind_variable(c,'start', x_start_period_name);
121: dbms_sql.bind_variable(c,'end', x_end_period_name);
122: dbms_sql.bind_variable(c,'orgid', x_org_id);
123:
124: rows_processed := dbms_sql.execute(c);
125:
126: dbms_sql.variable_value(c,'err', errbuf);

Line 124: rows_processed := dbms_sql.execute(c);

120: dbms_sql.bind_variable(c,'start', x_start_period_name);
121: dbms_sql.bind_variable(c,'end', x_end_period_name);
122: dbms_sql.bind_variable(c,'orgid', x_org_id);
123:
124: rows_processed := dbms_sql.execute(c);
125:
126: dbms_sql.variable_value(c,'err', errbuf);
127: dbms_sql.variable_value(c,'ret', retcode);
128:

Line 126: dbms_sql.variable_value(c,'err', errbuf);

122: dbms_sql.bind_variable(c,'orgid', x_org_id);
123:
124: rows_processed := dbms_sql.execute(c);
125:
126: dbms_sql.variable_value(c,'err', errbuf);
127: dbms_sql.variable_value(c,'ret', retcode);
128:
129: dbms_sql.close_cursor(c);
130:

Line 127: dbms_sql.variable_value(c,'ret', retcode);

123:
124: rows_processed := dbms_sql.execute(c);
125:
126: dbms_sql.variable_value(c,'err', errbuf);
127: dbms_sql.variable_value(c,'ret', retcode);
128:
129: dbms_sql.close_cursor(c);
130:
131: --exception

Line 129: dbms_sql.close_cursor(c);

125:
126: dbms_sql.variable_value(c,'err', errbuf);
127: dbms_sql.variable_value(c,'ret', retcode);
128:
129: dbms_sql.close_cursor(c);
130:
131: --exception
132: -- when compile_error then
133: -- std_compile_error(c, statement);