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_BALANCES

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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,