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

Line 849: l_main_cursor := DBMS_SQL.OPEN_CURSOR ;

845: -- END LOOP;
846:
847:
848: BEGIN
849: l_main_cursor := DBMS_SQL.OPEN_CURSOR ;
850: EXCEPTION
851: WHEN OTHERS THEN
852: g_retcode := SQLCODE;
853: g_ERRBUF := SQLERRM;

Line 854: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_l_main_cursor',g_ERRBUF) ;

850: EXCEPTION
851: WHEN OTHERS THEN
852: g_retcode := SQLCODE;
853: g_ERRBUF := SQLERRM;
854: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_l_main_cursor',g_ERRBUF) ;
855: RAISE;
856: END ;
857:
858: BEGIN

Line 859: dbms_sql.parse(l_main_cursor,l_main_sql,DBMS_SQL.V7);

855: RAISE;
856: END ;
857:
858: BEGIN
859: dbms_sql.parse(l_main_cursor,l_main_sql,DBMS_SQL.V7);
860: EXCEPTION
861: WHEN OTHERS THEN
862: g_retcode := SQLCODE;
863: g_ERRBUF := SQLERRM;

Line 864: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_parse_l_main_cursor',g_ERRBUF) ;

860: EXCEPTION
861: WHEN OTHERS THEN
862: g_retcode := SQLCODE;
863: g_ERRBUF := SQLERRM;
864: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_parse_l_main_cursor',g_ERRBUF) ;
865: RAISE;
866: END ;
867:
868: --log(C_STATE_LEVEL, l_module, 'g_period_name: '|| g_period_name );

Line 875: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);

871: log(C_STATE_LEVEL, l_module, 'g_coa_id: '|| g_coa_id );
872: log(C_STATE_LEVEL, l_module, 'l_column_id: '|| l_column_id );
873:
874: IF (l_rec_sla_detail = 'N') THEN
875: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);
876: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
877: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
878: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
879: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);

Line 876: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);

872: log(C_STATE_LEVEL, l_module, 'l_column_id: '|| l_column_id );
873:
874: IF (l_rec_sla_detail = 'N') THEN
875: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);
876: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
877: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
878: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
879: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
880: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);

Line 877: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);

873:
874: IF (l_rec_sla_detail = 'N') THEN
875: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);
876: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
877: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
878: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
879: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
880: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
881: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);

Line 878: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);

874: IF (l_rec_sla_detail = 'N') THEN
875: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);
876: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
877: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
878: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
879: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
880: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
881: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
882: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);

Line 879: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);

875: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);
876: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
877: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
878: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
879: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
880: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
881: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
882: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);
883: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);

Line 880: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);

876: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
877: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
878: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
879: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
880: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
881: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
882: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);
883: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
884: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);

Line 881: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);

877: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
878: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
879: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
880: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
881: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
882: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);
883: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
884: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
885: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);

Line 882: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);

878: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
879: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
880: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
881: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
882: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);
883: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
884: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
885: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
886: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);

Line 883: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);

879: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
880: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
881: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
882: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);
883: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
884: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
885: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
886: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
887: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);

Line 884: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);

880: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
881: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
882: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);
883: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
884: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
885: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
886: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
887: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
888: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);

Line 885: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);

881: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
882: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);
883: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
884: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
885: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
886: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
887: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
888: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
889: ELSE

Line 886: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);

882: --dbms_sql.bind_variable(l_main_cursor,':g_period_year',g_period_year);
883: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
884: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
885: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
886: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
887: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
888: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
889: ELSE
890: --dbms_sql.bind_variable(l_main_cursor,':g_period_name',g_period_name);

Line 887: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);

883: --dbms_sql.bind_variable(l_main_cursor,':g_period_num',g_period_num);
884: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
885: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
886: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
887: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
888: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
889: ELSE
890: --dbms_sql.bind_variable(l_main_cursor,':g_period_name',g_period_name);
891: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);

Line 888: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);

884: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
885: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
886: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
887: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
888: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
889: ELSE
890: --dbms_sql.bind_variable(l_main_cursor,':g_period_name',g_period_name);
891: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
892: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);

Line 890: --dbms_sql.bind_variable(l_main_cursor,':g_period_name',g_period_name);

886: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
887: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
888: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
889: ELSE
890: --dbms_sql.bind_variable(l_main_cursor,':g_period_name',g_period_name);
891: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
892: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
893: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
894: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);

Line 891: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);

887: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
888: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
889: ELSE
890: --dbms_sql.bind_variable(l_main_cursor,':g_period_name',g_period_name);
891: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
892: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
893: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
894: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
895: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);

Line 892: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);

888: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
889: ELSE
890: --dbms_sql.bind_variable(l_main_cursor,':g_period_name',g_period_name);
891: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
892: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
893: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
894: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
895: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
896: END IF;

Line 893: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);

889: ELSE
890: --dbms_sql.bind_variable(l_main_cursor,':g_period_name',g_period_name);
891: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
892: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
893: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
894: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
895: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
896: END IF;
897:

Line 894: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);

890: --dbms_sql.bind_variable(l_main_cursor,':g_period_name',g_period_name);
891: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
892: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
893: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
894: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
895: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
896: END IF;
897:
898: log(C_STATE_LEVEL, l_module, 'completed dbms_sql.bind_variable' );

Line 895: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);

891: dbms_sql.bind_variable(l_main_cursor,':g_ledger_id',g_ledger_id);
892: dbms_sql.bind_variable(l_main_cursor,':g_ussgl_flex_value_set_id',g_ussgl_flex_value_set_id);
893: dbms_sql.bind_variable(l_main_cursor,':g_coa_id',g_coa_id);
894: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
895: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
896: END IF;
897:
898: log(C_STATE_LEVEL, l_module, 'completed dbms_sql.bind_variable' );
899:

