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 207: dbms_sql.close_cursor(v_glbal_curid);

203: END IF;
204: END IF;
205: END IF;
206:
207: dbms_sql.close_cursor(v_glbal_curid);
208: dbms_sql.close_cursor(v_fct1_sel_curid);
209: dbms_sql.close_cursor(v_fct1_rcpt_sel_curid);
210: dbms_sql.close_cursor(v_fct1_rcpt_sel2_curid);
211:

Line 208: dbms_sql.close_cursor(v_fct1_sel_curid);

204: END IF;
205: END IF;
206:
207: dbms_sql.close_cursor(v_glbal_curid);
208: dbms_sql.close_cursor(v_fct1_sel_curid);
209: dbms_sql.close_cursor(v_fct1_rcpt_sel_curid);
210: dbms_sql.close_cursor(v_fct1_rcpt_sel2_curid);
211:
212: retcode := v_retcode;

Line 209: dbms_sql.close_cursor(v_fct1_rcpt_sel_curid);

205: END IF;
206:
207: dbms_sql.close_cursor(v_glbal_curid);
208: dbms_sql.close_cursor(v_fct1_sel_curid);
209: dbms_sql.close_cursor(v_fct1_rcpt_sel_curid);
210: dbms_sql.close_cursor(v_fct1_rcpt_sel2_curid);
211:
212: retcode := v_retcode;
213: errbuf := v_errbuf;

Line 210: dbms_sql.close_cursor(v_fct1_rcpt_sel2_curid);

206:
207: dbms_sql.close_cursor(v_glbal_curid);
208: dbms_sql.close_cursor(v_fct1_sel_curid);
209: dbms_sql.close_cursor(v_fct1_rcpt_sel_curid);
210: dbms_sql.close_cursor(v_fct1_rcpt_sel2_curid);
211:
212: retcode := v_retcode;
213: errbuf := v_errbuf;
214:

Line 565: v_glbal_curid := dbms_sql.open_cursor;

561:
562: l_stage := 1;
563: l_out := v_fct1_attr_select;
564:
565: v_glbal_curid := dbms_sql.open_cursor;
566: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);
567: dbms_sql.define_column(v_glbal_curid, 1, v_amount);
568: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);
569:

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

562: l_stage := 1;
563: l_out := v_fct1_attr_select;
564:
565: v_glbal_curid := dbms_sql.open_cursor;
566: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);
567: dbms_sql.define_column(v_glbal_curid, 1, v_amount);
568: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);
569:
570: v_fct1_sel :=

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

563: l_out := v_fct1_attr_select;
564:
565: v_glbal_curid := dbms_sql.open_cursor;
566: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);
567: dbms_sql.define_column(v_glbal_curid, 1, v_amount);
568: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);
569:
570: v_fct1_sel :=
571: 'SELECT ROUND(SUM(NVL(ffrt.amount,0) ),2) ';

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

564:
565: v_glbal_curid := dbms_sql.open_cursor;
566: dbms_sql.parse(v_glbal_curid, v_fct1_attr_select, dbms_sql.v7);
567: dbms_sql.define_column(v_glbal_curid, 1, v_amount);
568: dbms_sql.bind_variable(v_glbal_curid,':b_sob',v_sob);
569:
570: v_fct1_sel :=
571: 'SELECT ROUND(SUM(NVL(ffrt.amount,0) ),2) ';
572:

Line 599: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;

595: v_fct1_rcpt_sel := v_fct1_rcpt_sel || l_temp1 || ' GROUP BY ffrt.recipient_name ';
596:
597: l_stage := 3;
598: l_out := v_fct1_rcpt_sel;
599: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
600: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
601: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
602: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
603: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);

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

596:
597: l_stage := 3;
598: l_out := v_fct1_rcpt_sel;
599: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
600: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
601: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
602: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
603: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);
604:

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

597: l_stage := 3;
598: l_out := v_fct1_rcpt_sel;
599: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
600: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
601: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
602: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
603: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);
604:
605: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel, 'GROUP BY ffrt.recipient_name',

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

