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.XLA_TACCOUNTS_DATA_PKG dependencies on DBMS_SQL

Line 392: c_ta := dbms_sql.open_cursor;

388: ,p_add_col_value_1
389: ,p_add_col_name_2
390: ,p_add_col_value_2
391: );
392: c_ta := dbms_sql.open_cursor;
393: dbms_sql.parse(c_ta, statement, dbms_sql.native);
394:
395: -- Generic bind
396: dbms_sql.bind_variable(c_ta, 'appl_id', p_application_id);

Line 393: dbms_sql.parse(c_ta, statement, dbms_sql.native);

389: ,p_add_col_name_2
390: ,p_add_col_value_2
391: );
392: c_ta := dbms_sql.open_cursor;
393: dbms_sql.parse(c_ta, statement, dbms_sql.native);
394:
395: -- Generic bind
396: dbms_sql.bind_variable(c_ta, 'appl_id', p_application_id);
397: dbms_sql.bind_variable(c_ta, 'set_of_books_id', p_set_of_books_id);

Line 396: dbms_sql.bind_variable(c_ta, 'appl_id', p_application_id);

392: c_ta := dbms_sql.open_cursor;
393: dbms_sql.parse(c_ta, statement, dbms_sql.native);
394:
395: -- Generic bind
396: dbms_sql.bind_variable(c_ta, 'appl_id', p_application_id);
397: dbms_sql.bind_variable(c_ta, 'set_of_books_id', p_set_of_books_id);
398:
399: -- Transaction specific bind
400: IF ( p_overRidingWhereClause IS NULL ) THEN

Line 397: dbms_sql.bind_variable(c_ta, 'set_of_books_id', p_set_of_books_id);

393: dbms_sql.parse(c_ta, statement, dbms_sql.native);
394:
395: -- Generic bind
396: dbms_sql.bind_variable(c_ta, 'appl_id', p_application_id);
397: dbms_sql.bind_variable(c_ta, 'set_of_books_id', p_set_of_books_id);
398:
399: -- Transaction specific bind
400: IF ( p_overRidingWhereClause IS NULL ) THEN
401: IF ( p_add_col_name_1 IS NOT NULL ) THEN

Line 402: dbms_sql.bind_variable(c_ta, 'add_col_value_1', p_add_col_value_1);

398:
399: -- Transaction specific bind
400: IF ( p_overRidingWhereClause IS NULL ) THEN
401: IF ( p_add_col_name_1 IS NOT NULL ) THEN
402: dbms_sql.bind_variable(c_ta, 'add_col_value_1', p_add_col_value_1);
403: END IF;
404:
405: IF ( p_add_col_name_2 IS NOT NULL ) THEN
406: dbms_sql.bind_variable(c_ta, 'add_col_value_2', p_add_col_value_2);

Line 406: dbms_sql.bind_variable(c_ta, 'add_col_value_2', p_add_col_value_2);

402: dbms_sql.bind_variable(c_ta, 'add_col_value_1', p_add_col_value_1);
403: END IF;
404:
405: IF ( p_add_col_name_2 IS NOT NULL ) THEN
406: dbms_sql.bind_variable(c_ta, 'add_col_value_2', p_add_col_value_2);
407: END IF;
408:
409: IF ( p_trx_header_table IS NOT NULL ) THEN
410: dbms_sql.bind_variable(c_ta, 'trx_header_table', p_trx_header_table);

Line 410: dbms_sql.bind_variable(c_ta, 'trx_header_table', p_trx_header_table);

406: dbms_sql.bind_variable(c_ta, 'add_col_value_2', p_add_col_value_2);
407: END IF;
408:
409: IF ( p_trx_header_table IS NOT NULL ) THEN
410: dbms_sql.bind_variable(c_ta, 'trx_header_table', p_trx_header_table);
411: END IF;
412:
413: IF ( p_trx_header_id IS NOT NULL ) THEN
414: dbms_sql.bind_variable(c_ta, 'trx_header_id', p_trx_header_id);

Line 414: dbms_sql.bind_variable(c_ta, 'trx_header_id', p_trx_header_id);

410: dbms_sql.bind_variable(c_ta, 'trx_header_table', p_trx_header_table);
411: END IF;
412:
413: IF ( p_trx_header_id IS NOT NULL ) THEN
414: dbms_sql.bind_variable(c_ta, 'trx_header_id', p_trx_header_id);
415: END IF;
416:
417: -- Mfg. PAC transactions support
418: IF ( p_Cost_Type_ID IS NOT NULL ) THEN

Line 419: dbms_sql.bind_variable(c_ta, 'cost_type_id', p_cost_type_id);

415: END IF;
416:
417: -- Mfg. PAC transactions support
418: IF ( p_Cost_Type_ID IS NOT NULL ) THEN
419: dbms_sql.bind_variable(c_ta, 'cost_type_id', p_cost_type_id);
420: END IF;
421:
422: END IF;
423:

Line 425: dbms_sql.define_column( c_ta, 1, l_ccid );

421:
422: END IF;
423:
424: -- Define columns
425: dbms_sql.define_column( c_ta, 1, l_ccid );
426: dbms_sql.define_column( c_ta, 2, l_segment1_value, 255 );
427: dbms_sql.define_column( c_ta, 3, l_segment2_value, 255 );
428: dbms_sql.define_column( c_ta, 4, l_segment3_value, 255 );
429: dbms_sql.define_column( c_ta, 5, l_segment4_value, 255 );

Line 426: dbms_sql.define_column( c_ta, 2, l_segment1_value, 255 );

422: END IF;
423:
424: -- Define columns
425: dbms_sql.define_column( c_ta, 1, l_ccid );
426: dbms_sql.define_column( c_ta, 2, l_segment1_value, 255 );
427: dbms_sql.define_column( c_ta, 3, l_segment2_value, 255 );
428: dbms_sql.define_column( c_ta, 4, l_segment3_value, 255 );
429: dbms_sql.define_column( c_ta, 5, l_segment4_value, 255 );
430: dbms_sql.define_column( c_ta, 6, l_ae_line_ref, 1000 );

Line 427: dbms_sql.define_column( c_ta, 3, l_segment2_value, 255 );

423:
424: -- Define columns
425: dbms_sql.define_column( c_ta, 1, l_ccid );
426: dbms_sql.define_column( c_ta, 2, l_segment1_value, 255 );
427: dbms_sql.define_column( c_ta, 3, l_segment2_value, 255 );
428: dbms_sql.define_column( c_ta, 4, l_segment3_value, 255 );
429: dbms_sql.define_column( c_ta, 5, l_segment4_value, 255 );
430: dbms_sql.define_column( c_ta, 6, l_ae_line_ref, 1000 );
431: dbms_sql.define_column( c_ta, 7, l_ae_line_ref_int, 1000 );

Line 428: dbms_sql.define_column( c_ta, 4, l_segment3_value, 255 );

424: -- Define columns
425: dbms_sql.define_column( c_ta, 1, l_ccid );
426: dbms_sql.define_column( c_ta, 2, l_segment1_value, 255 );
427: dbms_sql.define_column( c_ta, 3, l_segment2_value, 255 );
428: dbms_sql.define_column( c_ta, 4, l_segment3_value, 255 );
429: dbms_sql.define_column( c_ta, 5, l_segment4_value, 255 );
430: dbms_sql.define_column( c_ta, 6, l_ae_line_ref, 1000 );
431: dbms_sql.define_column( c_ta, 7, l_ae_line_ref_int, 1000 );
432: dbms_sql.define_column( c_ta, 8, l_entered_currency, 15 );

Line 429: dbms_sql.define_column( c_ta, 5, l_segment4_value, 255 );

425: dbms_sql.define_column( c_ta, 1, l_ccid );
426: dbms_sql.define_column( c_ta, 2, l_segment1_value, 255 );
427: dbms_sql.define_column( c_ta, 3, l_segment2_value, 255 );
428: dbms_sql.define_column( c_ta, 4, l_segment3_value, 255 );
429: dbms_sql.define_column( c_ta, 5, l_segment4_value, 255 );
430: dbms_sql.define_column( c_ta, 6, l_ae_line_ref, 1000 );
431: dbms_sql.define_column( c_ta, 7, l_ae_line_ref_int, 1000 );
432: dbms_sql.define_column( c_ta, 8, l_entered_currency, 15 );
433: dbms_sql.define_column( c_ta, 9, l_entered_dr );