Line 898: log(C_STATE_LEVEL, l_module, 'completed dbms_sql.bind_variable' );

894: dbms_sql.bind_variable(l_main_cursor,':l_agree_num',p_agree_num);
895: dbms_sql.bind_variable(l_main_cursor,':l_column_id',l_column_id);
896: END IF;
897:
898: log(C_STATE_LEVEL, l_module, 'completed dbms_sql.bind_variable' );
899:
900: l_count :=0;
901: IF gt_seg_codes(1) IS NOT NULL THEN
902: l_count := l_count+1 ;

Line 903: dbms_sql.define_column(l_main_cursor,l_count,l_segment1,25);

899:
900: l_count :=0;
901: IF gt_seg_codes(1) IS NOT NULL THEN
902: l_count := l_count+1 ;
903: dbms_sql.define_column(l_main_cursor,l_count,l_segment1,25);
904: END IF;
905: IF gt_seg_codes(2) IS NOT NULL THEN
906: l_count := l_count+1 ;
907: dbms_sql.define_column(l_main_cursor,l_count,l_segment2,25);

Line 907: dbms_sql.define_column(l_main_cursor,l_count,l_segment2,25);

903: dbms_sql.define_column(l_main_cursor,l_count,l_segment1,25);
904: END IF;
905: IF gt_seg_codes(2) IS NOT NULL THEN
906: l_count := l_count+1 ;
907: dbms_sql.define_column(l_main_cursor,l_count,l_segment2,25);
908: END IF;
909: IF gt_seg_codes(3) IS NOT NULL THEN
910: l_count := l_count+1 ;
911: dbms_sql.define_column(l_main_cursor,l_count,l_segment3,25);

Line 911: dbms_sql.define_column(l_main_cursor,l_count,l_segment3,25);

907: dbms_sql.define_column(l_main_cursor,l_count,l_segment2,25);
908: END IF;
909: IF gt_seg_codes(3) IS NOT NULL THEN
910: l_count := l_count+1 ;
911: dbms_sql.define_column(l_main_cursor,l_count,l_segment3,25);
912: END IF;
913: IF gt_seg_codes(4) IS NOT NULL THEN
914: l_count := l_count+1 ;
915: dbms_sql.define_column(l_main_cursor,l_count,l_segment4,25);

Line 915: dbms_sql.define_column(l_main_cursor,l_count,l_segment4,25);

911: dbms_sql.define_column(l_main_cursor,l_count,l_segment3,25);
912: END IF;
913: IF gt_seg_codes(4) IS NOT NULL THEN
914: l_count := l_count+1 ;
915: dbms_sql.define_column(l_main_cursor,l_count,l_segment4,25);
916: END IF;
917: IF gt_seg_codes(5) IS NOT NULL THEN
918: l_count := l_count+1 ;
919: dbms_sql.define_column(l_main_cursor,l_count,l_segment5,25);

Line 919: dbms_sql.define_column(l_main_cursor,l_count,l_segment5,25);

915: dbms_sql.define_column(l_main_cursor,l_count,l_segment4,25);
916: END IF;
917: IF gt_seg_codes(5) IS NOT NULL THEN
918: l_count := l_count+1 ;
919: dbms_sql.define_column(l_main_cursor,l_count,l_segment5,25);
920: END IF;
921: IF gt_seg_codes(6) IS NOT NULL THEN
922: l_count := l_count+1 ;
923: dbms_sql.define_column(l_main_cursor,l_count,l_segment6,25);

Line 923: dbms_sql.define_column(l_main_cursor,l_count,l_segment6,25);

919: dbms_sql.define_column(l_main_cursor,l_count,l_segment5,25);
920: END IF;
921: IF gt_seg_codes(6) IS NOT NULL THEN
922: l_count := l_count+1 ;
923: dbms_sql.define_column(l_main_cursor,l_count,l_segment6,25);
924: END IF;
925: IF gt_seg_codes(7) IS NOT NULL THEN
926: l_count := l_count+1 ;
927: dbms_sql.define_column(l_main_cursor,l_count,l_segment7,25);

Line 927: dbms_sql.define_column(l_main_cursor,l_count,l_segment7,25);

923: dbms_sql.define_column(l_main_cursor,l_count,l_segment6,25);
924: END IF;
925: IF gt_seg_codes(7) IS NOT NULL THEN
926: l_count := l_count+1 ;
927: dbms_sql.define_column(l_main_cursor,l_count,l_segment7,25);
928: END IF;
929: IF gt_seg_codes(8) IS NOT NULL THEN
930: l_count := l_count+1 ;
931: dbms_sql.define_column(l_main_cursor,l_count,l_segment8,25);

Line 931: dbms_sql.define_column(l_main_cursor,l_count,l_segment8,25);

927: dbms_sql.define_column(l_main_cursor,l_count,l_segment7,25);
928: END IF;
929: IF gt_seg_codes(8) IS NOT NULL THEN
930: l_count := l_count+1 ;
931: dbms_sql.define_column(l_main_cursor,l_count,l_segment8,25);
932: END IF;
933: IF gt_seg_codes(9) IS NOT NULL THEN
934: l_count := l_count+1 ;
935: dbms_sql.define_column(l_main_cursor,l_count,l_segment9,25);

Line 935: dbms_sql.define_column(l_main_cursor,l_count,l_segment9,25);

931: dbms_sql.define_column(l_main_cursor,l_count,l_segment8,25);
932: END IF;
933: IF gt_seg_codes(9) IS NOT NULL THEN
934: l_count := l_count+1 ;
935: dbms_sql.define_column(l_main_cursor,l_count,l_segment9,25);
936: END IF;
937: IF gt_seg_codes(10) IS NOT NULL THEN
938: l_count := l_count+1 ;
939: dbms_sql.define_column(l_main_cursor,l_count,l_segment10,25);

