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

Line 1017: v_glbal_curid := dbms_sql.open_cursor;

1013: OR (nvl(dets.fund_status,''B'') = ''B'' ))) '
1014: ;
1015: l_stage := 1;
1016: l_out := v_fct1_attr_select;
1017: v_glbal_curid := dbms_sql.open_cursor;
1018: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);
1019: dbms_sql.define_column(v_glbal_curid, 1, v_amount);
1020: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);
1021: v_fct1_sel := 'SELECT ROUND(SUM(NVL(ffrt.amount,0) ),2) ';

Line 1018: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);

1014: ;
1015: l_stage := 1;
1016: l_out := v_fct1_attr_select;
1017: v_glbal_curid := dbms_sql.open_cursor;
1018: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);
1019: dbms_sql.define_column(v_glbal_curid, 1, v_amount);
1020: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);
1021: v_fct1_sel := 'SELECT ROUND(SUM(NVL(ffrt.amount,0) ),2) ';
1022: v_fct1_rcpt_sel := v_fct1_sel || ' , ffrt.recipient_name ';

Line 1019: dbms_sql.define_column(v_glbal_curid, 1, v_amount);

1015: l_stage := 1;
1016: l_out := v_fct1_attr_select;
1017: v_glbal_curid := dbms_sql.open_cursor;
1018: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);
1019: dbms_sql.define_column(v_glbal_curid, 1, v_amount);
1020: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);
1021: v_fct1_sel := 'SELECT ROUND(SUM(NVL(ffrt.amount,0) ),2) ';
1022: v_fct1_rcpt_sel := v_fct1_sel || ' , ffrt.recipient_name ';
1023: l_temp1 := '

Line 1020: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);

1016: l_out := v_fct1_attr_select;
1017: v_glbal_curid := dbms_sql.open_cursor;
1018: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);
1019: dbms_sql.define_column(v_glbal_curid, 1, v_amount);
1020: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);
1021: v_fct1_sel := 'SELECT ROUND(SUM(NVL(ffrt.amount,0) ),2) ';
1022: v_fct1_rcpt_sel := v_fct1_sel || ' , ffrt.recipient_name ';
1023: l_temp1 := '
1024: FROM fv_ccid_cfs_gt fvcc,

Line 1045: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;

1041: v_fct1_sel := v_fct1_sel || l_temp1;
1042: v_fct1_rcpt_sel := v_fct1_rcpt_sel || l_temp1 || ' GROUP BY ffrt.recipient_name ';
1043: l_stage := 3;
1044: l_out := v_fct1_rcpt_sel;
1045: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
1046: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
1047: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
1048: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
1049: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);

Line 1046: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);

1042: v_fct1_rcpt_sel := v_fct1_rcpt_sel || l_temp1 || ' GROUP BY ffrt.recipient_name ';
1043: l_stage := 3;
1044: l_out := v_fct1_rcpt_sel;
1045: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
1046: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
1047: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
1048: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
1049: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);
1050: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel, 'GROUP BY ffrt.recipient_name', 'AND ffrt.recipient_name = :cv_recipient_name');

Line 1047: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);

1043: l_stage := 3;
1044: l_out := v_fct1_rcpt_sel;
1045: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
1046: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
1047: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
1048: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
1049: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);
1050: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel, 'GROUP BY ffrt.recipient_name', 'AND ffrt.recipient_name = :cv_recipient_name');
1051: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel2, ', ffrt.recipient_name', ', 1');

Line 1048: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);

1044: l_out := v_fct1_rcpt_sel;
1045: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
1046: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
1047: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
1048: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
1049: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);
1050: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel, 'GROUP BY ffrt.recipient_name', 'AND ffrt.recipient_name = :cv_recipient_name');
1051: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel2, ', ffrt.recipient_name', ', 1');
1052: l_stage := 4;

Line 1049: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);

1045: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
1046: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
1047: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
1048: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
1049: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);
1050: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel, 'GROUP BY ffrt.recipient_name', 'AND ffrt.recipient_name = :cv_recipient_name');
1051: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel2, ', ffrt.recipient_name', ', 1');
1052: l_stage := 4;
1053: l_out := v_fct1_rcpt_sel2;

Line 1054: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;

1050: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel, 'GROUP BY ffrt.recipient_name', 'AND ffrt.recipient_name = :cv_recipient_name');
1051: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel2, ', ffrt.recipient_name', ', 1');
1052: l_stage := 4;
1053: l_out := v_fct1_rcpt_sel2;
1054: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
1055: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
1056: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
1057: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
1058: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);

Line 1055: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);

1051: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel2, ', ffrt.recipient_name', ', 1');
1052: l_stage := 4;
1053: l_out := v_fct1_rcpt_sel2;
1054: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
1055: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
1056: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
1057: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
1058: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
1059: l_stage := 5;

Line 1056: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);

1052: l_stage := 4;
1053: l_out := v_fct1_rcpt_sel2;
1054: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
1055: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
1056: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
1057: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
1058: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
1059: l_stage := 5;
1060: l_out := v_fct1_sel;

Line 1057: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);

1053: l_out := v_fct1_rcpt_sel2;
1054: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
1055: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
1056: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
1057: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
1058: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
1059: l_stage := 5;
1060: l_out := v_fct1_sel;
1061: v_fct1_sel_curid := dbms_sql.open_cursor;

Line 1058: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);

1054: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
1055: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
1056: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
1057: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
1058: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
1059: l_stage := 5;
1060: l_out := v_fct1_sel;
1061: v_fct1_sel_curid := dbms_sql.open_cursor;
1062: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);

Line 1061: v_fct1_sel_curid := dbms_sql.open_cursor;

1057: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
1058: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
1059: l_stage := 5;
1060: l_out := v_fct1_sel;
1061: v_fct1_sel_curid := dbms_sql.open_cursor;
1062: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);
1063: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);
1064: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);
1065: v_glbal_select :=

Line 1062: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);

1058: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
1059: l_stage := 5;
1060: l_out := v_fct1_sel;
1061: v_fct1_sel_curid := dbms_sql.open_cursor;
1062: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);
1063: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);
1064: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);
1065: v_glbal_select :=
1066: ' SELECT /*+ USE_HASH (glbal) */

Line 1063: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);

1059: l_stage := 5;
1060: l_out := v_fct1_sel;
1061: v_fct1_sel_curid := dbms_sql.open_cursor;
1062: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);
1063: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);
1064: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);
1065: v_glbal_select :=
1066: ' SELECT /*+ USE_HASH (glbal) */
1067: NVL(DECODE(:cv_balance_type,

Line 1064: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);

1060: l_out := v_fct1_sel;
1061: v_fct1_sel_curid := dbms_sql.open_cursor;
1062: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);
1063: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);
1064: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);
1065: v_glbal_select :=
1066: ' SELECT /*+ USE_HASH (glbal) */
1067: NVL(DECODE(:cv_balance_type,
1068: ''B'', ROUND(NVL(SUM(NVL(glbal.begin_balance_dr,0) -

Line 1104: v_sbr_curid := dbms_sql.open_cursor;

1100: and (trunc(fund_cancel_date) > :cv_end_date or fund_cancel_date is null))
1101: OR (nvl(dets.fund_status,''B'') = ''B'' ))) ';
1102: l_stage := 6;
1103: l_out := v_glbal_select;
1104: v_sbr_curid := dbms_sql.open_cursor;
1105: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
1106: dbms_sql.define_column(v_sbr_curid, 1, v_amount);
1107: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
1108: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);

Line 1105: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);

1101: OR (nvl(dets.fund_status,''B'') = ''B'' ))) ';
1102: l_stage := 6;
1103: l_out := v_glbal_select;
1104: v_sbr_curid := dbms_sql.open_cursor;
1105: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
1106: dbms_sql.define_column(v_sbr_curid, 1, v_amount);
1107: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
1108: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
1109: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);

Line 1106: dbms_sql.define_column(v_sbr_curid, 1, v_amount);

1102: l_stage := 6;
1103: l_out := v_glbal_select;
1104: v_sbr_curid := dbms_sql.open_cursor;
1105: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
1106: dbms_sql.define_column(v_sbr_curid, 1, v_amount);
1107: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
1108: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
1109: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);
1110: EXCEPTION

