APPS.XTR_SETTLEMENT dependencies on XTR_SETTLEMENT

Line 1: PACKAGE BODY XTR_SETTLEMENT as

1: PACKAGE BODY XTR_SETTLEMENT as
2: /* $Header: xtrsettb.pls 120.8 2005/07/29 15:01:42 csutaria ship $ */
3: ---------------------------------------------------------------------------------
4:
5:

Line 42: XTR_SETTLEMENT_SCRIPTS s

38: cursor HEADER_REC is
39: select distinct s.script_name, s.script_type, s.package_name
40: from XTR_DEAL_DATE_AMOUNTS_V dda,
41: XTR_BANK_ACCOUNTS ba,
42: XTR_SETTLEMENT_SCRIPTS s
43: WHERE trunc(dda.actual_settlement_date) = trunc(NVL(Settlement_date,dda.actual_settlement_date))
44: and dda.company_code = NVL(l_company, dda.company_code)
45: and NVL(dda.beneficiary_party,dda.cparty_code) like NVL(l_cparty,'%')
46: and dda.amount >= NVL(l_setl_amt_from, dda.amount)

Line 73: xtr_debug_pkg.debug('SETTLEMENT_SCRIPTS: ' || '>XTR_SETTLEMENT.settlement_script');

69: -- cep_standard.enable_debug;
70: xtr_debug_pkg.enable_file_debug;
71: END IF;
72: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
73: xtr_debug_pkg.debug('SETTLEMENT_SCRIPTS: ' || '>XTR_SETTLEMENT.settlement_script');
74: END IF;
75: settlement_date := to_date(l_paydate, 'YYYY/MM/DD HH24:MI:SS');
76:
77: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 201: xtr_debug_pkg.debug('SETTLEMENT_SCRIPTS: ' || '> Close Cursor XTR_SETTLEMENT HEADER_REC ');

197:
198: END LOOP; -- end header_rec loop thru scripts
199: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
200: xtr_debug_pkg.debug('SETTLEMENT_SCRIPTS: ' || '> END LOOP ');
201: xtr_debug_pkg.debug('SETTLEMENT_SCRIPTS: ' || '> Close Cursor XTR_SETTLEMENT HEADER_REC ');
202: END IF;
203: close HEADER_REC; -- close cursor
204:
205: IF (l_display_debug = 'Y') THEN

Line 219: END XTR_SETTLEMENT;

215:
216: END SETTLEMENT_SCRIPTS;
217: -----------------------------------------------------------------------------------
218:
219: END XTR_SETTLEMENT;