598: l_out := v_fct1_rcpt_sel;
599: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
600: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
601: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
602: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
603: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);
604:
605: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel, 'GROUP BY ffrt.recipient_name',
606: 'AND ffrt.recipient_name = :cv_recipient_name');

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

599: v_fct1_rcpt_sel_curid := dbms_sql.open_cursor;
600: dbms_sql.parse(v_fct1_rcpt_sel_curid, v_fct1_rcpt_sel, dbms_sql.v7);
601: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 1, v_amount);
602: dbms_sql.define_column(v_fct1_rcpt_sel_curid, 2, v_recipient_name, 240);
603: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':b_sob',v_sob);
604:
605: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel, 'GROUP BY ffrt.recipient_name',
606: 'AND ffrt.recipient_name = :cv_recipient_name');
607: v_fct1_rcpt_sel2 := REPLACE(v_fct1_rcpt_sel2, ', ffrt.recipient_name', ', 1');

Line 612: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;

608:
609:
610: l_stage := 4;
611: l_out := v_fct1_rcpt_sel2;
612: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
613: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
614: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
615: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
616: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);

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

609:
610: l_stage := 4;
611: l_out := v_fct1_rcpt_sel2;
612: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
613: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
614: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
615: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
616: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
617:

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

610: l_stage := 4;
611: l_out := v_fct1_rcpt_sel2;
612: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
613: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
614: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
615: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
616: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
617:
618:

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

611: l_out := v_fct1_rcpt_sel2;
612: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
613: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
614: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
615: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
616: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
617:
618:
619: l_stage := 5;

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

612: v_fct1_rcpt_sel2_curid := dbms_sql.open_cursor;
613: dbms_sql.parse(v_fct1_rcpt_sel2_curid, v_fct1_rcpt_sel2, dbms_sql.v7);
614: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 1, v_amount);
615: dbms_sql.define_column(v_fct1_rcpt_sel2_curid, 2, v_recipient_name, 240);
616: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':b_sob',v_sob);
617:
618:
619: l_stage := 5;
620: l_out := v_fct1_sel;

Line 622: v_fct1_sel_curid := dbms_sql.open_cursor;

618:
619: l_stage := 5;
620: l_out := v_fct1_sel;
621:
622: v_fct1_sel_curid := dbms_sql.open_cursor;
623: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);
624: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);
625: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);
626:

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

619: l_stage := 5;
620: l_out := v_fct1_sel;
621:
622: v_fct1_sel_curid := dbms_sql.open_cursor;
623: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);
624: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);
625: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);
626:
627:

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

620: l_out := v_fct1_sel;
621:
622: v_fct1_sel_curid := dbms_sql.open_cursor;
623: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);
624: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);
625: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);
626:
627:
628: v_glbal_select :=

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

621:
622: v_fct1_sel_curid := dbms_sql.open_cursor;
623: dbms_sql.parse(v_fct1_sel_curid, v_fct1_sel, dbms_sql.v7);
624: dbms_sql.define_column(v_fct1_sel_curid, 1, v_amount);
625: dbms_sql.bind_variable(v_fct1_sel_curid,':b_sob',v_sob);
626:
627:
628: v_glbal_select :=
629: ' SELECT /*+ USE_HASH (glbal) */

Line 668: v_sbr_curid := dbms_sql.open_cursor;

664:
665: l_stage := 6;
666: l_out := v_glbal_select;
667:
668: v_sbr_curid := dbms_sql.open_cursor;
669: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
670: dbms_sql.define_column(v_sbr_curid, 1, v_amount);
671: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
672: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);

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

665: l_stage := 6;
666: l_out := v_glbal_select;
667:
668: v_sbr_curid := dbms_sql.open_cursor;
669: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
670: dbms_sql.define_column(v_sbr_curid, 1, v_amount);
671: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
672: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
673: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);

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

666: l_out := v_glbal_select;
667:
668: v_sbr_curid := dbms_sql.open_cursor;
669: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
670: dbms_sql.define_column(v_sbr_curid, 1, v_amount);
671: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
672: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
673: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);
674:

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

