APPS.XTR_EFT_SCRIPT_P dependencies on XTR_SETTLEMENT_SCRIPTS

Line 21: from XTR_SETTLEMENT_SCRIPTS

17: --
18: cursor SEL_SCRIPTS is
19: select distinct substr(script_name,1,4), package_name,eft_script_output_path,
20: transmission_code
21: from XTR_SETTLEMENT_SCRIPTS
22: where script_type = 'SCRIPT'
23: and script_name = l_script_name
24: and authorised = 'Y';
25: -- and run_requested_on is NOT NULL;

Line 151: update XTR_SETTLEMENT_SCRIPTS

147: IF xtr_risk_debug_pkg.g_Debug THEN
148: XTR_RISK_DEBUG_PKG.dpop('CALL_SCRIPTS: ' || 'Call scripts');
149: END IF;
150:
151: update XTR_SETTLEMENT_SCRIPTS
152: set run_requested_on = trunc(sysdate),
153: last_run_on = trunc(sysdate),
154: last_run_by = fnd_global.user_id,
155: last_file_created = l_file_name

Line 222: XTR_SETTLEMENT_SCRIPTS s

218: cursor HEADER_REC is
219: select distinct d.account_no
220: from XTR_DEAL_DATE_AMOUNTS_V d,
221: XTR_BANK_ACCOUNTS b,
222: XTR_SETTLEMENT_SCRIPTS s
223: -- RV 2305918 where d.actual_settlement_date = NVL(to_date(settlement_date,'DD-MON-RR'), d.actual_settlement_date)
224: where d.actual_settlement_date = NVL(trunc(settlement_date), d.actual_settlement_date)
225: and d.company_code = l_company
226: and NVL(d.beneficiary_party,d.cparty_code) like nvl(l_cparty,'%')

Line 493: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '>UPDATE xtr_settlement_scripts table');

489: end if;
490: cre_count := 0;
491: --
492: IF xtr_risk_debug_pkg.g_Debug THEN
493: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '>UPDATE xtr_settlement_scripts table');
494: END IF;
495: update XTR_SETTLEMENT_SCRIPTS
496: set run_requested_on = null,
497: only_new_transactions = null,

Line 495: update XTR_SETTLEMENT_SCRIPTS

491: --
492: IF xtr_risk_debug_pkg.g_Debug THEN
493: XTR_RISK_DEBUG_PKG.dlog('BNZ_EFT: ' || '>UPDATE xtr_settlement_scripts table');
494: END IF;
495: update XTR_SETTLEMENT_SCRIPTS
496: set run_requested_on = null,
497: only_new_transactions = null,
498: --RV 2305918 last_run_on = to_date(settlement_date,'DD-MON-RR'),
499: last_run_on = trunc(settlement_date),

Line 522: XTR_SETTLEMENT_SCRIPTS s

518: and d.settle = 'Y'
519: and ((upper(sett) = 'Y') or (upper(sett) = 'N' and d.settlement_actioned is NULL))
520: and d.account_no = (select distinct b.account_number
521: from XTR_BANK_ACCOUNTS b,
522: XTR_SETTLEMENT_SCRIPTS s
523: where b.account_number = d.account_no
524: and b.party_code = upper(l_company)
525: and SUBSTR(b.eft_script_name,1,4) = l_eft_script_name --RV
526: and s.script_name = b.eft_script_name

Line 656: XTR_SETTLEMENT_SCRIPTS s

652: cursor HEADER_REC is
653: select distinct sw.company_acct_no
654: from XTR_SWIFT_EFT_V sw,
655: XTR_BANK_ACCOUNTS b,
656: XTR_SETTLEMENT_SCRIPTS s
657: where sw.settlement_date = NVL(trunc(settlement_date), sw.settlement_date)
658: and sw.company = l_company
659: and sw.cparty = nvl(l_cparty,sw.cparty)
660: and sw.company_acct_no = NVL(l_account, sw.company_acct_no)

Line 974: XTR_SETTLEMENT_SCRIPTS s

970: cursor HEADER_REC is
971: select distinct sw.company_acct_no
972: from XTR_SWIFT_EFT_V sw,
973: XTR_BANK_ACCOUNTS b,
974: XTR_SETTLEMENT_SCRIPTS s
975: where sw.settlement_date = NVL(trunc(settlement_date), sw.settlement_date)
976: and sw.company = l_company
977: and sw.cparty = nvl(l_cparty,sw.cparty)
978: and sw.company_acct_no = NVL(l_account, sw.company_acct_no)