Line 1107: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);

1103: l_out := v_glbal_select;
1104: v_sbr_curid := dbms_sql.open_cursor;
1105: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
1106: dbms_sql.define_column(v_sbr_curid, 1, v_amount);
1107: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
1108: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
1109: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);
1110: EXCEPTION
1111: WHEN OTHERS THEN

Line 1108: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);

1104: v_sbr_curid := dbms_sql.open_cursor;
1105: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
1106: dbms_sql.define_column(v_sbr_curid, 1, v_amount);
1107: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
1108: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
1109: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);
1110: EXCEPTION
1111: WHEN OTHERS THEN
1112: v_retcode := SQLCODE ;

Line 1109: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);

1105: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
1106: dbms_sql.define_column(v_sbr_curid, 1, v_amount);
1107: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
1108: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
1109: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);
1110: EXCEPTION
1111: WHEN OTHERS THEN
1112: v_retcode := SQLCODE ;
1113: v_errbuf := SQLERRM || ' [BUILD_DYNAMIC_QUERY] ' ;

Line 1160: -- $$$dbms_sql.bind_variable(v_cursor_id1,':cv_line_id',v_line_id);

1156: v_col_6_amt := 0;
1157: v_col_7_amt := 0;
1158: v_col_8_amt := 0;
1159: IF lines_rec.line_type IN ('D', 'D2') THEN
1160: -- $$$dbms_sql.bind_variable(v_cursor_id1,':cv_line_id',v_line_id);
1161: SELECT COUNT(*)
1162: INTO l_line_cnt
1163: FROM fv_cfs_rep_line_dtl
1164: WHERE line_id = v_line_id;

Line 1188: -- $$$dbms_sql.bind_variable(v_cursor_id1,':cv_line_id',v_line_id);

1184: v_errbuf := 'SEED Data not properly Loaded. Please Verify and reinvoke the Process.';
1185: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',v_errbuf);
1186: RETURN;
1187: END IF;
1188: -- $$$dbms_sql.bind_variable(v_cursor_id1,':cv_line_id',v_line_id);
1189: process_total_line;
1190: istotal_cal:=1;
1191: populate_temp_table;
1192: istotal_cal :=0;

Line 1508: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_id',v_line_id);

1504: fnd_file.put_line(fnd_file.log, 'Warning: Accounting Flexfield - '||l_conc_segs||' needs further definition.');
1505: v_retcode := 1;
1506: ELSE --- 1
1507: IF v_by_recipient = 'Y' THEN --- 2
1508: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_id',v_line_id);
1509: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1510: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);
1511: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1512: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);

Line 1509: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);

1505: v_retcode := 1;
1506: ELSE --- 1
1507: IF v_by_recipient = 'Y' THEN --- 2
1508: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_id',v_line_id);
1509: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1510: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);
1511: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1512: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1513: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);

Line 1510: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);

1506: ELSE --- 1
1507: IF v_by_recipient = 'Y' THEN --- 2
1508: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_id',v_line_id);
1509: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1510: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);
1511: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1512: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1513: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1514: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);

Line 1511: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);

1507: IF v_by_recipient = 'Y' THEN --- 2
1508: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_id',v_line_id);
1509: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1510: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);
1511: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1512: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1513: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1514: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1515: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);

Line 1512: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);

1508: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_id',v_line_id);
1509: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1510: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);
1511: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1512: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1513: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1514: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1515: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1516: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);

Line 1513: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);

1509: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1510: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);
1511: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1512: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1513: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1514: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1515: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1516: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);
1517: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);

Line 1514: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);

1510: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);
1511: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1512: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1513: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1514: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1515: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1516: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);
1517: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1518: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_num', v_end_period);

Line 1515: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);

1511: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1512: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1513: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1514: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1515: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1516: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);
1517: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1518: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_num', v_end_period);
1519: LOOP

Line 1516: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);

1512: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1513: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1514: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1515: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1516: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);
1517: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1518: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_num', v_end_period);
1519: LOOP
1520: l_ignore := dbms_sql.fetch_rows(v_fct1_rcpt_sel_curid);

Line 1517: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);

1513: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1514: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1515: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1516: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);
1517: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1518: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_num', v_end_period);
1519: LOOP
1520: l_ignore := dbms_sql.fetch_rows(v_fct1_rcpt_sel_curid);
1521: EXIT

Line 1518: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_num', v_end_period);

1514: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1515: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1516: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);
1517: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1518: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_num', v_end_period);
1519: LOOP
1520: l_ignore := dbms_sql.fetch_rows(v_fct1_rcpt_sel_curid);
1521: EXIT
1522: WHEN l_ignore= 0;

Line 1520: l_ignore := dbms_sql.fetch_rows(v_fct1_rcpt_sel_curid);

1516: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);
1517: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1518: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_num', v_end_period);
1519: LOOP
1520: l_ignore := dbms_sql.fetch_rows(v_fct1_rcpt_sel_curid);
1521: EXIT
1522: WHEN l_ignore= 0;
1523: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 1, v_amount);
1524: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 2, v_recipient_name);

Line 1523: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 1, v_amount);

1519: LOOP
1520: l_ignore := dbms_sql.fetch_rows(v_fct1_rcpt_sel_curid);
1521: EXIT
1522: WHEN l_ignore= 0;
1523: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 1, v_amount);
1524: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 2, v_recipient_name);
1525: v_col_1_amt := NVL(v_amount, 0);
1526: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);
1527: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);

Line 1524: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 2, v_recipient_name);

1520: l_ignore := dbms_sql.fetch_rows(v_fct1_rcpt_sel_curid);
1521: EXIT
1522: WHEN l_ignore= 0;
1523: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 1, v_amount);
1524: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 2, v_recipient_name);
1525: v_col_1_amt := NVL(v_amount, 0);
1526: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);
1527: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);
1528: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);

Line 1528: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);

1524: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 2, v_recipient_name);
1525: v_col_1_amt := NVL(v_amount, 0);
1526: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);
1527: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);
1528: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);
1529: l_ignore := dbms_sql.execute_and_fetch(v_fct1_rcpt_sel2_curid);
1530: dbms_sql.column_value(v_fct1_rcpt_sel2_curid, 1, v_amount);
1531: v_col_2_amt := NVL(v_amount, 0);
1532: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient group by amount: '||v_amount);

Line 1529: l_ignore := dbms_sql.execute_and_fetch(v_fct1_rcpt_sel2_curid);

1525: v_col_1_amt := NVL(v_amount, 0);
1526: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);
1527: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);
1528: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);
1529: l_ignore := dbms_sql.execute_and_fetch(v_fct1_rcpt_sel2_curid);
1530: dbms_sql.column_value(v_fct1_rcpt_sel2_curid, 1, v_amount);
1531: v_col_2_amt := NVL(v_amount, 0);
1532: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient group by amount: '||v_amount);
1533: l_found := FALSE;

Line 1530: dbms_sql.column_value(v_fct1_rcpt_sel2_curid, 1, v_amount);

1526: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);
1527: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);
1528: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);
1529: l_ignore := dbms_sql.execute_and_fetch(v_fct1_rcpt_sel2_curid);
1530: dbms_sql.column_value(v_fct1_rcpt_sel2_curid, 1, v_amount);
1531: v_col_2_amt := NVL(v_amount, 0);
1532: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient group by amount: '||v_amount);
1533: l_found := FALSE;
1534: FOR i IN 1..l_recipient_cnt - 1

Line 1585: dbms_sql.bind_variable(v_glbal_curid,':cv_line_id',v_line_id);

1581: v_cy_gl_beg_bal := 0;
1582: v_cy_gl_end_bal := 0;
1583: -- Get beginning balances for current and prior years from
1584: -- facts1 attributes.
1585: dbms_sql.bind_variable(v_glbal_curid,':cv_line_id',v_line_id);
1586: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1587: -- Get prior year beginning balance
1588: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1589: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');

Line 1586: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.line_detail_id);