667:
668: v_sbr_curid := dbms_sql.open_cursor;
669: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
670: dbms_sql.define_column(v_sbr_curid, 1, v_amount);
671: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
672: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
673: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);
674:
675:

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

668: v_sbr_curid := dbms_sql.open_cursor;
669: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
670: dbms_sql.define_column(v_sbr_curid, 1, v_amount);
671: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
672: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
673: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);
674:
675:
676: EXCEPTION

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

669: dbms_sql.parse(v_sbr_curid, v_glbal_select, dbms_sql.v7);
670: dbms_sql.define_column(v_sbr_curid, 1, v_amount);
671: dbms_sql.bind_variable(v_sbr_curid,':b_chart_of_accounts_id', v_chart_of_accounts_id);
672: dbms_sql.bind_variable(v_sbr_curid,':b_sob',v_sob);
673: dbms_sql.bind_variable(v_sbr_curid,':v_currency_code',v_currency_code);
674:
675:
676: EXCEPTION
677: WHEN OTHERS THEN

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

713: v_col_2_amt := 0;
714: v_col_3_amt := 0;
715: v_col_4_amt := 0;
716: IF lines_rec.line_type IN ('D', 'D2') THEN
717: -- $$$dbms_sql.bind_variable(v_cursor_id1,':cv_line_id',v_line_id);
718: SELECT count(*)
719: INTO l_line_cnt
720: FROM fv_cfs_rep_line_dtl
721: WHERE line_id = v_line_id;

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

740: v_errbuf := 'SEED Data not properly Loaded. Please Verify and reinvoke the Process.';
741: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',v_errbuf);
742: RETURN;
743: END IF;
744: -- $$$dbms_sql.bind_variable(v_cursor_id1,':cv_line_id',v_line_id);
745: process_total_line;
746:
747: populate_temp_table;
748: ELSIF lines_rec.line_type IN ('L', 'F') THEN

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

991: v_retcode := 1;
992: ELSE --- 1
993: IF v_by_recipient = 'Y' THEN --- 2
994:
995: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_id',v_line_id);
996: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
997: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);
998: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
999: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);

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

992: ELSE --- 1
993: IF v_by_recipient = 'Y' THEN --- 2
994:
995: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_id',v_line_id);
996: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
997: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);
998: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
999: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1000: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);

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

993: IF v_by_recipient = 'Y' THEN --- 2
994:
995: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_id',v_line_id);
996: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
997: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);
998: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
999: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1000: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1001:

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

994:
995: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_id',v_line_id);
996: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
997: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);
998: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
999: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1000: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1001:
1002: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);

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

995: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_id',v_line_id);
996: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
997: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);
998: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
999: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1000: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1001:
1002: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1003: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);

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

996: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
997: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_balance_type',detail_rec.balance_type);
998: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
999: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1000: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1001:
1002: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1003: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1004: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);

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

998: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
999: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1000: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1001:
1002: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1003: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1004: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);
1005: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1006: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_num', v_end_period);

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

999: dbms_sql.bind_variable(v_fct1_rcpt_sel_curid,':cv_period_num', v_end_period);
1000: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1001:
1002: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1003: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1004: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);
1005: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1006: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_num', v_end_period);
1007:

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

1000: l_ignore := dbms_sql.execute(v_fct1_rcpt_sel_curid);
1001:
1002: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1003: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1004: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);
1005: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1006: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_num', v_end_period);
1007:
1008: LOOP

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

1001:
1002: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1003: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1004: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);
1005: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1006: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_num', v_end_period);
1007:
1008: LOOP
1009: l_ignore := dbms_sql.fetch_rows(v_fct1_rcpt_sel_curid);

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

1002: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_id',v_line_id);
1003: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1004: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_balance_type',detail_rec.balance_type);
1005: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1006: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_num', v_end_period);
1007:
1008: LOOP
1009: l_ignore := dbms_sql.fetch_rows(v_fct1_rcpt_sel_curid);
1010: EXIT WHEN l_ignore= 0;

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

1005: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1006: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_period_num', v_end_period);
1007:
1008: LOOP
1009: l_ignore := dbms_sql.fetch_rows(v_fct1_rcpt_sel_curid);
1010: EXIT WHEN l_ignore= 0;
1011: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 1, v_amount);
1012: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 2, v_recipient_name);
1013: v_col_1_amt := nvl(v_amount, 0);

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

