eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_CP_PRIORDAY dependencies on CE_CP_PRIORDAY

Line 1: PACKAGE BODY CE_CP_PRIORDAY AS

1: PACKAGE BODY CE_CP_PRIORDAY AS
2: /* $Header: cecpprib.pls 120.5 2006/07/11 13:25:20 jikumar ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
5:

Line 27: cep_standard.debug('>>CE_CP_PRIORDAY.set_parameters -------');

23: p_debug_path VARCHAR2,
24: p_debug_file VARCHAR2) IS
25: BEGIN
26: IF l_debug in ('Y', 'C') THEN
27: cep_standard.debug('>>CE_CP_PRIORDAY.set_parameters -------');
28: END IF;
29: CE_CP_PRIORDAY.G_worksheet_header_id := p_worksheet_header_id;
30: IF (p_as_of_date is null) THEN
31: CE_CP_PRIORDAY.G_purge_flag := 'Y';

Line 29: CE_CP_PRIORDAY.G_worksheet_header_id := p_worksheet_header_id;

25: BEGIN
26: IF l_debug in ('Y', 'C') THEN
27: cep_standard.debug('>>CE_CP_PRIORDAY.set_parameters -------');
28: END IF;
29: CE_CP_PRIORDAY.G_worksheet_header_id := p_worksheet_header_id;
30: IF (p_as_of_date is null) THEN
31: CE_CP_PRIORDAY.G_purge_flag := 'Y';
32: ELSE
33: CE_CP_PRIORDAY.G_purge_flag := 'N';

Line 31: CE_CP_PRIORDAY.G_purge_flag := 'Y';

27: cep_standard.debug('>>CE_CP_PRIORDAY.set_parameters -------');
28: END IF;
29: CE_CP_PRIORDAY.G_worksheet_header_id := p_worksheet_header_id;
30: IF (p_as_of_date is null) THEN
31: CE_CP_PRIORDAY.G_purge_flag := 'Y';
32: ELSE
33: CE_CP_PRIORDAY.G_purge_flag := 'N';
34: END IF;
35: CE_CP_PRIORDAY.G_as_of_date := nvl(to_date(p_as_of_date,

Line 33: CE_CP_PRIORDAY.G_purge_flag := 'N';

29: CE_CP_PRIORDAY.G_worksheet_header_id := p_worksheet_header_id;
30: IF (p_as_of_date is null) THEN
31: CE_CP_PRIORDAY.G_purge_flag := 'Y';
32: ELSE
33: CE_CP_PRIORDAY.G_purge_flag := 'N';
34: END IF;
35: CE_CP_PRIORDAY.G_as_of_date := nvl(to_date(p_as_of_date,
36: 'YYYY/MM/DD HH24:MI:SS'),
37: trunc(sysdate));

Line 35: CE_CP_PRIORDAY.G_as_of_date := nvl(to_date(p_as_of_date,

31: CE_CP_PRIORDAY.G_purge_flag := 'Y';
32: ELSE
33: CE_CP_PRIORDAY.G_purge_flag := 'N';
34: END IF;
35: CE_CP_PRIORDAY.G_as_of_date := nvl(to_date(p_as_of_date,
36: 'YYYY/MM/DD HH24:MI:SS'),
37: trunc(sysdate));
38: CE_CP_PRIORDAY.G_display_debug := p_display_debug;
39: CE_CP_PRIORDAY.G_debug_path := p_debug_path;

Line 38: CE_CP_PRIORDAY.G_display_debug := p_display_debug;

34: END IF;
35: CE_CP_PRIORDAY.G_as_of_date := nvl(to_date(p_as_of_date,
36: 'YYYY/MM/DD HH24:MI:SS'),
37: trunc(sysdate));
38: CE_CP_PRIORDAY.G_display_debug := p_display_debug;
39: CE_CP_PRIORDAY.G_debug_path := p_debug_path;
40: CE_CP_PRIORDAY.G_debug_file := p_debug_file;
41:
42: cep_standard.debug('G_worksheet_header_id = ' ||

Line 39: CE_CP_PRIORDAY.G_debug_path := p_debug_path;

35: CE_CP_PRIORDAY.G_as_of_date := nvl(to_date(p_as_of_date,
36: 'YYYY/MM/DD HH24:MI:SS'),
37: trunc(sysdate));
38: CE_CP_PRIORDAY.G_display_debug := p_display_debug;
39: CE_CP_PRIORDAY.G_debug_path := p_debug_path;
40: CE_CP_PRIORDAY.G_debug_file := p_debug_file;
41:
42: cep_standard.debug('G_worksheet_header_id = ' ||
43: CE_CP_PRIORDAY.G_worksheet_header_id);

Line 40: CE_CP_PRIORDAY.G_debug_file := p_debug_file;

36: 'YYYY/MM/DD HH24:MI:SS'),
37: trunc(sysdate));
38: CE_CP_PRIORDAY.G_display_debug := p_display_debug;
39: CE_CP_PRIORDAY.G_debug_path := p_debug_path;
40: CE_CP_PRIORDAY.G_debug_file := p_debug_file;
41:
42: cep_standard.debug('G_worksheet_header_id = ' ||
43: CE_CP_PRIORDAY.G_worksheet_header_id);
44: cep_standard.debug('G_as_of_date = ' || CE_CP_PRIORDAY.G_as_of_date);

Line 43: CE_CP_PRIORDAY.G_worksheet_header_id);

39: CE_CP_PRIORDAY.G_debug_path := p_debug_path;
40: CE_CP_PRIORDAY.G_debug_file := p_debug_file;
41:
42: cep_standard.debug('G_worksheet_header_id = ' ||
43: CE_CP_PRIORDAY.G_worksheet_header_id);
44: cep_standard.debug('G_as_of_date = ' || CE_CP_PRIORDAY.G_as_of_date);
45: cep_standard.debug('G_display_debug = ' || CE_CP_PRIORDAY.G_display_debug);
46: cep_standard.debug('G_debug_path = ' || CE_CP_PRIORDAY.G_debug_path);
47: cep_standard.debug('G_debug_file = ' || CE_CP_PRIORDAY.G_debug_file);

Line 44: cep_standard.debug('G_as_of_date = ' || CE_CP_PRIORDAY.G_as_of_date);

40: CE_CP_PRIORDAY.G_debug_file := p_debug_file;
41:
42: cep_standard.debug('G_worksheet_header_id = ' ||
43: CE_CP_PRIORDAY.G_worksheet_header_id);
44: cep_standard.debug('G_as_of_date = ' || CE_CP_PRIORDAY.G_as_of_date);
45: cep_standard.debug('G_display_debug = ' || CE_CP_PRIORDAY.G_display_debug);
46: cep_standard.debug('G_debug_path = ' || CE_CP_PRIORDAY.G_debug_path);
47: cep_standard.debug('G_debug_file = ' || CE_CP_PRIORDAY.G_debug_file);
48:

Line 45: cep_standard.debug('G_display_debug = ' || CE_CP_PRIORDAY.G_display_debug);

41:
42: cep_standard.debug('G_worksheet_header_id = ' ||
43: CE_CP_PRIORDAY.G_worksheet_header_id);
44: cep_standard.debug('G_as_of_date = ' || CE_CP_PRIORDAY.G_as_of_date);
45: cep_standard.debug('G_display_debug = ' || CE_CP_PRIORDAY.G_display_debug);
46: cep_standard.debug('G_debug_path = ' || CE_CP_PRIORDAY.G_debug_path);
47: cep_standard.debug('G_debug_file = ' || CE_CP_PRIORDAY.G_debug_file);
48:
49: END set_parameters;

Line 46: cep_standard.debug('G_debug_path = ' || CE_CP_PRIORDAY.G_debug_path);

42: cep_standard.debug('G_worksheet_header_id = ' ||
43: CE_CP_PRIORDAY.G_worksheet_header_id);
44: cep_standard.debug('G_as_of_date = ' || CE_CP_PRIORDAY.G_as_of_date);
45: cep_standard.debug('G_display_debug = ' || CE_CP_PRIORDAY.G_display_debug);
46: cep_standard.debug('G_debug_path = ' || CE_CP_PRIORDAY.G_debug_path);
47: cep_standard.debug('G_debug_file = ' || CE_CP_PRIORDAY.G_debug_file);
48:
49: END set_parameters;
50:

Line 47: cep_standard.debug('G_debug_file = ' || CE_CP_PRIORDAY.G_debug_file);

43: CE_CP_PRIORDAY.G_worksheet_header_id);
44: cep_standard.debug('G_as_of_date = ' || CE_CP_PRIORDAY.G_as_of_date);
45: cep_standard.debug('G_display_debug = ' || CE_CP_PRIORDAY.G_display_debug);
46: cep_standard.debug('G_debug_path = ' || CE_CP_PRIORDAY.G_debug_path);
47: cep_standard.debug('G_debug_file = ' || CE_CP_PRIORDAY.G_debug_file);
48:
49: END set_parameters;
50:
51: PROCEDURE calculate_summary IS

Line 53: l_bank_account_id CE_CP_PRIORDAY_BALANCES.bank_account_id%TYPE;

49: END set_parameters;
50:
51: PROCEDURE calculate_summary IS
52: l_ws_id CE_CP_WORKSHEET_HEADERS.worksheet_header_id%TYPE;
53: l_bank_account_id CE_CP_PRIORDAY_BALANCES.bank_account_id%TYPE;
54: l_currency_code VARCHAR2(15);
55: l_statement_date DATE;
56: tmp_balance NUMBER;
57:

Line 66: AND OPEN.statement_date < CE_CP_PRIORDAY.G_as_of_date

62: FROM CE_CP_OPEN_BAL_V OPEN,
63: CE_CP_WS_BA_V WBA
64: WHERE WBA.worksheet_header_id = p_ws_id
65: AND WBA.bank_account_id = OPEN.bank_account_id
66: AND OPEN.statement_date < CE_CP_PRIORDAY.G_as_of_date
67: AND OPEN.next_stmt_date >= CE_CP_PRIORDAY.G_as_of_date;
68:
69: CURSOR ba_cursor IS
70: SELECT bank_account_id,

Line 67: AND OPEN.next_stmt_date >= CE_CP_PRIORDAY.G_as_of_date;

63: CE_CP_WS_BA_V WBA
64: WHERE WBA.worksheet_header_id = p_ws_id
65: AND WBA.bank_account_id = OPEN.bank_account_id
66: AND OPEN.statement_date < CE_CP_PRIORDAY.G_as_of_date
67: AND OPEN.next_stmt_date >= CE_CP_PRIORDAY.G_as_of_date;
68:
69: CURSOR ba_cursor IS
70: SELECT bank_account_id,
71: currency_code,

Line 74: WHERE statement_date < CE_CP_PRIORDAY.G_as_of_date

70: SELECT bank_account_id,
71: currency_code,
72: statement_date
73: FROM CE_CP_OPEN_BAL_V
74: WHERE statement_date < CE_CP_PRIORDAY.G_as_of_date
75: AND next_stmt_date >= CE_CP_PRIORDAY.G_as_of_date;
76:
77: CURSOR ws_cursor IS
78: SELECT worksheet_header_id

Line 75: AND next_stmt_date >= CE_CP_PRIORDAY.G_as_of_date;

71: currency_code,
72: statement_date
73: FROM CE_CP_OPEN_BAL_V
74: WHERE statement_date < CE_CP_PRIORDAY.G_as_of_date
75: AND next_stmt_date >= CE_CP_PRIORDAY.G_as_of_date;
76:
77: CURSOR ws_cursor IS
78: SELECT worksheet_header_id
79: FROM CE_CP_WORKSHEET_HEADERS

Line 81: AND (CE_CP_PRIORDAY.G_worksheet_header_id is null

77: CURSOR ws_cursor IS
78: SELECT worksheet_header_id
79: FROM CE_CP_WORKSHEET_HEADERS
80: WHERE pd_flag = 'Y'
81: AND (CE_CP_PRIORDAY.G_worksheet_header_id is null
82: OR worksheet_header_id = CE_CP_PRIORDAY.G_worksheet_header_id);
83:
84: BEGIN
85:

Line 82: OR worksheet_header_id = CE_CP_PRIORDAY.G_worksheet_header_id);

78: SELECT worksheet_header_id
79: FROM CE_CP_WORKSHEET_HEADERS
80: WHERE pd_flag = 'Y'
81: AND (CE_CP_PRIORDAY.G_worksheet_header_id is null
82: OR worksheet_header_id = CE_CP_PRIORDAY.G_worksheet_header_id);
83:
84: BEGIN
85:
86: IF l_debug in ('Y', 'C') THEN

Line 87: cep_standard.debug('>>CE_CP_PRIORDAY.calculate_summary -------');

83:
84: BEGIN
85:
86: IF l_debug in ('Y', 'C') THEN
87: cep_standard.debug('>>CE_CP_PRIORDAY.calculate_summary -------');
88: END IF;
89:
90: /* purge prior-day data */
91: IF (CE_CP_PRIORDAY.G_purge_flag = 'Y') THEN