Line 939: dbms_sql.define_column(l_main_cursor,l_count,l_segment10,25);

935: dbms_sql.define_column(l_main_cursor,l_count,l_segment9,25);
936: END IF;
937: IF gt_seg_codes(10) IS NOT NULL THEN
938: l_count := l_count+1 ;
939: dbms_sql.define_column(l_main_cursor,l_count,l_segment10,25);
940: END IF;
941: IF gt_seg_codes(11) IS NOT NULL THEN
942: l_count := l_count+1 ;
943: dbms_sql.define_column(l_main_cursor,l_count,l_segment11,25);

Line 943: dbms_sql.define_column(l_main_cursor,l_count,l_segment11,25);

939: dbms_sql.define_column(l_main_cursor,l_count,l_segment10,25);
940: END IF;
941: IF gt_seg_codes(11) IS NOT NULL THEN
942: l_count := l_count+1 ;
943: dbms_sql.define_column(l_main_cursor,l_count,l_segment11,25);
944: END IF;
945: IF gt_seg_codes(12) IS NOT NULL THEN
946: l_count := l_count+1 ;
947: dbms_sql.define_column(l_main_cursor,l_count,l_segment12,25);

Line 947: dbms_sql.define_column(l_main_cursor,l_count,l_segment12,25);

943: dbms_sql.define_column(l_main_cursor,l_count,l_segment11,25);
944: END IF;
945: IF gt_seg_codes(12) IS NOT NULL THEN
946: l_count := l_count+1 ;
947: dbms_sql.define_column(l_main_cursor,l_count,l_segment12,25);
948: END IF;
949: IF gt_seg_codes(13) IS NOT NULL THEN
950: l_count := l_count+1 ;
951: dbms_sql.define_column(l_main_cursor,l_count,l_segment13,25);

Line 951: dbms_sql.define_column(l_main_cursor,l_count,l_segment13,25);

947: dbms_sql.define_column(l_main_cursor,l_count,l_segment12,25);
948: END IF;
949: IF gt_seg_codes(13) IS NOT NULL THEN
950: l_count := l_count+1 ;
951: dbms_sql.define_column(l_main_cursor,l_count,l_segment13,25);
952: END IF;
953: IF gt_seg_codes(14) IS NOT NULL THEN
954: l_count := l_count+1 ;
955: dbms_sql.define_column(l_main_cursor,l_count,l_segment14,25);

Line 955: dbms_sql.define_column(l_main_cursor,l_count,l_segment14,25);

951: dbms_sql.define_column(l_main_cursor,l_count,l_segment13,25);
952: END IF;
953: IF gt_seg_codes(14) IS NOT NULL THEN
954: l_count := l_count+1 ;
955: dbms_sql.define_column(l_main_cursor,l_count,l_segment14,25);
956: END IF;
957: IF gt_seg_codes(15) IS NOT NULL THEN
958: l_count := l_count+1 ;
959: dbms_sql.define_column(l_main_cursor,l_count,l_segment15,25);

Line 959: dbms_sql.define_column(l_main_cursor,l_count,l_segment15,25);

955: dbms_sql.define_column(l_main_cursor,l_count,l_segment14,25);
956: END IF;
957: IF gt_seg_codes(15) IS NOT NULL THEN
958: l_count := l_count+1 ;
959: dbms_sql.define_column(l_main_cursor,l_count,l_segment15,25);
960: END IF;
961: IF gt_seg_codes(16) IS NOT NULL THEN
962: l_count := l_count+1 ;
963: dbms_sql.define_column(l_main_cursor,l_count,l_segment16,25);

Line 963: dbms_sql.define_column(l_main_cursor,l_count,l_segment16,25);

959: dbms_sql.define_column(l_main_cursor,l_count,l_segment15,25);
960: END IF;
961: IF gt_seg_codes(16) IS NOT NULL THEN
962: l_count := l_count+1 ;
963: dbms_sql.define_column(l_main_cursor,l_count,l_segment16,25);
964: END IF;
965: IF gt_seg_codes(17) IS NOT NULL THEN
966: l_count := l_count+1 ;
967: dbms_sql.define_column(l_main_cursor,l_count,l_segment17,25);

Line 967: dbms_sql.define_column(l_main_cursor,l_count,l_segment17,25);

963: dbms_sql.define_column(l_main_cursor,l_count,l_segment16,25);
964: END IF;
965: IF gt_seg_codes(17) IS NOT NULL THEN
966: l_count := l_count+1 ;
967: dbms_sql.define_column(l_main_cursor,l_count,l_segment17,25);
968: END IF;
969: IF gt_seg_codes(18) IS NOT NULL THEN
970: l_count := l_count+1 ;
971: dbms_sql.define_column(l_main_cursor,l_count,l_segment18,25);

Line 971: dbms_sql.define_column(l_main_cursor,l_count,l_segment18,25);

967: dbms_sql.define_column(l_main_cursor,l_count,l_segment17,25);
968: END IF;
969: IF gt_seg_codes(18) IS NOT NULL THEN
970: l_count := l_count+1 ;
971: dbms_sql.define_column(l_main_cursor,l_count,l_segment18,25);
972: END IF;
973: IF gt_seg_codes(19) IS NOT NULL THEN
974: l_count := l_count+1 ;
975: dbms_sql.define_column(l_main_cursor,l_count,l_segment19,25);

Line 975: dbms_sql.define_column(l_main_cursor,l_count,l_segment19,25);

