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_1219_TRANSACTIONS dependencies on DBMS_SQL

Line 700: l_cur:= dbms_sql.open_cursor;

696: and nvl(fda.segment30,''-1'') = decode(fda.segment30,null,''-1'',
697: gcc.segment30)';
698:
699: l_string := l_string1 || l_string2 || l_string3 ;
700: l_cur:= dbms_sql.open_cursor;
701: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
702:
703: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
704: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

Line 701: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

697: gcc.segment30)';
698:
699: l_string := l_string1 || l_string2 || l_string3 ;
700: l_cur:= dbms_sql.open_cursor;
701: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
702:
703: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
704: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
705: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

Line 703: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);

699: l_string := l_string1 || l_string2 || l_string3 ;
700: l_cur:= dbms_sql.open_cursor;
701: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
702:
703: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
704: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
705: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
706: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
707: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

Line 704: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

700: l_cur:= dbms_sql.open_cursor;
701: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
702:
703: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
704: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
705: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
706: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
707: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
708: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

Line 705: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

701: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
702:
703: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
704: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
705: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
706: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
707: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
708: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
709:

Line 706: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);

702:
703: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
704: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
705: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
706: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
707: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
708: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
709:
710: l_row := dbms_sql.EXECUTE(l_cur);

Line 707: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

703: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
704: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
705: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
706: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
707: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
708: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
709:
710: l_row := dbms_sql.EXECUTE(l_cur);
711: dbms_sql.close_cursor(l_cur);

Line 708: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

704: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
705: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
706: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
707: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
708: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
709:
710: l_row := dbms_sql.EXECUTE(l_cur);
711: dbms_sql.close_cursor(l_cur);
712: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 710: l_row := dbms_sql.EXECUTE(l_cur);

706: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
707: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
708: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
709:
710: l_row := dbms_sql.EXECUTE(l_cur);
711: dbms_sql.close_cursor(l_cur);
712: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
713: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
714: l_module_name,'1. l_end_date1 : '||l_end_date1);

Line 711: dbms_sql.close_cursor(l_cur);

707: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
708: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
709:
710: l_row := dbms_sql.EXECUTE(l_cur);
711: dbms_sql.close_cursor(l_cur);
712: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
713: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
714: l_module_name,'1. l_end_date1 : '||l_end_date1);
715: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 882: l_cur:= dbms_sql.open_cursor;

878: and nvl(fda.segment30,''-1'') = decode(fda.segment30,null,''-1'',
879: gcc.segment30)';
880:
881: l_string := l_string1 || l_string2 || l_string3 ;
882: l_cur:= dbms_sql.open_cursor;
883: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
884:
885: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
886: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

Line 883: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

879: gcc.segment30)';
880:
881: l_string := l_string1 || l_string2 || l_string3 ;
882: l_cur:= dbms_sql.open_cursor;
883: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
884:
885: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
886: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
887: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

Line 885: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);

881: l_string := l_string1 || l_string2 || l_string3 ;
882: l_cur:= dbms_sql.open_cursor;
883: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
884:
885: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
886: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
887: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
888: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
889: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

Line 886: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

882: l_cur:= dbms_sql.open_cursor;
883: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
884:
885: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
886: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
887: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
888: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
889: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
890: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

Line 887: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

883: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
884:
885: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
886: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
887: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
888: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
889: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
890: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
891:

Line 888: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);

884:
885: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
886: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
887: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
888: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
889: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
890: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
891:
892: l_row := dbms_sql.EXECUTE(l_cur);

Line 889: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

885: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
886: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
887: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
888: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
889: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
890: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
891:
892: l_row := dbms_sql.EXECUTE(l_cur);
893: dbms_sql.close_cursor(l_cur);

Line 890: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

886: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
887: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
888: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
889: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
890: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
891:
892: l_row := dbms_sql.EXECUTE(l_cur);
893: dbms_sql.close_cursor(l_cur);
894: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 892: l_row := dbms_sql.EXECUTE(l_cur);

888: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
889: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
890: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
891:
892: l_row := dbms_sql.EXECUTE(l_cur);
893: dbms_sql.close_cursor(l_cur);
894: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
895: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
896: l_module_name,'1. l_end_date1 : '||l_end_date1);

Line 893: dbms_sql.close_cursor(l_cur);

889: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
890: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
891:
892: l_row := dbms_sql.EXECUTE(l_cur);
893: dbms_sql.close_cursor(l_cur);
894: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
895: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
896: l_module_name,'1. l_end_date1 : '||l_end_date1);
897: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 1058: l_cur:= dbms_sql.open_cursor;

1054: and nvl(fda.segment30,''-1'') = decode(fda.segment30,null,''-1'',
1055: gcc.segment30)';
1056:
1057: l_string := l_string1 || l_string2 || l_string3 ;
1058: l_cur:= dbms_sql.open_cursor;
1059: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1060:
1061: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1062: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