1582: v_cy_gl_end_bal := 0;
1583: -- Get beginning balances for current and prior years from
1584: -- facts1 attributes.
1585: dbms_sql.bind_variable(v_glbal_curid,':cv_line_id',v_line_id);
1586: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1587: -- Get prior year beginning balance
1588: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1589: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1590: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);

Line 1588: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);

1584: -- facts1 attributes.
1585: dbms_sql.bind_variable(v_glbal_curid,':cv_line_id',v_line_id);
1586: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1587: -- Get prior year beginning balance
1588: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1589: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1590: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
1591: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1592: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);

Line 1589: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');

1585: dbms_sql.bind_variable(v_glbal_curid,':cv_line_id',v_line_id);
1586: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1587: -- Get prior year beginning balance
1588: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1589: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1590: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
1591: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1592: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
1593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);

Line 1590: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);

1586: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1587: -- Get prior year beginning balance
1588: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1589: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1590: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
1591: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1592: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
1593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
1594: -- Get current year beginning balance

Line 1591: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);

1587: -- Get prior year beginning balance
1588: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1589: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1590: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
1591: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1592: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
1593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
1594: -- Get current year beginning balance
1595: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);

Line 1592: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);

1588: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1589: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1590: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
1591: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1592: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
1593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
1594: -- Get current year beginning balance
1595: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1596: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);

Line 1595: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);

1591: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1592: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
1593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
1594: -- Get current year beginning balance
1595: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1596: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);
1597: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1598: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1599: dbms_sql.column_value(v_glbal_curid, 1, v_cy_gl_beg_bal);

Line 1596: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);

1592: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
1593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
1594: -- Get current year beginning balance
1595: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1596: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);
1597: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1598: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1599: dbms_sql.column_value(v_glbal_curid, 1, v_cy_gl_beg_bal);
1600: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin gl bal: '||v_cy_gl_beg_bal);

Line 1597: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');

1593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
1594: -- Get current year beginning balance
1595: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1596: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);
1597: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1598: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1599: dbms_sql.column_value(v_glbal_curid, 1, v_cy_gl_beg_bal);
1600: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin gl bal: '||v_cy_gl_beg_bal);
1601: -- ===================================================================

Line 1598: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);

1594: -- Get current year beginning balance
1595: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1596: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);
1597: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1598: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1599: dbms_sql.column_value(v_glbal_curid, 1, v_cy_gl_beg_bal);
1600: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin gl bal: '||v_cy_gl_beg_bal);
1601: -- ===================================================================
1602: IF v_report_type <> 'sbr' AND l_account_type NOT IN ('D','C') THEN --- 3

Line 1599: dbms_sql.column_value(v_glbal_curid, 1, v_cy_gl_beg_bal);

1595: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1596: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);
1597: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1598: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1599: dbms_sql.column_value(v_glbal_curid, 1, v_cy_gl_beg_bal);
1600: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin gl bal: '||v_cy_gl_beg_bal);
1601: -- ===================================================================
1602: IF v_report_type <> 'sbr' AND l_account_type NOT IN ('D','C') THEN --- 3
1603: v_py_fct1_begbal := 0;

Line 1633: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);

1629: END IF;
1630: END IF;
1631: -- Get facts1 ending balance for prior year
1632: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1633: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1634: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1635: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1636: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1637: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);

Line 1634: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);

1630: END IF;
1631: -- Get facts1 ending balance for prior year
1632: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1633: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1634: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1635: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1636: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1637: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1638: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);

Line 1635: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);

1631: -- Get facts1 ending balance for prior year
1632: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1633: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1634: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1635: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1636: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1637: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1638: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1639: dbms_sql.column_value(v_fct1_sel_curid, 1, v_py_fct1_endbal);

Line 1636: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');

1632: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1633: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1634: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1635: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1636: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1637: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1638: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1639: dbms_sql.column_value(v_fct1_sel_curid, 1, v_py_fct1_endbal);
1640: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end facts1 bal: '||v_py_fct1_endbal);

Line 1637: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);

1633: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1634: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1635: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1636: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1637: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1638: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1639: dbms_sql.column_value(v_fct1_sel_curid, 1, v_py_fct1_endbal);
1640: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end facts1 bal: '||v_py_fct1_endbal);
1641: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_py_gl_beg_bal,0), NVL(v_py_fct1_endbal,0));

Line 1638: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);

1634: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1635: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1636: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1637: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1638: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1639: dbms_sql.column_value(v_fct1_sel_curid, 1, v_py_fct1_endbal);
1640: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end facts1 bal: '||v_py_fct1_endbal);
1641: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_py_gl_beg_bal,0), NVL(v_py_fct1_endbal,0));
1642: END IF;

Line 1639: dbms_sql.column_value(v_fct1_sel_curid, 1, v_py_fct1_endbal);

1635: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1636: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1637: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1638: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1639: dbms_sql.column_value(v_fct1_sel_curid, 1, v_py_fct1_endbal);
1640: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end facts1 bal: '||v_py_fct1_endbal);
1641: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_py_gl_beg_bal,0), NVL(v_py_fct1_endbal,0));
1642: END IF;
1643: -- Set prior year amounts for reporting

Line 1679: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);

1675: END IF;
1676: END IF;
1677: -- Get facts1 ending balance for current year
1678: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1679: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1680: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1681: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1682: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1683: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);

Line 1680: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);

1676: END IF;
1677: -- Get facts1 ending balance for current year
1678: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1679: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1680: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1681: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1682: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1683: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1684: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);

Line 1681: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);

1677: -- Get facts1 ending balance for current year
1678: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1679: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1680: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1681: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1682: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1683: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1684: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1685: dbms_sql.column_value(v_fct1_sel_curid, 1, v_cy_fct1_endbal);

Line 1682: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');

1678: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1679: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1680: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1681: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1682: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1683: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1684: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1685: dbms_sql.column_value(v_fct1_sel_curid, 1, v_cy_fct1_endbal);
1686: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end facsts1 bal: '||v_cy_fct1_endbal);

Line 1683: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);

1679: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1680: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1681: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1682: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1683: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1684: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1685: dbms_sql.column_value(v_fct1_sel_curid, 1, v_cy_fct1_endbal);
1686: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end facsts1 bal: '||v_cy_fct1_endbal);
1687: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_cy_gl_beg_bal,0), NVL(v_cy_fct1_endbal,0));

Line 1684: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);

1680: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1681: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1682: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1683: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1684: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1685: dbms_sql.column_value(v_fct1_sel_curid, 1, v_cy_fct1_endbal);
1686: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end facsts1 bal: '||v_cy_fct1_endbal);
1687: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_cy_gl_beg_bal,0), NVL(v_cy_fct1_endbal,0));
1688: END IF;

Line 1685: dbms_sql.column_value(v_fct1_sel_curid, 1, v_cy_fct1_endbal);

1681: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1682: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1683: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1684: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1685: dbms_sql.column_value(v_fct1_sel_curid, 1, v_cy_fct1_endbal);
1686: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end facsts1 bal: '||v_cy_fct1_endbal);
1687: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_cy_gl_beg_bal,0), NVL(v_cy_fct1_endbal,0));
1688: END IF;
1689: -- Set current year amounts for reporting

Line 1711: dbms_sql.bind_variable(v_sbr_curid,':cv_line_id',v_line_id);

1707: v_cy_sbr_beg_bal := 0;
1708: v_cy_sbr_end_bal := 0;
1709: v_py_sbr_beg_bal := 0;
1710: v_py_sbr_end_bal := 0;
1711: dbms_sql.bind_variable(v_sbr_curid,':cv_line_id',v_line_id);
1712: dbms_sql.bind_variable(v_sbr_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1713: -- Get Current Year balances --
1714: -------------------------------
1715: IF detail_rec.balance_type = 'B' THEN

Line 1712: dbms_sql.bind_variable(v_sbr_curid,':cv_line_detail_id',detail_rec.line_detail_id);

1708: v_cy_sbr_end_bal := 0;
1709: v_py_sbr_beg_bal := 0;
1710: v_py_sbr_end_bal := 0;
1711: dbms_sql.bind_variable(v_sbr_curid,':cv_line_id',v_line_id);
1712: dbms_sql.bind_variable(v_sbr_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1713: -- Get Current Year balances --
1714: -------------------------------
1715: IF detail_rec.balance_type = 'B' THEN
1716: -- IF balance type is begin

Line 1717: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');

1713: -- Get Current Year balances --
1714: -------------------------------
1715: IF detail_rec.balance_type = 'B' THEN
1716: -- IF balance type is begin
1717: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1718: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1719: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1720: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1721: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

Line 1718: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);

1714: -------------------------------
1715: IF detail_rec.balance_type = 'B' THEN
1716: -- IF balance type is begin
1717: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1718: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1719: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1720: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1721: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1722: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);