1007:
1008: LOOP
1009: l_ignore := dbms_sql.fetch_rows(v_fct1_rcpt_sel_curid);
1010: EXIT WHEN l_ignore= 0;
1011: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 1, v_amount);
1012: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 2, v_recipient_name);
1013: v_col_1_amt := nvl(v_amount, 0);
1014:
1015: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);

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

1008: LOOP
1009: l_ignore := dbms_sql.fetch_rows(v_fct1_rcpt_sel_curid);
1010: EXIT WHEN l_ignore= 0;
1011: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 1, v_amount);
1012: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 2, v_recipient_name);
1013: v_col_1_amt := nvl(v_amount, 0);
1014:
1015: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);
1016: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);

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

1014:
1015: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);
1016: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);
1017:
1018: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);
1019: l_ignore := dbms_sql.execute_and_fetch(v_fct1_rcpt_sel2_curid);
1020: dbms_sql.column_value(v_fct1_rcpt_sel2_curid, 1, v_amount);
1021: v_col_2_amt := nvl(v_amount, 0);
1022: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient group by amount: '||v_amount);

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

1015: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);
1016: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);
1017:
1018: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);
1019: l_ignore := dbms_sql.execute_and_fetch(v_fct1_rcpt_sel2_curid);
1020: dbms_sql.column_value(v_fct1_rcpt_sel2_curid, 1, v_amount);
1021: v_col_2_amt := nvl(v_amount, 0);
1022: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient group by amount: '||v_amount);
1023:

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

1016: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);
1017:
1018: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);
1019: l_ignore := dbms_sql.execute_and_fetch(v_fct1_rcpt_sel2_curid);
1020: dbms_sql.column_value(v_fct1_rcpt_sel2_curid, 1, v_amount);
1021: v_col_2_amt := nvl(v_amount, 0);
1022: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient group by amount: '||v_amount);
1023:
1024: l_found := FALSE;

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

1075: v_cy_gl_end_bal := 0;
1076:
1077: -- Get beginning balances for current and prior years from
1078: -- facts1 attributes.
1079: dbms_sql.bind_variable(v_glbal_curid,':cv_line_id',v_line_id);
1080: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1081:
1082: -- Get prior year beginning balance
1083: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);

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

1076:
1077: -- Get beginning balances for current and prior years from
1078: -- facts1 attributes.
1079: dbms_sql.bind_variable(v_glbal_curid,':cv_line_id',v_line_id);
1080: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1081:
1082: -- Get prior year beginning balance
1083: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1084: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');

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

1079: dbms_sql.bind_variable(v_glbal_curid,':cv_line_id',v_line_id);
1080: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1081:
1082: -- Get prior year beginning balance
1083: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1084: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1085:
1086: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
1087: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);

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

1080: dbms_sql.bind_variable(v_glbal_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1081:
1082: -- Get prior year beginning balance
1083: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1084: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1085:
1086: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
1087: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1088: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);

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

1082: -- Get prior year beginning balance
1083: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1084: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1085:
1086: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
1087: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1088: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
1089: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
1090:

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

1083: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1084: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1085:
1086: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
1087: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1088: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
1089: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
1090:
1091: -- Get current year beginning balance

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

1084: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1085:
1086: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
1087: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1088: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
1089: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
1090:
1091: -- Get current year beginning balance
1092: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);

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

1088: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
1089: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
1090:
1091: -- Get current year beginning balance
1092: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1093:
1094: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);
1095: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1096: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);

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

1090:
1091: -- Get current year beginning balance
1092: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1093:
1094: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);
1095: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1096: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1097: dbms_sql.column_value(v_glbal_curid, 1, v_cy_gl_beg_bal);
1098: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin gl bal: '||v_cy_gl_beg_bal);

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

1091: -- Get current year beginning balance
1092: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1093:
1094: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);
1095: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1096: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1097: dbms_sql.column_value(v_glbal_curid, 1, v_cy_gl_beg_bal);
1098: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin gl bal: '||v_cy_gl_beg_bal);
1099:

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

