APPS.WSH_INVOICE_UTILITIES dependencies on DBMS_SQL

Line 113: -- Build the full select statement and using dbms_sql execute

109: --dbms_output.put_line('Position 2');
110: --dbms_output.put_line('Grouping Clause: ' || group_col_clause);
111: --dbms_output.put_line('Select Clause: ' || select_col);
112:
113: -- Build the full select statement and using dbms_sql execute
114: -- the statement
115: --dbms_output.put_line('Position 21');
116: grp_stmt := 'Select ' || select_col || ' group_cols,' ||
117: ' l.interface_line_attribute3, ROWID ' ||

Line 126: group_cursor := dbms_sql.open_cursor;

122: ' , l.interface_line_attribute3, l.org_id' ;
123:
124: --dbms_output.put_line(grp_stmt);
125: --dbms_output.put_line('Position 3');
126: group_cursor := dbms_sql.open_cursor;
127: dbms_sql.parse( group_cursor, grp_stmt, dbms_sql.v7);
128: --dbms_output.put_line('Position 31');
129: dbms_sql.define_column( group_cursor, 1, this_concat_cols, 5000);
130: dbms_sql.define_column( group_cursor, 2, this_del_name, 15);

Line 127: dbms_sql.parse( group_cursor, grp_stmt, dbms_sql.v7);

123:
124: --dbms_output.put_line(grp_stmt);
125: --dbms_output.put_line('Position 3');
126: group_cursor := dbms_sql.open_cursor;
127: dbms_sql.parse( group_cursor, grp_stmt, dbms_sql.v7);
128: --dbms_output.put_line('Position 31');
129: dbms_sql.define_column( group_cursor, 1, this_concat_cols, 5000);
130: dbms_sql.define_column( group_cursor, 2, this_del_name, 15);
131: dbms_sql.define_column( group_cursor, 3, this_rowid, 20);

Line 129: dbms_sql.define_column( group_cursor, 1, this_concat_cols, 5000);

125: --dbms_output.put_line('Position 3');
126: group_cursor := dbms_sql.open_cursor;
127: dbms_sql.parse( group_cursor, grp_stmt, dbms_sql.v7);
128: --dbms_output.put_line('Position 31');
129: dbms_sql.define_column( group_cursor, 1, this_concat_cols, 5000);
130: dbms_sql.define_column( group_cursor, 2, this_del_name, 15);
131: dbms_sql.define_column( group_cursor, 3, this_rowid, 20);
132: rows_processed := dbms_sql.execute (group_cursor);
133:

Line 130: dbms_sql.define_column( group_cursor, 2, this_del_name, 15);

126: group_cursor := dbms_sql.open_cursor;
127: dbms_sql.parse( group_cursor, grp_stmt, dbms_sql.v7);
128: --dbms_output.put_line('Position 31');
129: dbms_sql.define_column( group_cursor, 1, this_concat_cols, 5000);
130: dbms_sql.define_column( group_cursor, 2, this_del_name, 15);
131: dbms_sql.define_column( group_cursor, 3, this_rowid, 20);
132: rows_processed := dbms_sql.execute (group_cursor);
133:
134: --dbms_output.put_line('Position 4');

Line 131: dbms_sql.define_column( group_cursor, 3, this_rowid, 20);

127: dbms_sql.parse( group_cursor, grp_stmt, dbms_sql.v7);
128: --dbms_output.put_line('Position 31');
129: dbms_sql.define_column( group_cursor, 1, this_concat_cols, 5000);
130: dbms_sql.define_column( group_cursor, 2, this_del_name, 15);
131: dbms_sql.define_column( group_cursor, 3, this_rowid, 20);
132: rows_processed := dbms_sql.execute (group_cursor);
133:
134: --dbms_output.put_line('Position 4');
135: Loop

Line 132: rows_processed := dbms_sql.execute (group_cursor);

128: --dbms_output.put_line('Position 31');
129: dbms_sql.define_column( group_cursor, 1, this_concat_cols, 5000);
130: dbms_sql.define_column( group_cursor, 2, this_del_name, 15);
131: dbms_sql.define_column( group_cursor, 3, this_rowid, 20);
132: rows_processed := dbms_sql.execute (group_cursor);
133:
134: --dbms_output.put_line('Position 4');
135: Loop
136: if ( dbms_sql.fetch_rows (group_cursor) > 0 ) Then

Line 136: if ( dbms_sql.fetch_rows (group_cursor) > 0 ) Then

132: rows_processed := dbms_sql.execute (group_cursor);
133:
134: --dbms_output.put_line('Position 4');
135: Loop
136: if ( dbms_sql.fetch_rows (group_cursor) > 0 ) Then
137: dbms_sql.column_value (group_cursor, 1, this_concat_cols);
138: dbms_sql.column_value (group_cursor, 2, this_del_name);
139: dbms_sql.column_value (group_cursor, 3, this_rowid);
140: Else

Line 137: dbms_sql.column_value (group_cursor, 1, this_concat_cols);

133:
134: --dbms_output.put_line('Position 4');
135: Loop
136: if ( dbms_sql.fetch_rows (group_cursor) > 0 ) Then
137: dbms_sql.column_value (group_cursor, 1, this_concat_cols);
138: dbms_sql.column_value (group_cursor, 2, this_del_name);
139: dbms_sql.column_value (group_cursor, 3, this_rowid);
140: Else
141: exit;

Line 138: dbms_sql.column_value (group_cursor, 2, this_del_name);

134: --dbms_output.put_line('Position 4');
135: Loop
136: if ( dbms_sql.fetch_rows (group_cursor) > 0 ) Then
137: dbms_sql.column_value (group_cursor, 1, this_concat_cols);
138: dbms_sql.column_value (group_cursor, 2, this_del_name);
139: dbms_sql.column_value (group_cursor, 3, this_rowid);
140: Else
141: exit;
142: End if;

Line 139: dbms_sql.column_value (group_cursor, 3, this_rowid);

135: Loop
136: if ( dbms_sql.fetch_rows (group_cursor) > 0 ) Then
137: dbms_sql.column_value (group_cursor, 1, this_concat_cols);
138: dbms_sql.column_value (group_cursor, 2, this_del_name);
139: dbms_sql.column_value (group_cursor, 3, this_rowid);
140: Else
141: exit;
142: End if;
143:

Line 202: dbms_sql.close_cursor (group_cursor);

198: where rowid = chartorowid(this_rowid);
199:
200: End Loop;
201:
202: dbms_sql.close_cursor (group_cursor);
203:
204: Return;
205:
206: EXCEPTION