Line 1719: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);

1715: IF detail_rec.balance_type = 'B' THEN
1716: -- IF balance type is begin
1717: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1718: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1719: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1720: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1721: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1722: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1723: v_amount := v_cy_sbr_beg_bal;

Line 1720: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);

1716: -- IF balance type is begin
1717: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1718: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1719: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1720: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1721: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1722: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1723: v_amount := v_cy_sbr_beg_bal;
1724: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_sbr_beg_bal);

Line 1721: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

1717: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1718: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1719: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1720: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1721: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1722: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1723: v_amount := v_cy_sbr_beg_bal;
1724: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_sbr_beg_bal);
1725: ELSIF detail_rec.balance_type IN ('C','D','E','G','I','J') THEN

Line 1722: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);

1718: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1719: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1720: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1721: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1722: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1723: v_amount := v_cy_sbr_beg_bal;
1724: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_sbr_beg_bal);
1725: ELSIF detail_rec.balance_type IN ('C','D','E','G','I','J') THEN
1726: -- IF balance type is ending, ending cr only or ending dr only

Line 1728: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');

1724: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_sbr_beg_bal);
1725: ELSIF detail_rec.balance_type IN ('C','D','E','G','I','J') THEN
1726: -- IF balance type is ending, ending cr only or ending dr only
1727: -- Get the begin balance
1728: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1729: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1730: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1731: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1732: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

Line 1729: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);

1725: ELSIF detail_rec.balance_type IN ('C','D','E','G','I','J') THEN
1726: -- IF balance type is ending, ending cr only or ending dr only
1727: -- Get the begin balance
1728: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1729: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1730: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1731: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1732: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1733: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);

Line 1730: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);

1726: -- IF balance type is ending, ending cr only or ending dr only
1727: -- Get the begin balance
1728: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1729: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1730: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1731: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1732: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1733: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1734: -- Get the end balance

Line 1731: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);

1727: -- Get the begin balance
1728: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1729: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1730: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1731: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1732: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1733: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1734: -- Get the end balance
1735: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');

Line 1732: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

1728: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1729: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1730: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1731: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1732: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1733: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1734: -- Get the end balance
1735: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1736: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);

Line 1733: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);

1729: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1730: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1731: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1732: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1733: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1734: -- Get the end balance
1735: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1736: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1737: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);

Line 1735: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');

1731: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1732: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1733: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1734: -- Get the end balance
1735: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1736: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1737: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1738: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1739: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

Line 1736: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);

1732: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1733: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1734: -- Get the end balance
1735: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1736: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1737: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1738: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1739: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1740: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_end_bal);

Line 1737: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);

1733: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1734: -- Get the end balance
1735: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1736: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1737: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1738: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1739: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1740: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_end_bal);
1741: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end bal: '||v_cy_sbr_end_bal);

Line 1738: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);

1734: -- Get the end balance
1735: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1736: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1737: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1738: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1739: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1740: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_end_bal);
1741: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end bal: '||v_cy_sbr_end_bal);
1742: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_cy_sbr_beg_bal,0), NVL(v_cy_sbr_end_bal,0));

Line 1739: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

1735: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1736: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1737: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1738: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1739: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1740: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_end_bal);
1741: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end bal: '||v_cy_sbr_end_bal);
1742: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_cy_sbr_beg_bal,0), NVL(v_cy_sbr_end_bal,0));
1743: END IF;

Line 1740: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_end_bal);

1736: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1737: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1738: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1739: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1740: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_end_bal);
1741: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end bal: '||v_cy_sbr_end_bal);
1742: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_cy_sbr_beg_bal,0), NVL(v_cy_sbr_end_bal,0));
1743: END IF;
1744: -- Set current year amounts for reporting

Line 1762: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');

1758: ---- Get Prior year balances ----
1759: ---------------------------------
1760: IF detail_rec.balance_type = 'B' THEN
1761: -- If balance type is begin
1762: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1763: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1764: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1765: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1766: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

Line 1763: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);

1759: ---------------------------------
1760: IF detail_rec.balance_type = 'B' THEN
1761: -- If balance type is begin
1762: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1763: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1764: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1765: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1766: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1767: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);

Line 1764: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);

1760: IF detail_rec.balance_type = 'B' THEN
1761: -- If balance type is begin
1762: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1763: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1764: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1765: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1766: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1767: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1768: v_amount := v_py_sbr_beg_bal;

Line 1765: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);

1761: -- If balance type is begin
1762: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1763: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1764: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1765: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1766: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1767: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1768: v_amount := v_py_sbr_beg_bal;
1769: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_sbr_beg_bal);

Line 1766: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

1762: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1763: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1764: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1765: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1766: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1767: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1768: v_amount := v_py_sbr_beg_bal;
1769: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_sbr_beg_bal);
1770: -- IF balance type is ending, ending cr only or ending dr only

Line 1767: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);

1763: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1764: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1765: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1766: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1767: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1768: v_amount := v_py_sbr_beg_bal;
1769: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_sbr_beg_bal);
1770: -- IF balance type is ending, ending cr only or ending dr only
1771: ELSIF detail_rec.balance_type IN ('C', 'D','E','G','I','J') THEN

Line 1773: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');

1769: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_sbr_beg_bal);
1770: -- IF balance type is ending, ending cr only or ending dr only
1771: ELSIF detail_rec.balance_type IN ('C', 'D','E','G','I','J') THEN
1772: -- Get the begin balance
1773: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1774: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1775: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1776: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1777: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

Line 1774: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);

1770: -- IF balance type is ending, ending cr only or ending dr only
1771: ELSIF detail_rec.balance_type IN ('C', 'D','E','G','I','J') THEN
1772: -- Get the begin balance
1773: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1774: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1775: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1776: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1777: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1778: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);

Line 1775: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);

1771: ELSIF detail_rec.balance_type IN ('C', 'D','E','G','I','J') THEN
1772: -- Get the begin balance
1773: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1774: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1775: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1776: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1777: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1778: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1779: -- Get the end balance

Line 1776: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);

1772: -- Get the begin balance
1773: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1774: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1775: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1776: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1777: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1778: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1779: -- Get the end balance
1780: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');

Line 1777: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

1773: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1774: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1775: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1776: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1777: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1778: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1779: -- Get the end balance
1780: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1781: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);

Line 1778: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);

1774: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1775: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1776: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1777: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1778: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1779: -- Get the end balance
1780: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1781: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1782: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);

Line 1780: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');

1776: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1777: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1778: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1779: -- Get the end balance
1780: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1781: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1782: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1783: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1784: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

Line 1781: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);

1777: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1778: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1779: -- Get the end balance
1780: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1781: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1782: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1783: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1784: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1785: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);

Line 1782: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);

1778: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1779: -- Get the end balance
1780: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1781: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1782: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1783: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1784: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1785: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
1786: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);

Line 1783: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);

1779: -- Get the end balance
1780: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1781: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1782: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1783: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1784: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1785: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
1786: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);
1787: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_py_sbr_beg_bal,0), NVL(v_py_sbr_end_bal,0));

Line 1784: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

1780: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1781: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1782: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1783: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1784: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1785: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
1786: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);
1787: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_py_sbr_beg_bal,0), NVL(v_py_sbr_end_bal,0));
1788: END IF;

Line 1785: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);

1781: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1782: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1783: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1784: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1785: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
1786: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);
1787: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_py_sbr_beg_bal,0), NVL(v_py_sbr_end_bal,0));
1788: END IF;
1789: l_log_mesg := ', ' || NVL(v_amount, 0);