Line 430: dbms_sql.define_column( c_ta, 6, l_ae_line_ref, 1000 );

426: dbms_sql.define_column( c_ta, 2, l_segment1_value, 255 );
427: dbms_sql.define_column( c_ta, 3, l_segment2_value, 255 );
428: dbms_sql.define_column( c_ta, 4, l_segment3_value, 255 );
429: dbms_sql.define_column( c_ta, 5, l_segment4_value, 255 );
430: dbms_sql.define_column( c_ta, 6, l_ae_line_ref, 1000 );
431: dbms_sql.define_column( c_ta, 7, l_ae_line_ref_int, 1000 );
432: dbms_sql.define_column( c_ta, 8, l_entered_currency, 15 );
433: dbms_sql.define_column( c_ta, 9, l_entered_dr );
434: dbms_sql.define_column( c_ta, 10, l_entered_cr );

Line 431: dbms_sql.define_column( c_ta, 7, l_ae_line_ref_int, 1000 );

427: dbms_sql.define_column( c_ta, 3, l_segment2_value, 255 );
428: dbms_sql.define_column( c_ta, 4, l_segment3_value, 255 );
429: dbms_sql.define_column( c_ta, 5, l_segment4_value, 255 );
430: dbms_sql.define_column( c_ta, 6, l_ae_line_ref, 1000 );
431: dbms_sql.define_column( c_ta, 7, l_ae_line_ref_int, 1000 );
432: dbms_sql.define_column( c_ta, 8, l_entered_currency, 15 );
433: dbms_sql.define_column( c_ta, 9, l_entered_dr );
434: dbms_sql.define_column( c_ta, 10, l_entered_cr );
435: dbms_sql.define_column( c_ta, 11, l_acctd_dr );

Line 432: dbms_sql.define_column( c_ta, 8, l_entered_currency, 15 );

428: dbms_sql.define_column( c_ta, 4, l_segment3_value, 255 );
429: dbms_sql.define_column( c_ta, 5, l_segment4_value, 255 );
430: dbms_sql.define_column( c_ta, 6, l_ae_line_ref, 1000 );
431: dbms_sql.define_column( c_ta, 7, l_ae_line_ref_int, 1000 );
432: dbms_sql.define_column( c_ta, 8, l_entered_currency, 15 );
433: dbms_sql.define_column( c_ta, 9, l_entered_dr );
434: dbms_sql.define_column( c_ta, 10, l_entered_cr );
435: dbms_sql.define_column( c_ta, 11, l_acctd_dr );
436: dbms_sql.define_column( c_ta, 12, l_acctd_cr );

Line 433: dbms_sql.define_column( c_ta, 9, l_entered_dr );

429: dbms_sql.define_column( c_ta, 5, l_segment4_value, 255 );
430: dbms_sql.define_column( c_ta, 6, l_ae_line_ref, 1000 );
431: dbms_sql.define_column( c_ta, 7, l_ae_line_ref_int, 1000 );
432: dbms_sql.define_column( c_ta, 8, l_entered_currency, 15 );
433: dbms_sql.define_column( c_ta, 9, l_entered_dr );
434: dbms_sql.define_column( c_ta, 10, l_entered_cr );
435: dbms_sql.define_column( c_ta, 11, l_acctd_dr );
436: dbms_sql.define_column( c_ta, 12, l_acctd_cr );
437: dbms_sql.define_column( c_ta, 13, l_report_dr );

Line 434: dbms_sql.define_column( c_ta, 10, l_entered_cr );

430: dbms_sql.define_column( c_ta, 6, l_ae_line_ref, 1000 );
431: dbms_sql.define_column( c_ta, 7, l_ae_line_ref_int, 1000 );
432: dbms_sql.define_column( c_ta, 8, l_entered_currency, 15 );
433: dbms_sql.define_column( c_ta, 9, l_entered_dr );
434: dbms_sql.define_column( c_ta, 10, l_entered_cr );
435: dbms_sql.define_column( c_ta, 11, l_acctd_dr );
436: dbms_sql.define_column( c_ta, 12, l_acctd_cr );
437: dbms_sql.define_column( c_ta, 13, l_report_dr );
438: dbms_sql.define_column( c_ta, 14, l_report_cr );

Line 435: dbms_sql.define_column( c_ta, 11, l_acctd_dr );

431: dbms_sql.define_column( c_ta, 7, l_ae_line_ref_int, 1000 );
432: dbms_sql.define_column( c_ta, 8, l_entered_currency, 15 );
433: dbms_sql.define_column( c_ta, 9, l_entered_dr );
434: dbms_sql.define_column( c_ta, 10, l_entered_cr );
435: dbms_sql.define_column( c_ta, 11, l_acctd_dr );
436: dbms_sql.define_column( c_ta, 12, l_acctd_cr );
437: dbms_sql.define_column( c_ta, 13, l_report_dr );
438: dbms_sql.define_column( c_ta, 14, l_report_cr );
439: dbms_sql.define_column( c_ta, 15, l_period_name, 15 );

Line 436: dbms_sql.define_column( c_ta, 12, l_acctd_cr );

432: dbms_sql.define_column( c_ta, 8, l_entered_currency, 15 );
433: dbms_sql.define_column( c_ta, 9, l_entered_dr );
434: dbms_sql.define_column( c_ta, 10, l_entered_cr );
435: dbms_sql.define_column( c_ta, 11, l_acctd_dr );
436: dbms_sql.define_column( c_ta, 12, l_acctd_cr );
437: dbms_sql.define_column( c_ta, 13, l_report_dr );
438: dbms_sql.define_column( c_ta, 14, l_report_cr );
439: dbms_sql.define_column( c_ta, 15, l_period_name, 15 );
440: dbms_sql.define_column( c_ta, 16, l_status , 1 );

Line 437: dbms_sql.define_column( c_ta, 13, l_report_dr );

433: dbms_sql.define_column( c_ta, 9, l_entered_dr );
434: dbms_sql.define_column( c_ta, 10, l_entered_cr );
435: dbms_sql.define_column( c_ta, 11, l_acctd_dr );
436: dbms_sql.define_column( c_ta, 12, l_acctd_cr );
437: dbms_sql.define_column( c_ta, 13, l_report_dr );
438: dbms_sql.define_column( c_ta, 14, l_report_cr );
439: dbms_sql.define_column( c_ta, 15, l_period_name, 15 );
440: dbms_sql.define_column( c_ta, 16, l_status , 1 );
441: dbms_sql.define_column( c_ta, 17, l_account_type , 1 );

Line 438: dbms_sql.define_column( c_ta, 14, l_report_cr );

434: dbms_sql.define_column( c_ta, 10, l_entered_cr );
435: dbms_sql.define_column( c_ta, 11, l_acctd_dr );
436: dbms_sql.define_column( c_ta, 12, l_acctd_cr );
437: dbms_sql.define_column( c_ta, 13, l_report_dr );
438: dbms_sql.define_column( c_ta, 14, l_report_cr );
439: dbms_sql.define_column( c_ta, 15, l_period_name, 15 );
440: dbms_sql.define_column( c_ta, 16, l_status , 1 );
441: dbms_sql.define_column( c_ta, 17, l_account_type , 1 );
442:

Line 439: dbms_sql.define_column( c_ta, 15, l_period_name, 15 );

435: dbms_sql.define_column( c_ta, 11, l_acctd_dr );
436: dbms_sql.define_column( c_ta, 12, l_acctd_cr );
437: dbms_sql.define_column( c_ta, 13, l_report_dr );
438: dbms_sql.define_column( c_ta, 14, l_report_cr );
439: dbms_sql.define_column( c_ta, 15, l_period_name, 15 );
440: dbms_sql.define_column( c_ta, 16, l_status , 1 );
441: dbms_sql.define_column( c_ta, 17, l_account_type , 1 );
442:
443: rows := dbms_sql.execute(c_ta);