Line 91: IF (CE_CP_PRIORDAY.G_purge_flag = 'Y') THEN

87: cep_standard.debug('>>CE_CP_PRIORDAY.calculate_summary -------');
88: END IF;
89:
90: /* purge prior-day data */
91: IF (CE_CP_PRIORDAY.G_purge_flag = 'Y') THEN
92: BEGIN
93: DELETE CE_CP_PRIORDAY_BALANCES
94: WHERE worksheet_header_id = -1
95: AND as_of_date <= trunc(sysdate);

Line 93: DELETE CE_CP_PRIORDAY_BALANCES

89:
90: /* purge prior-day data */
91: IF (CE_CP_PRIORDAY.G_purge_flag = 'Y') THEN
92: BEGIN
93: DELETE CE_CP_PRIORDAY_BALANCES
94: WHERE worksheet_header_id = -1
95: AND as_of_date <= trunc(sysdate);
96: END;
97: ELSE

Line 99: DELETE CE_CP_PRIORDAY_BALANCES

95: AND as_of_date <= trunc(sysdate);
96: END;
97: ELSE
98: BEGIN
99: DELETE CE_CP_PRIORDAY_BALANCES
100: WHERE worksheet_header_id = -1
101: AND as_of_date = CE_CP_PRIORDAY.G_as_of_date;
102: END;
103: END IF;