Line 1059: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

1055: gcc.segment30)';
1056:
1057: l_string := l_string1 || l_string2 || l_string3 ;
1058: l_cur:= dbms_sql.open_cursor;
1059: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1060:
1061: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1062: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1063: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

Line 1061: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);

1057: l_string := l_string1 || l_string2 || l_string3 ;
1058: l_cur:= dbms_sql.open_cursor;
1059: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1060:
1061: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1062: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1063: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1064: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1065: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

Line 1062: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

1058: l_cur:= dbms_sql.open_cursor;
1059: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1060:
1061: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1062: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1063: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1064: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1065: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1066: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

Line 1063: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

1059: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1060:
1061: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1062: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1063: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1064: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1065: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1066: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1067:

Line 1064: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);

1060:
1061: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1062: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1063: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1064: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1065: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1066: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1067:
1068: l_row := dbms_sql.EXECUTE(l_cur);

Line 1065: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

1061: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1062: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1063: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1064: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1065: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1066: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1067:
1068: l_row := dbms_sql.EXECUTE(l_cur);
1069: dbms_sql.close_cursor(l_cur);

Line 1066: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

1062: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1063: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1064: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1065: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1066: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1067:
1068: l_row := dbms_sql.EXECUTE(l_cur);
1069: dbms_sql.close_cursor(l_cur);
1070: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1068: l_row := dbms_sql.EXECUTE(l_cur);

1064: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1065: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1066: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1067:
1068: l_row := dbms_sql.EXECUTE(l_cur);
1069: dbms_sql.close_cursor(l_cur);
1070: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1071: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1072: l_module_name,'1. l_end_date1 : '||l_end_date1);

Line 1069: dbms_sql.close_cursor(l_cur);

1065: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1066: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1067:
1068: l_row := dbms_sql.EXECUTE(l_cur);
1069: dbms_sql.close_cursor(l_cur);
1070: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1071: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1072: l_module_name,'1. l_end_date1 : '||l_end_date1);
1073: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 1236: l_cur:= dbms_sql.open_cursor;

1232: and nvl(fda.segment30,''-1'') = decode(fda.segment30,null,''-1'',
1233: gcc.segment30)';
1234:
1235: l_string := l_string1 || l_string2 || l_string3 ;
1236: l_cur:= dbms_sql.open_cursor;
1237: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1238:
1239: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1240: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

Line 1237: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

1233: gcc.segment30)';
1234:
1235: l_string := l_string1 || l_string2 || l_string3 ;
1236: l_cur:= dbms_sql.open_cursor;
1237: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1238:
1239: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1240: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1241: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

Line 1239: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);

1235: l_string := l_string1 || l_string2 || l_string3 ;
1236: l_cur:= dbms_sql.open_cursor;
1237: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1238:
1239: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1240: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1241: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1242: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1243: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

Line 1240: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

1236: l_cur:= dbms_sql.open_cursor;
1237: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1238:
1239: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1240: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1241: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1242: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1243: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1244: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

Line 1241: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

1237: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1238:
1239: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1240: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1241: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1242: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1243: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1244: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1245:

Line 1242: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);

1238:
1239: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1240: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1241: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1242: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1243: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1244: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1245:
1246: l_row := dbms_sql.EXECUTE(l_cur);

Line 1243: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

1239: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1240: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1241: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1242: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1243: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1244: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1245:
1246: l_row := dbms_sql.EXECUTE(l_cur);
1247: dbms_sql.close_cursor(l_cur);

Line 1244: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

1240: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1241: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1242: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1243: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1244: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1245:
1246: l_row := dbms_sql.EXECUTE(l_cur);
1247: dbms_sql.close_cursor(l_cur);
1248: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1246: l_row := dbms_sql.EXECUTE(l_cur);

1242: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1243: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1244: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1245:
1246: l_row := dbms_sql.EXECUTE(l_cur);
1247: dbms_sql.close_cursor(l_cur);
1248: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1250: l_module_name,'1. l_end_date1 : '||l_end_date1);

Line 1247: dbms_sql.close_cursor(l_cur);

1243: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1244: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1245:
1246: l_row := dbms_sql.EXECUTE(l_cur);
1247: dbms_sql.close_cursor(l_cur);
1248: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1250: l_module_name,'1. l_end_date1 : '||l_end_date1);
1251: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 1412: l_cur:= dbms_sql.open_cursor;

1408: and nvl(fda.segment30,''-1'') = decode(fda.segment30,null,''-1'',
1409: gcc.segment30)';
1410:
1411: l_string := l_string1 || l_string2 || l_string3 ;
1412: l_cur:= dbms_sql.open_cursor;
1413: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1414:
1415: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1416: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

Line 1413: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