Line 440: dbms_sql.define_column( c_ta, 16, l_status , 1 );

436: dbms_sql.define_column( c_ta, 12, l_acctd_cr );
437: dbms_sql.define_column( c_ta, 13, l_report_dr );
438: dbms_sql.define_column( c_ta, 14, l_report_cr );
439: dbms_sql.define_column( c_ta, 15, l_period_name, 15 );
440: dbms_sql.define_column( c_ta, 16, l_status , 1 );
441: dbms_sql.define_column( c_ta, 17, l_account_type , 1 );
442:
443: rows := dbms_sql.execute(c_ta);
444: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 441: dbms_sql.define_column( c_ta, 17, l_account_type , 1 );

437: dbms_sql.define_column( c_ta, 13, l_report_dr );
438: dbms_sql.define_column( c_ta, 14, l_report_cr );
439: dbms_sql.define_column( c_ta, 15, l_period_name, 15 );
440: dbms_sql.define_column( c_ta, 16, l_status , 1 );
441: dbms_sql.define_column( c_ta, 17, l_account_type , 1 );
442:
443: rows := dbms_sql.execute(c_ta);
444: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
445: trace

Line 443: rows := dbms_sql.execute(c_ta);

439: dbms_sql.define_column( c_ta, 15, l_period_name, 15 );
440: dbms_sql.define_column( c_ta, 16, l_status , 1 );
441: dbms_sql.define_column( c_ta, 17, l_account_type , 1 );
442:
443: rows := dbms_sql.execute(c_ta);
444: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
445: trace
446: (p_msg => 'end of procedure TA_INIT'
447: ,p_level => C_LEVEL_PROCEDURE

Line 569: c_tb := dbms_sql.open_cursor;

565: ,p_add_col_value_1
566: ,p_add_col_name_2
567: ,p_add_col_value_2
568: );
569: c_tb := dbms_sql.open_cursor;
570: dbms_sql.parse(c_tb, statement, dbms_sql.native);
571:
572: -- Generic bind
573: dbms_sql.bind_variable(c_tb, 'appl_id', p_application_id);

Line 570: dbms_sql.parse(c_tb, statement, dbms_sql.native);

566: ,p_add_col_name_2
567: ,p_add_col_value_2
568: );
569: c_tb := dbms_sql.open_cursor;
570: dbms_sql.parse(c_tb, statement, dbms_sql.native);
571:
572: -- Generic bind
573: dbms_sql.bind_variable(c_tb, 'appl_id', p_application_id);
574: dbms_sql.bind_variable(c_tb, 'set_of_books_id', p_set_of_books_id);

Line 573: dbms_sql.bind_variable(c_tb, 'appl_id', p_application_id);

569: c_tb := dbms_sql.open_cursor;
570: dbms_sql.parse(c_tb, statement, dbms_sql.native);
571:
572: -- Generic bind
573: dbms_sql.bind_variable(c_tb, 'appl_id', p_application_id);
574: dbms_sql.bind_variable(c_tb, 'set_of_books_id', p_set_of_books_id);
575:
576: -- Transaction specific bind
577: IF ( p_overRidingWhereClause IS NULL )

Line 574: dbms_sql.bind_variable(c_tb, 'set_of_books_id', p_set_of_books_id);

570: dbms_sql.parse(c_tb, statement, dbms_sql.native);
571:
572: -- Generic bind
573: dbms_sql.bind_variable(c_tb, 'appl_id', p_application_id);
574: dbms_sql.bind_variable(c_tb, 'set_of_books_id', p_set_of_books_id);
575:
576: -- Transaction specific bind
577: IF ( p_overRidingWhereClause IS NULL )
578: THEN

Line 580: dbms_sql.bind_variable(c_tb, 'add_col_value_1', p_add_col_value_1);

576: -- Transaction specific bind
577: IF ( p_overRidingWhereClause IS NULL )
578: THEN
579: IF ( p_add_col_name_1 IS NOT NULL ) THEN
580: dbms_sql.bind_variable(c_tb, 'add_col_value_1', p_add_col_value_1);
581: END IF;
582:
583: IF ( p_add_col_name_2 IS NOT NULL ) THEN
584: dbms_sql.bind_variable(c_tb, 'add_col_value_2', p_add_col_value_2);

Line 584: dbms_sql.bind_variable(c_tb, 'add_col_value_2', p_add_col_value_2);

580: dbms_sql.bind_variable(c_tb, 'add_col_value_1', p_add_col_value_1);
581: END IF;
582:
583: IF ( p_add_col_name_2 IS NOT NULL ) THEN
584: dbms_sql.bind_variable(c_tb, 'add_col_value_2', p_add_col_value_2);
585: END IF;
586:
587: IF ( p_trx_header_table IS NOT NULL ) THEN
588: dbms_sql.bind_variable(c_tb, 'trx_header_table', p_trx_header_table);

Line 588: dbms_sql.bind_variable(c_tb, 'trx_header_table', p_trx_header_table);

584: dbms_sql.bind_variable(c_tb, 'add_col_value_2', p_add_col_value_2);
585: END IF;
586:
587: IF ( p_trx_header_table IS NOT NULL ) THEN
588: dbms_sql.bind_variable(c_tb, 'trx_header_table', p_trx_header_table);
589: END IF;
590:
591: IF ( p_trx_header_id IS NOT NULL ) THEN
592: dbms_sql.bind_variable(c_tb, 'trx_header_id', p_trx_header_id);

Line 592: dbms_sql.bind_variable(c_tb, 'trx_header_id', p_trx_header_id);

588: dbms_sql.bind_variable(c_tb, 'trx_header_table', p_trx_header_table);
589: END IF;
590:
591: IF ( p_trx_header_id IS NOT NULL ) THEN
592: dbms_sql.bind_variable(c_tb, 'trx_header_id', p_trx_header_id);
593: END IF;
594:
595: -- Mfg. PAC transactions support
596: IF ( p_Cost_Type_ID IS NOT NULL ) THEN

Line 597: dbms_sql.bind_variable(c_tb, 'cost_type_id', p_cost_type_id);

593: END IF;
594:
595: -- Mfg. PAC transactions support
596: IF ( p_Cost_Type_ID IS NOT NULL ) THEN
597: dbms_sql.bind_variable(c_tb, 'cost_type_id', p_cost_type_id);
598: END IF;
599:
600: END IF;
601:

Line 603: dbms_sql.define_column( c_tb, 1, l_ccid );

599:
600: END IF;
601:
602: -- Define columns
603: dbms_sql.define_column( c_tb, 1, l_ccid );
604: dbms_sql.define_column( c_tb, 2, l_segment1_value, 255 );
605: dbms_sql.define_column( c_tb, 3, l_segment2_value, 255 );
606: dbms_sql.define_column( c_tb, 4, l_segment3_value, 255 );
607: dbms_sql.define_column( c_tb, 5, l_segment4_value, 255 );

Line 604: dbms_sql.define_column( c_tb, 2, l_segment1_value, 255 );

600: END IF;
601:
602: -- Define columns
603: dbms_sql.define_column( c_tb, 1, l_ccid );
604: dbms_sql.define_column( c_tb, 2, l_segment1_value, 255 );
605: dbms_sql.define_column( c_tb, 3, l_segment2_value, 255 );
606: dbms_sql.define_column( c_tb, 4, l_segment3_value, 255 );
607: dbms_sql.define_column( c_tb, 5, l_segment4_value, 255 );
608: dbms_sql.define_column( c_tb, 6, l_ae_line_ref, 1000 );

Line 605: dbms_sql.define_column( c_tb, 3, l_segment2_value, 255 );

601:
602: -- Define columns
603: dbms_sql.define_column( c_tb, 1, l_ccid );
604: dbms_sql.define_column( c_tb, 2, l_segment1_value, 255 );
605: dbms_sql.define_column( c_tb, 3, l_segment2_value, 255 );
606: dbms_sql.define_column( c_tb, 4, l_segment3_value, 255 );
607: dbms_sql.define_column( c_tb, 5, l_segment4_value, 255 );
608: dbms_sql.define_column( c_tb, 6, l_ae_line_ref, 1000 );
609: dbms_sql.define_column( c_tb, 7, l_ae_line_ref_int, 1000 );