Line 3160: v_cursor_id := dbms_sql.open_cursor;

3156:
3157: END IF;
3158: /*Executing the query_fetch_bud dynamic query to get the sum of amounts that has to be displayed under bud_col*/
3159: IF (query_fetch_bal_bud IS NOT NULL) THEN
3160: v_cursor_id := dbms_sql.open_cursor;
3161: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3162: -- print query
3163: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3164: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);

Line 3164: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);

3160: v_cursor_id := dbms_sql.open_cursor;
3161: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3162: -- print query
3163: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3164: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3165: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3166: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3167: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3168: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);

Line 3165: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);

3161: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3162: -- print query
3163: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3164: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3165: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3166: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3167: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3168: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3169: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);

Line 3166: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);

3162: -- print query
3163: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3164: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3165: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3166: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3167: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3168: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3169: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3170: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);

Line 3167: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);

3163: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3164: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3165: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3166: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3167: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3168: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3169: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3170: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3171: --print bind variables

Line 3168: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);

3164: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3165: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3166: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3167: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3168: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3169: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3170: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3171: --print bind variables
3172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);

Line 3169: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);

3165: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3166: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3167: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3168: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3169: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3170: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3171: --print bind variables
3172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);

Line 3170: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);

3166: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3167: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3168: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3169: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3170: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3171: --print bind variables
3172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);

Line 3176: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

3172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3176: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3177: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3178: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3179: END IF;
3180: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

Line 3180: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

3176: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3177: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3178: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3179: END IF;
3180: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3181: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3182: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3183: dbms_sql.close_cursor(v_cursor_id);
3184:

Line 3181: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);

3177: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3178: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3179: END IF;
3180: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3181: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3182: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3183: dbms_sql.close_cursor(v_cursor_id);
3184:
3185: v_bud_col:=nvl(v_bud_col,'Y');

Line 3182: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);

3178: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3179: END IF;
3180: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3181: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3182: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3183: dbms_sql.close_cursor(v_cursor_id);
3184:
3185: v_bud_col:=nvl(v_bud_col,'Y');
3186: v_nbfa_col:=nvl(v_nbfa_col,'N');

Line 3183: dbms_sql.close_cursor(v_cursor_id);

3179: END IF;
3180: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3181: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3182: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3183: dbms_sql.close_cursor(v_cursor_id);
3184:
3185: v_bud_col:=nvl(v_bud_col,'Y');
3186: v_nbfa_col:=nvl(v_nbfa_col,'N');
3187: IF UPPER(v_nbfa_col) ='Y' THEN

Line 3214: v_cursor_id := dbms_sql.open_cursor;

3210: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols
3211: where set_of_books_id='||v_sob||' AND treasury_symbol_id='||get_ts_id_rec.treasury_symbol_id||')
3212: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''';
3213:
3214: v_cursor_id := dbms_sql.open_cursor;
3215: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3216: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3217: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3218: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);

Line 3216: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);

3212: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''';
3213:
3214: v_cursor_id := dbms_sql.open_cursor;
3215: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3216: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3217: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3218: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3219: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3220: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);

Line 3217: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);

3213:
3214: v_cursor_id := dbms_sql.open_cursor;
3215: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3216: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3217: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3218: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3219: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3220: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3221: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);

Line 3218: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);

3214: v_cursor_id := dbms_sql.open_cursor;
3215: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3216: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3217: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3218: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3219: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3220: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3221: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3222: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);

Line 3219: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);

3215: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3216: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3217: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3218: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3219: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3220: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3221: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3222: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3223: -- print query

Line 3220: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);

3216: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3217: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3218: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3219: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3220: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3221: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3222: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3223: -- print query
3224: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);

Line 3221: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);

3217: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3218: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3219: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3220: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3221: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3222: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3223: -- print query
3224: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3225: --print bind variables

Line 3222: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);

3218: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3219: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3220: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3221: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3222: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3223: -- print query
3224: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3225: --print bind variables
3226: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);

Line 3230: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

3226: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3228: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3230: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3231: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3233: END IF;
3234: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

Line 3234: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

3230: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3231: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3233: END IF;
3234: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3235: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3236: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3237: dbms_sql.close_cursor(v_cursor_id);
3238: v_bud_col:=nvl(v_bud_col,'Y');

Line 3235: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);

3231: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3233: END IF;
3234: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3235: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3236: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3237: dbms_sql.close_cursor(v_cursor_id);
3238: v_bud_col:=nvl(v_bud_col,'Y');
3239: v_nbfa_col:=nvl(v_nbfa_col,'N');

Line 3236: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);

3232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3233: END IF;
3234: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3235: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3236: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3237: dbms_sql.close_cursor(v_cursor_id);
3238: v_bud_col:=nvl(v_bud_col,'Y');
3239: v_nbfa_col:=nvl(v_nbfa_col,'N');
3240: IF UPPER(v_nbfa_col) ='Y' THEN

Line 3237: dbms_sql.close_cursor(v_cursor_id);

3233: END IF;
3234: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3235: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3236: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3237: dbms_sql.close_cursor(v_cursor_id);
3238: v_bud_col:=nvl(v_bud_col,'Y');
3239: v_nbfa_col:=nvl(v_nbfa_col,'N');
3240: IF UPPER(v_nbfa_col) ='Y' THEN
3241: c_total_balance_nbfa:=c_total_balance_nbfa+c_total_balance;

Line 3264: v_cursor_id := dbms_sql.open_cursor;

3260: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols
3261: where set_of_books_id='||v_sob||' AND treasury_symbol_id='||get_ts_id_rec.treasury_symbol_id||')
3262: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''';
3263:
3264: v_cursor_id := dbms_sql.open_cursor;
3265: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause ||' '||group_by_clause;
3266: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3267: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3268: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);

Line 3266: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);

3262: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''';
3263:
3264: v_cursor_id := dbms_sql.open_cursor;
3265: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause ||' '||group_by_clause;
3266: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3267: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3268: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3269: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3270: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);

Line 3267: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);

3263:
3264: v_cursor_id := dbms_sql.open_cursor;
3265: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause ||' '||group_by_clause;
3266: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3267: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3268: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3269: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3270: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3271: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);

Line 3268: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);

3264: v_cursor_id := dbms_sql.open_cursor;
3265: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause ||' '||group_by_clause;
3266: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3267: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3268: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3269: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3270: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3271: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3272: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);

Line 3269: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);

3265: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause ||' '||group_by_clause;
3266: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3267: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3268: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3269: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3270: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3271: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3272: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3273: -- print query

Line 3270: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);

3266: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3267: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3268: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3269: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3270: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3271: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3272: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3273: -- print query
3274: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);

Line 3271: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);

3267: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3268: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3269: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3270: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3271: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3272: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3273: -- print query
3274: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3275: --print bind variables

Line 3272: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);

3268: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3269: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3270: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3271: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3272: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3273: -- print query
3274: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3275: --print bind variables
3276: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);

Line 3280: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

3276: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3278: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3279: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3280: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3281: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3282: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3283: END IF;
3284: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

Line 3284: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

3280: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3281: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3282: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3283: END IF;
3284: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3285: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3286: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3287: dbms_sql.close_cursor(v_cursor_id);
3288: v_bud_col:=nvl(v_bud_col,'Y');

Line 3285: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);

3281: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3282: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3283: END IF;
3284: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3285: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3286: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3287: dbms_sql.close_cursor(v_cursor_id);
3288: v_bud_col:=nvl(v_bud_col,'Y');
3289: v_nbfa_col:=nvl(v_nbfa_col,'N');

Line 3286: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);

3282: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3283: END IF;
3284: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3285: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3286: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3287: dbms_sql.close_cursor(v_cursor_id);
3288: v_bud_col:=nvl(v_bud_col,'Y');
3289: v_nbfa_col:=nvl(v_nbfa_col,'N');
3290: IF UPPER(v_nbfa_col) ='Y' THEN

Line 3287: dbms_sql.close_cursor(v_cursor_id);