971: dbms_sql.define_column(l_main_cursor,l_count,l_segment18,25);
972: END IF;
973: IF gt_seg_codes(19) IS NOT NULL THEN
974: l_count := l_count+1 ;
975: dbms_sql.define_column(l_main_cursor,l_count,l_segment19,25);
976: END IF;
977: IF gt_seg_codes(20) IS NOT NULL THEN
978: l_count := l_count+1 ;
979: dbms_sql.define_column(l_main_cursor,l_count,l_segment20,25);

Line 979: dbms_sql.define_column(l_main_cursor,l_count,l_segment20,25);

975: dbms_sql.define_column(l_main_cursor,l_count,l_segment19,25);
976: END IF;
977: IF gt_seg_codes(20) IS NOT NULL THEN
978: l_count := l_count+1 ;
979: dbms_sql.define_column(l_main_cursor,l_count,l_segment20,25);
980: END IF;
981: IF gt_seg_codes(21) IS NOT NULL THEN
982: l_count := l_count+1 ;
983: dbms_sql.define_column(l_main_cursor,l_count,l_segment21,25);

Line 983: dbms_sql.define_column(l_main_cursor,l_count,l_segment21,25);

979: dbms_sql.define_column(l_main_cursor,l_count,l_segment20,25);
980: END IF;
981: IF gt_seg_codes(21) IS NOT NULL THEN
982: l_count := l_count+1 ;
983: dbms_sql.define_column(l_main_cursor,l_count,l_segment21,25);
984: END IF;
985: IF gt_seg_codes(22) IS NOT NULL THEN
986: l_count := l_count+1 ;
987: dbms_sql.define_column(l_main_cursor,l_count,l_segment22,25);

Line 987: dbms_sql.define_column(l_main_cursor,l_count,l_segment22,25);

983: dbms_sql.define_column(l_main_cursor,l_count,l_segment21,25);
984: END IF;
985: IF gt_seg_codes(22) IS NOT NULL THEN
986: l_count := l_count+1 ;
987: dbms_sql.define_column(l_main_cursor,l_count,l_segment22,25);
988: END IF;
989: IF gt_seg_codes(23) IS NOT NULL THEN
990: l_count := l_count+1 ;
991: dbms_sql.define_column(l_main_cursor,l_count,l_segment23,25);

Line 991: dbms_sql.define_column(l_main_cursor,l_count,l_segment23,25);

987: dbms_sql.define_column(l_main_cursor,l_count,l_segment22,25);
988: END IF;
989: IF gt_seg_codes(23) IS NOT NULL THEN
990: l_count := l_count+1 ;
991: dbms_sql.define_column(l_main_cursor,l_count,l_segment23,25);
992: END IF;
993: IF gt_seg_codes(24) IS NOT NULL THEN
994: l_count := l_count+1 ;
995: dbms_sql.define_column(l_main_cursor,l_count,l_segment24,25);

Line 995: dbms_sql.define_column(l_main_cursor,l_count,l_segment24,25);

991: dbms_sql.define_column(l_main_cursor,l_count,l_segment23,25);
992: END IF;
993: IF gt_seg_codes(24) IS NOT NULL THEN
994: l_count := l_count+1 ;
995: dbms_sql.define_column(l_main_cursor,l_count,l_segment24,25);
996: END IF;
997: IF gt_seg_codes(25) IS NOT NULL THEN
998: l_count := l_count+1 ;
999: dbms_sql.define_column(l_main_cursor,l_count,l_segment25,25);

Line 999: dbms_sql.define_column(l_main_cursor,l_count,l_segment25,25);

995: dbms_sql.define_column(l_main_cursor,l_count,l_segment24,25);
996: END IF;
997: IF gt_seg_codes(25) IS NOT NULL THEN
998: l_count := l_count+1 ;
999: dbms_sql.define_column(l_main_cursor,l_count,l_segment25,25);
1000: END IF;
1001: IF gt_seg_codes(26) IS NOT NULL THEN
1002: l_count := l_count+1 ;
1003: dbms_sql.define_column(l_main_cursor,l_count,l_segment26,25);

Line 1003: dbms_sql.define_column(l_main_cursor,l_count,l_segment26,25);

999: dbms_sql.define_column(l_main_cursor,l_count,l_segment25,25);
1000: END IF;
1001: IF gt_seg_codes(26) IS NOT NULL THEN
1002: l_count := l_count+1 ;
1003: dbms_sql.define_column(l_main_cursor,l_count,l_segment26,25);
1004: END IF;
1005: IF gt_seg_codes(27) IS NOT NULL THEN
1006: l_count := l_count+1 ;
1007: dbms_sql.define_column(l_main_cursor,l_count,l_segment27,25);

Line 1007: dbms_sql.define_column(l_main_cursor,l_count,l_segment27,25);

1003: dbms_sql.define_column(l_main_cursor,l_count,l_segment26,25);
1004: END IF;
1005: IF gt_seg_codes(27) IS NOT NULL THEN
1006: l_count := l_count+1 ;
1007: dbms_sql.define_column(l_main_cursor,l_count,l_segment27,25);
1008: END IF;
1009: IF gt_seg_codes(28) IS NOT NULL THEN
1010: l_count := l_count+1 ;
1011: dbms_sql.define_column(l_main_cursor,l_count,l_segment28,25);

Line 1011: dbms_sql.define_column(l_main_cursor,l_count,l_segment28,25);

1007: dbms_sql.define_column(l_main_cursor,l_count,l_segment27,25);
1008: END IF;
1009: IF gt_seg_codes(28) IS NOT NULL THEN
1010: l_count := l_count+1 ;
1011: dbms_sql.define_column(l_main_cursor,l_count,l_segment28,25);
1012: END IF;
1013: IF gt_seg_codes(29) IS NOT NULL THEN
1014: l_count := l_count+1 ;
1015: dbms_sql.define_column(l_main_cursor,l_count,l_segment29,25);

Line 1015: dbms_sql.define_column(l_main_cursor,l_count,l_segment29,25);