Line 606: dbms_sql.define_column( c_tb, 4, l_segment3_value, 255 );

602: -- Define columns
603: dbms_sql.define_column( c_tb, 1, l_ccid );
604: dbms_sql.define_column( c_tb, 2, l_segment1_value, 255 );
605: dbms_sql.define_column( c_tb, 3, l_segment2_value, 255 );
606: dbms_sql.define_column( c_tb, 4, l_segment3_value, 255 );
607: dbms_sql.define_column( c_tb, 5, l_segment4_value, 255 );
608: dbms_sql.define_column( c_tb, 6, l_ae_line_ref, 1000 );
609: dbms_sql.define_column( c_tb, 7, l_ae_line_ref_int, 1000 );
610: dbms_sql.define_column( c_tb, 8, l_entered_currency, 15 );

Line 607: dbms_sql.define_column( c_tb, 5, l_segment4_value, 255 );

603: dbms_sql.define_column( c_tb, 1, l_ccid );
604: dbms_sql.define_column( c_tb, 2, l_segment1_value, 255 );
605: dbms_sql.define_column( c_tb, 3, l_segment2_value, 255 );
606: dbms_sql.define_column( c_tb, 4, l_segment3_value, 255 );
607: dbms_sql.define_column( c_tb, 5, l_segment4_value, 255 );
608: dbms_sql.define_column( c_tb, 6, l_ae_line_ref, 1000 );
609: dbms_sql.define_column( c_tb, 7, l_ae_line_ref_int, 1000 );
610: dbms_sql.define_column( c_tb, 8, l_entered_currency, 15 );
611: dbms_sql.define_column( c_tb, 9, l_entered_dr );

Line 608: dbms_sql.define_column( c_tb, 6, l_ae_line_ref, 1000 );

604: dbms_sql.define_column( c_tb, 2, l_segment1_value, 255 );
605: dbms_sql.define_column( c_tb, 3, l_segment2_value, 255 );
606: dbms_sql.define_column( c_tb, 4, l_segment3_value, 255 );
607: dbms_sql.define_column( c_tb, 5, l_segment4_value, 255 );
608: dbms_sql.define_column( c_tb, 6, l_ae_line_ref, 1000 );
609: dbms_sql.define_column( c_tb, 7, l_ae_line_ref_int, 1000 );
610: dbms_sql.define_column( c_tb, 8, l_entered_currency, 15 );
611: dbms_sql.define_column( c_tb, 9, l_entered_dr );
612: dbms_sql.define_column( c_tb, 10, l_entered_cr );

Line 609: dbms_sql.define_column( c_tb, 7, l_ae_line_ref_int, 1000 );

605: dbms_sql.define_column( c_tb, 3, l_segment2_value, 255 );
606: dbms_sql.define_column( c_tb, 4, l_segment3_value, 255 );
607: dbms_sql.define_column( c_tb, 5, l_segment4_value, 255 );
608: dbms_sql.define_column( c_tb, 6, l_ae_line_ref, 1000 );
609: dbms_sql.define_column( c_tb, 7, l_ae_line_ref_int, 1000 );
610: dbms_sql.define_column( c_tb, 8, l_entered_currency, 15 );
611: dbms_sql.define_column( c_tb, 9, l_entered_dr );
612: dbms_sql.define_column( c_tb, 10, l_entered_cr );
613: dbms_sql.define_column( c_tb, 11, l_acctd_dr );

Line 610: dbms_sql.define_column( c_tb, 8, l_entered_currency, 15 );

606: dbms_sql.define_column( c_tb, 4, l_segment3_value, 255 );
607: dbms_sql.define_column( c_tb, 5, l_segment4_value, 255 );
608: dbms_sql.define_column( c_tb, 6, l_ae_line_ref, 1000 );
609: dbms_sql.define_column( c_tb, 7, l_ae_line_ref_int, 1000 );
610: dbms_sql.define_column( c_tb, 8, l_entered_currency, 15 );
611: dbms_sql.define_column( c_tb, 9, l_entered_dr );
612: dbms_sql.define_column( c_tb, 10, l_entered_cr );
613: dbms_sql.define_column( c_tb, 11, l_acctd_dr );
614: dbms_sql.define_column( c_tb, 12, l_acctd_cr );

Line 611: dbms_sql.define_column( c_tb, 9, l_entered_dr );

607: dbms_sql.define_column( c_tb, 5, l_segment4_value, 255 );
608: dbms_sql.define_column( c_tb, 6, l_ae_line_ref, 1000 );
609: dbms_sql.define_column( c_tb, 7, l_ae_line_ref_int, 1000 );
610: dbms_sql.define_column( c_tb, 8, l_entered_currency, 15 );
611: dbms_sql.define_column( c_tb, 9, l_entered_dr );
612: dbms_sql.define_column( c_tb, 10, l_entered_cr );
613: dbms_sql.define_column( c_tb, 11, l_acctd_dr );
614: dbms_sql.define_column( c_tb, 12, l_acctd_cr );
615: dbms_sql.define_column( c_tb, 13, l_report_dr );

Line 612: dbms_sql.define_column( c_tb, 10, l_entered_cr );

608: dbms_sql.define_column( c_tb, 6, l_ae_line_ref, 1000 );
609: dbms_sql.define_column( c_tb, 7, l_ae_line_ref_int, 1000 );
610: dbms_sql.define_column( c_tb, 8, l_entered_currency, 15 );
611: dbms_sql.define_column( c_tb, 9, l_entered_dr );
612: dbms_sql.define_column( c_tb, 10, l_entered_cr );
613: dbms_sql.define_column( c_tb, 11, l_acctd_dr );
614: dbms_sql.define_column( c_tb, 12, l_acctd_cr );
615: dbms_sql.define_column( c_tb, 13, l_report_dr );
616: dbms_sql.define_column( c_tb, 14, l_report_cr );

Line 613: dbms_sql.define_column( c_tb, 11, l_acctd_dr );

609: dbms_sql.define_column( c_tb, 7, l_ae_line_ref_int, 1000 );
610: dbms_sql.define_column( c_tb, 8, l_entered_currency, 15 );
611: dbms_sql.define_column( c_tb, 9, l_entered_dr );
612: dbms_sql.define_column( c_tb, 10, l_entered_cr );
613: dbms_sql.define_column( c_tb, 11, l_acctd_dr );
614: dbms_sql.define_column( c_tb, 12, l_acctd_cr );
615: dbms_sql.define_column( c_tb, 13, l_report_dr );
616: dbms_sql.define_column( c_tb, 14, l_report_cr );
617: dbms_sql.define_column( c_tb, 15, l_period_name, 15 );

Line 614: dbms_sql.define_column( c_tb, 12, l_acctd_cr );

610: dbms_sql.define_column( c_tb, 8, l_entered_currency, 15 );
611: dbms_sql.define_column( c_tb, 9, l_entered_dr );
612: dbms_sql.define_column( c_tb, 10, l_entered_cr );
613: dbms_sql.define_column( c_tb, 11, l_acctd_dr );
614: dbms_sql.define_column( c_tb, 12, l_acctd_cr );
615: dbms_sql.define_column( c_tb, 13, l_report_dr );
616: dbms_sql.define_column( c_tb, 14, l_report_cr );
617: dbms_sql.define_column( c_tb, 15, l_period_name, 15 );
618: dbms_sql.define_column( c_tb, 16, l_status , 1 );

Line 615: dbms_sql.define_column( c_tb, 13, l_report_dr );

611: dbms_sql.define_column( c_tb, 9, l_entered_dr );
612: dbms_sql.define_column( c_tb, 10, l_entered_cr );
613: dbms_sql.define_column( c_tb, 11, l_acctd_dr );
614: dbms_sql.define_column( c_tb, 12, l_acctd_cr );
615: dbms_sql.define_column( c_tb, 13, l_report_dr );
616: dbms_sql.define_column( c_tb, 14, l_report_cr );
617: dbms_sql.define_column( c_tb, 15, l_period_name, 15 );
618: dbms_sql.define_column( c_tb, 16, l_status , 1 );
619: dbms_sql.define_column( c_tb, 17, l_account_type , 1 );