Line 101: AND as_of_date = CE_CP_PRIORDAY.G_as_of_date;

97: ELSE
98: BEGIN
99: DELETE CE_CP_PRIORDAY_BALANCES
100: WHERE worksheet_header_id = -1
101: AND as_of_date = CE_CP_PRIORDAY.G_as_of_date;
102: END;
103: END IF;
104:
105: /* generate prior-day data */

Line 114: LOCK TABLE CE_CP_PRIORDAY_BALANCES in EXCLUSIVE MODE;

110:
111: BEGIN
112:
113: --bug5219376
114: LOCK TABLE CE_CP_PRIORDAY_BALANCES in EXCLUSIVE MODE;
115:
116: INSERT INTO CE_CP_PRIORDAY_BALANCES
117: (worksheet_header_id,
118: as_of_date,

Line 116: INSERT INTO CE_CP_PRIORDAY_BALANCES

112:
113: --bug5219376
114: LOCK TABLE CE_CP_PRIORDAY_BALANCES in EXCLUSIVE MODE;
115:
116: INSERT INTO CE_CP_PRIORDAY_BALANCES
117: (worksheet_header_id,
118: as_of_date,
119: bank_account_id,
120: balance_date,

Line 129: CE_CP_PRIORDAY.G_as_of_date,

125: last_update_login,
126: creation_date,
127: created_by)
128: VALUES (-1,
129: CE_CP_PRIORDAY.G_as_of_date,
130: l_bank_account_id,
131: l_statement_date,
132: 'HEAD',
133: 0,

Line 152: < CE_CP_PRIORDAY.G_as_of_date;

148: AND nvl(actual_value_date, nvl(anticipated_value_date,
149: nvl(maturity_date, payment_date))) > l_statement_date
150: AND nvl(actual_value_date, nvl(anticipated_value_date,
151: nvl(maturity_date, payment_date)))
152: < CE_CP_PRIORDAY.G_as_of_date;
153:
154: IF (tmp_balance IS NOT NULL) THEN
155: BEGIN
156: INSERT INTO CE_CP_PRIORDAY_BALANCES

Line 156: INSERT INTO CE_CP_PRIORDAY_BALANCES

152: < CE_CP_PRIORDAY.G_as_of_date;
153:
154: IF (tmp_balance IS NOT NULL) THEN
155: BEGIN
156: INSERT INTO CE_CP_PRIORDAY_BALANCES
157: (worksheet_header_id,
158: as_of_date,
159: bank_account_id,
160: balance_date,

Line 169: CE_CP_PRIORDAY.G_as_of_date,

165: last_update_login,
166: creation_date,
167: created_by)
168: VALUES (-1,
169: CE_CP_PRIORDAY.G_as_of_date,
170: l_bank_account_id,
171: l_statement_date,
172: 'APP',
173: tmp_balance,

Line 190: AND cash_Activity_date < CE_CP_PRIORDAY.G_as_of_date;

186: INTO tmp_balance
187: FROM CE_AR_FC_RECEIPTS_V
188: WHERE bank_account_id = l_bank_account_id
189: AND cash_activity_date > l_statement_date
190: AND cash_Activity_date < CE_CP_PRIORDAY.G_as_of_date;
191:
192: IF (tmp_balance is not null) THEN
193: BEGIN
194: INSERT INTO CE_CP_PRIORDAY_BALANCES

Line 194: INSERT INTO CE_CP_PRIORDAY_BALANCES

190: AND cash_Activity_date < CE_CP_PRIORDAY.G_as_of_date;
191:
192: IF (tmp_balance is not null) THEN
193: BEGIN
194: INSERT INTO CE_CP_PRIORDAY_BALANCES
195: (worksheet_header_id,
196: as_of_date,
197: bank_account_id,
198: balance_date,

Line 207: CE_CP_PRIORDAY.G_as_of_date,

203: last_update_login,
204: creation_date,
205: created_by)
206: VALUES (-1,
207: CE_CP_PRIORDAY.G_as_of_date,
208: l_bank_account_id,
209: l_statement_date,
210: 'ARR',
211: tmp_balance,

Line 228: AND trx_date < CE_CP_PRIORDAY.G_as_of_date;

224: INTO tmp_balance
225: FROM CE_XTR_CASHFLOWS_V
226: WHERE bank_account_id = l_bank_account_id
227: AND trx_date > l_statement_date
228: AND trx_date < CE_CP_PRIORDAY.G_as_of_date;
229:
230: IF (tmp_balance is not null) THEN
231: BEGIN
232: INSERT INTO CE_CP_PRIORDAY_BALANCES

Line 232: INSERT INTO CE_CP_PRIORDAY_BALANCES

228: AND trx_date < CE_CP_PRIORDAY.G_as_of_date;
229:
230: IF (tmp_balance is not null) THEN
231: BEGIN
232: INSERT INTO CE_CP_PRIORDAY_BALANCES
233: (worksheet_header_id,
234: as_of_date,
235: bank_account_id,
236: balance_date,

Line 245: CE_CP_PRIORDAY.G_as_of_date,

241: last_update_login,
242: creation_date,
243: created_by)
244: VALUES (-1,
245: CE_CP_PRIORDAY.G_as_of_date,
246: l_bank_account_id,
247: l_statement_date,
248: 'XTR',
249: tmp_balance,

Line 266: AND trx_date < CE_CP_PRIORDAY.G_as_of_date;

262: INTO tmp_balance
263: FROM CE_PAY_FC_PAYROLL_V
264: WHERE bank_account_id = l_bank_account_id
265: AND trx_date > l_statement_date
266: AND trx_date < CE_CP_PRIORDAY.G_as_of_date;
267:
268: IF (tmp_balance is not null) THEN
269: BEGIN
270: INSERT INTO CE_CP_PRIORDAY_BALANCES

Line 270: INSERT INTO CE_CP_PRIORDAY_BALANCES

266: AND trx_date < CE_CP_PRIORDAY.G_as_of_date;
267:
268: IF (tmp_balance is not null) THEN
269: BEGIN
270: INSERT INTO CE_CP_PRIORDAY_BALANCES
271: (worksheet_header_id,
272: as_of_date,
273: bank_account_id,
274: balance_date,

Line 283: CE_CP_PRIORDAY.G_as_of_date,

279: last_update_login,
280: creation_date,
281: created_by)
282: VALUES (-1,
283: CE_CP_PRIORDAY.G_as_of_date,
284: l_bank_account_id,
285: l_statement_date,
286: 'PAY',
287: tmp_balance,

Line 301: AND cash_activity_date < CE_CP_PRIORDAY.G_as_of_date

297: SELECT sum(decode(currency_code, l_currency_code, cashflow_amount, base_amount))
298: INTO tmp_balance
299: FROM CE_CE_CASHFLOWS_V
300: WHERE cash_activity_date > l_statement_date
301: AND cash_activity_date < CE_CP_PRIORDAY.G_as_of_date
302: AND source_trxn_type <> 'STMT'
303: AND cashflow_direction = 'RECEIPT';
304:
305: IF (tmp_balance is not null) THEN

Line 307: INSERT INTO CE_CP_PRIORDAY_BALANCES

303: AND cashflow_direction = 'RECEIPT';
304:
305: IF (tmp_balance is not null) THEN
306: BEGIN
307: INSERT INTO CE_CP_PRIORDAY_BALANCES
308: (worksheet_header_id,
309: as_of_date,
310: bank_account_id,
311: balance_date,

Line 320: CE_CP_PRIORDAY.G_as_of_date,

316: last_update_login,
317: creation_date,
318: created_by)
319: VALUES (-1,
320: CE_CP_PRIORDAY.G_as_of_date,
321: l_bank_account_id,
322: l_statement_date,
323: 'CEI',
324: tmp_balance,

Line 340: AND cash_activity_date < CE_CP_PRIORDAY.G_as_of_date

336: SELECT sum(decode(currency_code, l_currency_code, cashflow_amount, base_amount))
337: INTO tmp_balance
338: FROM CE_CE_CASHFLOWS_V
339: WHERE cash_activity_date > l_statement_date
340: AND cash_activity_date < CE_CP_PRIORDAY.G_as_of_date
341: AND source_trxn_type <> 'STMT'
342: AND cashflow_direction = 'PAYMENT';
343:
344: IF (tmp_balance is not null) THEN

Line 346: INSERT INTO CE_CP_PRIORDAY_BALANCES

342: AND cashflow_direction = 'PAYMENT';
343:
344: IF (tmp_balance is not null) THEN
345: BEGIN
346: INSERT INTO CE_CP_PRIORDAY_BALANCES
347: (worksheet_header_id,
348: as_of_date,
349: bank_account_id,
350: balance_date,

Line 359: CE_CP_PRIORDAY.G_as_of_date,

355: last_update_login,
356: creation_date,
357: created_by)
358: VALUES (-1,
359: CE_CP_PRIORDAY.G_as_of_date,
360: l_bank_account_id,
361: l_statement_date,
362: 'CEO',
363: tmp_balance,

Line 389: IF (CE_CP_PRIORDAY.G_purge_flag = 'Y') THEN

385:
386: cep_standard.debug('l_ws_id = ' || l_ws_id);
387:
388: /* purge overdue data */
389: IF (CE_CP_PRIORDAY.G_purge_flag = 'Y') THEN
390: DELETE CE_CP_PRIORDAY_BALANCES
391: WHERE worksheet_header_id = l_ws_id
392: AND as_of_date <= trunc(sysdate);
393: ELSE

Line 390: DELETE CE_CP_PRIORDAY_BALANCES

386: cep_standard.debug('l_ws_id = ' || l_ws_id);
387:
388: /* purge overdue data */
389: IF (CE_CP_PRIORDAY.G_purge_flag = 'Y') THEN
390: DELETE CE_CP_PRIORDAY_BALANCES
391: WHERE worksheet_header_id = l_ws_id
392: AND as_of_date <= trunc(sysdate);
393: ELSE
394: DELETE CE_CP_PRIORDAY_BALANCES

Line 394: DELETE CE_CP_PRIORDAY_BALANCES

390: DELETE CE_CP_PRIORDAY_BALANCES
391: WHERE worksheet_header_id = l_ws_id
392: AND as_of_date <= trunc(sysdate);
393: ELSE
394: DELETE CE_CP_PRIORDAY_BALANCES
395: WHERE worksheet_header_id = l_ws_id
396: AND as_of_date = CE_CP_PRIORDAY.G_as_of_date;
397: END IF;
398:

Line 396: AND as_of_date = CE_CP_PRIORDAY.G_as_of_date;

392: AND as_of_date <= trunc(sysdate);
393: ELSE
394: DELETE CE_CP_PRIORDAY_BALANCES
395: WHERE worksheet_header_id = l_ws_id
396: AND as_of_date = CE_CP_PRIORDAY.G_as_of_date;
397: END IF;
398:
399: OPEN wsba_cursor(l_ws_id);
400: LOOP

Line 434: INSERT INTO CE_CP_PRIORDAY_BALANCES

430: AP.payment_method = WSL.payment_method);
431:
432: IF (tmp_balance is not null) THEN
433: BEGIN
434: INSERT INTO CE_CP_PRIORDAY_BALANCES
435: (worksheet_header_id,
436: as_of_date,
437: bank_account_id,
438: balance_date,

Line 447: CE_CP_PRIORDAY.G_as_of_date,

443: last_update_login,
444: creation_date,
445: created_by)
446: VALUES (l_ws_id,
447: CE_CP_PRIORDAY.G_as_of_date,
448: l_bank_account_id,
449: l_statement_date,
450: 'APPOD',
451: tmp_balance,

Line 481: INSERT INTO CE_CP_PRIORDAY_BALANCES

477:
478:
479: IF (tmp_balance is not null) THEN
480: BEGIN
481: INSERT INTO CE_CP_PRIORDAY_BALANCES
482: (worksheet_header_id,
483: as_of_date,
484: bank_account_id,
485: balance_date,

Line 494: CE_CP_PRIORDAY.G_as_of_date,

490: last_update_login,
491: creation_date,
492: created_by)
493: VALUES (l_ws_id,
494: CE_CP_PRIORDAY.G_as_of_date,
495: l_bank_account_id,
496: l_statement_date,
497: 'ARROD',
498: tmp_balance,

Line 528: INSERT INTO CE_CP_PRIORDAY_BALANCES

524: AND XTR.dda_deal_subtype = 'INDIC'));
525:
526: IF (tmp_balance is not null) THEN
527: BEGIN
528: INSERT INTO CE_CP_PRIORDAY_BALANCES
529: (worksheet_header_id,
530: as_of_date,
531: bank_account_id,
532: balance_date,

Line 541: CE_CP_PRIORDAY.G_as_of_date,

537: last_update_login,
538: creation_date,
539: created_by)
540: VALUES (l_ws_id,
541: CE_CP_PRIORDAY.G_as_of_date,
542: l_bank_account_id,
543: l_statement_date,
544: 'XTIOD',
545: tmp_balance,

Line 575: INSERT INTO CE_CP_PRIORDAY_BALANCES

571: AND XTR.dda_deal_subtype = 'INDIC'));
572:
573: IF (tmp_balance is not null) THEN
574: BEGIN
575: INSERT INTO CE_CP_PRIORDAY_BALANCES
576: (worksheet_header_id,
577: as_of_date,
578: bank_account_id,
579: balance_date,

Line 588: CE_CP_PRIORDAY.G_as_of_date,

584: last_update_login,
585: creation_date,
586: created_by)
587: VALUES (l_ws_id,
588: CE_CP_PRIORDAY.G_as_of_date,
589: l_bank_account_id,
590: l_statement_date,
591: 'XTOOD',
592: tmp_balance,

Line 628: INSERT INTO CE_CP_PRIORDAY_BALANCES

624:
625:
626: IF (tmp_balance is not null) THEN
627: BEGIN
628: INSERT INTO CE_CP_PRIORDAY_BALANCES
629: (worksheet_header_id,
630: as_of_date,
631: bank_account_id,
632: balance_date,

Line 641: CE_CP_PRIORDAY.G_as_of_date,

637: last_update_login,
638: creation_date,
639: created_by)
640: VALUES (l_ws_id,
641: CE_CP_PRIORDAY.G_as_of_date,
642: l_bank_account_id,
643: l_statement_date,
644: 'CEIOD',
645: tmp_balance,

Line 683: INSERT INTO CE_CP_PRIORDAY_BALANCES

679: AND CEO.source_trxn_type <> 'STMT';
680:
681: IF (tmp_balance is not null) THEN
682: BEGIN
683: INSERT INTO CE_CP_PRIORDAY_BALANCES
684: (worksheet_header_id,
685: as_of_date,
686: bank_account_id,
687: balance_date,

Line 696: CE_CP_PRIORDAY.G_as_of_date,

692: last_update_login,
693: creation_date,
694: created_by)
695: VALUES (l_ws_id,
696: CE_CP_PRIORDAY.G_as_of_date,
697: l_bank_account_id,
698: l_statement_date,
699: 'CEOOD',
700: tmp_balance,

Line 715: INSERT INTO CE_CP_PRIORDAY_BALANCES

711: END LOOP;
712: CLOSE wsba_cursor;
713:
714: BEGIN
715: INSERT INTO CE_CP_PRIORDAY_BALANCES
716: (worksheet_header_id,
717: as_of_date,
718: bank_account_id,
719: balance_date,

Line 728: CE_CP_PRIORDAY.G_as_of_date,

724: last_update_login,
725: creation_date,
726: created_by)
727: VALUES (l_ws_id,
728: CE_CP_PRIORDAY.G_as_of_date,
729: -1,
730: trunc(CE_CP_PRIORDAY.G_as_of_date),
731: 'HEAD',
732: 0,

Line 730: trunc(CE_CP_PRIORDAY.G_as_of_date),

726: created_by)
727: VALUES (l_ws_id,
728: CE_CP_PRIORDAY.G_as_of_date,
729: -1,
730: trunc(CE_CP_PRIORDAY.G_as_of_date),
731: 'HEAD',
732: 0,
733: trunc(sysdate),
734: -1,

Line 759: cep_standard.debug('>>CE_CP_PRIORDAY.gen_prior_day ------- '||sysdate||

755:
756: cep_standard.init_security;
757: IF l_debug in ('Y', 'C') THEN
758: cep_standard.enable_debug(p_debug_path, p_debug_file);
759: cep_standard.debug('>>CE_CP_PRIORDAY.gen_prior_day ------- '||sysdate||
760: ' -------');
761: cep_standard.debug('p_worksheet_header_id: '|| p_worksheet_header_id);
762: cep_standard.debug('p_as_of_date: '|| p_as_of_date);
763: cep_standard.debug('p_display_debug: '||p_display_debug);

Line 774: cep_standard.debug('<

770:
771: calculate_summary;
772:
773: IF l_debug in ('Y', 'C') THEN
774: cep_standard.debug('< 775: END IF;
776:
777: END gen_prior_day;
778:

Line 779: END CE_CP_PRIORDAY;

775: END IF;
776:
777: END gen_prior_day;
778:
779: END CE_CP_PRIORDAY;