1011: dbms_sql.define_column(l_main_cursor,l_count,l_segment28,25);
1012: END IF;
1013: IF gt_seg_codes(29) IS NOT NULL THEN
1014: l_count := l_count+1 ;
1015: dbms_sql.define_column(l_main_cursor,l_count,l_segment29,25);
1016: END IF;
1017: IF gt_seg_codes(30) IS NOT NULL THEN
1018: l_count := l_count+1 ;
1019: dbms_sql.define_column(l_main_cursor,l_count,l_segment30,25);

Line 1019: dbms_sql.define_column(l_main_cursor,l_count,l_segment30,25);

1015: dbms_sql.define_column(l_main_cursor,l_count,l_segment29,25);
1016: END IF;
1017: IF gt_seg_codes(30) IS NOT NULL THEN
1018: l_count := l_count+1 ;
1019: dbms_sql.define_column(l_main_cursor,l_count,l_segment30,25);
1020: END IF;
1021: l_count := l_count+1 ;
1022: dbms_sql.define_column(l_main_cursor,l_count,l_amount,25);
1023:

Line 1022: dbms_sql.define_column(l_main_cursor,l_count,l_amount,25);

1018: l_count := l_count+1 ;
1019: dbms_sql.define_column(l_main_cursor,l_count,l_segment30,25);
1020: END IF;
1021: l_count := l_count+1 ;
1022: dbms_sql.define_column(l_main_cursor,l_count,l_amount,25);
1023:
1024: log(C_STATE_LEVEL, l_module, 'completed dbms_sql.define_column' );
1025:
1026: BEGIN

Line 1024: log(C_STATE_LEVEL, l_module, 'completed dbms_sql.define_column' );

1020: END IF;
1021: l_count := l_count+1 ;
1022: dbms_sql.define_column(l_main_cursor,l_count,l_amount,25);
1023:
1024: log(C_STATE_LEVEL, l_module, 'completed dbms_sql.define_column' );
1025:
1026: BEGIN
1027: l_exec_ret := dbms_sql.execute(l_main_cursor);
1028: EXCEPTION

Line 1027: l_exec_ret := dbms_sql.execute(l_main_cursor);

1023:
1024: log(C_STATE_LEVEL, l_module, 'completed dbms_sql.define_column' );
1025:
1026: BEGIN
1027: l_exec_ret := dbms_sql.execute(l_main_cursor);
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: g_retcode := SQLCODE;
1031: g_ERRBUF := SQLERRM;

Line 1032: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_execute_l_main_cursor',g_ERRBUF) ;

1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: g_retcode := SQLCODE;
1031: g_ERRBUF := SQLERRM;
1032: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_execute_l_main_cursor',g_ERRBUF) ;
1033: RAISE;
1034: END ;
1035:
1036: log(C_STATE_LEVEL, l_module, 'completed dbms_sql.execute' );

Line 1036: log(C_STATE_LEVEL, l_module, 'completed dbms_sql.execute' );

1032: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_execute_l_main_cursor',g_ERRBUF) ;
1033: RAISE;
1034: END ;
1035:
1036: log(C_STATE_LEVEL, l_module, 'completed dbms_sql.execute' );
1037:
1038: l_trx_sql:='SELECT h.trx_number, h.purchase_order,
1039: h.start_date_commitment,
1040: h.end_date_commitment,

Line 1055: log(C_STATE_LEVEL, l_module, 'proceeding with dbms_sql.fetch_rows ' );

1051: l_extended_amount
1052: USING
1053: g_ledger_id, l_agree_num;
1054:
1055: log(C_STATE_LEVEL, l_module, 'proceeding with dbms_sql.fetch_rows ' );
1056:
1057: WHILE dbms_sql.fetch_rows(l_main_cursor)>0 LOOP
1058:
1059: log(C_STATE_LEVEL, l_module, 'In side while loop: ');

Line 1057: WHILE dbms_sql.fetch_rows(l_main_cursor)>0 LOOP

1053: g_ledger_id, l_agree_num;
1054:
1055: log(C_STATE_LEVEL, l_module, 'proceeding with dbms_sql.fetch_rows ' );
1056:
1057: WHILE dbms_sql.fetch_rows(l_main_cursor)>0 LOOP
1058:
1059: log(C_STATE_LEVEL, l_module, 'In side while loop: ');
1060:
1061: l_count:=0;

Line 1064: dbms_sql.column_value(l_main_cursor, l_count, l_segment1);

1060:
1061: l_count:=0;
1062: IF gt_seg_codes(1) IS NOT NULL THEN
1063: l_count := l_count+1 ;
1064: dbms_sql.column_value(l_main_cursor, l_count, l_segment1);
1065: log(C_STATE_LEVEL, l_module, ' l_segment1 '|| l_segment1);
1066: l_activity_rec.segment1 := l_segment1;
1067: END IF;
1068: IF gt_seg_codes(2) IS NOT NULL THEN

Line 1070: dbms_sql.column_value(l_main_cursor, l_count, l_segment2);

1066: l_activity_rec.segment1 := l_segment1;
1067: END IF;
1068: IF gt_seg_codes(2) IS NOT NULL THEN
1069: l_count := l_count+1 ;
1070: dbms_sql.column_value(l_main_cursor, l_count, l_segment2);
1071: log(C_STATE_LEVEL, l_module, ' l_segment2 '|| l_segment2);
1072: l_activity_rec.segment2 := l_segment2;
1073: END IF;
1074: IF gt_seg_codes(3) IS NOT NULL THEN

Line 1076: dbms_sql.column_value(l_main_cursor, l_count, l_segment3);