Line 616: dbms_sql.define_column( c_tb, 14, l_report_cr );

612: dbms_sql.define_column( c_tb, 10, l_entered_cr );
613: dbms_sql.define_column( c_tb, 11, l_acctd_dr );
614: dbms_sql.define_column( c_tb, 12, l_acctd_cr );
615: dbms_sql.define_column( c_tb, 13, l_report_dr );
616: dbms_sql.define_column( c_tb, 14, l_report_cr );
617: dbms_sql.define_column( c_tb, 15, l_period_name, 15 );
618: dbms_sql.define_column( c_tb, 16, l_status , 1 );
619: dbms_sql.define_column( c_tb, 17, l_account_type , 1 );
620:

Line 617: dbms_sql.define_column( c_tb, 15, l_period_name, 15 );

613: dbms_sql.define_column( c_tb, 11, l_acctd_dr );
614: dbms_sql.define_column( c_tb, 12, l_acctd_cr );
615: dbms_sql.define_column( c_tb, 13, l_report_dr );
616: dbms_sql.define_column( c_tb, 14, l_report_cr );
617: dbms_sql.define_column( c_tb, 15, l_period_name, 15 );
618: dbms_sql.define_column( c_tb, 16, l_status , 1 );
619: dbms_sql.define_column( c_tb, 17, l_account_type , 1 );
620:
621: rows := dbms_sql.execute(c_tb);

Line 618: dbms_sql.define_column( c_tb, 16, l_status , 1 );

614: dbms_sql.define_column( c_tb, 12, l_acctd_cr );
615: dbms_sql.define_column( c_tb, 13, l_report_dr );
616: dbms_sql.define_column( c_tb, 14, l_report_cr );
617: dbms_sql.define_column( c_tb, 15, l_period_name, 15 );
618: dbms_sql.define_column( c_tb, 16, l_status , 1 );
619: dbms_sql.define_column( c_tb, 17, l_account_type , 1 );
620:
621: rows := dbms_sql.execute(c_tb);
622: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 619: dbms_sql.define_column( c_tb, 17, l_account_type , 1 );

615: dbms_sql.define_column( c_tb, 13, l_report_dr );
616: dbms_sql.define_column( c_tb, 14, l_report_cr );
617: dbms_sql.define_column( c_tb, 15, l_period_name, 15 );
618: dbms_sql.define_column( c_tb, 16, l_status , 1 );
619: dbms_sql.define_column( c_tb, 17, l_account_type , 1 );
620:
621: rows := dbms_sql.execute(c_tb);
622: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
623: trace

Line 621: rows := dbms_sql.execute(c_tb);