1092: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1093:
1094: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);
1095: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1096: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1097: dbms_sql.column_value(v_glbal_curid, 1, v_cy_gl_beg_bal);
1098: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin gl bal: '||v_cy_gl_beg_bal);
1099:
1100: -- ===================================================================

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

1093:
1094: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);
1095: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1096: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1097: dbms_sql.column_value(v_glbal_curid, 1, v_cy_gl_beg_bal);
1098: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin gl bal: '||v_cy_gl_beg_bal);
1099:
1100: -- ===================================================================
1101:

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

1138: END IF;
1139:
1140: -- Get facts1 ending balance for prior year
1141: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1142: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1143: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1144: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1145: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1146: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);

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

1139:
1140: -- Get facts1 ending balance for prior year
1141: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1142: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1143: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1144: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1145: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1146: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1147: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);

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

1140: -- Get facts1 ending balance for prior year
1141: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1142: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1143: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1144: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1145: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1146: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1147: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1148: dbms_sql.column_value(v_fct1_sel_curid, 1, v_py_fct1_endbal);

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

1141: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1142: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1143: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1144: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1145: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1146: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1147: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1148: dbms_sql.column_value(v_fct1_sel_curid, 1, v_py_fct1_endbal);
1149: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end facts1 bal: '||v_py_fct1_endbal);

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

1142: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1143: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1144: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1145: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1146: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1147: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1148: dbms_sql.column_value(v_fct1_sel_curid, 1, v_py_fct1_endbal);
1149: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end facts1 bal: '||v_py_fct1_endbal);
1150:

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

1143: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1144: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1145: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1146: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1147: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1148: dbms_sql.column_value(v_fct1_sel_curid, 1, v_py_fct1_endbal);
1149: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end facts1 bal: '||v_py_fct1_endbal);
1150:
1151: v_amount := get_bal_type_amt(detail_rec.balance_type,

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

1144: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1145: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1146: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1147: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1148: dbms_sql.column_value(v_fct1_sel_curid, 1, v_py_fct1_endbal);
1149: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end facts1 bal: '||v_py_fct1_endbal);
1150:
1151: v_amount := get_bal_type_amt(detail_rec.balance_type,
1152: v_natural_balance_type,

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

1174: END IF;
1175:
1176: -- Get facts1 ending balance for current year
1177: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1178: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1179: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1180: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1181: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1182: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);

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

1175:
1176: -- Get facts1 ending balance for current year
1177: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1178: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1179: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1180: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1181: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1182: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1183: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);

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

1176: -- Get facts1 ending balance for current year
1177: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1178: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1179: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1180: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1181: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1182: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1183: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1184: dbms_sql.column_value(v_fct1_sel_curid, 1, v_cy_fct1_endbal);

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

1177: IF detail_rec.balance_type IN ('C', 'D', 'E', 'G', 'I', 'J') THEN
1178: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1179: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1180: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1181: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1182: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1183: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1184: dbms_sql.column_value(v_fct1_sel_curid, 1, v_cy_fct1_endbal);
1185: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end facsts1 bal: '||v_cy_fct1_endbal);

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

1178: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_id',v_line_id);
1179: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1180: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1181: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1182: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1183: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1184: dbms_sql.column_value(v_fct1_sel_curid, 1, v_cy_fct1_endbal);
1185: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end facsts1 bal: '||v_cy_fct1_endbal);
1186:

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

