[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT dim_attribute_numeric_member
FROM fem_entities_attr
WHERE entity_id = p_consolidation_entity_id
AND attribute_id =
gcs_utility_pkg.g_dimension_attr_info
('ENTITY_ID-ELIMINATION_ENTITY').attribute_id
AND version_id =
gcs_utility_pkg.g_dimension_attr_info
('ENTITY_ID-ELIMINATION_ENTITY').version_id;
'SELECT gat.assoc_entry_id, gat.cal_period_id, fcpa.number_assign_value + 1 '
|| g_nl
|| 'INTO l_entry_id, l_cal_period_id, l_year_to_apply_re '
|| g_nl
|| 'FROM fem_cal_periods_attr fcpa, gcs_ad_transactions gat'
|| g_nl
|| ' WHERE fcpa.cal_period_id = gat.cal_period_id
AND fcpa.attribute_id = ' ||
gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id ||'
AND fcpa.version_id = ' ||
gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id ||'
AND gat.AD_TRANSACTION_ID = '
|| p_xns_id
);
SELECT gat.assoc_entry_id, gat.cal_period_id, fcpa.number_assign_value + 1
INTO l_entry_id, l_cal_period_id, l_year_to_apply_re
FROM fem_cal_periods_attr fcpa, gcs_ad_transactions gat
WHERE fcpa.cal_period_id = gat.cal_period_id
AND fcpa.attribute_id =
gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').attribute_id
AND fcpa.version_id =
gcs_utility_pkg.g_dimension_attr_info ('CAL_PERIOD_ID-ACCOUNTING_YEAR').version_id
AND gat.ad_transaction_id = p_xns_id;
'SELECT gcs_entry_headers_s.NEXTVAL'
|| g_nl
|| 'INTO l_entry_id'
|| g_nl
|| 'FROM dual'
);
SELECT gcs_entry_headers_s.NEXTVAL
INTO l_entry_id
FROM DUAL;
gcs_entry_pkg.insert_entry_header
(p_entry_id => l_entry_id,
p_hierarchy_id => p_hierarchy_id,
p_entity_id => p_entity_id,
p_year_to_apply_re => l_year_to_apply_re,
p_start_cal_period_id => l_cal_period_id,
p_end_cal_period_id => NULL,
p_entry_type_code => p_entry_type_code,
p_balance_type_code => p_balance_type_code,
p_currency_code => p_currency_code,
p_process_code => 'ALL_RUN_FOR_PERIOD',
p_description => p_description,
p_entry_name => p_entry_name,
p_category_code => 'ACQ_DISP',
x_errbuf => l_errbuf,
x_retcode => l_retcode
);
'UPDATE gcs_ad_transactions'
|| g_nl
|| 'SET ASSOC_ENTRY_ID = '
|| l_entry_id
|| ', total_consideration = '
|| p_consideration_amount
|| g_nl
|| ', last_update_date = sysdate'
|| g_nl
|| 'WHERE AD_TRANSACTION_ID = '
|| p_xns_id
);
UPDATE gcs_ad_transactions
SET assoc_entry_id = l_entry_id,
total_consideration = p_consideration_amount,
last_update_date = sysdate
WHERE ad_transaction_id = p_xns_id;
SELECT 'Y'
INTO l_processed_entry_flag
FROM DUAL
WHERE EXISTS (SELECT run_detail_id
FROM gcs_cons_eng_run_dtls gcerd
WHERE gcerd.entry_id = l_entry_id);
FND_FILE.PUT_LINE(FND_FILE.LOG, g_pkg_name || '.' || l_api_name || ' UPDATE EXISTING ENTRY');
'UPDATE gcs_entry_headers'
|| g_nl
|| 'SET entry_name = '
|| p_entry_name
|| g_nl
|| ', description = '
|| p_description
|| ', balance_type_code = '
|| p_balance_type_code
|| g_nl
|| ', last_update_date = sysdate'
|| g_nl
|| 'WHERE entry_id = '
|| l_entry_id
);
UPDATE gcs_entry_headers
SET entry_name = p_entry_name,
description = p_description,
balance_type_code = p_balance_type_code,
last_update_date = sysdate
WHERE entry_id = l_entry_id;
'UPDATE gcs_ad_transactions'
|| g_nl
|| 'SET total_consideration = '
|| p_consideration_amount
|| g_nl
|| ', last_update_date = sysdate'
|| g_nl
|| 'WHERE AD_TRANSACTION_ID = '
|| p_xns_id
);
UPDATE gcs_ad_transactions
SET total_consideration = p_consideration_amount,
last_update_date = sysdate
WHERE ad_transaction_id = p_xns_id;
'SELECT gcs_entry_headers_s.NEXTVAL'
|| g_nl
|| 'INTO l_new_entry_id'
|| g_nl
|| 'FROM dual'
);
SELECT gcs_entry_headers_s.NEXTVAL
INTO l_new_entry_id
FROM DUAL;
'UPDATE gcs_entry_headers'
|| g_nl
|| 'SET disabled_flag = ''Y'''
|| g_nl
|| ',entry_name = substr(entry_name, 0, 55) || '' OLD ->'' || '
|| l_new_entry_id
|| ', last_update_date = sysdate '
|| g_nl
|| 'WHERE entry_id = '
|| l_entry_id
);
UPDATE gcs_entry_headers
SET disabled_flag = 'Y',
entry_name = substr(entry_name, 0, 55) || ' OLD ->' || l_new_entry_id,
last_update_date = sysdate
WHERE entry_id = l_entry_id;
gcs_entry_pkg.insert_entry_header
(p_entry_id => l_entry_id,
p_hierarchy_id => p_hierarchy_id,
p_entity_id => p_entity_id,
p_year_to_apply_re => l_year_to_apply_re,
p_start_cal_period_id => l_cal_period_id,
p_end_cal_period_id => NULL,
p_entry_type_code => p_entry_type_code,
p_balance_type_code => p_balance_type_code,
p_currency_code => p_currency_code,
p_process_code => 'ALL_RUN_FOR_PERIOD',
p_description => p_description,
p_entry_name => p_entry_name,
p_category_code => 'ACQ_DISP',
x_errbuf => l_errbuf,
x_retcode => l_retcode
);
'UPDATE gcs_ad_transactions'
|| g_nl
|| 'SET ASSOC_ENTRY_ID = '
|| l_entry_id
|| ', total_consideration = '
|| p_consideration_amount
|| g_nl
|| ', last_update_date = sysdate'
|| g_nl
|| 'WHERE AD_TRANSACTION_ID = '
|| p_xns_id
);
UPDATE gcs_ad_transactions
SET assoc_entry_id = l_entry_id,
total_consideration = p_consideration_amount,
last_update_date = sysdate
WHERE ad_transaction_id = p_xns_id;
l_event_name VARCHAR2 (100) := 'oracle.apps.gcs.transaction.acqdisp.update';
'select assoc_entry_id into l_orig_entry_id from gcs_ad_transactions
where ad_transaction_id = '
|| p_xns_id
);
select assoc_entry_id
into l_orig_entry_id
from gcs_ad_transactions
where ad_transaction_id = p_xns_id;
'select decode(count(entry_id), 0, ''ACTUAL'', ''ADB'') into l_balance_type_code
from gcs_entry_lines where entry_id = -1 and financial_elem_id = 140'
);
select decode(count(entry_id), 0, 'ACTUAL', 'ADB')
into l_balance_type_code
from gcs_entry_lines
where entry_id = -1
and financial_elem_id = 140;
'delete from gcs_entry_lines'
|| g_nl
|| 'where entry_id = '
|| l_entry_id
);
DELETE FROM gcs_entry_lines
WHERE entry_id = l_entry_id;
'update gcs_entry_lines'
|| g_nl
|| 'set entry_id = '
|| l_entry_id
|| ', last_update_date = sysdate,'
|| g_nl
|| ' line_type_code = decode((SELECT feata.dim_attribute_varchar_member
FROM fem_ext_acct_types_attr feata,
fem_ln_items_attr flia
WHERE gcs_entry_lines.line_item_id =
flia.line_item_id
AND flia.value_set_id =' ||
gcs_utility_pkg.g_gcs_dimension_info ('LINE_ITEM_ID').associated_value_set_id || '
AND flia.attribute_id = '||
gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').attribute_id || '
AND flia.version_id = '||
gcs_utility_pkg.g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE').version_id || '
AND feata.attribute_id = '||
gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').attribute_id || '
AND feata.version_id = '||
gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id || '
AND feata.ext_account_type_code =
flia.dim_attribute_varchar_member), ''REVENUE'', ''PROFIT_LOSS'',
''EXPENSE'', ''PROFIT_LOSS'', ''BALANCE_SHEET'') '
|| g_nl
|| 'where entry_id = -1'
);
UPDATE gcs_entry_lines
SET entry_id = l_entry_id,
last_update_date = sysdate,
ytd_balance_e = NVL(ytd_debit_balance_e, 0) - NVL(ytd_credit_balance_e, 0),
line_type_code = decode(
(SELECT feata.dim_attribute_varchar_member
FROM fem_ext_acct_types_attr feata,
fem_ln_items_attr flia
WHERE gcs_entry_lines.line_item_id = flia.line_item_id
AND flia.value_set_id = l_line_item_vs_id
AND flia.attribute_id = l_ext_acct_type_attr
AND flia.version_id = l_ext_acct_type_version
AND feata.attribute_id = l_basic_acct_type_attr
AND feata.version_id = l_basic_acct_type_version
AND feata.ext_account_type_code = flia.dim_attribute_varchar_member
), 'REVENUE', 'PROFIT_LOSS', 'EXPENSE', 'PROFIT_LOSS', 'BALANCE_SHEET'
)
WHERE entry_id = -1;
'SELECT org_output_code INTO l_org_code '
|| 'FROM gcs_categories_b WHERE category_code = ''ACQ_DISP'''
);
SELECT org_output_code
INTO l_org_code
FROM gcs_categories_b
WHERE category_code = 'ACQ_DISP';
'update gcs_ad_transactions'
|| g_nl
|| 'set request_id = '
|| fnd_global.conc_request_id
|| g_nl
|| ', last_update_date = sysdate'
|| g_nl
|| 'where ad_transaction_id = ' || p_xns_id
);
UPDATE gcs_ad_transactions
SET request_id = fnd_global.conc_request_id,
last_update_date = sysdate
WHERE ad_transaction_id = p_xns_id;
:= 'oracle.apps.gcs.transaction.acqdisp.update';
select assoc_entry_id
into l_orig_entry_id
from gcs_ad_transactions
where ad_transaction_id = p_xns_id;
select decode(count(ad_transaction_id), 0, 'ACTUAL', 'ADB')
into l_balance_type_code
from gcs_ad_trial_balances
where ad_transaction_id = -1
and financial_elem_id = 140;
'DELETE FROM GCS_AD_TRIAL_BALANCES'
|| g_nl
|| 'WHERE AD_TRANSACTION_ID = '
|| p_xns_id
);
DELETE FROM gcs_ad_trial_balances
WHERE ad_transaction_id = p_xns_id;
'UPDATE GCS_AD_TRIAL_BALANCES'
|| g_nl
|| 'SET ad_transaction_id = '
|| p_xns_id
|| ', last_update_date = sysdate'
|| g_nl
|| 'WHERE AD_TRANSACTION_ID = -1'
);
UPDATE gcs_ad_trial_balances
SET ad_transaction_id = p_xns_id,
last_update_date = sysdate
WHERE ad_transaction_id = -1;
SELECT decode(NVL(gcerd.run_detail_id, 0), 0, 'N', 'Y'), xns.assoc_entry_id
FROM gcs_ad_transactions xns, gcs_cons_eng_run_dtls gcerd
WHERE xns.ad_transaction_id = p_xns_id
and gcerd.entry_id (+) = xns.assoc_entry_id;
:= 'oracle.apps.gcs.transaction.acqdisp.update';
'UPDATE gcs_entry_headers set disabled_flag = ''Y'' WHERE entry_id = '
|| l_entry_id
);
update gcs_entry_headers set disabled_flag = 'Y' where entry_id = l_entry_id;
'UPDATE gcs_ad_transactions set assoc_entry_id = null, request_id = null WHERE ad_transaction_id = '
|| p_xns_id
);
update gcs_ad_transactions set assoc_entry_id = null, request_id = null where ad_transaction_id = p_xns_id;
'DELETE FROM gcs_entry_headers WHERE entry_id = '
|| l_entry_id
);
delete from gcs_entry_headers where entry_id = l_entry_id;
'DELETE FROM gcs_entry_lines WHERE entry_id = '
|| l_entry_id
);
delete from gcs_entry_lines where entry_id = l_entry_id;
'UPDATE gcs_ad_transactions set assoc_entry_id = null, request_id = null WHERE ad_transaction_id = '
|| p_xns_id
);
update gcs_ad_transactions set assoc_entry_id = null, request_id = null where ad_transaction_id = p_xns_id;
'UPDATE gcs_ad_transactions set request_id = null WHERE ad_transaction_id = '
|| p_xns_id
);
update gcs_ad_transactions set request_id = null where ad_transaction_id = p_xns_id;