617: dbms_sql.define_column( c_tb, 15, l_period_name, 15 );
618: dbms_sql.define_column( c_tb, 16, l_status , 1 );
619: dbms_sql.define_column( c_tb, 17, l_account_type , 1 );
620:
621: rows := dbms_sql.execute(c_tb);
622: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
623: trace
624: (p_msg => 'end of procedure TB_INIT'
625: ,p_level => C_LEVEL_PROCEDURE

Line 1347: IF ( dbms_sql.fetch_rows(c_ta) > 0 ) THEN

1343: -- Fetch Data and populate tables
1344: -- Exit if rowCnt > rows_requested or End_of_fetch.
1345: LOOP
1346: EXIT WHEN l_rowCnt > p_rows;
1347: IF ( dbms_sql.fetch_rows(c_ta) > 0 ) THEN
1348:
1349: dbms_sql.column_value( c_ta, 1, l_ccid );
1350: dbms_sql.column_value( c_ta, 2, l_segment1_value );
1351: dbms_sql.column_value( c_ta, 3, l_segment2_value );

Line 1349: dbms_sql.column_value( c_ta, 1, l_ccid );

1345: LOOP
1346: EXIT WHEN l_rowCnt > p_rows;
1347: IF ( dbms_sql.fetch_rows(c_ta) > 0 ) THEN
1348:
1349: dbms_sql.column_value( c_ta, 1, l_ccid );
1350: dbms_sql.column_value( c_ta, 2, l_segment1_value );
1351: dbms_sql.column_value( c_ta, 3, l_segment2_value );
1352: dbms_sql.column_value( c_ta, 4, l_segment3_value );
1353: dbms_sql.column_value( c_ta, 5, l_segment4_value );

Line 1350: dbms_sql.column_value( c_ta, 2, l_segment1_value );

1346: EXIT WHEN l_rowCnt > p_rows;
1347: IF ( dbms_sql.fetch_rows(c_ta) > 0 ) THEN
1348:
1349: dbms_sql.column_value( c_ta, 1, l_ccid );
1350: dbms_sql.column_value( c_ta, 2, l_segment1_value );
1351: dbms_sql.column_value( c_ta, 3, l_segment2_value );
1352: dbms_sql.column_value( c_ta, 4, l_segment3_value );
1353: dbms_sql.column_value( c_ta, 5, l_segment4_value );
1354: dbms_sql.column_value( c_ta, 6, l_ae_line_ref );

Line 1351: dbms_sql.column_value( c_ta, 3, l_segment2_value );

1347: IF ( dbms_sql.fetch_rows(c_ta) > 0 ) THEN
1348:
1349: dbms_sql.column_value( c_ta, 1, l_ccid );
1350: dbms_sql.column_value( c_ta, 2, l_segment1_value );
1351: dbms_sql.column_value( c_ta, 3, l_segment2_value );
1352: dbms_sql.column_value( c_ta, 4, l_segment3_value );
1353: dbms_sql.column_value( c_ta, 5, l_segment4_value );
1354: dbms_sql.column_value( c_ta, 6, l_ae_line_ref );
1355: dbms_sql.column_value( c_ta, 7, l_ae_line_ref_int );

Line 1352: dbms_sql.column_value( c_ta, 4, l_segment3_value );

1348:
1349: dbms_sql.column_value( c_ta, 1, l_ccid );
1350: dbms_sql.column_value( c_ta, 2, l_segment1_value );
1351: dbms_sql.column_value( c_ta, 3, l_segment2_value );
1352: dbms_sql.column_value( c_ta, 4, l_segment3_value );
1353: dbms_sql.column_value( c_ta, 5, l_segment4_value );
1354: dbms_sql.column_value( c_ta, 6, l_ae_line_ref );
1355: dbms_sql.column_value( c_ta, 7, l_ae_line_ref_int );
1356: dbms_sql.column_value( c_ta, 8, l_entered_currency );

Line 1353: dbms_sql.column_value( c_ta, 5, l_segment4_value );

1349: dbms_sql.column_value( c_ta, 1, l_ccid );
1350: dbms_sql.column_value( c_ta, 2, l_segment1_value );
1351: dbms_sql.column_value( c_ta, 3, l_segment2_value );
1352: dbms_sql.column_value( c_ta, 4, l_segment3_value );
1353: dbms_sql.column_value( c_ta, 5, l_segment4_value );
1354: dbms_sql.column_value( c_ta, 6, l_ae_line_ref );
1355: dbms_sql.column_value( c_ta, 7, l_ae_line_ref_int );
1356: dbms_sql.column_value( c_ta, 8, l_entered_currency );
1357: dbms_sql.column_value( c_ta, 9, l_entered_dr );

Line 1354: dbms_sql.column_value( c_ta, 6, l_ae_line_ref );

1350: dbms_sql.column_value( c_ta, 2, l_segment1_value );
1351: dbms_sql.column_value( c_ta, 3, l_segment2_value );
1352: dbms_sql.column_value( c_ta, 4, l_segment3_value );
1353: dbms_sql.column_value( c_ta, 5, l_segment4_value );
1354: dbms_sql.column_value( c_ta, 6, l_ae_line_ref );
1355: dbms_sql.column_value( c_ta, 7, l_ae_line_ref_int );
1356: dbms_sql.column_value( c_ta, 8, l_entered_currency );
1357: dbms_sql.column_value( c_ta, 9, l_entered_dr );
1358: dbms_sql.column_value( c_ta, 10, l_entered_cr );

Line 1355: dbms_sql.column_value( c_ta, 7, l_ae_line_ref_int );

1351: dbms_sql.column_value( c_ta, 3, l_segment2_value );
1352: dbms_sql.column_value( c_ta, 4, l_segment3_value );
1353: dbms_sql.column_value( c_ta, 5, l_segment4_value );
1354: dbms_sql.column_value( c_ta, 6, l_ae_line_ref );
1355: dbms_sql.column_value( c_ta, 7, l_ae_line_ref_int );
1356: dbms_sql.column_value( c_ta, 8, l_entered_currency );
1357: dbms_sql.column_value( c_ta, 9, l_entered_dr );
1358: dbms_sql.column_value( c_ta, 10, l_entered_cr );
1359: dbms_sql.column_value( c_ta, 11, l_acctd_dr );

Line 1356: dbms_sql.column_value( c_ta, 8, l_entered_currency );

1352: dbms_sql.column_value( c_ta, 4, l_segment3_value );
1353: dbms_sql.column_value( c_ta, 5, l_segment4_value );
1354: dbms_sql.column_value( c_ta, 6, l_ae_line_ref );
1355: dbms_sql.column_value( c_ta, 7, l_ae_line_ref_int );
1356: dbms_sql.column_value( c_ta, 8, l_entered_currency );
1357: dbms_sql.column_value( c_ta, 9, l_entered_dr );
1358: dbms_sql.column_value( c_ta, 10, l_entered_cr );
1359: dbms_sql.column_value( c_ta, 11, l_acctd_dr );
1360: dbms_sql.column_value( c_ta, 12, l_acctd_cr );

Line 1357: dbms_sql.column_value( c_ta, 9, l_entered_dr );

1353: dbms_sql.column_value( c_ta, 5, l_segment4_value );
1354: dbms_sql.column_value( c_ta, 6, l_ae_line_ref );
1355: dbms_sql.column_value( c_ta, 7, l_ae_line_ref_int );
1356: dbms_sql.column_value( c_ta, 8, l_entered_currency );
1357: dbms_sql.column_value( c_ta, 9, l_entered_dr );
1358: dbms_sql.column_value( c_ta, 10, l_entered_cr );
1359: dbms_sql.column_value( c_ta, 11, l_acctd_dr );
1360: dbms_sql.column_value( c_ta, 12, l_acctd_cr );
1361: dbms_sql.column_value( c_ta, 13, l_report_dr );

Line 1358: dbms_sql.column_value( c_ta, 10, l_entered_cr );

1354: dbms_sql.column_value( c_ta, 6, l_ae_line_ref );
1355: dbms_sql.column_value( c_ta, 7, l_ae_line_ref_int );
1356: dbms_sql.column_value( c_ta, 8, l_entered_currency );
1357: dbms_sql.column_value( c_ta, 9, l_entered_dr );
1358: dbms_sql.column_value( c_ta, 10, l_entered_cr );
1359: dbms_sql.column_value( c_ta, 11, l_acctd_dr );
1360: dbms_sql.column_value( c_ta, 12, l_acctd_cr );
1361: dbms_sql.column_value( c_ta, 13, l_report_dr );
1362: dbms_sql.column_value( c_ta, 14, l_report_cr );

Line 1359: dbms_sql.column_value( c_ta, 11, l_acctd_dr );

1355: dbms_sql.column_value( c_ta, 7, l_ae_line_ref_int );
1356: dbms_sql.column_value( c_ta, 8, l_entered_currency );
1357: dbms_sql.column_value( c_ta, 9, l_entered_dr );
1358: dbms_sql.column_value( c_ta, 10, l_entered_cr );
1359: dbms_sql.column_value( c_ta, 11, l_acctd_dr );
1360: dbms_sql.column_value( c_ta, 12, l_acctd_cr );
1361: dbms_sql.column_value( c_ta, 13, l_report_dr );
1362: dbms_sql.column_value( c_ta, 14, l_report_cr );
1363: dbms_sql.column_value( c_ta, 15, l_period_name );

Line 1360: dbms_sql.column_value( c_ta, 12, l_acctd_cr );

1356: dbms_sql.column_value( c_ta, 8, l_entered_currency );
1357: dbms_sql.column_value( c_ta, 9, l_entered_dr );
1358: dbms_sql.column_value( c_ta, 10, l_entered_cr );
1359: dbms_sql.column_value( c_ta, 11, l_acctd_dr );
1360: dbms_sql.column_value( c_ta, 12, l_acctd_cr );
1361: dbms_sql.column_value( c_ta, 13, l_report_dr );
1362: dbms_sql.column_value( c_ta, 14, l_report_cr );
1363: dbms_sql.column_value( c_ta, 15, l_period_name );
1364: dbms_sql.column_value( c_ta, 16, l_status );

Line 1361: dbms_sql.column_value( c_ta, 13, l_report_dr );

1357: dbms_sql.column_value( c_ta, 9, l_entered_dr );
1358: dbms_sql.column_value( c_ta, 10, l_entered_cr );
1359: dbms_sql.column_value( c_ta, 11, l_acctd_dr );
1360: dbms_sql.column_value( c_ta, 12, l_acctd_cr );
1361: dbms_sql.column_value( c_ta, 13, l_report_dr );
1362: dbms_sql.column_value( c_ta, 14, l_report_cr );
1363: dbms_sql.column_value( c_ta, 15, l_period_name );
1364: dbms_sql.column_value( c_ta, 16, l_status );
1365: dbms_sql.column_value( c_ta, 17, l_account_type );

Line 1362: dbms_sql.column_value( c_ta, 14, l_report_cr );

1358: dbms_sql.column_value( c_ta, 10, l_entered_cr );
1359: dbms_sql.column_value( c_ta, 11, l_acctd_dr );
1360: dbms_sql.column_value( c_ta, 12, l_acctd_cr );
1361: dbms_sql.column_value( c_ta, 13, l_report_dr );
1362: dbms_sql.column_value( c_ta, 14, l_report_cr );
1363: dbms_sql.column_value( c_ta, 15, l_period_name );
1364: dbms_sql.column_value( c_ta, 16, l_status );
1365: dbms_sql.column_value( c_ta, 17, l_account_type );
1366:

Line 1363: dbms_sql.column_value( c_ta, 15, l_period_name );

1359: dbms_sql.column_value( c_ta, 11, l_acctd_dr );
1360: dbms_sql.column_value( c_ta, 12, l_acctd_cr );
1361: dbms_sql.column_value( c_ta, 13, l_report_dr );
1362: dbms_sql.column_value( c_ta, 14, l_report_cr );
1363: dbms_sql.column_value( c_ta, 15, l_period_name );
1364: dbms_sql.column_value( c_ta, 16, l_status );
1365: dbms_sql.column_value( c_ta, 17, l_account_type );
1366:
1367: l_account := l_segment1_value||l_segment2_value||l_segment3_value||l_segment4_value;

Line 1364: dbms_sql.column_value( c_ta, 16, l_status );

1360: dbms_sql.column_value( c_ta, 12, l_acctd_cr );
1361: dbms_sql.column_value( c_ta, 13, l_report_dr );
1362: dbms_sql.column_value( c_ta, 14, l_report_cr );
1363: dbms_sql.column_value( c_ta, 15, l_period_name );
1364: dbms_sql.column_value( c_ta, 16, l_status );
1365: dbms_sql.column_value( c_ta, 17, l_account_type );
1366:
1367: l_account := l_segment1_value||l_segment2_value||l_segment3_value||l_segment4_value;
1368:

Line 1365: dbms_sql.column_value( c_ta, 17, l_account_type );

1361: dbms_sql.column_value( c_ta, 13, l_report_dr );
1362: dbms_sql.column_value( c_ta, 14, l_report_cr );
1363: dbms_sql.column_value( c_ta, 15, l_period_name );
1364: dbms_sql.column_value( c_ta, 16, l_status );
1365: dbms_sql.column_value( c_ta, 17, l_account_type );
1366:
1367: l_account := l_segment1_value||l_segment2_value||l_segment3_value||l_segment4_value;
1368:
1369: IF g_firstRow is null THEN

Line 1941: IF (dbms_sql.IS_OPEN(c_ta)) THEN

1937: (p_msg => 'no more rows'
1938: ,p_level => C_LEVEL_STATEMENT
1939: ,p_module =>l_log_module);
1940: END IF;
1941: IF (dbms_sql.IS_OPEN(c_ta)) THEN
1942: dbms_sql.close_cursor(c_ta);
1943: END IF;
1944: p_eof := TRUE;
1945:

Line 1942: dbms_sql.close_cursor(c_ta);

1938: ,p_level => C_LEVEL_STATEMENT
1939: ,p_module =>l_log_module);
1940: END IF;
1941: IF (dbms_sql.IS_OPEN(c_ta)) THEN
1942: dbms_sql.close_cursor(c_ta);
1943: END IF;
1944: p_eof := TRUE;
1945:
1946: getNetBalance(g_totalEntCcidDr

Line 2237: IF ( dbms_sql.fetch_rows(c_tb) > 0 ) THEN

2233: ,p_module =>l_log_module);
2234: l_temp:=l_temp+1;
2235: end loop;
2236: END IF;
2237: IF ( dbms_sql.fetch_rows(c_tb) > 0 ) THEN
2238: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2239: trace
2240: (p_msg => 'dbms_sql.fetch_rows(c_tb) > 0'
2241: ,p_level => C_LEVEL_STATEMENT

Line 2240: (p_msg => 'dbms_sql.fetch_rows(c_tb) > 0'

2236: END IF;
2237: IF ( dbms_sql.fetch_rows(c_tb) > 0 ) THEN
2238: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2239: trace
2240: (p_msg => 'dbms_sql.fetch_rows(c_tb) > 0'
2241: ,p_level => C_LEVEL_STATEMENT
2242: ,p_module =>l_log_module);
2243: END IF;
2244:

Line 2245: dbms_sql.column_value( c_tb, 1, l_ccid );

2241: ,p_level => C_LEVEL_STATEMENT
2242: ,p_module =>l_log_module);
2243: END IF;
2244:
2245: dbms_sql.column_value( c_tb, 1, l_ccid );
2246: dbms_sql.column_value( c_tb, 2, l_segment1_value );
2247: dbms_sql.column_value( c_tb, 3, l_segment2_value );
2248: dbms_sql.column_value( c_tb, 4, l_segment3_value );
2249: dbms_sql.column_value( c_tb, 5, l_segment4_value );

Line 2246: dbms_sql.column_value( c_tb, 2, l_segment1_value );

2242: ,p_module =>l_log_module);
2243: END IF;
2244:
2245: dbms_sql.column_value( c_tb, 1, l_ccid );
2246: dbms_sql.column_value( c_tb, 2, l_segment1_value );
2247: dbms_sql.column_value( c_tb, 3, l_segment2_value );
2248: dbms_sql.column_value( c_tb, 4, l_segment3_value );
2249: dbms_sql.column_value( c_tb, 5, l_segment4_value );
2250: dbms_sql.column_value( c_tb, 6, l_ae_line_ref );