1409: gcc.segment30)';
1410:
1411: l_string := l_string1 || l_string2 || l_string3 ;
1412: l_cur:= dbms_sql.open_cursor;
1413: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1414:
1415: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1416: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1417: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

Line 1415: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);

1411: l_string := l_string1 || l_string2 || l_string3 ;
1412: l_cur:= dbms_sql.open_cursor;
1413: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1414:
1415: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1416: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1417: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1418: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1419: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

Line 1416: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

1412: l_cur:= dbms_sql.open_cursor;
1413: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1414:
1415: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1416: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1417: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1418: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1419: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1420: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

Line 1417: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

1413: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1414:
1415: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1416: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1417: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1418: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1419: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1420: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1421:

Line 1418: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);

1414:
1415: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1416: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1417: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1418: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1419: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1420: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1421:
1422: l_row := dbms_sql.EXECUTE(l_cur);

Line 1419: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

1415: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1416: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1417: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1418: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1419: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1420: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1421:
1422: l_row := dbms_sql.EXECUTE(l_cur);
1423: dbms_sql.close_cursor(l_cur);

Line 1420: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

1416: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1417: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1418: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1419: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1420: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1421:
1422: l_row := dbms_sql.EXECUTE(l_cur);
1423: dbms_sql.close_cursor(l_cur);
1424: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1422: l_row := dbms_sql.EXECUTE(l_cur);

1418: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1419: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1420: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1421:
1422: l_row := dbms_sql.EXECUTE(l_cur);
1423: dbms_sql.close_cursor(l_cur);
1424: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1426: l_module_name,'1. l_end_date1 : '||l_end_date1);

Line 1423: dbms_sql.close_cursor(l_cur);

1419: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1420: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1421:
1422: l_row := dbms_sql.EXECUTE(l_cur);
1423: dbms_sql.close_cursor(l_cur);
1424: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1426: l_module_name,'1. l_end_date1 : '||l_end_date1);
1427: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 1592: l_cur:= dbms_sql.open_cursor;

1588: and nvl(fda.segment30,''-1'') = decode(fda.segment30,null,''-1'',
1589: gcc.segment30)';
1590:
1591: l_string := l_string1 || l_string2 || l_string3 ;
1592: l_cur:= dbms_sql.open_cursor;
1593: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1594:
1595: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1596: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

Line 1593: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

1589: gcc.segment30)';
1590:
1591: l_string := l_string1 || l_string2 || l_string3 ;
1592: l_cur:= dbms_sql.open_cursor;
1593: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1594:
1595: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1596: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1597: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

Line 1595: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);

1591: l_string := l_string1 || l_string2 || l_string3 ;
1592: l_cur:= dbms_sql.open_cursor;
1593: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1594:
1595: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1596: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1597: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1598: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1599: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

Line 1596: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

1592: l_cur:= dbms_sql.open_cursor;
1593: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1594:
1595: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1596: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1597: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1598: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1599: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1600: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

Line 1597: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

1593: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1594:
1595: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1596: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1597: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1598: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1599: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1600: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1601:

Line 1598: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);

1594:
1595: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1596: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1597: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1598: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1599: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1600: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1601:
1602: l_row := dbms_sql.EXECUTE(l_cur);

Line 1599: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

1595: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1596: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1597: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1598: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1599: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1600: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1601:
1602: l_row := dbms_sql.EXECUTE(l_cur);
1603: dbms_sql.close_cursor(l_cur);

Line 1600: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

1596: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1597: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1598: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1599: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1600: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1601:
1602: l_row := dbms_sql.EXECUTE(l_cur);
1603: dbms_sql.close_cursor(l_cur);
1604: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1602: l_row := dbms_sql.EXECUTE(l_cur);

1598: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1599: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1600: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1601:
1602: l_row := dbms_sql.EXECUTE(l_cur);
1603: dbms_sql.close_cursor(l_cur);
1604: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1605: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1606: l_module_name,'1. l_end_date1 : '||l_end_date1);

Line 1603: dbms_sql.close_cursor(l_cur);

1599: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1600: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1601:
1602: l_row := dbms_sql.EXECUTE(l_cur);
1603: dbms_sql.close_cursor(l_cur);
1604: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1605: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1606: l_module_name,'1. l_end_date1 : '||l_end_date1);
1607: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 1773: l_cur:= dbms_sql.open_cursor;

1769: and nvl(fda.segment30,''-1'') = decode(fda.segment30,null,''-1'',
1770: gcc.segment30)';
1771:
1772: l_string := l_string1 || l_string2 || l_string3 ;
1773: l_cur:= dbms_sql.open_cursor;
1774: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1775:
1776: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1777: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

Line 1774: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