1072: l_activity_rec.segment2 := l_segment2;
1073: END IF;
1074: IF gt_seg_codes(3) IS NOT NULL THEN
1075: l_count := l_count+1 ;
1076: dbms_sql.column_value(l_main_cursor, l_count, l_segment3);
1077: log(C_STATE_LEVEL, l_module, ' l_segment3 '|| l_segment3);
1078: l_activity_rec.segment3 := l_segment3;
1079: END IF;
1080: IF gt_seg_codes(4) IS NOT NULL THEN

Line 1082: dbms_sql.column_value(l_main_cursor, l_count, l_segment4);

1078: l_activity_rec.segment3 := l_segment3;
1079: END IF;
1080: IF gt_seg_codes(4) IS NOT NULL THEN
1081: l_count := l_count+1 ;
1082: dbms_sql.column_value(l_main_cursor, l_count, l_segment4);
1083: log(C_STATE_LEVEL, l_module, ' l_segment4 '|| l_segment4);
1084: l_activity_rec.segment4 := l_segment4;
1085: END IF;
1086: IF gt_seg_codes(5) IS NOT NULL THEN

Line 1088: dbms_sql.column_value(l_main_cursor, l_count, l_segment5);

1084: l_activity_rec.segment4 := l_segment4;
1085: END IF;
1086: IF gt_seg_codes(5) IS NOT NULL THEN
1087: l_count := l_count+1 ;
1088: dbms_sql.column_value(l_main_cursor, l_count, l_segment5);
1089: log(C_STATE_LEVEL, l_module, ' l_segment5 '|| l_segment5);
1090: l_activity_rec.segment5 := l_segment5;
1091: END IF;
1092: IF gt_seg_codes(6) IS NOT NULL THEN

Line 1094: dbms_sql.column_value(l_main_cursor, l_count, l_segment6);

1090: l_activity_rec.segment5 := l_segment5;
1091: END IF;
1092: IF gt_seg_codes(6) IS NOT NULL THEN
1093: l_count := l_count+1 ;
1094: dbms_sql.column_value(l_main_cursor, l_count, l_segment6);
1095: log(C_STATE_LEVEL, l_module, ' l_segment6 '|| l_segment6);
1096: l_activity_rec.segment6 := l_segment6;
1097: END IF;
1098: IF gt_seg_codes(7) IS NOT NULL THEN

Line 1100: dbms_sql.column_value(l_main_cursor, l_count, l_segment7);

1096: l_activity_rec.segment6 := l_segment6;
1097: END IF;
1098: IF gt_seg_codes(7) IS NOT NULL THEN
1099: l_count := l_count+1 ;
1100: dbms_sql.column_value(l_main_cursor, l_count, l_segment7);
1101: log(C_STATE_LEVEL, l_module, ' l_segment7 '|| l_segment7);
1102: l_activity_rec.segment7 := l_segment7;
1103: END IF;
1104: IF gt_seg_codes(8) IS NOT NULL THEN

Line 1106: dbms_sql.column_value(l_main_cursor, l_count, l_segment8);

1102: l_activity_rec.segment7 := l_segment7;
1103: END IF;
1104: IF gt_seg_codes(8) IS NOT NULL THEN
1105: l_count := l_count+1 ;
1106: dbms_sql.column_value(l_main_cursor, l_count, l_segment8);
1107: log(C_STATE_LEVEL, l_module, ' l_segment8 '|| l_segment8);
1108: l_activity_rec.segment8 := l_segment8;
1109: END IF;
1110: IF gt_seg_codes(9) IS NOT NULL THEN

Line 1112: dbms_sql.column_value(l_main_cursor, l_count, l_segment9);

1108: l_activity_rec.segment8 := l_segment8;
1109: END IF;
1110: IF gt_seg_codes(9) IS NOT NULL THEN
1111: l_count := l_count+1 ;
1112: dbms_sql.column_value(l_main_cursor, l_count, l_segment9);
1113: log(C_STATE_LEVEL, l_module, ' l_segment9 '|| l_segment9);
1114: l_activity_rec.segment9 := l_segment9;
1115: END IF;
1116: IF gt_seg_codes(10) IS NOT NULL THEN

Line 1118: dbms_sql.column_value(l_main_cursor, l_count, l_segment10);

1114: l_activity_rec.segment9 := l_segment9;
1115: END IF;
1116: IF gt_seg_codes(10) IS NOT NULL THEN
1117: l_count := l_count+1 ;
1118: dbms_sql.column_value(l_main_cursor, l_count, l_segment10);
1119: log(C_STATE_LEVEL, l_module, ' l_segment10 '|| l_segment10);
1120: l_activity_rec.segment10 := l_segment10;
1121: END IF;
1122: IF gt_seg_codes(11) IS NOT NULL THEN

Line 1124: dbms_sql.column_value(l_main_cursor, l_count, l_segment11);

1120: l_activity_rec.segment10 := l_segment10;
1121: END IF;
1122: IF gt_seg_codes(11) IS NOT NULL THEN
1123: l_count := l_count+1 ;
1124: dbms_sql.column_value(l_main_cursor, l_count, l_segment11);
1125: log(C_STATE_LEVEL, l_module, ' l_segment11 '|| l_segment11);
1126: l_activity_rec.segment11 := l_segment11;
1127: END IF;
1128: IF gt_seg_codes(12) IS NOT NULL THEN

Line 1130: dbms_sql.column_value(l_main_cursor, l_count, l_segment12);

1126: l_activity_rec.segment11 := l_segment11;
1127: END IF;
1128: IF gt_seg_codes(12) IS NOT NULL THEN
1129: l_count := l_count+1 ;
1130: dbms_sql.column_value(l_main_cursor, l_count, l_segment12);
1131: log(C_STATE_LEVEL, l_module, ' l_segment12 '|| l_segment12);
1132: l_activity_rec.segment12 := l_segment12;
1133: END IF;
1134: IF gt_seg_codes(13) IS NOT NULL THEN