3283: END IF;
3284: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3285: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3286: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3287: dbms_sql.close_cursor(v_cursor_id);
3288: v_bud_col:=nvl(v_bud_col,'Y');
3289: v_nbfa_col:=nvl(v_nbfa_col,'N');
3290: IF UPPER(v_nbfa_col) ='Y' THEN
3291: c_total_balance_nbfa:=c_total_balance_nbfa+c_total_balance;

Line 3315: v_cursor_id := dbms_sql.open_cursor;

3311: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''
3312: AND begin_end = ''E''';
3313:
3314: IF (query_fetch_bal_bud IS NOT NULL) THEN
3315: v_cursor_id := dbms_sql.open_cursor;
3316: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3317: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3318: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3319: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);

Line 3317: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);

3313:
3314: IF (query_fetch_bal_bud IS NOT NULL) THEN
3315: v_cursor_id := dbms_sql.open_cursor;
3316: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3317: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3318: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3319: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3320: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3321: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);

Line 3318: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);

3314: IF (query_fetch_bal_bud IS NOT NULL) THEN
3315: v_cursor_id := dbms_sql.open_cursor;
3316: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3317: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3318: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3319: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3320: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3321: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3322: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);

Line 3319: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);

3315: v_cursor_id := dbms_sql.open_cursor;
3316: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3317: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3318: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3319: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3320: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3321: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3322: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3323: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);

Line 3320: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);

3316: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3317: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3318: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3319: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3320: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3321: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3322: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3323: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3324: -- print query

Line 3321: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);

3317: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3318: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3319: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3320: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3321: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3322: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3323: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3324: -- print query
3325: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);

Line 3322: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);

3318: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3319: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3320: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3321: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3322: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3323: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3324: -- print query
3325: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3326: --print bind variables

Line 3323: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);

3319: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3320: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3321: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3322: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3323: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3324: -- print query
3325: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3326: --print bind variables
3327: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);

Line 3331: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

3327: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sbr_treasury_symbol_id);
3329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3331: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3332: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3333: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3334: END IF;
3335: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

Line 3335: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

3331: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3332: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3333: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3334: END IF;
3335: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3336: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3337: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3338: dbms_sql.close_cursor(v_cursor_id);
3339: v_bud_col:=nvl(v_bud_col,'Y');

Line 3336: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);

3332: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3333: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3334: END IF;
3335: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3336: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3337: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3338: dbms_sql.close_cursor(v_cursor_id);
3339: v_bud_col:=nvl(v_bud_col,'Y');
3340: v_nbfa_col:=nvl(v_nbfa_col,'N');

Line 3337: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);

3333: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3334: END IF;
3335: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3336: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3337: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3338: dbms_sql.close_cursor(v_cursor_id);
3339: v_bud_col:=nvl(v_bud_col,'Y');
3340: v_nbfa_col:=nvl(v_nbfa_col,'N');
3341: IF ( c_sbr_balance_type = 'ED')THEN

Line 3338: dbms_sql.close_cursor(v_cursor_id);

3334: END IF;
3335: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3336: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3337: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3338: dbms_sql.close_cursor(v_cursor_id);
3339: v_bud_col:=nvl(v_bud_col,'Y');
3340: v_nbfa_col:=nvl(v_nbfa_col,'N');
3341: IF ( c_sbr_balance_type = 'ED')THEN
3342: IF (c_total_balance < 0) THEN

Line 3381: v_cursor_id := dbms_sql.open_cursor;

3377: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols
3378: where set_of_books_id='||v_sob||' AND treasury_symbol_id='||get_ts_id_rec.treasury_symbol_id||')
3379: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''';
3380:
3381: v_cursor_id := dbms_sql.open_cursor;
3382: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3383: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3384: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3385: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);

Line 3383: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);

