[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT USER_JE_SOURCE_NAME
INTO p_adb_name
FROM GL_JE_SOURCES
WHERE JE_SOURCE_NAME = 'Average Consolidation';
SELECT USER_JE_SOURCE_NAME
INTO p_name
FROM GL_JE_SOURCES
WHERE JE_SOURCE_NAME = 'Consolidation';
v_R_SQL := 'SELECT s.SEGMENT_NUM, ' ||
's.APPLICATION_COLUMN_NAME, ' ||
's.DISPLAY_SIZE ' ||
'FROM FND_FLEX_VALUE_SETS vs, ' ||
'FND_ID_FLEX_SEGMENTS s ' ||
'WHERE vs.flex_value_set_id = s.flex_value_set_id ' ||
'AND s.ID_FLEX_NUM = :coa_id ' ||
'AND s.application_id = :app_id ' ||
'AND s.id_flex_code = :gl' ||
' order by segment_num';
v_R_SQL := 'SELECT s.SEGMENT_NUM, ' ||
's.APPLICATION_COLUMN_NAME, ' ||
's.DISPLAY_SIZE ' ||
'FROM FND_FLEX_VALUE_SETS vs, ' ||
'FND_ID_FLEX_SEGMENTS s ' ||
'WHERE vs.flex_value_set_id = s.flex_value_set_id ' ||
'AND s.ID_FLEX_NUM = :coa_id ' ||
'AND s.application_id = :app_id ' ||
'AND s.id_flex_code = :gl_name' ||
' order by segment_num';
SELECT email_address
FROM fnd_user
WHERE user_name = p_user_name;
v_SQL1 := 'select user_id from fnd_user' ||
' where user_name = :name';
v_SQL1 := 'select responsibility_id from fnd_responsibility_tl' ||
' where responsibility_name = :name' ||
' and application_id = :app_id' ||
' and language = :l';
v_SQL1 := 'select name from gl_ledgers' ||
' WHERE ledger_id = :l_id';
v_SQL1 := 'select suspense_allowed_flag from gl_ledgers' ||
' WHERE ledger_id = :l_id';
v_SQL1 := 'select enable_average_balances_flag from gl_ledgers' ||
' where ledger_id = :ledger_id';
v_SQL1 := 'select consolidation_ledger_flag from gl_ledgers' ||
' where ledger_id = :ledger_id';
v_SQL1 := 'SELECT CURRENCY_CODE FROM gl_ledgers' ||
' WHERE ledger_id = :ledger_id';
v_SQL1 := 'select chart_of_accounts_id from gl_ledgers' ||
' where ledger_id = :ledger_id';
v_SQL1 := 'select count(*) from gl_periods p, gl_ledgers l ' ||
'where p.period_set_name = l.period_set_name ' ||
'and p.period_type = l.accounted_period_type ' ||
'and l.ledger_id = :s ' ||
'and p.period_name = :pd';
v_PDSQL := 'select p.start_date, p.end_date, p.quarter_start_date, ' ||
'p.year_start_date from ' ||
'gl_periods p, gl_ledgers l ' ||
'where p.period_set_name = l.period_set_name ' ||
'and p.period_type = l.accounted_period_type ' ||
'and l.ledger_id = :s ' ||
'and p.period_name = :pd';
select user_id
from fnd_user
where user_name = p_user_name;
v_SQL1 := 'select responsibility_id from fnd_responsibility_tl ' ||
'where responsibility_name = :name ' ||
'and application_id = :app_id ' ||
'and language = :l';
v_SelectSQL2 varchar2(1000);
v_SelectSQL2 := 'select count(*) from fnd_responsibility_tl ' ||
'where responsibility_name = :resp_name ' ||
'and application_id = :app_id ' ||
'and language = :l';
EXECUTE IMMEDIATE v_SelectSQL2 INTO l_count USING resp_name, l_app_id,userenv('LANG');
SELECT menu_id INTO l_menu from fnd_menus where menu_name = 'GL_SU_J_IMPORT';
v_SQL := 'select count(*) from fnd_resp_functions' ||
' where application_id = :app_id' ||
' and responsibility_id = :r_id' ||
' and action_id = :menu_id' ||
' and rule_type = :r';
select budget_version_id
from gl_budget_versions
where budget_name = p_budget_name;
SELECT NAME
INTO p_access_set
FROM GL_ACCESS_SETS
WHERE ACCESS_SET_ID = l_access_set_id;
/*v_SQL := 'select default_ledger_id from gl_access_sets' ||
' where access_set_id = :s';*/
v_SQL := 'select ledger_id from gl_ledgers' ||
' where name = :s';
v_SQL := 'select access_privilege_code from gl_access_set_assignments' ||
' where access_set_id = :s and ledger_id = :l';
SELECT GL_INTERFACE_CONTROL_S.NEXTVAL
FROM sys.DUAL;
v_SQL := 'grant select, update, insert, delete on ' || l_table_name
|| ' to ' || db_username;
v_UpdateSQL varchar2(500);
v_SelectSQL varchar2(1000);
v_SelectSQL := 'select user_je_source_name from gl_je_sources ' ||
'WHERE je_source_name = :s_name';
EXECUTE IMMEDIATE v_SelectSQL INTO l_user_je_source_name USING l_adb_je_source;
v_UpdateSQL := 'UPDATE ' || l_table_name ||
' SET group_id = :group_id' ||
' WHERE ledger_id = :ledger_id' ||
' AND period_name = :period_name' ||
' AND actual_flag = :flag' ||
' AND user_je_source_name = :s_name';
EXECUTE IMMEDIATE v_UpdateSQL USING group_id, ledger_id, pd_name,
actual_flag, l_user_je_source_name;
v_SelectSQL := 'select user_je_source_name from gl_je_sources ' ||
'WHERE je_source_name = :s_name';
EXECUTE IMMEDIATE v_SelectSQL INTO l_user_je_source_name USING l_je_source;
v_UpdateSQL := 'UPDATE ' || l_table_name ||
' SET group_id = :group_id' ||
' WHERE ledger_id = :ledger_id' ||
' AND period_name = :period_name' ||
' AND actual_flag = :flag' ||
' AND user_je_source_name = :s_name';
EXECUTE IMMEDIATE v_UpdateSQL USING group_id, ledger_id, pd_name,
actual_flag, l_user_je_source_name;
v_SelectSQL varchar2(500);
v_SelectSQL2 varchar2(500);
v_SelectSQL := 'select * from gl_je_headers' ||
' where status = :s and je_batch_id = :b_id' ||
' and ledger_id = :sid' ||
' and je_source = :je' ||
' and period_name = :name' ||
' and actual_flag = :flag';
OPEN v_ReturnCursor FOR v_SelectSQL USING status, batch_id, ledger_id,
l_adb_je_source, pd_name, actual_flag;
v_SelectSQL := 'select * from gl_je_headers' ||
' where status = :s and je_batch_id = :b_id' ||
' and ledger_id = :sid' ||
' and je_source = :je' ||
' and period_name = :name' ||
' and actual_flag = :flag';
OPEN v_ReturnCursor FOR v_SelectSQL USING status, batch_id, ledger_id,
l_je_source, pd_name, actual_flag;
v_SelectSQL2 := 'select count(*) from gl_je_lines' ||
' where je_header_id = :id';
EXECUTE IMMEDIATE v_SelectSQL2 INTO v_count USING v_header_id;
SELECT gl_je_posting_s.NEXTVAL
FROM sys.dual;
select chart_of_accounts_id
from gl_ledgers
where ledger_id = ledger_id;
v_UpdateSQL varchar2(1000);
v_SelectSQL varchar2(1000);
v_SelectSQL := 'select status, request_id, budgetary_control_status ' ||
'from gl_je_batches ' ||
'WHERE je_batch_id = :b_id ' ||
'and default_period_name = :pd ' ||
-- 'and ledger_id = :ledger ' ||
'and actual_flag = :flag ' ||
'FOR UPDATE OF status, posting_run_id';
EXECUTE IMMEDIATE v_SelectSQL INTO l_status, l_request_id, l_budgetary_status USING batch_id, pd_name, actual_flag;
v_UpdateSQL := 'UPDATE gl_je_batches ' ||
'SET posting_run_id = :post_run_id, ' ||
'status = :bs ' ||
'WHERE je_batch_id = :b_id ' ||
'and default_period_name = :pd ' ||
-- 'and ledger_id = :ledger ' ||
'and actual_flag = :flag';
EXECUTE IMMEDIATE v_UpdateSQL USING post_run_id,l_batch_status,
batch_id, pd_name, actual_flag;
v_SelectSQL := 'select name from gl_je_batches ' ||
'WHERE je_batch_id = :b_id';
EXECUTE IMMEDIATE v_SelectSQL INTO l_batch_name USING batch_id;
v_Ledger_SQL := 'SELECT max(JEH.ledger_id) ' ||
'FROM GL_JE_HEADERS JEH ' ||
'WHERE JEH.je_batch_id = :je_batch_id ' ||
'GROUP BY JEH.je_batch_id ' ||
'HAVING count(distinct JEH.ledger_id) = 1';
v_ALC_SQL := 'SELECT 1 ' ||
'FROM GL_JE_HEADERS JEH ' ||
'WHERE JEH.je_batch_id = :je_batch_id ' ||
'AND JEH.actual_flag != ' || '''' || 'B' || '''' ||
' AND JEH.reversed_je_header_id IS NULL ' ||
'AND EXISTS ' ||
'(SELECT 1 ' ||
'FROM GL_LEDGER_RELATIONSHIPS LRL ' ||
'WHERE LRL.source_ledger_id = JEH.ledger_id ' ||
'AND LRL.target_ledger_category_code = ' ||
'''' || 'ALC' || '''' ||
' AND LRL.relationship_type_code IN ( ' ||
'''' || 'JOURNAL' || '''' || ', ' ||
'''' || 'SUBLEDGER' || '''' || ') ' ||
'AND LRL.application_id = 101 ' ||
'AND LRL.relationship_enabled_flag = ' ||
'''' || 'Y' || '''' ||
' AND JEH.je_source NOT IN ' ||
'(SELECT INC.je_source_name ' ||
'FROM GL_JE_INCLUSION_RULES INC ' ||
'WHERE INC.je_rule_set_id = ' ||
'LRL.gl_je_conversion_set_id ' ||
'AND INC.je_source_name = JEH.je_source ' ||
'AND INC.je_category_name = ' ||
'''' || 'Other' || '''' ||
' AND INC.include_flag = ' ||
'''' || 'N' || '''' ||
' AND INC.user_updatable_flag = ' ||
'''' || 'N' || '''' || '))';
v_UpdateSQL := 'UPDATE gl_je_batches ' ||
'SET request_id = :request_id ' ||
'WHERE je_batch_id = :b_id ' ||
'and default_period_name = :pd ' ||
-- 'and ledger_id = :ledger ' ||
'and posting_run_id = :post_run_id ' ||
'and actual_flag = :flag';
EXECUTE IMMEDIATE v_UpdateSQL USING reqid, batch_id, pd_name, post_run_id, actual_flag;
v_SelectSQL varchar2(300);
v_SelectSQL := 'select count(*) from gl_interface_control '||
'where group_id = :group_id';
EXECUTE IMMEDIATE v_SelectSQL INTO l_count USING p_group_id;
v_SelectSQL varchar2(500);