1179: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1180: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1181: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1182: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1183: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1184: dbms_sql.column_value(v_fct1_sel_curid, 1, v_cy_fct1_endbal);
1185: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end facsts1 bal: '||v_cy_fct1_endbal);
1186:
1187: v_amount := get_bal_type_amt(detail_rec.balance_type,

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

1180: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1181: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1182: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1183: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1184: dbms_sql.column_value(v_fct1_sel_curid, 1, v_cy_fct1_endbal);
1185: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end facsts1 bal: '||v_cy_fct1_endbal);
1186:
1187: v_amount := get_bal_type_amt(detail_rec.balance_type,
1188: v_natural_balance_type,

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

1213: v_cy_sbr_end_bal := 0;
1214: v_py_sbr_beg_bal := 0;
1215: v_py_sbr_end_bal := 0;
1216:
1217: dbms_sql.bind_variable(v_sbr_curid,':cv_line_id',v_line_id);
1218: dbms_sql.bind_variable(v_sbr_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1219:
1220: -- Get Current Year balances --
1221: -------------------------------

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

1214: v_py_sbr_beg_bal := 0;
1215: v_py_sbr_end_bal := 0;
1216:
1217: dbms_sql.bind_variable(v_sbr_curid,':cv_line_id',v_line_id);
1218: dbms_sql.bind_variable(v_sbr_curid,':cv_line_detail_id',detail_rec.line_detail_id);
1219:
1220: -- Get Current Year balances --
1221: -------------------------------
1222: IF detail_rec.balance_type = 'B' THEN

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

1220: -- Get Current Year balances --
1221: -------------------------------
1222: IF detail_rec.balance_type = 'B' THEN
1223: -- IF balance type is begin
1224: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1225: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1226: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1227: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1228: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

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

1221: -------------------------------
1222: IF detail_rec.balance_type = 'B' THEN
1223: -- IF balance type is begin
1224: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1225: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1226: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1227: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1228: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1229: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);

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

1222: IF detail_rec.balance_type = 'B' THEN
1223: -- IF balance type is begin
1224: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1225: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1226: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1227: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1228: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1229: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1230: v_amount := v_cy_sbr_beg_bal;

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

1223: -- IF balance type is begin
1224: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1225: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1226: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1227: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1228: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1229: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1230: v_amount := v_cy_sbr_beg_bal;
1231: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_sbr_beg_bal);

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

1224: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1225: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1226: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1227: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1228: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1229: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1230: v_amount := v_cy_sbr_beg_bal;
1231: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_sbr_beg_bal);
1232: ELSIF detail_rec.balance_type IN ('C','D','E','G','I','J') THEN

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

1225: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1226: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1227: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1228: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1229: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1230: v_amount := v_cy_sbr_beg_bal;
1231: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_sbr_beg_bal);
1232: ELSIF detail_rec.balance_type IN ('C','D','E','G','I','J') THEN
1233: -- IF balance type is ending, ending cr only or ending dr only

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

1231: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_sbr_beg_bal);
1232: ELSIF detail_rec.balance_type IN ('C','D','E','G','I','J') THEN
1233: -- IF balance type is ending, ending cr only or ending dr only
1234: -- Get the begin balance
1235: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1236: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1237: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1238: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1239: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

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

1232: ELSIF detail_rec.balance_type IN ('C','D','E','G','I','J') THEN
1233: -- IF balance type is ending, ending cr only or ending dr only
1234: -- Get the begin balance
1235: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1236: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1237: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1238: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1239: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1240: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);

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

1233: -- IF balance type is ending, ending cr only or ending dr only
1234: -- Get the begin balance
1235: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1236: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1237: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1238: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1239: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1240: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1241: -- Get the end balance

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

1234: -- Get the begin balance
1235: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1236: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1237: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1238: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1239: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1240: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1241: -- Get the end balance
1242: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');

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

1235: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1236: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1237: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1238: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1239: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1240: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1241: -- Get the end balance
1242: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1243: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);

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

1236: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period);
1237: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_end_date);
1238: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1239: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1240: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1241: -- Get the end balance
1242: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1243: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1244: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);

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

1238: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1239: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1240: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1241: -- Get the end balance
1242: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1243: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1244: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1245: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1246: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

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

1239: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1240: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1241: -- Get the end balance
1242: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1243: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1244: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1245: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1246: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1247: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_end_bal);

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

1240: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1241: -- Get the end balance
1242: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1243: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1244: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1245: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1246: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1247: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_end_bal);
1248: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end bal: '||v_cy_sbr_end_bal);

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

1241: -- Get the end balance
1242: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1243: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1244: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1245: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1246: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1247: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_end_bal);
1248: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end bal: '||v_cy_sbr_end_bal);
1249:

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

