[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
ad_ddl.build_statement(' -- p_line_item_id Line Item Id of retained earnings selected for the hierarchy.', r); r:=r+1;
ad_ddl.build_statement(' SELECT ''X''', r); r:=r+1;
ad_ddl.build_statement(' ''INSERT /*+ parallel (gcs_entry_lines) */ INTO gcs_entry_lines(entry_id, '' ||', r); r:=r+1;
ad_ddl.build_statement(' ''last_update_date, last_updated_by, last_update_login)'' || g_nl ||', r); r:=r+1;
ad_ddl.build_statement(' ''SELECT '' || p_new_entry_id || '', '' ||', r); r:=r+1;
ad_ddl.build_statement(' INSERT /*+ parallel (gcs_entry_lines) */ INTO gcs_entry_lines(', r); r:=r+1;
ad_ddl.build_statement(' creation_date, created_by, last_update_date, last_updated_by,', r); r:=r+1;
ad_ddl.build_statement(' last_update_login)', r); r:=r+1;
ad_ddl.build_statement(' SELECT', r); r:=r+1;