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.FII_AR_SALES_CREDITS_C dependencies on FII_AR_SALES_CREDITS

Line 1: PACKAGE BODY FII_AR_SALES_CREDITS_C AS

1: PACKAGE BODY FII_AR_SALES_CREDITS_C AS
2: /* $Header: FIIARSCB.pls 120.1 2005/10/30 05:13:24 appldev noship $ */
3:
4: g_errbuf VARCHAR2(2000) := NULL;
5: g_retcode VARCHAR2(20) := NULL;

Line 34: --FII_UTIL.truncate_table(p_table_name => 'fii_ar_sales_credits_t', p_retcode => l_retcode);

30: -----------------------------------------------------------------------
31: PROCEDURE Clean_Up IS
32: l_retcode VARCHAR2(20);
33: BEGIN
34: --FII_UTIL.truncate_table(p_table_name => 'fii_ar_sales_credits_t', p_retcode => l_retcode);
35: if l_retcode = -1 then
36: g_retcode := -2;
37: RAISE g_truncate_failure;
38: end if;

Line 119: -- Populate FII_AR_SALES_CREDITS with AR Sales Credits that have been inserted since the last Run Date

115: fii_util.put_line(' ');
116: fii_util.start_timer;
117: end if;
118:
119: -- Populate FII_AR_SALES_CREDITS with AR Sales Credits that have been inserted since the last Run Date
120: insert into fii_ar_sales_credits (
121: SALESCREDIT_PK, INVOICE_LINE_ID,
122: SALESREP_ID, SALESGROUP_ID,
123: REVENUE_PERCENT_SPLIT,

Line 120: insert into fii_ar_sales_credits (

116: fii_util.start_timer;
117: end if;
118:
119: -- Populate FII_AR_SALES_CREDITS with AR Sales Credits that have been inserted since the last Run Date
120: insert into fii_ar_sales_credits (
121: SALESCREDIT_PK, INVOICE_LINE_ID,
122: SALESREP_ID, SALESGROUP_ID,
123: REVENUE_PERCENT_SPLIT,
124: CREATED_BY, LAST_UPDATED_BY,

Line 178: UPDATE FII_AR_SALES_CREDITS_D_T

174: fii_util.put_line('');
175: end if;
176:
177: -- Mark rows updated and deleted in the AR application for processing
178: UPDATE FII_AR_SALES_CREDITS_D_T
179: SET STATUS_FLAG = 'P';
180:
181: if g_debug_flag = 'Y' then
182: fii_util.put_line('Marked '||SQL%ROWCOUNT||' rows in FII_AR_SALES_CREDITS_D_T as updated / deleted in AR');

Line 182: fii_util.put_line('Marked '||SQL%ROWCOUNT||' rows in FII_AR_SALES_CREDITS_D_T as updated / deleted in AR');

178: UPDATE FII_AR_SALES_CREDITS_D_T
179: SET STATUS_FLAG = 'P';
180:
181: if g_debug_flag = 'Y' then
182: fii_util.put_line('Marked '||SQL%ROWCOUNT||' rows in FII_AR_SALES_CREDITS_D_T as updated / deleted in AR');
183: fii_util.stop_timer;
184: fii_util.print_timer('Duration');
185: fii_util.start_timer;
186: fii_util.put_line('');

Line 189: -- Merge the updated Sales Credits into FII_AR_SALES_CREDITS using FII_AR_SALESCREDIT_D_T.SALESCREDIT_PK to join with RA_CUST_TRX_LINE_SALESREPS_ALL

185: fii_util.start_timer;
186: fii_util.put_line('');
187: end if;
188:
189: -- Merge the updated Sales Credits into FII_AR_SALES_CREDITS using FII_AR_SALESCREDIT_D_T.SALESCREDIT_PK to join with RA_CUST_TRX_LINE_SALESREPS_ALL
190: -- (for existing rows, delete them if the new revenue percent is 0 else update them; for new rows, insert them if the revenue percent is non-0)
191:
192: -- For non-0 rows, update existing rows and insert new rows
193: MERGE INTO FII_AR_SALES_CREDITS f

Line 193: MERGE INTO FII_AR_SALES_CREDITS f

189: -- Merge the updated Sales Credits into FII_AR_SALES_CREDITS using FII_AR_SALESCREDIT_D_T.SALESCREDIT_PK to join with RA_CUST_TRX_LINE_SALESREPS_ALL
190: -- (for existing rows, delete them if the new revenue percent is 0 else update them; for new rows, insert them if the revenue percent is non-0)
191:
192: -- For non-0 rows, update existing rows and insert new rows
193: MERGE INTO FII_AR_SALES_CREDITS f
194: USING (SELECT sr.* FROM FII_AR_SALES_CREDITS_D_T del, RA_CUST_TRX_LINE_SALESREPS_ALL sr
195: WHERE nvl(revenue_percent_split, 0) <> 0
196: AND del.salescredit_pk = sr.cust_trx_line_salesrep_id
197: AND del.dml_type = 'U'

Line 194: USING (SELECT sr.* FROM FII_AR_SALES_CREDITS_D_T del, RA_CUST_TRX_LINE_SALESREPS_ALL sr

190: -- (for existing rows, delete them if the new revenue percent is 0 else update them; for new rows, insert them if the revenue percent is non-0)
191:
192: -- For non-0 rows, update existing rows and insert new rows
193: MERGE INTO FII_AR_SALES_CREDITS f
194: USING (SELECT sr.* FROM FII_AR_SALES_CREDITS_D_T del, RA_CUST_TRX_LINE_SALESREPS_ALL sr
195: WHERE nvl(revenue_percent_split, 0) <> 0
196: AND del.salescredit_pk = sr.cust_trx_line_salesrep_id
197: AND del.dml_type = 'U'
198: AND sr.customer_trx_line_id is not null) stg

Line 234: DELETE FROM FII_AR_SALES_CREDITS

230: fii_util.put_line('');
231: end if;
232:
233: -- For rows updated in AR to have revenue_percent=0, delete them from FII
234: DELETE FROM FII_AR_SALES_CREDITS
235: WHERE SALESCREDIT_PK in
236: (select SALESCREDIT_PK from FII_AR_SALES_CREDITS_D_T del, RA_CUST_TRX_LINE_SALESREPS_ALL sr
237: where nvl(REVENUE_PERCENT_SPLIT, 0) = 0
238: and del.salescredit_pk = sr.cust_trx_line_salesrep_id

Line 236: (select SALESCREDIT_PK from FII_AR_SALES_CREDITS_D_T del, RA_CUST_TRX_LINE_SALESREPS_ALL sr

232:
233: -- For rows updated in AR to have revenue_percent=0, delete them from FII
234: DELETE FROM FII_AR_SALES_CREDITS
235: WHERE SALESCREDIT_PK in
236: (select SALESCREDIT_PK from FII_AR_SALES_CREDITS_D_T del, RA_CUST_TRX_LINE_SALESREPS_ALL sr
237: where nvl(REVENUE_PERCENT_SPLIT, 0) = 0
238: and del.salescredit_pk = sr.cust_trx_line_salesrep_id
239: and del.dml_type = 'U');
240:

Line 250: DELETE FROM FII_AR_SALES_CREDITS

246: fii_util.put_line('');
247: end if;
248:
249: -- Process / Delete rows deleted from the AR application
250: DELETE FROM FII_AR_SALES_CREDITS
251: WHERE SALESCREDIT_PK in
252: (select SALESCREDIT_PK from FII_AR_SALES_CREDITS_D_T
253: where STATUS_FLAG = 'P'
254: and DML_TYPE = 'D');

Line 252: (select SALESCREDIT_PK from FII_AR_SALES_CREDITS_D_T

248:
249: -- Process / Delete rows deleted from the AR application
250: DELETE FROM FII_AR_SALES_CREDITS
251: WHERE SALESCREDIT_PK in
252: (select SALESCREDIT_PK from FII_AR_SALES_CREDITS_D_T
253: where STATUS_FLAG = 'P'
254: and DML_TYPE = 'D');
255:
256: if g_debug_flag = 'Y' then

Line 265: DELETE FROM FII_AR_SALES_CREDITS_D_T

261: fii_util.put_line('');
262: end if;
263:
264: -- Delete deletions that have been processed
265: DELETE FROM FII_AR_SALES_CREDITS_D_T
266: where STATUS_FLAG = 'P';
267:
268: if g_debug_flag = 'Y' then
269: fii_util.put_line('Deleted '||SQL%ROWCOUNT||' rows in FII_AR_SALES_CREDITS_D_T as processed');

Line 269: fii_util.put_line('Deleted '||SQL%ROWCOUNT||' rows in FII_AR_SALES_CREDITS_D_T as processed');

265: DELETE FROM FII_AR_SALES_CREDITS_D_T
266: where STATUS_FLAG = 'P';
267:
268: if g_debug_flag = 'Y' then
269: fii_util.put_line('Deleted '||SQL%ROWCOUNT||' rows in FII_AR_SALES_CREDITS_D_T as processed');
270: fii_util.stop_timer;
271: fii_util.print_timer('Duration');
272: fii_util.put_line(' ');
273: end if;

Line 298: -- Insert dummy records based on the 0 revenue percent rows deleted in the merge phase (using the Snapshot Log for FII_AR_SALES_CREDITS)

294: fii_util.put_line('Inserting dummy records for the deleted invoice lines');
295: fii_util.start_timer;
296: end if;
297:
298: -- Insert dummy records based on the 0 revenue percent rows deleted in the merge phase (using the Snapshot Log for FII_AR_SALES_CREDITS)
299: insert into fii_ar_sales_credits (
300: SALESCREDIT_PK, INVOICE_LINE_ID,
301: SALESREP_ID, SALESGROUP_ID,
302: REVENUE_PERCENT_SPLIT,

Line 299: insert into fii_ar_sales_credits (

295: fii_util.start_timer;
296: end if;
297:
298: -- Insert dummy records based on the 0 revenue percent rows deleted in the merge phase (using the Snapshot Log for FII_AR_SALES_CREDITS)
299: insert into fii_ar_sales_credits (
300: SALESCREDIT_PK, INVOICE_LINE_ID,
301: SALESREP_ID, SALESGROUP_ID,
302: REVENUE_PERCENT_SPLIT,
303: CREATED_BY, LAST_UPDATED_BY,

Line 312: from mlog$_fii_ar_sales_credits sc_log

308: 100,
309: g_fii_user_id, g_fii_user_id,
310: g_fii_login_id,
311: SYSDATE, SYSDATE
312: from mlog$_fii_ar_sales_credits sc_log
313: --where invoice_line_id not in (select distinct invoice_line_id from fii_ar_sales_credits)
314: where not exists (select 'X' from fii_ar_sales_credits where invoice_line_id = sc_log.invoice_line_id)
315: and dmltype$$ = 'D';
316:

Line 313: --where invoice_line_id not in (select distinct invoice_line_id from fii_ar_sales_credits)

309: g_fii_user_id, g_fii_user_id,
310: g_fii_login_id,
311: SYSDATE, SYSDATE
312: from mlog$_fii_ar_sales_credits sc_log
313: --where invoice_line_id not in (select distinct invoice_line_id from fii_ar_sales_credits)
314: where not exists (select 'X' from fii_ar_sales_credits where invoice_line_id = sc_log.invoice_line_id)
315: and dmltype$$ = 'D';
316:
317: if g_debug_flag = 'Y' then

Line 314: where not exists (select 'X' from fii_ar_sales_credits where invoice_line_id = sc_log.invoice_line_id)

310: g_fii_login_id,
311: SYSDATE, SYSDATE
312: from mlog$_fii_ar_sales_credits sc_log
313: --where invoice_line_id not in (select distinct invoice_line_id from fii_ar_sales_credits)
314: where not exists (select 'X' from fii_ar_sales_credits where invoice_line_id = sc_log.invoice_line_id)
315: and dmltype$$ = 'D';
316:
317: if g_debug_flag = 'Y' then
318: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');

Line 326: -- Delete dummy records based on the Snapshot Log for FII_AR_SALES_CREDITS

322: fii_util.put_line('Deleting dummy records for new invoice line sales credits');
323: fii_util.start_timer;
324: end if;
325:
326: -- Delete dummy records based on the Snapshot Log for FII_AR_SALES_CREDITS
327: delete from fii_ar_sales_credits
328: where salescredit_pk in
329: (select -invoice_line_id
330: from mlog$_fii_ar_sales_credits

Line 327: delete from fii_ar_sales_credits

323: fii_util.start_timer;
324: end if;
325:
326: -- Delete dummy records based on the Snapshot Log for FII_AR_SALES_CREDITS
327: delete from fii_ar_sales_credits
328: where salescredit_pk in
329: (select -invoice_line_id
330: from mlog$_fii_ar_sales_credits
331: where dmltype$$ = 'I'

Line 330: from mlog$_fii_ar_sales_credits

326: -- Delete dummy records based on the Snapshot Log for FII_AR_SALES_CREDITS
327: delete from fii_ar_sales_credits
328: where salescredit_pk in
329: (select -invoice_line_id
330: from mlog$_fii_ar_sales_credits
331: where dmltype$$ = 'I'
332: and salescredit_pk > 0);
333:
334: if g_debug_flag = 'Y' then

Line 344: insert into fii_ar_sales_credits (

340: fii_util.start_timer;
341: end if;
342:
343: -- Insert dummy records from the Snapshot Log for FII_AR_REVENUE_B
344: insert into fii_ar_sales_credits (
345: SALESCREDIT_PK, INVOICE_LINE_ID,
346: SALESREP_ID, SALESGROUP_ID,
347: REVENUE_PERCENT_SPLIT,
348: CREATED_BY, LAST_UPDATED_BY,

Line 358: --where invoice_line_id not in (select distinct invoice_line_id from fii_ar_sales_credits)

354: g_fii_user_id, g_fii_user_id,
355: g_fii_login_id,
356: SYSDATE, SYSDATE
357: from mlog$_fii_ar_revenue_b rev_log
358: --where invoice_line_id not in (select distinct invoice_line_id from fii_ar_sales_credits)
359: where not exists (select 'X' from fii_ar_sales_credits where invoice_line_id = rev_log.invoice_line_id)
360: and dmltype$$ = 'I';
361:
362: if g_debug_flag = 'Y' then

Line 359: where not exists (select 'X' from fii_ar_sales_credits where invoice_line_id = rev_log.invoice_line_id)

355: g_fii_login_id,
356: SYSDATE, SYSDATE
357: from mlog$_fii_ar_revenue_b rev_log
358: --where invoice_line_id not in (select distinct invoice_line_id from fii_ar_sales_credits)
359: where not exists (select 'X' from fii_ar_sales_credits where invoice_line_id = rev_log.invoice_line_id)
360: and dmltype$$ = 'I';
361:
362: if g_debug_flag = 'Y' then
363: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');

Line 395: -- Insert a dummy record into FII_AR_SALES_CREDITS for all Adjustments

391: fii_util.put_line(' ');
392: fii_util.put_line('start of first insert');
393: end if;
394:
395: -- Insert a dummy record into FII_AR_SALES_CREDITS for all Adjustments
396: insert into fii_ar_sales_CREDITS F (
397: SALESCREDIT_PK, INVOICE_LINE_ID,
398: SALESREP_ID, SALESGROUP_ID,
399: REVENUE_PERCENT_SPLIT,

Line 396: insert into fii_ar_sales_CREDITS F (

392: fii_util.put_line('start of first insert');
393: end if;
394:
395: -- Insert a dummy record into FII_AR_SALES_CREDITS for all Adjustments
396: insert into fii_ar_sales_CREDITS F (
397: SALESCREDIT_PK, INVOICE_LINE_ID,
398: SALESREP_ID, SALESGROUP_ID,
399: REVENUE_PERCENT_SPLIT,
400: CREATED_BY, LAST_UPDATED_BY,

Line 415: insert /+ APPEND PARALLEL(F) / into fii_ar_sales_CREDITS F (

411: fii_util.put_line('start of second insert');
412: end if;
413:
414: -- Initial Load from RA_CUST_TRX_LINE_SALESREPS_ALL
415: insert /*+ APPEND PARALLEL(F) */ into fii_ar_sales_CREDITS F (
416: SALESCREDIT_PK, INVOICE_LINE_ID,
417: SALESREP_ID, SALESGROUP_ID,
418: REVENUE_PERCENT_SPLIT,
419: CREATED_BY, LAST_UPDATED_BY,

Line 448: insert /+ APPEND PARALLEL(F) / into fii_ar_sales_CREDITS F (

444: fii_util.put_line('start of third insert');
445: end if;
446:
447: -- Initial Load of dummy records from FII_AR_REVENUE_B
448: insert /*+ APPEND PARALLEL(F) */ into fii_ar_sales_CREDITS F (
449: SALESCREDIT_PK, INVOICE_LINE_ID,
450: SALESREP_ID, SALESGROUP_ID,
451: REVENUE_PERCENT_SPLIT,
452: CREATED_BY, LAST_UPDATED_BY,

Line 467: from fii_ar_sales_CREDITS b

463: and invoice_line_id is not null
464: and invoice_line_id not in (
465: select /*+ hash_aj parallel_index(b) index_ffs(b) */
466: invoice_line_id
467: from fii_ar_sales_CREDITS b
468: where invoice_line_id is not null);
469:
470: if g_debug_flag = 'Y' then
471: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');

Line 533: fii_util.initialize('FII_AR_SALES_CREDITS.log','FII_AR_SALES_CREDITS.out',l_dir, 'FII_AR_SALES_CREDITS_I');

529: -- the log directory
530: ------------------------------------------------
531:
532: IF g_program_type = 'I' THEN
533: fii_util.initialize('FII_AR_SALES_CREDITS.log','FII_AR_SALES_CREDITS.out',l_dir, 'FII_AR_SALES_CREDITS_I');
534: ELSIF g_program_type = 'L' THEN
535: fii_util.initialize('FII_AR_SALES_CREDITS.log','FII_AR_SALES_CREDITS.out',l_dir, 'FII_AR_SALES_CREDITS_L');
536: END IF;
537:

Line 535: fii_util.initialize('FII_AR_SALES_CREDITS.log','FII_AR_SALES_CREDITS.out',l_dir, 'FII_AR_SALES_CREDITS_L');

531:
532: IF g_program_type = 'I' THEN
533: fii_util.initialize('FII_AR_SALES_CREDITS.log','FII_AR_SALES_CREDITS.out',l_dir, 'FII_AR_SALES_CREDITS_I');
534: ELSIF g_program_type = 'L' THEN
535: fii_util.initialize('FII_AR_SALES_CREDITS.log','FII_AR_SALES_CREDITS.out',l_dir, 'FII_AR_SALES_CREDITS_L');
536: END IF;
537:
538: IF g_program_type = 'I' THEN
539: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AR_SALES_CREDITS_I')) THEN

Line 539: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AR_SALES_CREDITS_I')) THEN

535: fii_util.initialize('FII_AR_SALES_CREDITS.log','FII_AR_SALES_CREDITS.out',l_dir, 'FII_AR_SALES_CREDITS_L');
536: END IF;
537:
538: IF g_program_type = 'I' THEN
539: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AR_SALES_CREDITS_I')) THEN
540: fii_util.put_line('Error in BIS setup FII_AR_SALES_CREDITS_I');
541: raise_application_error(-20000,errbuf);
542: return;
543: END IF;

Line 540: fii_util.put_line('Error in BIS setup FII_AR_SALES_CREDITS_I');

536: END IF;
537:
538: IF g_program_type = 'I' THEN
539: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AR_SALES_CREDITS_I')) THEN
540: fii_util.put_line('Error in BIS setup FII_AR_SALES_CREDITS_I');
541: raise_application_error(-20000,errbuf);
542: return;
543: END IF;
544: ELSIF g_program_type = 'L' THEN

Line 545: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AR_SALES_CREDITS_L')) THEN

541: raise_application_error(-20000,errbuf);
542: return;
543: END IF;
544: ELSIF g_program_type = 'L' THEN
545: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AR_SALES_CREDITS_L')) THEN
546: fii_util.put_line('Error in BIS setup FII_AR_SALES_CREDITS_L');
547: raise_application_error(-20000,errbuf);
548: return;
549: END IF;

Line 546: fii_util.put_line('Error in BIS setup FII_AR_SALES_CREDITS_L');

542: return;
543: END IF;
544: ELSIF g_program_type = 'L' THEN
545: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AR_SALES_CREDITS_L')) THEN
546: fii_util.put_line('Error in BIS setup FII_AR_SALES_CREDITS_L');
547: raise_application_error(-20000,errbuf);
548: return;
549: END IF;
550: END IF;

Line 574: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_AR_SALES_CREDITS_D_T', p_retcode => l_retcode);

570: IF g_debug_flag = 'Y' then
571: fii_util.put_line('Running Initial Load, truncate staging and base summary table.');
572: END IF;
573:
574: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_AR_SALES_CREDITS_D_T', p_retcode => l_retcode);
575: if l_retcode = -1 then
576: g_retcode := -2;
577: raise g_truncate_failure;
578: end if;

Line 579: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_AR_SALES_CREDITS', p_retcode => l_retcode);

575: if l_retcode = -1 then
576: g_retcode := -2;
577: raise g_truncate_failure;
578: end if;
579: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_AR_SALES_CREDITS', p_retcode => l_retcode);
580: if l_retcode = -1 then
581: g_retcode := -2;
582: raise g_truncate_failure;
583: end if;

Line 584: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_SALES_CREDITS_I');

580: if l_retcode = -1 then
581: g_retcode := -2;
582: raise g_truncate_failure;
583: end if;
584: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_SALES_CREDITS_I');
585: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_SALES_CREDITS_L');
586: COMMIT;
587: END IF;
588:

Line 585: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_SALES_CREDITS_L');

581: g_retcode := -2;
582: raise g_truncate_failure;
583: end if;
584: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_SALES_CREDITS_I');
585: BIS_COLLECTION_UTILITIES.DELETELOGFOROBJECT('FII_AR_SALES_CREDITS_L');
586: COMMIT;
587: END IF;
588:
589: l_section := 'M-Section 30';

Line 597: fii_util.put_line('INITIAL LOAD: populating FII_AR_SALES_CREDITS');

593: IF (g_program_type = 'L') THEN
594: if g_debug_flag = 'Y' then
595: fii_util.put_line(' ');
596: fii_util.put_timestamp;
597: fii_util.put_line('INITIAL LOAD: populating FII_AR_SALES_CREDITS');
598: end if;
599: AR_SC_INIT;
600: ELSE
601: -----------------------------------------------------------------

Line 602: -- obtain the largest salescredit_pk in fii_ar_sales_credits

598: end if;
599: AR_SC_INIT;
600: ELSE
601: -----------------------------------------------------------------
602: -- obtain the largest salescredit_pk in fii_ar_sales_credits
603: -----------------------------------------------------------------
604: select max(salescredit_pk) into g_max_salescredit_pk
605: from fii_ar_sales_credits;
606:

Line 605: from fii_ar_sales_credits;

601: -----------------------------------------------------------------
602: -- obtain the largest salescredit_pk in fii_ar_sales_credits
603: -----------------------------------------------------------------
604: select max(salescredit_pk) into g_max_salescredit_pk
605: from fii_ar_sales_credits;
606:
607: if g_debug_flag = 'Y' then
608: fii_util.put_line(' ');
609: fii_util.put_line('Largest salescredit_pk in fii_ar_sales_credits is '||

Line 609: fii_util.put_line('Largest salescredit_pk in fii_ar_sales_credits is '||

605: from fii_ar_sales_credits;
606:
607: if g_debug_flag = 'Y' then
608: fii_util.put_line(' ');
609: fii_util.put_line('Largest salescredit_pk in fii_ar_sales_credits is '||
610: to_char(g_max_salescredit_pk));
611: fii_util.put_line(' ');
612: fii_util.put_timestamp;
613: fii_util.put_line('INCREMENTAL LOAD: populating FII_AR_SALES_CREDITS with new Sales Credits');

Line 613: fii_util.put_line('INCREMENTAL LOAD: populating FII_AR_SALES_CREDITS with new Sales Credits');

609: fii_util.put_line('Largest salescredit_pk in fii_ar_sales_credits is '||
610: to_char(g_max_salescredit_pk));
611: fii_util.put_line(' ');
612: fii_util.put_timestamp;
613: fii_util.put_line('INCREMENTAL LOAD: populating FII_AR_SALES_CREDITS with new Sales Credits');
614: end if;
615:
616: -- Insert Sales Credits records created in AR after the last run
617: l_count := POPULATE_SC_INSERT;

Line 631: fii_util.put_line('INCREMENTAL LOAD: cleaning up dummy records in FII_AR_SALES_CREDITS');

627:
628: if g_debug_flag = 'Y' then
629: fii_util.put_line(' ');
630: fii_util.put_timestamp;
631: fii_util.put_line('INCREMENTAL LOAD: cleaning up dummy records in FII_AR_SALES_CREDITS');
632: end if;
633:
634: -- clean up the dummy records in FII_AR_SALES_CREDITS
635: CLEANUP_SC;

Line 634: -- clean up the dummy records in FII_AR_SALES_CREDITS

630: fii_util.put_timestamp;
631: fii_util.put_line('INCREMENTAL LOAD: cleaning up dummy records in FII_AR_SALES_CREDITS');
632: end if;
633:
634: -- clean up the dummy records in FII_AR_SALES_CREDITS
635: CLEANUP_SC;
636:
637: END IF;
638:

Line 701: insert into fii_ar_sales_credits_d_t (

697: l_pos NUMBER;
698: BEGIN
699: l_pos := instr(l_key, '_');
700: l_key := substr(l_key, 1, l_pos - 1);
701: insert into fii_ar_sales_credits_d_t (
702: SALESCREDIT_PK,
703: DML_TYPE,
704: STATUS_FLAG,
705: LAST_UPDATE_DATE,

Line 732: from fii_ar_sales_credits_d_t

728: l_key := substr(l_key, 1, l_pos - 1);
729:
730: BEGIN
731: select 'Y' into l_exists
732: from fii_ar_sales_credits_d_t
733: where salescredit_pk = to_number(l_key)
734: and dml_type = 'U';
735:
736: EXCEPTION

Line 738: insert into fii_ar_sales_credits_d_t (

734: and dml_type = 'U';
735:
736: EXCEPTION
737: WHEN NO_DATA_FOUND THEN
738: insert into fii_ar_sales_credits_d_t (
739: SALESCREDIT_PK,
740: DML_TYPE,
741: STATUS_FLAG,
742: LAST_UPDATE_DATE,

Line 761: END FII_AR_SALES_CREDITS_C;

757: WHEN OTHERS THEN
758: return 'ERROR';
759: END update_salescredit_sub;
760:
761: END FII_AR_SALES_CREDITS_C;