Line 2247: dbms_sql.column_value( c_tb, 3, l_segment2_value );

2243: END IF;
2244:
2245: dbms_sql.column_value( c_tb, 1, l_ccid );
2246: dbms_sql.column_value( c_tb, 2, l_segment1_value );
2247: dbms_sql.column_value( c_tb, 3, l_segment2_value );
2248: dbms_sql.column_value( c_tb, 4, l_segment3_value );
2249: dbms_sql.column_value( c_tb, 5, l_segment4_value );
2250: dbms_sql.column_value( c_tb, 6, l_ae_line_ref );
2251: dbms_sql.column_value( c_tb, 7, l_ae_line_ref_int );

Line 2248: dbms_sql.column_value( c_tb, 4, l_segment3_value );

2244:
2245: dbms_sql.column_value( c_tb, 1, l_ccid );
2246: dbms_sql.column_value( c_tb, 2, l_segment1_value );
2247: dbms_sql.column_value( c_tb, 3, l_segment2_value );
2248: dbms_sql.column_value( c_tb, 4, l_segment3_value );
2249: dbms_sql.column_value( c_tb, 5, l_segment4_value );
2250: dbms_sql.column_value( c_tb, 6, l_ae_line_ref );
2251: dbms_sql.column_value( c_tb, 7, l_ae_line_ref_int );
2252: dbms_sql.column_value( c_tb, 8, l_entered_currency );

Line 2249: dbms_sql.column_value( c_tb, 5, l_segment4_value );

2245: dbms_sql.column_value( c_tb, 1, l_ccid );
2246: dbms_sql.column_value( c_tb, 2, l_segment1_value );
2247: dbms_sql.column_value( c_tb, 3, l_segment2_value );
2248: dbms_sql.column_value( c_tb, 4, l_segment3_value );
2249: dbms_sql.column_value( c_tb, 5, l_segment4_value );
2250: dbms_sql.column_value( c_tb, 6, l_ae_line_ref );
2251: dbms_sql.column_value( c_tb, 7, l_ae_line_ref_int );
2252: dbms_sql.column_value( c_tb, 8, l_entered_currency );
2253: dbms_sql.column_value( c_tb, 9, l_entered_dr );

Line 2250: dbms_sql.column_value( c_tb, 6, l_ae_line_ref );

2246: dbms_sql.column_value( c_tb, 2, l_segment1_value );
2247: dbms_sql.column_value( c_tb, 3, l_segment2_value );
2248: dbms_sql.column_value( c_tb, 4, l_segment3_value );
2249: dbms_sql.column_value( c_tb, 5, l_segment4_value );
2250: dbms_sql.column_value( c_tb, 6, l_ae_line_ref );
2251: dbms_sql.column_value( c_tb, 7, l_ae_line_ref_int );
2252: dbms_sql.column_value( c_tb, 8, l_entered_currency );
2253: dbms_sql.column_value( c_tb, 9, l_entered_dr );
2254: dbms_sql.column_value( c_tb, 10, l_entered_cr );

Line 2251: dbms_sql.column_value( c_tb, 7, l_ae_line_ref_int );

2247: dbms_sql.column_value( c_tb, 3, l_segment2_value );
2248: dbms_sql.column_value( c_tb, 4, l_segment3_value );
2249: dbms_sql.column_value( c_tb, 5, l_segment4_value );
2250: dbms_sql.column_value( c_tb, 6, l_ae_line_ref );
2251: dbms_sql.column_value( c_tb, 7, l_ae_line_ref_int );
2252: dbms_sql.column_value( c_tb, 8, l_entered_currency );
2253: dbms_sql.column_value( c_tb, 9, l_entered_dr );
2254: dbms_sql.column_value( c_tb, 10, l_entered_cr );
2255: dbms_sql.column_value( c_tb, 11, l_acctd_dr );

Line 2252: dbms_sql.column_value( c_tb, 8, l_entered_currency );

2248: dbms_sql.column_value( c_tb, 4, l_segment3_value );
2249: dbms_sql.column_value( c_tb, 5, l_segment4_value );
2250: dbms_sql.column_value( c_tb, 6, l_ae_line_ref );
2251: dbms_sql.column_value( c_tb, 7, l_ae_line_ref_int );
2252: dbms_sql.column_value( c_tb, 8, l_entered_currency );
2253: dbms_sql.column_value( c_tb, 9, l_entered_dr );
2254: dbms_sql.column_value( c_tb, 10, l_entered_cr );
2255: dbms_sql.column_value( c_tb, 11, l_acctd_dr );
2256: dbms_sql.column_value( c_tb, 12, l_acctd_cr );

Line 2253: dbms_sql.column_value( c_tb, 9, l_entered_dr );

2249: dbms_sql.column_value( c_tb, 5, l_segment4_value );
2250: dbms_sql.column_value( c_tb, 6, l_ae_line_ref );
2251: dbms_sql.column_value( c_tb, 7, l_ae_line_ref_int );
2252: dbms_sql.column_value( c_tb, 8, l_entered_currency );
2253: dbms_sql.column_value( c_tb, 9, l_entered_dr );
2254: dbms_sql.column_value( c_tb, 10, l_entered_cr );
2255: dbms_sql.column_value( c_tb, 11, l_acctd_dr );
2256: dbms_sql.column_value( c_tb, 12, l_acctd_cr );
2257: dbms_sql.column_value( c_tb, 13, l_report_dr );