1242: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1243: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1244: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1245: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1246: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1247: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_end_bal);
1248: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end bal: '||v_cy_sbr_end_bal);
1249:
1250: v_amount := get_bal_type_amt(detail_rec.balance_type,

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

1243: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_end_period);
1244: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1245: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1246: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1247: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_end_bal);
1248: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end bal: '||v_cy_sbr_end_bal);
1249:
1250: v_amount := get_bal_type_amt(detail_rec.balance_type,
1251: v_natural_balance_type,

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

1265: ---- Get Prior year balances ----
1266: ---------------------------------
1267: IF detail_rec.balance_type = 'B' THEN
1268: -- If balance type is begin
1269: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1270: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1271: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1272: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1273: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

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

1266: ---------------------------------
1267: IF detail_rec.balance_type = 'B' THEN
1268: -- If balance type is begin
1269: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1270: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1271: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1272: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1273: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1274: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);

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

1267: IF detail_rec.balance_type = 'B' THEN
1268: -- If balance type is begin
1269: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1270: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1271: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1272: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1273: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1274: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1275: v_amount := v_py_sbr_beg_bal;

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

1268: -- If balance type is begin
1269: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1270: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1271: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1272: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1273: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1274: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1275: v_amount := v_py_sbr_beg_bal;
1276: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_sbr_beg_bal);

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

1269: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1270: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1271: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1272: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1273: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1274: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1275: v_amount := v_py_sbr_beg_bal;
1276: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_sbr_beg_bal);
1277: -- IF balance type is ending, ending cr only or ending dr only

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

1270: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1271: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1272: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1273: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1274: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1275: v_amount := v_py_sbr_beg_bal;
1276: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_sbr_beg_bal);
1277: -- IF balance type is ending, ending cr only or ending dr only
1278: ELSIF detail_rec.balance_type IN ('C', 'D','E','G','I','J') THEN

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

1276: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_sbr_beg_bal);
1277: -- IF balance type is ending, ending cr only or ending dr only
1278: ELSIF detail_rec.balance_type IN ('C', 'D','E','G','I','J') THEN
1279: -- Get the begin balance
1280: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1281: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1282: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1283: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1284: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

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

1277: -- IF balance type is ending, ending cr only or ending dr only
1278: ELSIF detail_rec.balance_type IN ('C', 'D','E','G','I','J') THEN
1279: -- Get the begin balance
1280: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1281: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1282: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1283: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1284: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1285: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);

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

1278: ELSIF detail_rec.balance_type IN ('C', 'D','E','G','I','J') THEN
1279: -- Get the begin balance
1280: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1281: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1282: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1283: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1284: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1285: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1286: -- Get the end balance

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

1279: -- Get the begin balance
1280: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1281: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1282: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1283: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1284: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1285: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1286: -- Get the end balance
1287: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');

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

1280: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
1281: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1282: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1283: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1284: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1285: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1286: -- Get the end balance
1287: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1288: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);

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

1281: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
1282: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
1283: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1284: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1285: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1286: -- Get the end balance
1287: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1288: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1289: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);

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

1283: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1284: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1285: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1286: -- Get the end balance
1287: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1288: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1289: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1290: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1291: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);

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

1284: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1285: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1286: -- Get the end balance
1287: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1288: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1289: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1290: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1291: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1292: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);

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

1285: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1286: -- Get the end balance
1287: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1288: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1289: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1290: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1291: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1292: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
1293: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);

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

1286: -- Get the end balance
1287: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1288: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1289: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1290: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1291: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1292: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
1293: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);
1294: v_amount := get_bal_type_amt(detail_rec.balance_type,

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

1287: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','E');
1288: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1289: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1290: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1291: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1292: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
1293: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);
1294: v_amount := get_bal_type_amt(detail_rec.balance_type,
1295: v_natural_balance_type,

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

1288: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_period_num);
1289: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1290: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1291: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1292: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
1293: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);
1294: v_amount := get_bal_type_amt(detail_rec.balance_type,
1295: v_natural_balance_type,
1296: NVL(v_py_sbr_beg_bal,0),