3379: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''';
3380:
3381: v_cursor_id := dbms_sql.open_cursor;
3382: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3383: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3384: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3385: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3386: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3387: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);

Line 3384: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);

3380:
3381: v_cursor_id := dbms_sql.open_cursor;
3382: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3383: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3384: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3385: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3386: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3387: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3388: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);

Line 3385: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);

3381: v_cursor_id := dbms_sql.open_cursor;
3382: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3383: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3384: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3385: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3386: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3387: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3388: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3389: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);

Line 3386: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);

3382: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3383: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3384: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3385: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3386: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3387: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3388: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3389: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3390: -- print query

Line 3387: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);

3383: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3384: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3385: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3386: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3387: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3388: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3389: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3390: -- print query
3391: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);

Line 3388: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);

3384: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3385: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3386: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3387: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3388: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3389: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3390: -- print query
3391: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3392: --print bind variables

Line 3389: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);

3385: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3386: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);
3387: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3388: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3389: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3390: -- print query
3391: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3392: --print bind variables
3393: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);

Line 3397: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

3393: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3397: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3398:
3399:
3400: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3401: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

Line 3403: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

3399:
3400: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3401: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3402: END IF;
3403: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3404: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3405: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3406: dbms_sql.close_cursor(v_cursor_id);
3407:

Line 3404: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);

3400: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3401: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3402: END IF;
3403: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3404: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3405: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3406: dbms_sql.close_cursor(v_cursor_id);
3407:
3408:

Line 3405: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);

3401: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3402: END IF;
3403: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3404: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3405: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3406: dbms_sql.close_cursor(v_cursor_id);
3407:
3408:
3409: IF (c_sbr_balance_type = 'E-BD') THEN

Line 3406: dbms_sql.close_cursor(v_cursor_id);

3402: END IF;
3403: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3404: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3405: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);
3406: dbms_sql.close_cursor(v_cursor_id);
3407:
3408:
3409: IF (c_sbr_balance_type = 'E-BD') THEN
3410: IF (c_total_balance > 0) THEN

Line 3528: ELSIF dbms_sql.is_open(v_cursor_id) THEN

3524: g_error_code := SQLCODE;
3525: g_error_message := SQLERRM;
3526: IF balance_type_cursor%ISOPEN THEN
3527: CLOSE balance_type_cursor;
3528: ELSIF dbms_sql.is_open(v_cursor_id) THEN
3529: dbms_sql.close_cursor(v_cursor_id);
3530: END IF;
3531: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:'||G_ERROR_MESSAGE);
3532: --

Line 3529: dbms_sql.close_cursor(v_cursor_id);

3525: g_error_message := SQLERRM;
3526: IF balance_type_cursor%ISOPEN THEN
3527: CLOSE balance_type_cursor;
3528: ELSIF dbms_sql.is_open(v_cursor_id) THEN
3529: dbms_sql.close_cursor(v_cursor_id);
3530: END IF;
3531: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:'||G_ERROR_MESSAGE);
3532: --
3533: END build_fiscal_line_columns;

Line 3632: v_glbal_curid := dbms_sql.open_cursor;

3628: and (trunc(fund_cancel_date) > :cv_end_date or fund_cancel_date is null)))';
3629:
3630: l_stage := 1;
3631: l_out := v_fct1_attr_select;
3632: v_glbal_curid := dbms_sql.open_cursor;
3633: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);
3634: dbms_sql.define_column(v_glbal_curid, 1, v_amount);
3635: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);
3636:

Line 3633: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);

3629:
3630: l_stage := 1;
3631: l_out := v_fct1_attr_select;
3632: v_glbal_curid := dbms_sql.open_cursor;
3633: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);
3634: dbms_sql.define_column(v_glbal_curid, 1, v_amount);
3635: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);
3636:
3637: v_fct1_sel := 'SELECT ROUND(SUM(NVL(ffrt.amount,0) ),2) ';

Line 3634: dbms_sql.define_column(v_glbal_curid, 1, v_amount);

3630: l_stage := 1;
3631: l_out := v_fct1_attr_select;
3632: v_glbal_curid := dbms_sql.open_cursor;
3633: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);
3634: dbms_sql.define_column(v_glbal_curid, 1, v_amount);
3635: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);
3636:
3637: v_fct1_sel := 'SELECT ROUND(SUM(NVL(ffrt.amount,0) ),2) ';
3638: v_fct1_rcpt_sel := v_fct1_sel || ' , ffrt.recipient_name ';

Line 3635: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);

3631: l_out := v_fct1_attr_select;
3632: v_glbal_curid := dbms_sql.open_cursor;
3633: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);
3634: dbms_sql.define_column(v_glbal_curid, 1, v_amount);
3635: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);
3636:
3637: v_fct1_sel := 'SELECT ROUND(SUM(NVL(ffrt.amount,0) ),2) ';
3638: v_fct1_rcpt_sel := v_fct1_sel || ' , ffrt.recipient_name ';
3639: l_temp1 := '

Line 3658: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;

3654: v_fct1_rcpt_sel := v_fct1_rcpt_sel || l_temp1 || ' GROUP BY ffrt.recipient_name ';
3655: l_stage := 3;
3656: l_out := v_fct1_rcpt_sel;
3657:
3658: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
3659: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
3660: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
3661: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
3662: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);

Line 3659: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);

3655: l_stage := 3;
3656: l_out := v_fct1_rcpt_sel;
3657:
3658: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
3659: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
3660: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
3661: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
3662: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);
3663: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel, 'GROUP BY ffrt.recipient_name', 'AND ffrt.recipient_name = :cv_recipient_name');

Line 3660: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);

3656: l_out := v_fct1_rcpt_sel;
3657:
3658: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
3659: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
3660: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
3661: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
3662: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);
3663: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel, 'GROUP BY ffrt.recipient_name', 'AND ffrt.recipient_name = :cv_recipient_name');
3664: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel2, ', ffrt.recipient_name', ', 1');

Line 3661: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);

3657:
3658: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
3659: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
3660: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
3661: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
3662: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);
3663: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel, 'GROUP BY ffrt.recipient_name', 'AND ffrt.recipient_name = :cv_recipient_name');
3664: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel2, ', ffrt.recipient_name', ', 1');
3665: l_stage := 4;

Line 3662: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);

3658: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
3659: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
3660: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
3661: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
3662: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);
3663: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel, 'GROUP BY ffrt.recipient_name', 'AND ffrt.recipient_name = :cv_recipient_name');
3664: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel2, ', ffrt.recipient_name', ', 1');
3665: l_stage := 4;
3666: l_out := v_fct1_rcpt_sel2;

Line 3667: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;

3663: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel, 'GROUP BY ffrt.recipient_name', 'AND ffrt.recipient_name = :cv_recipient_name');
3664: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel2, ', ffrt.recipient_name', ', 1');
3665: l_stage := 4;
3666: l_out := v_fct1_rcpt_sel2;
3667: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
3668: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
3669: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
3670: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
3671: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);

Line 3668: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);

3664: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel2, ', ffrt.recipient_name', ', 1');
3665: l_stage := 4;
3666: l_out := v_fct1_rcpt_sel2;
3667: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
3668: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
3669: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
3670: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
3671: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
3672: l_stage := 5;

Line 3669: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);

3665: l_stage := 4;
3666: l_out := v_fct1_rcpt_sel2;
3667: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
3668: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
3669: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
3670: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
3671: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
3672: l_stage := 5;
3673: l_out := v_fct1_sel;

Line 3670: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);

3666: l_out := v_fct1_rcpt_sel2;
3667: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
3668: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
3669: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
3670: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
3671: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
3672: l_stage := 5;
3673: l_out := v_fct1_sel;
3674: v_fct1_sel_curid := dbms_sql.open_cursor;

Line 3671: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);

3667: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
3668: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
3669: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
3670: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
3671: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
3672: l_stage := 5;
3673: l_out := v_fct1_sel;
3674: v_fct1_sel_curid := dbms_sql.open_cursor;
3675: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);

Line 3674: v_fct1_sel_curid := dbms_sql.open_cursor;

3670: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
3671: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
3672: l_stage := 5;
3673: l_out := v_fct1_sel;
3674: v_fct1_sel_curid := dbms_sql.open_cursor;
3675: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);
3676: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);
3677: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);
3678: */

Line 3675: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);

3671: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
3672: l_stage := 5;
3673: l_out := v_fct1_sel;
3674: v_fct1_sel_curid := dbms_sql.open_cursor;
3675: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);
3676: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);
3677: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);
3678: */
3679:

Line 3676: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);

3672: l_stage := 5;
3673: l_out := v_fct1_sel;
3674: v_fct1_sel_curid := dbms_sql.open_cursor;
3675: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);
3676: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);
3677: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);
3678: */
3679:
3680: v_glbal_select :=

Line 3677: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);

3673: l_out := v_fct1_sel;
3674: v_fct1_sel_curid := dbms_sql.open_cursor;
3675: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);
3676: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);
3677: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);
3678: */
3679:
3680: v_glbal_select :=
3681: ' SELECT

Line 3720: v_sbr_curid := dbms_sql.open_cursor;

3716: OR ((trunc(fund_expire_date) >= :cv_end_date or fund_expire_date is null)
3717: and (trunc(fund_cancel_date) > :cv_end_date or fund_cancel_date is null)))) ';*/
3718: l_stage := 6;
3719: l_out := v_glbal_select;
3720: v_sbr_curid := dbms_sql.open_cursor;
3721: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
3722:
3723: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
3724: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);

Line 3721: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);

3717: and (trunc(fund_cancel_date) > :cv_end_date or fund_cancel_date is null)))) ';*/
3718: l_stage := 6;
3719: l_out := v_glbal_select;
3720: v_sbr_curid := dbms_sql.open_cursor;
3721: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
3722:
3723: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
3724: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
3725: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);

Line 3723: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);

3719: l_out := v_glbal_select;
3720: v_sbr_curid := dbms_sql.open_cursor;
3721: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
3722:
3723: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
3724: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
3725: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);
3726:
3727: EXCEPTION

Line 3724: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);

3720: v_sbr_curid := dbms_sql.open_cursor;
3721: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
3722:
3723: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
3724: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
3725: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);
3726:
3727: EXCEPTION
3728: WHEN OTHERS THEN

Line 3725: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);

3721: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
3722:
3723: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
3724: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
3725: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);
3726:
3727: EXCEPTION
3728: WHEN OTHERS THEN
3729: v_retcode := SQLCODE ;

Line 3861: dbms_sql.bind_variable(v_glbal_curid,':cv_line_id',v_line_id);

3857: v_cy_gl_beg_bal := 0;
3858: v_cy_gl_end_bal := 0;
3859: /* -- Get beginning balances for current and prior years from
3860: -- facts1 attributes.
3861: dbms_sql.bind_variable(v_glbal_curid,':cv_line_id',v_line_id);
3862: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.sbr_line_acct_id);
3863: -- Get prior year beginning balance
3864: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3865: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');

Line 3862: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.sbr_line_acct_id);

3858: v_cy_gl_end_bal := 0;
3859: /* -- Get beginning balances for current and prior years from
3860: -- facts1 attributes.
3861: dbms_sql.bind_variable(v_glbal_curid,':cv_line_id',v_line_id);
3862: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.sbr_line_acct_id);
3863: -- Get prior year beginning balance
3864: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3865: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
3866: --dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);

Line 3864: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',p_fiscal_year-1);

3860: -- facts1 attributes.
3861: dbms_sql.bind_variable(v_glbal_curid,':cv_line_id',v_line_id);
3862: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.sbr_line_acct_id);
3863: -- Get prior year beginning balance
3864: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3865: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
3866: --dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
3867: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
3868: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);

Line 3865: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');

3861: dbms_sql.bind_variable(v_glbal_curid,':cv_line_id',v_line_id);
3862: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.sbr_line_acct_id);
3863: -- Get prior year beginning balance
3864: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3865: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
3866: --dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
3867: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
3868: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
3869: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);

Line 3866: --dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);

3862: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.sbr_line_acct_id);
3863: -- Get prior year beginning balance
3864: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3865: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
3866: --dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
3867: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
3868: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
3869: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
3870: */

Line 3867: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);

3863: -- Get prior year beginning balance
3864: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3865: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
3866: --dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
3867: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
3868: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
3869: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
3870: */
3871: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_report_type: '||v_report_type);

Line 3868: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);

3864: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3865: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
3866: --dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
3867: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
3868: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
3869: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
3870: */
3871: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_report_type: '||v_report_type);
3872: IF UPPER(v_report_type) = 'SBR' THEN

Line 3879: dbms_sql.bind_variable(v_sbr_curid,':cv_line_id',v_line_id);

3875: v_cy_sbr_end_bal := 0;
3876: v_py_sbr_beg_bal := 0;
3877: v_py_sbr_end_bal := 0;
3878: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'bEFORE IF detail_rec.sbr_balance_type:detail_rec.acct_number-> '||detail_rec.sbr_balance_type||'::'||detail_rec.acct_number);
3879: dbms_sql.bind_variable(v_sbr_curid,':cv_line_id',v_line_id);
3880: dbms_sql.bind_variable(v_sbr_curid,':cv_line_detail_id',detail_rec.sbr_line_acct_id);
3881: --dbms_sql.bind_variable(v_sbr_curid,':cv_account_number',detail_rec.acct_number);
3882: dbms_sql.bind_variable(v_sbr_curid,':cv_acc_num',detail_rec.acct_number||'%');
3883:

Line 3880: dbms_sql.bind_variable(v_sbr_curid,':cv_line_detail_id',detail_rec.sbr_line_acct_id);

3876: v_py_sbr_beg_bal := 0;
3877: v_py_sbr_end_bal := 0;
3878: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'bEFORE IF detail_rec.sbr_balance_type:detail_rec.acct_number-> '||detail_rec.sbr_balance_type||'::'||detail_rec.acct_number);
3879: dbms_sql.bind_variable(v_sbr_curid,':cv_line_id',v_line_id);
3880: dbms_sql.bind_variable(v_sbr_curid,':cv_line_detail_id',detail_rec.sbr_line_acct_id);
3881: --dbms_sql.bind_variable(v_sbr_curid,':cv_account_number',detail_rec.acct_number);
3882: dbms_sql.bind_variable(v_sbr_curid,':cv_acc_num',detail_rec.acct_number||'%');
3883:
3884:

Line 3881: --dbms_sql.bind_variable(v_sbr_curid,':cv_account_number',detail_rec.acct_number);

3877: v_py_sbr_end_bal := 0;
3878: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'bEFORE IF detail_rec.sbr_balance_type:detail_rec.acct_number-> '||detail_rec.sbr_balance_type||'::'||detail_rec.acct_number);
3879: dbms_sql.bind_variable(v_sbr_curid,':cv_line_id',v_line_id);
3880: dbms_sql.bind_variable(v_sbr_curid,':cv_line_detail_id',detail_rec.sbr_line_acct_id);
3881: --dbms_sql.bind_variable(v_sbr_curid,':cv_account_number',detail_rec.acct_number);
3882: dbms_sql.bind_variable(v_sbr_curid,':cv_acc_num',detail_rec.acct_number||'%');
3883:
3884:
3885: ---- Get Prior year balances ----

Line 3882: dbms_sql.bind_variable(v_sbr_curid,':cv_acc_num',detail_rec.acct_number||'%');

3878: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'bEFORE IF detail_rec.sbr_balance_type:detail_rec.acct_number-> '||detail_rec.sbr_balance_type||'::'||detail_rec.acct_number);
3879: dbms_sql.bind_variable(v_sbr_curid,':cv_line_id',v_line_id);
3880: dbms_sql.bind_variable(v_sbr_curid,':cv_line_detail_id',detail_rec.sbr_line_acct_id);
3881: --dbms_sql.bind_variable(v_sbr_curid,':cv_account_number',detail_rec.acct_number);
3882: dbms_sql.bind_variable(v_sbr_curid,':cv_acc_num',detail_rec.acct_number||'%');
3883:
3884:
3885: ---- Get Prior year balances ----
3886: ---------------------------------

Line 3891: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);

3887:
3888: IF detail_rec.sbr_balance_type = 'B' THEN
3889: -- If balance type is begin
3890: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'inside IF detail_rec.sbr_balance_type: '||detail_rec.sbr_balance_type);
3891: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3892: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
3893: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
3894:
3895:

Line 3892: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');

3888: IF detail_rec.sbr_balance_type = 'B' THEN
3889: -- If balance type is begin
3890: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'inside IF detail_rec.sbr_balance_type: '||detail_rec.sbr_balance_type);
3891: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3892: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
3893: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
3894:
3895:
3896: ---dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);

Line 3893: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);

3889: -- If balance type is begin
3890: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'inside IF detail_rec.sbr_balance_type: '||detail_rec.sbr_balance_type);
3891: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3892: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
3893: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
3894:
3895:
3896: ---dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
3897: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);

Line 3896: ---dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);

3892: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
3893: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
3894:
3895:
3896: ---dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
3897: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3898: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_sbr_curid : ');
3899: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3900:

Line 3897: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);

3893: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
3894:
3895:
3896: ---dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
3897: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3898: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_sbr_curid : ');
3899: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3900:
3901: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);

Line 3899: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

3895:
3896: ---dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
3897: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3898: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_sbr_curid : ');
3899: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3900:
3901: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
3902: v_amount := v_py_sbr_beg_bal;
3903: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_amount);

Line 3901: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);

3897: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3898: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_sbr_curid : ');
3899: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3900:
3901: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
3902: v_amount := v_py_sbr_beg_bal;
3903: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_amount);
3904: -- IF balance type is ending, ending cr only or ending dr only
3905: ELSIF detail_rec.sbr_balance_type IN ('C', 'D','E','G','I','J') THEN

Line 3907: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);

3903: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_amount);
3904: -- IF balance type is ending, ending cr only or ending dr only
3905: ELSIF detail_rec.sbr_balance_type IN ('C', 'D','E','G','I','J') THEN
3906: -- Get the begin balance
3907: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3908: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
3909: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
3910: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
3911: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);

Line 3908: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');

3904: -- IF balance type is ending, ending cr only or ending dr only
3905: ELSIF detail_rec.sbr_balance_type IN ('C', 'D','E','G','I','J') THEN
3906: -- Get the begin balance
3907: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3908: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
3909: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
3910: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
3911: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3912: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

Line 3909: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);

3905: ELSIF detail_rec.sbr_balance_type IN ('C', 'D','E','G','I','J') THEN
3906: -- Get the begin balance
3907: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3908: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
3909: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
3910: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
3911: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3912: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3913: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);

Line 3910: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);

3906: -- Get the begin balance
3907: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3908: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
3909: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
3910: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
3911: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3912: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3913: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
3914:

Line 3911: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);

3907: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3908: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
3909: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
3910: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
3911: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3912: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3913: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
3914:
3915: -- Get the end balance

Line 3912: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

3908: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
3909: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
3910: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
3911: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3912: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3913: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
3914:
3915: -- Get the end balance
3916: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);

Line 3913: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);

3909: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
3910: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
3911: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3912: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3913: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
3914:
3915: -- Get the end balance
3916: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3917: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');

Line 3916: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);

3912: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3913: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
3914:
3915: -- Get the end balance
3916: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3917: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
3918: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
3919: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
3920: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);

Line 3917: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');

3913: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
3914:
3915: -- Get the end balance
3916: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3917: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
3918: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
3919: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
3920: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3921: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

Line 3918: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);

3914:
3915: -- Get the end balance
3916: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3917: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
3918: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
3919: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
3920: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3921: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3922: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);

Line 3919: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);

3915: -- Get the end balance
3916: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3917: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
3918: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
3919: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
3920: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3921: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3922: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
3923:

Line 3920: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);

3916: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3917: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
3918: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
3919: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
3920: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3921: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3922: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
3923:
3924: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);

Line 3921: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

3917: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
3918: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
3919: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
3920: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3921: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3922: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
3923:
3924: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);
3925: v_amount := get_bal_type_amt(detail_rec.sbr_balance_type, v_natural_balance_type, NVL(v_py_sbr_beg_bal,0), NVL(v_py_sbr_end_bal,0));

Line 3922: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);

3918: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
3919: --dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
3920: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3921: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3922: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
3923:
3924: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);
3925: v_amount := get_bal_type_amt(detail_rec.sbr_balance_type, v_natural_balance_type, NVL(v_py_sbr_beg_bal,0), NVL(v_py_sbr_end_bal,0));
3926: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_amount: '||v_amount);