Line 1136: dbms_sql.column_value(l_main_cursor, l_count, l_segment13);

1132: l_activity_rec.segment12 := l_segment12;
1133: END IF;
1134: IF gt_seg_codes(13) IS NOT NULL THEN
1135: l_count := l_count+1 ;
1136: dbms_sql.column_value(l_main_cursor, l_count, l_segment13);
1137: log(C_STATE_LEVEL, l_module, ' l_segment13 '|| l_segment13);
1138: l_activity_rec.segment13 := l_segment13;
1139: END IF;
1140: IF gt_seg_codes(14) IS NOT NULL THEN

Line 1142: dbms_sql.column_value(l_main_cursor, l_count, l_segment14);

1138: l_activity_rec.segment13 := l_segment13;
1139: END IF;
1140: IF gt_seg_codes(14) IS NOT NULL THEN
1141: l_count := l_count+1 ;
1142: dbms_sql.column_value(l_main_cursor, l_count, l_segment14);
1143: log(C_STATE_LEVEL, l_module, ' l_segment14 '|| l_segment14);
1144: l_activity_rec.segment14 := l_segment14;
1145: END IF;
1146: IF gt_seg_codes(15) IS NOT NULL THEN

Line 1148: dbms_sql.column_value(l_main_cursor, l_count, l_segment15);

1144: l_activity_rec.segment14 := l_segment14;
1145: END IF;
1146: IF gt_seg_codes(15) IS NOT NULL THEN
1147: l_count := l_count+1 ;
1148: dbms_sql.column_value(l_main_cursor, l_count, l_segment15);
1149: log(C_STATE_LEVEL, l_module, ' l_segment15 '|| l_segment15);
1150: l_activity_rec.segment15 := l_segment15;
1151: END IF;
1152: IF gt_seg_codes(16) IS NOT NULL THEN

Line 1154: dbms_sql.column_value(l_main_cursor, l_count, l_segment16);

1150: l_activity_rec.segment15 := l_segment15;
1151: END IF;
1152: IF gt_seg_codes(16) IS NOT NULL THEN
1153: l_count := l_count+1 ;
1154: dbms_sql.column_value(l_main_cursor, l_count, l_segment16);
1155: log(C_STATE_LEVEL, l_module, ' l_segment16 '|| l_segment16);
1156: l_activity_rec.segment16 := l_segment16;
1157: END IF;
1158: IF gt_seg_codes(17) IS NOT NULL THEN

Line 1160: dbms_sql.column_value(l_main_cursor, l_count, l_segment17);

1156: l_activity_rec.segment16 := l_segment16;
1157: END IF;
1158: IF gt_seg_codes(17) IS NOT NULL THEN
1159: l_count := l_count+1 ;
1160: dbms_sql.column_value(l_main_cursor, l_count, l_segment17);
1161: log(C_STATE_LEVEL, l_module, ' l_segment17 '|| l_segment17);
1162: l_activity_rec.segment17 := l_segment17;
1163: END IF;
1164: IF gt_seg_codes(18) IS NOT NULL THEN

Line 1166: dbms_sql.column_value(l_main_cursor, l_count, l_segment18);

1162: l_activity_rec.segment17 := l_segment17;
1163: END IF;
1164: IF gt_seg_codes(18) IS NOT NULL THEN
1165: l_count := l_count+1 ;
1166: dbms_sql.column_value(l_main_cursor, l_count, l_segment18);
1167: log(C_STATE_LEVEL, l_module, ' l_segment18 '|| l_segment18);
1168: l_activity_rec.segment18 := l_segment18;
1169: END IF;
1170: IF gt_seg_codes(19) IS NOT NULL THEN

Line 1172: dbms_sql.column_value(l_main_cursor, l_count, l_segment19);

1168: l_activity_rec.segment18 := l_segment18;
1169: END IF;
1170: IF gt_seg_codes(19) IS NOT NULL THEN
1171: l_count := l_count+1 ;
1172: dbms_sql.column_value(l_main_cursor, l_count, l_segment19);
1173: log(C_STATE_LEVEL, l_module, ' l_segment19 '|| l_segment19);
1174: l_activity_rec.segment19 := l_segment19;
1175: END IF;
1176: IF gt_seg_codes(20) IS NOT NULL THEN

Line 1178: dbms_sql.column_value(l_main_cursor, l_count, l_segment20);

1174: l_activity_rec.segment19 := l_segment19;
1175: END IF;
1176: IF gt_seg_codes(20) IS NOT NULL THEN
1177: l_count := l_count+1 ;
1178: dbms_sql.column_value(l_main_cursor, l_count, l_segment20);
1179: log(C_STATE_LEVEL, l_module, ' l_segment20 '|| l_segment20);
1180: l_activity_rec.segment20 := l_segment20;
1181: END IF;
1182: IF gt_seg_codes(21) IS NOT NULL THEN

Line 1184: dbms_sql.column_value(l_main_cursor, l_count, l_segment21);

1180: l_activity_rec.segment20 := l_segment20;
1181: END IF;
1182: IF gt_seg_codes(21) IS NOT NULL THEN
1183: l_count := l_count+1 ;
1184: dbms_sql.column_value(l_main_cursor, l_count, l_segment21);
1185: log(C_STATE_LEVEL, l_module, ' l_segment21 '|| l_segment21);
1186: l_activity_rec.segment21 := l_segment21;
1187: END IF;
1188: IF gt_seg_codes(22) IS NOT NULL THEN

Line 1190: dbms_sql.column_value(l_main_cursor, l_count, l_segment22);

