[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select text
from xtr_sys_languages_vl
where item_name = p_Field_Name;
select 1
from XTR_MASTER_CURRENCIES
where currency = c_curr;
select a.BANK_CODE,
a.AUTHORISED
from XTR_BANK_ACCOUNTS_V a,
XTR_PARTY_INFO b
where a.party_code = c_party
and a.currency = c_curr
and nvl(a.setoff_account_yn,'N') <> 'Y'
and a.account_number = c_party_acct
and a.bank_code = b.party_code
order by nvl(a.authorised,'N') desc;
select 1
from XTR_AUTH_PRODUCT_TYPES_V
where deal_type = C_iac_type
and Product_Type = c_product;
select 1
from XTR_PORTFOLIOS_V
where company_code = c_comp
and nvl(external_portfolio,'N') <> 'Y'
and portfolio = c_portfolio;
select 1
into l_temp
from xtr_dealer_codes_v
where dealer_code = p_dealer_code
and rownum = 1;
select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no from DUAL;
select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no2 from DUAL;
select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no from DUAL;
select XTR_SETTLEMENT_NUMBER_S.NEXTVAL into p_settle_no2 from DUAL;
insert into XTR_DEAL_DATE_AMOUNTS_V
(deal_type, amount_type, date_type, product_type,
deal_number, transaction_number, transaction_date,
currency, amount, hce_amount, amount_date,
cashflow_amount, company_code, account_no, action_code,
cparty_code, cparty_account_no, status_code,
exp_settle_reqd, deal_subtype, portfolio_code, dealer_code,
limit_party, DUAL_AUTHORISATION_BY, DUAL_AUTHORISATION_ON,
SETTLE, SETTLEMENT_NUMBER, SETTLEMENT_AUTHORISED_BY, ACTUAL_SETTLEMENT_DATE,
TRANS_MTS, AUDIT_INDICATOR)
values ( ARec_IAC.deal_type, 'AMOUNT', 'VALUE', ARec_IAC.PRODUCT_TYPE,
0, p_tran_num, ARec_IAC.deal_date, -- per TD design
ARec_IAC.CURRENCY, ARec_IAC.TRANSFER_AMOUNT, 0, ARec_IAC.Transfer_date,
-ARec_IAC.TRANSFER_AMOUNT,ARec_IAC.COMPANY_CODE, ARec_IAC.ACCOUNT_NO_FROM, 'PAY',
ARec_IAC.COMPANY_CODE, ARec_IAC.ACCOUNT_NO_TO, ARec_IAC.STATUS_CODE,
'Y', ARec_IAC.DEAL_SUBTYPE, ARec_IAC.PORTFOLIO_CODE, ARec_IAC.DEALER_CODE,
p_From_Bank, l_dual_auth_by, l_dual_auth_on,
l_settle, l_settle_no, l_settle_auth, l_settle_date,
l_trans_mts, l_audit_indic);
insert into XTR_DEAL_DATE_AMOUNTS_V
(deal_type, amount_type, date_type, product_type,
deal_number, transaction_number, transaction_date,
currency, amount, hce_amount, amount_date,
cashflow_amount, company_code, account_no, action_code,
cparty_code, cparty_account_no, status_code,
exp_settle_reqd, deal_subtype, portfolio_code, dealer_code,
limit_party, DUAL_AUTHORISATION_BY, DUAL_AUTHORISATION_ON,
SETTLE, SETTLEMENT_NUMBER, SETTLEMENT_AUTHORISED_BY, ACTUAL_SETTLEMENT_DATE,
TRANS_MTS, AUDIT_INDICATOR)
values ( ARec_IAC.deal_type, 'AMOUNT', 'VALUE', ARec_IAC.PRODUCT_TYPE,
0, p_tran_num, ARec_IAC.deal_date, -- per TD design
ARec_IAC.CURRENCY, ARec_IAC.TRANSFER_AMOUNT, 0, ARec_IAC.TRANSFER_DATE,
ARec_IAC.TRANSFER_AMOUNT, ARec_IAC.COMPANY_CODE, ARec_IAC.ACCOUNT_NO_TO, 'REC',
ARec_IAC.COMPANY_CODE, ARec_IAC.ACCOUNT_NO_FROM, ARec_IAC.STATUS_CODE,
'Y', ARec_IAC.DEAL_SUBTYPE, ARec_IAC.PORTFOLIO_CODE, ARec_IAC.DEALER_CODE,
p_To_Bank, l_dual_auth_by, l_dual_auth_on,
l_settle, l_settle_no2, l_settle_auth, l_settle_date,
l_trans_mts, l_audit_indic);
select XTR_EXPOSURE_TRANS_S.NEXTVAL
from DUAL;
Insert into XTR_INTERACCT_TRANSFERS(
ACCOUNT_NO_FROM,
ACCOUNT_NO_TO,
COMPANY_CODE,
CURRENCY,
DEAL_SUBTYPE,
DEAL_TYPE,
PORTFOLIO_CODE,
PRODUCT_TYPE,
STATUS_CODE,
TRANSFER_AMOUNT,
TRANSFER_DATE,
TRANSACTION_NUMBER,
CREATION_DATE,
CREATED_BY,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
DUAL_AUTHORISATION_BY,
DUAL_AUTHORISATION_ON,
DEAL_DATE,
DEALER_CODE,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
EXTERNAL_SOURCE)
Values ( ARec_IAC.ACCOUNT_NO_FROM,
ARec_IAC.ACCOUNT_NO_TO,
ARec_IAC.COMPANY_CODE,
ARec_IAC.CURRENCY,
ARec_IAC.DEAL_SUBTYPE, -- DEAL_SUBTYPE
ARec_IAC.DEAL_TYPE, -- DEAL_TYPE
ARec_IAC.PORTFOLIO_CODE,
ARec_IAC.PRODUCT_TYPE,
ARec_IAC.STATUS_CODE, -- STATUS_CODE
ARec_IAC.TRANSFER_AMOUNT,
ARec_IAC.TRANSFER_DATE,
p_tran_num, -- TRANSACTION_NUMBER
G_sys_date, -- CREATION_DATE
fnd_global.user_id, -- CREATED_BY
fnd_global.user_id, -- LAST_UPDATED_BY
G_sys_date, -- LAST_UPDATE_DATE
fnd_global.user_id, -- LAST_UPDATE_LOGIN
l_dual_dealer, -- DUAL_AUTHORIZATION_BY
l_dual_date, -- DUAL_AUTHORIZATION_ON
ARec_IAC.DEAL_DATE, -- DEAL DATE
ARec_IAC.DEALER_CODE, -- DEALER_CODE
fnd_global.conc_request_id,
fnd_global.prog_appl_id,
fnd_global.conc_program_id,
G_sys_date,
ARec_IAC.EXTERNAL_SOURCE);
select dealer_code
from xtr_dealer_codes_v
where user_id = p_fnd_user;
select 1
from xtr_parties_v
where party_type = 'C'
and party_code = l_comp;
select XTR_EXPOSURE_TRANS_S.NEXTVAL
from DUAL;
Select sysdate, trunc(sysdate)
into G_sys_date, G_iac_date
From Dual;