Line 2254: dbms_sql.column_value( c_tb, 10, l_entered_cr );

2250: dbms_sql.column_value( c_tb, 6, l_ae_line_ref );
2251: dbms_sql.column_value( c_tb, 7, l_ae_line_ref_int );
2252: dbms_sql.column_value( c_tb, 8, l_entered_currency );
2253: dbms_sql.column_value( c_tb, 9, l_entered_dr );
2254: dbms_sql.column_value( c_tb, 10, l_entered_cr );
2255: dbms_sql.column_value( c_tb, 11, l_acctd_dr );
2256: dbms_sql.column_value( c_tb, 12, l_acctd_cr );
2257: dbms_sql.column_value( c_tb, 13, l_report_dr );
2258: dbms_sql.column_value( c_tb, 14, l_report_cr );

Line 2255: dbms_sql.column_value( c_tb, 11, l_acctd_dr );

2251: dbms_sql.column_value( c_tb, 7, l_ae_line_ref_int );
2252: dbms_sql.column_value( c_tb, 8, l_entered_currency );
2253: dbms_sql.column_value( c_tb, 9, l_entered_dr );
2254: dbms_sql.column_value( c_tb, 10, l_entered_cr );
2255: dbms_sql.column_value( c_tb, 11, l_acctd_dr );
2256: dbms_sql.column_value( c_tb, 12, l_acctd_cr );
2257: dbms_sql.column_value( c_tb, 13, l_report_dr );
2258: dbms_sql.column_value( c_tb, 14, l_report_cr );
2259: dbms_sql.column_value( c_tb, 15, l_period_name );

Line 2256: dbms_sql.column_value( c_tb, 12, l_acctd_cr );

2252: dbms_sql.column_value( c_tb, 8, l_entered_currency );
2253: dbms_sql.column_value( c_tb, 9, l_entered_dr );
2254: dbms_sql.column_value( c_tb, 10, l_entered_cr );
2255: dbms_sql.column_value( c_tb, 11, l_acctd_dr );
2256: dbms_sql.column_value( c_tb, 12, l_acctd_cr );
2257: dbms_sql.column_value( c_tb, 13, l_report_dr );
2258: dbms_sql.column_value( c_tb, 14, l_report_cr );
2259: dbms_sql.column_value( c_tb, 15, l_period_name );
2260: dbms_sql.column_value( c_tb, 16, l_status );

Line 2257: dbms_sql.column_value( c_tb, 13, l_report_dr );

2253: dbms_sql.column_value( c_tb, 9, l_entered_dr );
2254: dbms_sql.column_value( c_tb, 10, l_entered_cr );
2255: dbms_sql.column_value( c_tb, 11, l_acctd_dr );
2256: dbms_sql.column_value( c_tb, 12, l_acctd_cr );
2257: dbms_sql.column_value( c_tb, 13, l_report_dr );
2258: dbms_sql.column_value( c_tb, 14, l_report_cr );
2259: dbms_sql.column_value( c_tb, 15, l_period_name );
2260: dbms_sql.column_value( c_tb, 16, l_status );
2261: dbms_sql.column_value( c_tb, 17, l_account_type );

Line 2258: dbms_sql.column_value( c_tb, 14, l_report_cr );

2254: dbms_sql.column_value( c_tb, 10, l_entered_cr );
2255: dbms_sql.column_value( c_tb, 11, l_acctd_dr );
2256: dbms_sql.column_value( c_tb, 12, l_acctd_cr );
2257: dbms_sql.column_value( c_tb, 13, l_report_dr );
2258: dbms_sql.column_value( c_tb, 14, l_report_cr );
2259: dbms_sql.column_value( c_tb, 15, l_period_name );
2260: dbms_sql.column_value( c_tb, 16, l_status );
2261: dbms_sql.column_value( c_tb, 17, l_account_type );
2262:

Line 2259: dbms_sql.column_value( c_tb, 15, l_period_name );

2255: dbms_sql.column_value( c_tb, 11, l_acctd_dr );
2256: dbms_sql.column_value( c_tb, 12, l_acctd_cr );
2257: dbms_sql.column_value( c_tb, 13, l_report_dr );
2258: dbms_sql.column_value( c_tb, 14, l_report_cr );
2259: dbms_sql.column_value( c_tb, 15, l_period_name );
2260: dbms_sql.column_value( c_tb, 16, l_status );
2261: dbms_sql.column_value( c_tb, 17, l_account_type );
2262:
2263: l_account := l_segment1_value||l_segment2_value||l_segment3_value||l_segment4_value;

Line 2260: dbms_sql.column_value( c_tb, 16, l_status );

2256: dbms_sql.column_value( c_tb, 12, l_acctd_cr );
2257: dbms_sql.column_value( c_tb, 13, l_report_dr );
2258: dbms_sql.column_value( c_tb, 14, l_report_cr );
2259: dbms_sql.column_value( c_tb, 15, l_period_name );
2260: dbms_sql.column_value( c_tb, 16, l_status );
2261: dbms_sql.column_value( c_tb, 17, l_account_type );
2262:
2263: l_account := l_segment1_value||l_segment2_value||l_segment3_value||l_segment4_value;
2264:

Line 2261: dbms_sql.column_value( c_tb, 17, l_account_type );

2257: dbms_sql.column_value( c_tb, 13, l_report_dr );
2258: dbms_sql.column_value( c_tb, 14, l_report_cr );
2259: dbms_sql.column_value( c_tb, 15, l_period_name );
2260: dbms_sql.column_value( c_tb, 16, l_status );
2261: dbms_sql.column_value( c_tb, 17, l_account_type );
2262:
2263: l_account := l_segment1_value||l_segment2_value||l_segment3_value||l_segment4_value;
2264:
2265: IF g_tb_firstRow is null THEN

Line 2683: IF dbms_sql.IS_OPEN(c_tb) THEN

2679: ,p_level => C_LEVEL_STATEMENT
2680: ,p_module =>l_log_module);
2681: END IF;
2682:
2683: IF dbms_sql.IS_OPEN(c_tb) THEN
2684: dbms_sql.close_cursor(c_tb);
2685: END IF;
2686: p_eof := TRUE;
2687:

Line 2684: dbms_sql.close_cursor(c_tb);

2680: ,p_module =>l_log_module);
2681: END IF;
2682:
2683: IF dbms_sql.IS_OPEN(c_tb) THEN
2684: dbms_sql.close_cursor(c_tb);
2685: END IF;
2686: p_eof := TRUE;
2687:
2688: --IF (NOT g_tb_secure) THEN

Line 3223: IF dbms_sql.IS_OPEN(c_ta) THEN

3219: ,p_level => C_LEVEL_PROCEDURE
3220: ,p_module =>l_log_module);
3221: END IF;
3222:
3223: IF dbms_sql.IS_OPEN(c_ta) THEN
3224: dbms_sql.close_cursor(c_ta);
3225: END IF;
3226: END ta_close;
3227:

Line 3224: dbms_sql.close_cursor(c_ta);

3220: ,p_module =>l_log_module);
3221: END IF;
3222:
3223: IF dbms_sql.IS_OPEN(c_ta) THEN
3224: dbms_sql.close_cursor(c_ta);
3225: END IF;
3226: END ta_close;
3227:
3228: /* Close TB cursor */

Line 3242: IF dbms_sql.IS_OPEN(c_tb) THEN

3238: ,p_level => C_LEVEL_PROCEDURE
3239: ,p_module =>l_log_module);
3240: END IF;
3241:
3242: IF dbms_sql.IS_OPEN(c_tb) THEN
3243: dbms_sql.close_cursor(c_tb);
3244: END IF;
3245: END tb_close;
3246:

Line 3243: dbms_sql.close_cursor(c_tb);

3239: ,p_module =>l_log_module);
3240: END IF;
3241:
3242: IF dbms_sql.IS_OPEN(c_tb) THEN
3243: dbms_sql.close_cursor(c_tb);
3244: END IF;
3245: END tb_close;
3246:
3247: /* Returns the total */