1186: l_activity_rec.segment21 := l_segment21;
1187: END IF;
1188: IF gt_seg_codes(22) IS NOT NULL THEN
1189: l_count := l_count+1 ;
1190: dbms_sql.column_value(l_main_cursor, l_count, l_segment22);
1191: log(C_STATE_LEVEL, l_module, ' l_segment22 '|| l_segment22);
1192: l_activity_rec.segment22 := l_segment22;
1193: END IF;
1194: IF gt_seg_codes(23) IS NOT NULL THEN

Line 1196: dbms_sql.column_value(l_main_cursor, l_count, l_segment23);

1192: l_activity_rec.segment22 := l_segment22;
1193: END IF;
1194: IF gt_seg_codes(23) IS NOT NULL THEN
1195: l_count := l_count+1 ;
1196: dbms_sql.column_value(l_main_cursor, l_count, l_segment23);
1197: log(C_STATE_LEVEL, l_module, ' l_segment23 '|| l_segment23);
1198: l_activity_rec.segment23 := l_segment23;
1199: END IF;
1200: IF gt_seg_codes(24) IS NOT NULL THEN

Line 1202: dbms_sql.column_value(l_main_cursor, l_count, l_segment24);

1198: l_activity_rec.segment23 := l_segment23;
1199: END IF;
1200: IF gt_seg_codes(24) IS NOT NULL THEN
1201: l_count := l_count+1 ;
1202: dbms_sql.column_value(l_main_cursor, l_count, l_segment24);
1203: log(C_STATE_LEVEL, l_module, ' l_segment24 '|| l_segment24);
1204: l_activity_rec.segment24 := l_segment24;
1205: END IF;
1206: IF gt_seg_codes(25) IS NOT NULL THEN

Line 1208: dbms_sql.column_value(l_main_cursor, l_count, l_segment25);

1204: l_activity_rec.segment24 := l_segment24;
1205: END IF;
1206: IF gt_seg_codes(25) IS NOT NULL THEN
1207: l_count := l_count+1 ;
1208: dbms_sql.column_value(l_main_cursor, l_count, l_segment25);
1209: log(C_STATE_LEVEL, l_module, ' l_segment25 '|| l_segment25);
1210: l_activity_rec.segment25 := l_segment25;
1211: END IF;
1212: IF gt_seg_codes(26) IS NOT NULL THEN

Line 1214: dbms_sql.column_value(l_main_cursor, l_count, l_segment26);

1210: l_activity_rec.segment25 := l_segment25;
1211: END IF;
1212: IF gt_seg_codes(26) IS NOT NULL THEN
1213: l_count := l_count+1 ;
1214: dbms_sql.column_value(l_main_cursor, l_count, l_segment26);
1215: log(C_STATE_LEVEL, l_module, ' l_segment26 '|| l_segment26);
1216: l_activity_rec.segment26 := l_segment26;
1217: END IF;
1218: IF gt_seg_codes(27) IS NOT NULL THEN

Line 1220: dbms_sql.column_value(l_main_cursor, l_count, l_segment27);

1216: l_activity_rec.segment26 := l_segment26;
1217: END IF;
1218: IF gt_seg_codes(27) IS NOT NULL THEN
1219: l_count := l_count+1 ;
1220: dbms_sql.column_value(l_main_cursor, l_count, l_segment27);
1221: log(C_STATE_LEVEL, l_module, ' l_segment27 '|| l_segment27);
1222: l_activity_rec.segment27 := l_segment27;
1223: END IF;
1224: IF gt_seg_codes(28) IS NOT NULL THEN

Line 1226: dbms_sql.column_value(l_main_cursor, l_count, l_segment28);

1222: l_activity_rec.segment27 := l_segment27;
1223: END IF;
1224: IF gt_seg_codes(28) IS NOT NULL THEN
1225: l_count := l_count+1 ;
1226: dbms_sql.column_value(l_main_cursor, l_count, l_segment28);
1227: log(C_STATE_LEVEL, l_module, ' l_segment28 '|| l_segment28);
1228: l_activity_rec.segment28 := l_segment28;
1229: END IF;
1230: IF gt_seg_codes(29) IS NOT NULL THEN

Line 1232: dbms_sql.column_value(l_main_cursor, l_count, l_segment29);

1228: l_activity_rec.segment28 := l_segment28;
1229: END IF;
1230: IF gt_seg_codes(29) IS NOT NULL THEN
1231: l_count := l_count+1 ;
1232: dbms_sql.column_value(l_main_cursor, l_count, l_segment29);
1233: log(C_STATE_LEVEL, l_module, ' l_segment29 '|| l_segment29);
1234: l_activity_rec.segment29 := l_segment29;
1235: END IF;
1236: IF gt_seg_codes(30) IS NOT NULL THEN

Line 1238: dbms_sql.column_value(l_main_cursor, l_count, l_segment30);

1234: l_activity_rec.segment29 := l_segment29;
1235: END IF;
1236: IF gt_seg_codes(30) IS NOT NULL THEN
1237: l_count := l_count+1 ;
1238: dbms_sql.column_value(l_main_cursor, l_count, l_segment30);
1239: log(C_STATE_LEVEL, l_module, ' l_segment30 '|| l_segment30);
1240: l_activity_rec.segment30 := l_segment30;
1241: END IF;
1242: l_count := l_count+1 ;

Line 1243: dbms_sql.column_value(l_main_cursor, l_count, l_amount);

1239: log(C_STATE_LEVEL, l_module, ' l_segment30 '|| l_segment30);
1240: l_activity_rec.segment30 := l_segment30;
1241: END IF;
1242: l_count := l_count+1 ;
1243: dbms_sql.column_value(l_main_cursor, l_count, l_amount);
1244: log(C_STATE_LEVEL, l_module, 'l_amount '|| l_amount);
1245:
1246:
1247: IF (l_natural_balance_type = 'Credit') then