1770: gcc.segment30)';
1771:
1772: l_string := l_string1 || l_string2 || l_string3 ;
1773: l_cur:= dbms_sql.open_cursor;
1774: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1775:
1776: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1777: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1778: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

Line 1776: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);

1772: l_string := l_string1 || l_string2 || l_string3 ;
1773: l_cur:= dbms_sql.open_cursor;
1774: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1775:
1776: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1777: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1778: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1779: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1780: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

Line 1777: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

1773: l_cur:= dbms_sql.open_cursor;
1774: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1775:
1776: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1777: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1778: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1779: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1780: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1781: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

Line 1778: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

1774: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1775:
1776: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1777: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1778: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1779: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1780: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1781: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1782:

Line 1779: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);

1775:
1776: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1777: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1778: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1779: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1780: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1781: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1782:
1783: l_row := dbms_sql.EXECUTE(l_cur);

Line 1780: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

1776: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1777: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1778: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1779: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1780: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1781: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1782:
1783: l_row := dbms_sql.EXECUTE(l_cur);
1784: dbms_sql.close_cursor(l_cur);

Line 1781: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

1777: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1778: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1779: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1780: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1781: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1782:
1783: l_row := dbms_sql.EXECUTE(l_cur);
1784: dbms_sql.close_cursor(l_cur);
1785: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1783: l_row := dbms_sql.EXECUTE(l_cur);

1779: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1780: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1781: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1782:
1783: l_row := dbms_sql.EXECUTE(l_cur);
1784: dbms_sql.close_cursor(l_cur);
1785: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1787: l_module_name,'1. l_end_date1 : '||l_end_date1);

Line 1784: dbms_sql.close_cursor(l_cur);

1780: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1781: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1782:
1783: l_row := dbms_sql.EXECUTE(l_cur);
1784: dbms_sql.close_cursor(l_cur);
1785: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1786: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1787: l_module_name,'1. l_end_date1 : '||l_end_date1);
1788: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 1953: l_cur:= dbms_sql.open_cursor;

1949: and nvl(fda.segment30,''-1'') = decode(fda.segment30,null,''-1'',
1950: gcc.segment30)';
1951:
1952: l_string := l_string1 || l_string2 || l_string3 ;
1953: l_cur:= dbms_sql.open_cursor;
1954: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1955:
1956: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1957: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

Line 1954: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);

1950: gcc.segment30)';
1951:
1952: l_string := l_string1 || l_string2 || l_string3 ;
1953: l_cur:= dbms_sql.open_cursor;
1954: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1955:
1956: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1957: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1958: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

Line 1956: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);

1952: l_string := l_string1 || l_string2 || l_string3 ;
1953: l_cur:= dbms_sql.open_cursor;
1954: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1955:
1956: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1957: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1958: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1959: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1960: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

Line 1957: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);

1953: l_cur:= dbms_sql.open_cursor;
1954: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1955:
1956: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1957: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1958: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1959: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1960: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1961: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

Line 1958: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);

1954: dbms_sql.parse(l_cur, l_string, DBMS_SQL.V7);
1955:
1956: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1957: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1958: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1959: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1960: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1961: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1962:

Line 1959: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);

1955:
1956: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1957: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1958: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1959: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1960: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1961: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1962:
1963: l_row := dbms_sql.EXECUTE(l_cur);

Line 1960: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);

1956: dbms_sql.bind_variable(l_cur,':b_sob',p_set_bks_id);
1957: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1958: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1959: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1960: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1961: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1962:
1963: l_row := dbms_sql.EXECUTE(l_cur);
1964: dbms_sql.close_cursor(l_cur);

Line 1961: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);

1957: dbms_sql.bind_variable(l_cur,':b_start_date1',l_start_date1);
1958: dbms_sql.bind_variable(l_cur,':b_end_date1',l_end_date1);
1959: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1960: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1961: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1962:
1963: l_row := dbms_sql.EXECUTE(l_cur);
1964: dbms_sql.close_cursor(l_cur);
1965: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1963: l_row := dbms_sql.EXECUTE(l_cur);

1959: dbms_sql.bind_variable(l_cur,':b_gl_period',p_gl_period);
1960: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1961: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1962:
1963: l_row := dbms_sql.EXECUTE(l_cur);
1964: dbms_sql.close_cursor(l_cur);
1965: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1966: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1967: l_module_name,'1. l_end_date1 : '||l_end_date1);

Line 1964: dbms_sql.close_cursor(l_cur);

1960: dbms_sql.bind_variable(l_cur,':b_currency_code',l_currency_code);
1961: dbms_sql.bind_variable(l_cur,':b_bl_seg_name',bl_seg_name);
1962:
1963: l_row := dbms_sql.EXECUTE(l_cur);
1964: dbms_sql.close_cursor(l_cur);
1965: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1966: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1967: l_module_name,'1. l_end_date1 : '||l_end_date1);
1968: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,