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

Line 743: vl_main_cursor := DBMS_SQL.OPEN_CURSOR ;

739: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
740: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Selecting FACTS Transactions.....') ;
741: END IF;
742: Begin
743: vl_main_cursor := DBMS_SQL.OPEN_CURSOR ;
744: Exception
745: When Others Then
746: vp_retcode := sqlcode ;
747: VP_ERRBUF := sqlerrm ;

Line 801: dbms_sql.parse(vl_main_cursor, vl_main_select, DBMS_SQL.V7) ;

797: || v_segment ||v_cohort_select ||
798: ' ORDER BY GLCC.' || v_acc_seg_name ;
799:
800: Begin
801: dbms_sql.parse(vl_main_cursor, vl_main_select, DBMS_SQL.V7) ;
802: Exception
803: When Others Then
804: vp_retcode := sqlcode ;
805: VP_ERRBUF := sqlerrm ;

Line 812: dbms_sql.bind_variable(vl_main_cursor,':actual_flag', 'A');

808: Return ;
809: End ;
810:
811: -- Bind the variables
812: dbms_sql.bind_variable(vl_main_cursor,':actual_flag', 'A');
813: dbms_sql.bind_variable(vl_main_cursor,':fund_value', v_fund_value);
814: dbms_sql.bind_variable(vl_main_cursor,':set_of_books_id', vp_set_of_books_id);
815: dbms_sql.bind_variable(vl_main_cursor,':report_fiscal_yr', vp_report_fiscal_yr);
816: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);

Line 813: dbms_sql.bind_variable(vl_main_cursor,':fund_value', v_fund_value);

809: End ;
810:
811: -- Bind the variables
812: dbms_sql.bind_variable(vl_main_cursor,':actual_flag', 'A');
813: dbms_sql.bind_variable(vl_main_cursor,':fund_value', v_fund_value);
814: dbms_sql.bind_variable(vl_main_cursor,':set_of_books_id', vp_set_of_books_id);
815: dbms_sql.bind_variable(vl_main_cursor,':report_fiscal_yr', vp_report_fiscal_yr);
816: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);
817:

Line 814: dbms_sql.bind_variable(vl_main_cursor,':set_of_books_id', vp_set_of_books_id);

810:
811: -- Bind the variables
812: dbms_sql.bind_variable(vl_main_cursor,':actual_flag', 'A');
813: dbms_sql.bind_variable(vl_main_cursor,':fund_value', v_fund_value);
814: dbms_sql.bind_variable(vl_main_cursor,':set_of_books_id', vp_set_of_books_id);
815: dbms_sql.bind_variable(vl_main_cursor,':report_fiscal_yr', vp_report_fiscal_yr);
816: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);
817:
818:

Line 815: dbms_sql.bind_variable(vl_main_cursor,':report_fiscal_yr', vp_report_fiscal_yr);

811: -- Bind the variables
812: dbms_sql.bind_variable(vl_main_cursor,':actual_flag', 'A');
813: dbms_sql.bind_variable(vl_main_cursor,':fund_value', v_fund_value);
814: dbms_sql.bind_variable(vl_main_cursor,':set_of_books_id', vp_set_of_books_id);
815: dbms_sql.bind_variable(vl_main_cursor,':report_fiscal_yr', vp_report_fiscal_yr);
816: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);
817:
818:
819: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);

Line 816: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);

812: dbms_sql.bind_variable(vl_main_cursor,':actual_flag', 'A');
813: dbms_sql.bind_variable(vl_main_cursor,':fund_value', v_fund_value);
814: dbms_sql.bind_variable(vl_main_cursor,':set_of_books_id', vp_set_of_books_id);
815: dbms_sql.bind_variable(vl_main_cursor,':report_fiscal_yr', vp_report_fiscal_yr);
816: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);
817:
818:
819: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);
820: dbms_sql.define_column(vl_main_cursor, 2, vl_acct_num, 25);

Line 819: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);

815: dbms_sql.bind_variable(vl_main_cursor,':report_fiscal_yr', vp_report_fiscal_yr);
816: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);
817:
818:
819: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);
820: dbms_sql.define_column(vl_main_cursor, 2, vl_acct_num, 25);
821: dbms_sql.define_column(vl_main_cursor, 3, vl_fund_value, 25);
822: dbms_sql.define_column(vl_main_cursor, 4, v_fiscal_yr, 25);
823: dbms_sql.define_column(vl_main_cursor, 5, vg_amount);

Line 820: dbms_sql.define_column(vl_main_cursor, 2, vl_acct_num, 25);

816: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);
817:
818:
819: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);
820: dbms_sql.define_column(vl_main_cursor, 2, vl_acct_num, 25);
821: dbms_sql.define_column(vl_main_cursor, 3, vl_fund_value, 25);
822: dbms_sql.define_column(vl_main_cursor, 4, v_fiscal_yr, 25);
823: dbms_sql.define_column(vl_main_cursor, 5, vg_amount);
824:

Line 821: dbms_sql.define_column(vl_main_cursor, 3, vl_fund_value, 25);

817:
818:
819: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);
820: dbms_sql.define_column(vl_main_cursor, 2, vl_acct_num, 25);
821: dbms_sql.define_column(vl_main_cursor, 3, vl_fund_value, 25);
822: dbms_sql.define_column(vl_main_cursor, 4, v_fiscal_yr, 25);
823: dbms_sql.define_column(vl_main_cursor, 5, vg_amount);
824:
825: IF v_cohort_seg_name IS NOT NULL THEN

Line 822: dbms_sql.define_column(vl_main_cursor, 4, v_fiscal_yr, 25);

818:
819: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);
820: dbms_sql.define_column(vl_main_cursor, 2, vl_acct_num, 25);
821: dbms_sql.define_column(vl_main_cursor, 3, vl_fund_value, 25);
822: dbms_sql.define_column(vl_main_cursor, 4, v_fiscal_yr, 25);
823: dbms_sql.define_column(vl_main_cursor, 5, vg_amount);
824:
825: IF v_cohort_seg_name IS NOT NULL THEN
826: dbms_sql.define_column(vl_main_cursor, 6, vl_cohort_yr, 25);

Line 823: dbms_sql.define_column(vl_main_cursor, 5, vg_amount);

819: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);
820: dbms_sql.define_column(vl_main_cursor, 2, vl_acct_num, 25);
821: dbms_sql.define_column(vl_main_cursor, 3, vl_fund_value, 25);
822: dbms_sql.define_column(vl_main_cursor, 4, v_fiscal_yr, 25);
823: dbms_sql.define_column(vl_main_cursor, 5, vg_amount);
824:
825: IF v_cohort_seg_name IS NOT NULL THEN
826: dbms_sql.define_column(vl_main_cursor, 6, vl_cohort_yr, 25);
827: END IF;

Line 826: dbms_sql.define_column(vl_main_cursor, 6, vl_cohort_yr, 25);

822: dbms_sql.define_column(vl_main_cursor, 4, v_fiscal_yr, 25);
823: dbms_sql.define_column(vl_main_cursor, 5, vg_amount);
824:
825: IF v_cohort_seg_name IS NOT NULL THEN
826: dbms_sql.define_column(vl_main_cursor, 6, vl_cohort_yr, 25);
827: END IF;
828:
829: Begin
830: vl_exec_ret := dbms_sql.execute(vl_main_cursor);

Line 830: vl_exec_ret := dbms_sql.execute(vl_main_cursor);

826: dbms_sql.define_column(vl_main_cursor, 6, vl_cohort_yr, 25);
827: END IF;
828:
829: Begin
830: vl_exec_ret := dbms_sql.execute(vl_main_cursor);
831: Exception
832: When Others Then
833: vp_retcode := sqlcode ;
834: VP_ERRBUF := sqlerrm ;

Line 881: vl_main_fetch := dbms_sql.fetch_rows(vl_main_cursor) ;

877:
878: v_period_dr := 0;
879: v_period_cr := 0;
880:
881: vl_main_fetch := dbms_sql.fetch_rows(vl_main_cursor) ;
882:
883: IF (VL_MAIN_FETCH = 0) then
884: exit;
885: End if;

Line 892: dbms_sql.column_value(vl_main_cursor, 1, vl_ccid);

888: -- Increase the counter for number of records
889: vl_row_count := vl_row_count + 1 ;
890:
891: -- Fetch the Records into Variables
892: dbms_sql.column_value(vl_main_cursor, 1, vl_ccid);
893: dbms_sql.column_value(vl_main_cursor, 2, vl_acct_num);
894: dbms_sql.column_value(vl_main_cursor, 3, vl_fund_value);
895: dbms_sql.column_value(vl_main_cursor, 4, v_fiscal_yr);
896: dbms_sql.column_value(vl_main_cursor, 5, vg_amount);

Line 893: dbms_sql.column_value(vl_main_cursor, 2, vl_acct_num);

889: vl_row_count := vl_row_count + 1 ;
890:
891: -- Fetch the Records into Variables
892: dbms_sql.column_value(vl_main_cursor, 1, vl_ccid);
893: dbms_sql.column_value(vl_main_cursor, 2, vl_acct_num);
894: dbms_sql.column_value(vl_main_cursor, 3, vl_fund_value);
895: dbms_sql.column_value(vl_main_cursor, 4, v_fiscal_yr);
896: dbms_sql.column_value(vl_main_cursor, 5, vg_amount);
897:

Line 894: dbms_sql.column_value(vl_main_cursor, 3, vl_fund_value);

890:
891: -- Fetch the Records into Variables
892: dbms_sql.column_value(vl_main_cursor, 1, vl_ccid);
893: dbms_sql.column_value(vl_main_cursor, 2, vl_acct_num);
894: dbms_sql.column_value(vl_main_cursor, 3, vl_fund_value);
895: dbms_sql.column_value(vl_main_cursor, 4, v_fiscal_yr);
896: dbms_sql.column_value(vl_main_cursor, 5, vg_amount);
897:
898: IF v_cohort_seg_name IS NOT NULL THEN

Line 895: dbms_sql.column_value(vl_main_cursor, 4, v_fiscal_yr);

891: -- Fetch the Records into Variables
892: dbms_sql.column_value(vl_main_cursor, 1, vl_ccid);
893: dbms_sql.column_value(vl_main_cursor, 2, vl_acct_num);
894: dbms_sql.column_value(vl_main_cursor, 3, vl_fund_value);
895: dbms_sql.column_value(vl_main_cursor, 4, v_fiscal_yr);
896: dbms_sql.column_value(vl_main_cursor, 5, vg_amount);
897:
898: IF v_cohort_seg_name IS NOT NULL THEN
899: dbms_sql.column_value(vl_main_cursor, 6, vl_cohort_yr);

Line 896: dbms_sql.column_value(vl_main_cursor, 5, vg_amount);

892: dbms_sql.column_value(vl_main_cursor, 1, vl_ccid);
893: dbms_sql.column_value(vl_main_cursor, 2, vl_acct_num);
894: dbms_sql.column_value(vl_main_cursor, 3, vl_fund_value);
895: dbms_sql.column_value(vl_main_cursor, 4, v_fiscal_yr);
896: dbms_sql.column_value(vl_main_cursor, 5, vg_amount);
897:
898: IF v_cohort_seg_name IS NOT NULL THEN
899: dbms_sql.column_value(vl_main_cursor, 6, vl_cohort_yr);
900: END IF;

Line 899: dbms_sql.column_value(vl_main_cursor, 6, vl_cohort_yr);

895: dbms_sql.column_value(vl_main_cursor, 4, v_fiscal_yr);
896: dbms_sql.column_value(vl_main_cursor, 5, vg_amount);
897:
898: IF v_cohort_seg_name IS NOT NULL THEN
899: dbms_sql.column_value(vl_main_cursor, 6, vl_cohort_yr);
900: END IF;
901:
902: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
903: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 1178: vl_legis_cursor := DBMS_SQL.OPEN_CURSOR ;

1174: -- derived from Budget Execution tables and store them in a
1175: -- cursor. Then roll them up and insert the summarized record
1176: -- into the temp table. Dynamic SQL used for implementation.
1177: Begin
1178: vl_legis_cursor := DBMS_SQL.OPEN_CURSOR ;
1179: Exception
1180: When Others Then
1181: vp_retcode := sqlcode ;
1182: VP_ERRBUF := sqlerrm ;

Line 1256: dbms_sql.parse(vl_legis_cursor,vl_legis_select,DBMS_SQL.V7);

1252: END IF;
1253:
1254:
1255: Begin
1256: dbms_sql.parse(vl_legis_cursor,vl_legis_select,DBMS_SQL.V7);
1257: Exception
1258: When Others Then
1259: vp_retcode := sqlcode ;
1260: VP_ERRBUF := sqlerrm ;

Line 1267: dbms_sql.bind_variable(vl_legis_cursor,':ccid', vl_ccid);

1263: Return ;
1264: End ;
1265:
1266: -- Bind the variables
1267: dbms_sql.bind_variable(vl_legis_cursor,':ccid', vl_ccid);
1268: dbms_sql.bind_variable(vl_legis_cursor,':je_status', 'P');
1269: dbms_sql.bind_variable(vl_legis_cursor,':begin_period_start_dt',
1270: v_begin_period_start_dt);
1271: dbms_sql.bind_variable(vl_legis_cursor,':period_end_dt',

Line 1268: dbms_sql.bind_variable(vl_legis_cursor,':je_status', 'P');

1264: End ;
1265:
1266: -- Bind the variables
1267: dbms_sql.bind_variable(vl_legis_cursor,':ccid', vl_ccid);
1268: dbms_sql.bind_variable(vl_legis_cursor,':je_status', 'P');
1269: dbms_sql.bind_variable(vl_legis_cursor,':begin_period_start_dt',
1270: v_begin_period_start_dt);
1271: dbms_sql.bind_variable(vl_legis_cursor,':period_end_dt',
1272: v_period_end_dt);

Line 1269: dbms_sql.bind_variable(vl_legis_cursor,':begin_period_start_dt',

1265:
1266: -- Bind the variables
1267: dbms_sql.bind_variable(vl_legis_cursor,':ccid', vl_ccid);
1268: dbms_sql.bind_variable(vl_legis_cursor,':je_status', 'P');
1269: dbms_sql.bind_variable(vl_legis_cursor,':begin_period_start_dt',
1270: v_begin_period_start_dt);
1271: dbms_sql.bind_variable(vl_legis_cursor,':period_end_dt',
1272: v_period_end_dt);
1273: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',

Line 1271: dbms_sql.bind_variable(vl_legis_cursor,':period_end_dt',

1267: dbms_sql.bind_variable(vl_legis_cursor,':ccid', vl_ccid);
1268: dbms_sql.bind_variable(vl_legis_cursor,':je_status', 'P');
1269: dbms_sql.bind_variable(vl_legis_cursor,':begin_period_start_dt',
1270: v_begin_period_start_dt);
1271: dbms_sql.bind_variable(vl_legis_cursor,':period_end_dt',
1272: v_period_end_dt);
1273: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1274: vp_set_of_books_id);
1275: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);

Line 1273: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',

1269: dbms_sql.bind_variable(vl_legis_cursor,':begin_period_start_dt',
1270: v_begin_period_start_dt);
1271: dbms_sql.bind_variable(vl_legis_cursor,':period_end_dt',
1272: v_period_end_dt);
1273: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1274: vp_set_of_books_id);
1275: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);
1276: dbms_sql.bind_variable(vl_legis_cursor,':fund_value', vl_fund_value);
1277: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);

Line 1275: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);

1271: dbms_sql.bind_variable(vl_legis_cursor,':period_end_dt',
1272: v_period_end_dt);
1273: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1274: vp_set_of_books_id);
1275: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);
1276: dbms_sql.bind_variable(vl_legis_cursor,':fund_value', vl_fund_value);
1277: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);
1278: dbms_sql.bind_variable(vl_legis_cursor,':currency_code', vp_currency_code);
1279: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',

Line 1276: dbms_sql.bind_variable(vl_legis_cursor,':fund_value', vl_fund_value);

1272: v_period_end_dt);
1273: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1274: vp_set_of_books_id);
1275: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);
1276: dbms_sql.bind_variable(vl_legis_cursor,':fund_value', vl_fund_value);
1277: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);
1278: dbms_sql.bind_variable(vl_legis_cursor,':currency_code', vp_currency_code);
1279: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1280: vp_set_of_books_id);

Line 1277: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);

1273: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1274: vp_set_of_books_id);
1275: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);
1276: dbms_sql.bind_variable(vl_legis_cursor,':fund_value', vl_fund_value);
1277: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);
1278: dbms_sql.bind_variable(vl_legis_cursor,':currency_code', vp_currency_code);
1279: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1280: vp_set_of_books_id);
1281: dbms_sql.bind_variable(vl_legis_cursor,':report_fiscal_yr',

Line 1278: dbms_sql.bind_variable(vl_legis_cursor,':currency_code', vp_currency_code);

1274: vp_set_of_books_id);
1275: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);
1276: dbms_sql.bind_variable(vl_legis_cursor,':fund_value', vl_fund_value);
1277: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);
1278: dbms_sql.bind_variable(vl_legis_cursor,':currency_code', vp_currency_code);
1279: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1280: vp_set_of_books_id);
1281: dbms_sql.bind_variable(vl_legis_cursor,':report_fiscal_yr',
1282: vp_report_fiscal_yr);

Line 1279: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',

1275: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);
1276: dbms_sql.bind_variable(vl_legis_cursor,':fund_value', vl_fund_value);
1277: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);
1278: dbms_sql.bind_variable(vl_legis_cursor,':currency_code', vp_currency_code);
1279: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1280: vp_set_of_books_id);
1281: dbms_sql.bind_variable(vl_legis_cursor,':report_fiscal_yr',
1282: vp_report_fiscal_yr);
1283: dbms_sql.bind_variable(vl_legis_cursor,':period_num', v_period_num);

Line 1281: dbms_sql.bind_variable(vl_legis_cursor,':report_fiscal_yr',

1277: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);
1278: dbms_sql.bind_variable(vl_legis_cursor,':currency_code', vp_currency_code);
1279: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1280: vp_set_of_books_id);
1281: dbms_sql.bind_variable(vl_legis_cursor,':report_fiscal_yr',
1282: vp_report_fiscal_yr);
1283: dbms_sql.bind_variable(vl_legis_cursor,':period_num', v_period_num);
1284:
1285:

Line 1283: dbms_sql.bind_variable(vl_legis_cursor,':period_num', v_period_num);

1279: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1280: vp_set_of_books_id);
1281: dbms_sql.bind_variable(vl_legis_cursor,':report_fiscal_yr',
1282: vp_report_fiscal_yr);
1283: dbms_sql.bind_variable(vl_legis_cursor,':period_num', v_period_num);
1284:
1285:
1286: dbms_sql.define_column(vl_legis_cursor, 1, vl_legis_ref, 240);
1287: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );

Line 1286: dbms_sql.define_column(vl_legis_cursor, 1, vl_legis_ref, 240);

1282: vp_report_fiscal_yr);
1283: dbms_sql.bind_variable(vl_legis_cursor,':period_num', v_period_num);
1284:
1285:
1286: dbms_sql.define_column(vl_legis_cursor, 1, vl_legis_ref, 240);
1287: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );
1288: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1289: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1290: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );

Line 1287: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );

1283: dbms_sql.bind_variable(vl_legis_cursor,':period_num', v_period_num);
1284:
1285:
1286: dbms_sql.define_column(vl_legis_cursor, 1, vl_legis_ref, 240);
1287: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );
1288: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1289: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1290: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1291: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );

Line 1288: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );

1284:
1285:
1286: dbms_sql.define_column(vl_legis_cursor, 1, vl_legis_ref, 240);
1287: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );
1288: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1289: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1290: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1291: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1292: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );

Line 1289: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );

1285:
1286: dbms_sql.define_column(vl_legis_cursor, 1, vl_legis_ref, 240);
1287: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );
1288: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1289: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1290: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1291: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1292: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1293: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );

Line 1290: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );

1286: dbms_sql.define_column(vl_legis_cursor, 1, vl_legis_ref, 240);
1287: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );
1288: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1289: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1290: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1291: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1292: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1293: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1294: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );

Line 1291: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );

1287: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );
1288: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1289: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1290: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1291: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1292: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1293: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1294: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );
1295: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_batch_id );

Line 1292: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );

1288: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1289: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1290: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1291: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1292: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1293: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1294: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );
1295: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_batch_id );
1296: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_sla_flag,1 );

Line 1293: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );

1289: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1290: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1291: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1292: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1293: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1294: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );
1295: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_batch_id );
1296: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_sla_flag,1 );
1297:

Line 1294: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );

1290: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1291: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1292: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1293: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1294: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );
1295: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_batch_id );
1296: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_sla_flag,1 );
1297:
1298: vl_count := 12;

Line 1295: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_batch_id );

1291: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1292: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1293: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1294: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );
1295: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_batch_id );
1296: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_sla_flag,1 );
1297:
1298: vl_count := 12;
1299:

Line 1296: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_sla_flag,1 );

1292: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1293: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1294: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );
1295: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_batch_id );
1296: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_sla_flag,1 );
1297:
1298: vl_count := 12;
1299:
1300: IF va_pl_code_col IS NOT NULL THEN

Line 1301: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_pl_code, 150);

1297:
1298: vl_count := 12;
1299:
1300: IF va_pl_code_col IS NOT NULL THEN
1301: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_pl_code, 150);
1302: vl_count := vl_count + 1;
1303: END IF;
1304:
1305: IF va_tr_main_acct_col IS NOT NULL THEN

Line 1306: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_tr_main_acct, 150);

1302: vl_count := vl_count + 1;
1303: END IF;
1304:
1305: IF va_tr_main_acct_col IS NOT NULL THEN
1306: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_tr_main_acct, 150);
1307: vl_count := vl_count + 1;
1308: END IF;
1309:
1310: IF va_tr_dept_id_col IS NOT NULL THEN

Line 1311: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_tr_dept_id, 150);

1307: vl_count := vl_count + 1;
1308: END IF;
1309:
1310: IF va_tr_dept_id_col IS NOT NULL THEN
1311: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_tr_dept_id, 150);
1312: vl_count := vl_count + 1;
1313: END IF;
1314:
1315: IF va_advance_type_col IS NOT NULL THEN

Line 1316: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_advance_type, 150);

1312: vl_count := vl_count + 1;
1313: END IF;
1314:
1315: IF va_advance_type_col IS NOT NULL THEN
1316: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_advance_type, 150);
1317: END IF;
1318:
1319: Begin
1320: vl_exec_ret := dbms_sql.execute(vl_legis_cursor);

Line 1320: vl_exec_ret := dbms_sql.execute(vl_legis_cursor);

1316: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_advance_type, 150);
1317: END IF;
1318:
1319: Begin
1320: vl_exec_ret := dbms_sql.execute(vl_legis_cursor);
1321: Exception
1322: When Others Then
1323: vp_retcode := sqlcode ;
1324: VP_ERRBUF := sqlerrm ;

Line 1332: if dbms_sql.fetch_rows(vl_legis_cursor) = 0 then

1328: End ;
1329: va_account_ctr := 0;
1330: Loop
1331: vl_exception_cat := 0;
1332: if dbms_sql.fetch_rows(vl_legis_cursor) = 0 then
1333: exit;
1334: End if;
1335:
1336: -- Fetch the Records into Variables

Line 1337: dbms_sql.column_value(vl_legis_cursor,1,vl_legis_ref);

1333: exit;
1334: End if;
1335:
1336: -- Fetch the Records into Variables
1337: dbms_sql.column_value(vl_legis_cursor,1,vl_legis_ref);
1338: dbms_sql.column_value(vl_legis_cursor,2,vl_legis_amount);
1339: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1340: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1341: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);

Line 1338: dbms_sql.column_value(vl_legis_cursor,2,vl_legis_amount);

1334: End if;
1335:
1336: -- Fetch the Records into Variables
1337: dbms_sql.column_value(vl_legis_cursor,1,vl_legis_ref);
1338: dbms_sql.column_value(vl_legis_cursor,2,vl_legis_amount);
1339: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1340: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1341: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1342: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);

Line 1339: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);

1335:
1336: -- Fetch the Records into Variables
1337: dbms_sql.column_value(vl_legis_cursor,1,vl_legis_ref);
1338: dbms_sql.column_value(vl_legis_cursor,2,vl_legis_amount);
1339: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1340: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1341: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1342: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1343: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);

Line 1340: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);

1336: -- Fetch the Records into Variables
1337: dbms_sql.column_value(vl_legis_cursor,1,vl_legis_ref);
1338: dbms_sql.column_value(vl_legis_cursor,2,vl_legis_amount);
1339: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1340: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1341: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1342: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1343: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1344:

Line 1341: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);

1337: dbms_sql.column_value(vl_legis_cursor,1,vl_legis_ref);
1338: dbms_sql.column_value(vl_legis_cursor,2,vl_legis_amount);
1339: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1340: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1341: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1342: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1343: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1344:
1345: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );

Line 1342: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);

1338: dbms_sql.column_value(vl_legis_cursor,2,vl_legis_amount);
1339: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1340: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1341: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1342: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1343: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1344:
1345: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );
1346: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_line_num );

Line 1343: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);

1339: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1340: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1341: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1342: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1343: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1344:
1345: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );
1346: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_line_num );
1347: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_batch_id );

Line 1345: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );

1341: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1342: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1343: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1344:
1345: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );
1346: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_line_num );
1347: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_batch_id );
1348: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_sla_flag );
1349:

Line 1346: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_line_num );

1342: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1343: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1344:
1345: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );
1346: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_line_num );
1347: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_batch_id );
1348: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_sla_flag );
1349:
1350: vl_count := 12;

Line 1347: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_batch_id );

1343: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1344:
1345: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );
1346: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_line_num );
1347: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_batch_id );
1348: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_sla_flag );
1349:
1350: vl_count := 12;
1351:

Line 1348: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_sla_flag );

1344:
1345: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );
1346: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_line_num );
1347: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_batch_id );
1348: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_sla_flag );
1349:
1350: vl_count := 12;
1351:
1352: IF va_pl_code_col IS NOT NULL THEN

Line 1353: dbms_sql.column_value(vl_legis_cursor, vl_count, vl_pl_code);

1349:
1350: vl_count := 12;
1351:
1352: IF va_pl_code_col IS NOT NULL THEN
1353: dbms_sql.column_value(vl_legis_cursor, vl_count, vl_pl_code);
1354: vl_count := vl_count + 1;
1355: END IF;
1356:
1357: IF va_tr_main_acct_col IS NOT NULL THEN

Line 1358: dbms_sql.column_value(vl_legis_cursor, vl_count, vl_tr_main_acct);

1354: vl_count := vl_count + 1;
1355: END IF;
1356:
1357: IF va_tr_main_acct_col IS NOT NULL THEN
1358: dbms_sql.column_value(vl_legis_cursor, vl_count, vl_tr_main_acct);
1359: vl_count := vl_count + 1;
1360: END IF;
1361:
1362: IF va_tr_dept_id_col IS NOT NULL THEN

Line 1363: dbms_sql.column_value(vl_legis_cursor, vl_count, vl_tr_dept_id);

1359: vl_count := vl_count + 1;
1360: END IF;
1361:
1362: IF va_tr_dept_id_col IS NOT NULL THEN
1363: dbms_sql.column_value(vl_legis_cursor, vl_count, vl_tr_dept_id);
1364: vl_count := vl_count + 1;
1365: END IF;
1366:
1367: IF va_advance_type_col IS NOT NULL THEN

Line 1368: dbms_sql.column_value(vl_legis_cursor, vl_count, vl_advance_type);

1364: vl_count := vl_count + 1;
1365: END IF;
1366:
1367: IF va_advance_type_col IS NOT NULL THEN
1368: dbms_sql.column_value(vl_legis_cursor, vl_count, vl_advance_type);
1369: END IF;
1370:
1371: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1372: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 1577: dbms_sql.Close_Cursor(vl_legis_cursor);

1573: End Loop; -- legis cur ;
1574:
1575: -- Close the Legislative Indicator Cursor
1576: Begin
1577: dbms_sql.Close_Cursor(vl_legis_cursor);
1578: Exception
1579: When Others Then
1580: vp_retcode := sqlcode ;
1581: VP_ERRBUF := sqlerrm ;

Line 1633: vl_appor_cursor := DBMS_SQL.OPEN_CURSOR ;

1629:
1630: If v_catb_prg_seg_name IS NOT NULL OR
1631: v_prn_prg_seg_name IS NOT NULL Then
1632: Begin
1633: vl_appor_cursor := DBMS_SQL.OPEN_CURSOR ;
1634: Exception
1635: When Others Then
1636: vp_retcode := sqlcode ;
1637: VP_ERRBUF := sqlerrm ;

Line 1656: dbms_sql.parse(vl_appor_cursor,vl_appor_select,

1652: v_fiscal_yr,
1653: vl_appor_period,
1654: vl_appor_select) ;
1655: Begin
1656: dbms_sql.parse(vl_appor_cursor,vl_appor_select,
1657: DBMS_SQL.V7);
1658: Exception
1659: When Others Then
1660: vp_retcode := sqlcode ;

Line 1657: DBMS_SQL.V7);

1653: vl_appor_period,
1654: vl_appor_select) ;
1655: Begin
1656: dbms_sql.parse(vl_appor_cursor,vl_appor_select,
1657: DBMS_SQL.V7);
1658: Exception
1659: When Others Then
1660: vp_retcode := sqlcode ;
1661: vp_errbuf := sqlerrm || ' [MAIN - APPOR]' ;

Line 1668: dbms_sql.bind_variable(vl_appor_cursor, ':ccid', vl_ccid);

1664: Return ;
1665: End ;
1666:
1667: -- Bind the variables
1668: dbms_sql.bind_variable(vl_appor_cursor, ':ccid', vl_ccid);
1669: dbms_sql.bind_variable(vl_appor_cursor, ':actual_flag', 'A');
1670: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1671: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1672: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);

Line 1669: dbms_sql.bind_variable(vl_appor_cursor, ':actual_flag', 'A');

1665: End ;
1666:
1667: -- Bind the variables
1668: dbms_sql.bind_variable(vl_appor_cursor, ':ccid', vl_ccid);
1669: dbms_sql.bind_variable(vl_appor_cursor, ':actual_flag', 'A');
1670: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1671: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1672: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1673: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);

Line 1670: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);

1666:
1667: -- Bind the variables
1668: dbms_sql.bind_variable(vl_appor_cursor, ':ccid', vl_ccid);
1669: dbms_sql.bind_variable(vl_appor_cursor, ':actual_flag', 'A');
1670: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1671: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1672: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1673: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);
1674: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',

Line 1671: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);

1667: -- Bind the variables
1668: dbms_sql.bind_variable(vl_appor_cursor, ':ccid', vl_ccid);
1669: dbms_sql.bind_variable(vl_appor_cursor, ':actual_flag', 'A');
1670: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1671: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1672: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1673: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);
1674: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',
1675: vp_report_fiscal_yr);

Line 1672: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);

1668: dbms_sql.bind_variable(vl_appor_cursor, ':ccid', vl_ccid);
1669: dbms_sql.bind_variable(vl_appor_cursor, ':actual_flag', 'A');
1670: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1671: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1672: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1673: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);
1674: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',
1675: vp_report_fiscal_yr);
1676: dbms_sql.bind_variable(vl_appor_cursor, ':set_of_books_id',

Line 1673: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);

1669: dbms_sql.bind_variable(vl_appor_cursor, ':actual_flag', 'A');
1670: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1671: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1672: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1673: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);
1674: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',
1675: vp_report_fiscal_yr);
1676: dbms_sql.bind_variable(vl_appor_cursor, ':set_of_books_id',
1677: vp_set_of_books_id);

Line 1674: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',

1670: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1671: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1672: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1673: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);
1674: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',
1675: vp_report_fiscal_yr);
1676: dbms_sql.bind_variable(vl_appor_cursor, ':set_of_books_id',
1677: vp_set_of_books_id);
1678: dbms_sql.bind_variable(vl_appor_cursor, ':currency_code',

Line 1676: dbms_sql.bind_variable(vl_appor_cursor, ':set_of_books_id',

1672: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1673: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);
1674: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',
1675: vp_report_fiscal_yr);
1676: dbms_sql.bind_variable(vl_appor_cursor, ':set_of_books_id',
1677: vp_set_of_books_id);
1678: dbms_sql.bind_variable(vl_appor_cursor, ':currency_code',
1679: vp_currency_code);
1680:

Line 1678: dbms_sql.bind_variable(vl_appor_cursor, ':currency_code',

1674: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',
1675: vp_report_fiscal_yr);
1676: dbms_sql.bind_variable(vl_appor_cursor, ':set_of_books_id',
1677: vp_set_of_books_id);
1678: dbms_sql.bind_variable(vl_appor_cursor, ':currency_code',
1679: vp_currency_code);
1680:
1681:
1682: dbms_sql.define_column(vl_appor_cursor,1,vl_acct_num,25);

Line 1682: dbms_sql.define_column(vl_appor_cursor,1,vl_acct_num,25);

1678: dbms_sql.bind_variable(vl_appor_cursor, ':currency_code',
1679: vp_currency_code);
1680:
1681:
1682: dbms_sql.define_column(vl_appor_cursor,1,vl_acct_num,25);
1683: dbms_sql.define_column(vl_appor_cursor,2,vl_fund_value,25);
1684: vl_counter := 3;
1685:
1686: IF v_catb_prg_seg_name IS NOT NULL THEN

Line 1683: dbms_sql.define_column(vl_appor_cursor,2,vl_fund_value,25);

1679: vp_currency_code);
1680:
1681:
1682: dbms_sql.define_column(vl_appor_cursor,1,vl_acct_num,25);
1683: dbms_sql.define_column(vl_appor_cursor,2,vl_fund_value,25);
1684: vl_counter := 3;
1685:
1686: IF v_catb_prg_seg_name IS NOT NULL THEN
1687: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_catb_program,25);

Line 1687: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_catb_program,25);

1683: dbms_sql.define_column(vl_appor_cursor,2,vl_fund_value,25);
1684: vl_counter := 3;
1685:
1686: IF v_catb_prg_seg_name IS NOT NULL THEN
1687: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_catb_program,25);
1688: vl_counter := vl_counter + 1;
1689: END IF;
1690:
1691: IF v_prn_prg_seg_name IS NOT NULL THEN

Line 1692: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_prn_program,25);

1688: vl_counter := vl_counter + 1;
1689: END IF;
1690:
1691: IF v_prn_prg_seg_name IS NOT NULL THEN
1692: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_prn_program,25);
1693: vl_counter := vl_counter + 1;
1694: END IF;
1695:
1696: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_amount);

Line 1696: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_amount);

1692: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_prn_program,25);
1693: vl_counter := vl_counter + 1;
1694: END IF;
1695:
1696: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_amount);
1697: vl_counter := vl_counter + 1;
1698: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_period_activity);
1699: vl_counter := vl_counter + 1;
1700: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_dr);

Line 1698: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_period_activity);

1694: END IF;
1695:
1696: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_amount);
1697: vl_counter := vl_counter + 1;
1698: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_period_activity);
1699: vl_counter := vl_counter + 1;
1700: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_dr);
1701: vl_counter := vl_counter + 1;
1702: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_cr);

Line 1700: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_dr);

1696: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_amount);
1697: vl_counter := vl_counter + 1;
1698: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_period_activity);
1699: vl_counter := vl_counter + 1;
1700: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_dr);
1701: vl_counter := vl_counter + 1;
1702: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_cr);
1703: vl_counter := vl_counter + 1;
1704:

Line 1702: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_cr);

1698: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_period_activity);
1699: vl_counter := vl_counter + 1;
1700: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_dr);
1701: vl_counter := vl_counter + 1;
1702: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_cr);
1703: vl_counter := vl_counter + 1;
1704:
1705: If v_cohort_Seg_name is not null Then
1706: dbms_sql.define_column(vl_appor_cursor, vl_counter, vl_cohort_yr, 25);

Line 1706: dbms_sql.define_column(vl_appor_cursor, vl_counter, vl_cohort_yr, 25);

1702: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_cr);
1703: vl_counter := vl_counter + 1;
1704:
1705: If v_cohort_Seg_name is not null Then
1706: dbms_sql.define_column(vl_appor_cursor, vl_counter, vl_cohort_yr, 25);
1707: end If ;
1708:
1709: Begin
1710: vl_exec_ret := dbms_sql.execute(vl_appor_cursor);

Line 1710: vl_exec_ret := dbms_sql.execute(vl_appor_cursor);

1706: dbms_sql.define_column(vl_appor_cursor, vl_counter, vl_cohort_yr, 25);
1707: end If ;
1708:
1709: Begin
1710: vl_exec_ret := dbms_sql.execute(vl_appor_cursor);
1711: Exception
1712: When Others Then
1713: vp_retcode := sqlcode ;
1714: vp_errbuf := sqlerrm||'[execute_vl_appor_cursor]' ;

Line 1724: if dbms_sql.fetch_rows(vl_appor_cursor) = 0 then

1720: --------------------------------------------------------------------------
1721: -- Reset the counter for apportionment cat b Dtl
1722: -- vl_appor_ctr := 0 ;
1723: LOOP
1724: if dbms_sql.fetch_rows(vl_appor_cursor) = 0 then
1725: exit;
1726: else
1727: -- Fetch the Records into Variables
1728: dbms_sql.column_value(vl_appor_cursor,1,vl_acct_num);

Line 1728: dbms_sql.column_value(vl_appor_cursor,1,vl_acct_num);

1724: if dbms_sql.fetch_rows(vl_appor_cursor) = 0 then
1725: exit;
1726: else
1727: -- Fetch the Records into Variables
1728: dbms_sql.column_value(vl_appor_cursor,1,vl_acct_num);
1729: dbms_sql.column_value(vl_appor_cursor,2,vl_fund_value);
1730:
1731: vl_counter := 3;
1732: IF v_catb_prg_seg_name IS NOT NULL THEN

Line 1729: dbms_sql.column_value(vl_appor_cursor,2,vl_fund_value);

1725: exit;
1726: else
1727: -- Fetch the Records into Variables
1728: dbms_sql.column_value(vl_appor_cursor,1,vl_acct_num);
1729: dbms_sql.column_value(vl_appor_cursor,2,vl_fund_value);
1730:
1731: vl_counter := 3;
1732: IF v_catb_prg_seg_name IS NOT NULL THEN
1733: dbms_sql.column_value(vl_appor_cursor,vl_counter,vl_catb_program);

Line 1733: dbms_sql.column_value(vl_appor_cursor,vl_counter,vl_catb_program);

1729: dbms_sql.column_value(vl_appor_cursor,2,vl_fund_value);
1730:
1731: vl_counter := 3;
1732: IF v_catb_prg_seg_name IS NOT NULL THEN
1733: dbms_sql.column_value(vl_appor_cursor,vl_counter,vl_catb_program);
1734: vl_counter := vl_counter + 1;
1735: END IF;
1736:
1737: IF v_prn_prg_seg_name IS NOT NULL THEN

Line 1738: dbms_sql.column_value(vl_appor_cursor,vl_counter,vl_prn_program);

1734: vl_counter := vl_counter + 1;
1735: END IF;
1736:
1737: IF v_prn_prg_seg_name IS NOT NULL THEN
1738: dbms_sql.column_value(vl_appor_cursor,vl_counter,vl_prn_program);
1739: vl_counter := vl_counter + 1;
1740: END IF;
1741:
1742: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_amount);

Line 1742: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_amount);

1738: dbms_sql.column_value(vl_appor_cursor,vl_counter,vl_prn_program);
1739: vl_counter := vl_counter + 1;
1740: END IF;
1741:
1742: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_amount);
1743: vl_counter := vl_counter + 1;
1744:
1745: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_activity);
1746: vl_counter := vl_counter + 1;

Line 1745: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_activity);

1741:
1742: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_amount);
1743: vl_counter := vl_counter + 1;
1744:
1745: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_activity);
1746: vl_counter := vl_counter + 1;
1747:
1748: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_dr);
1749: vl_counter := vl_counter + 1;

Line 1748: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_dr);

1744:
1745: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_activity);
1746: vl_counter := vl_counter + 1;
1747:
1748: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_dr);
1749: vl_counter := vl_counter + 1;
1750:
1751: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_cr);
1752: vl_counter := vl_counter + 1;

Line 1751: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_cr);

1747:
1748: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_dr);
1749: vl_counter := vl_counter + 1;
1750:
1751: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_cr);
1752: vl_counter := vl_counter + 1;
1753:
1754: If v_cohort_Seg_name is not null Then
1755: -- vl_counter := vl_counter + 1;

Line 1756: dbms_sql.column_value(vl_appor_cursor,vl_counter, vl_cohort_yr);

1752: vl_counter := vl_counter + 1;
1753:
1754: If v_cohort_Seg_name is not null Then
1755: -- vl_counter := vl_counter + 1;
1756: dbms_sql.column_value(vl_appor_cursor,vl_counter, vl_cohort_yr);
1757: end If ;
1758: -- vl_appor_ctr := vl_appor_ctr + 1 ;
1759: -- Get_Appor_Cat_B_Text(vl_program) ;
1760:

Line 1807: dbms_sql.Close_Cursor(vl_appor_cursor);

1803: -------------------------------------------------------------------
1804:
1805: -- Close the Apportionment Category Cursor
1806: Begin
1807: dbms_sql.Close_Cursor(vl_appor_cursor);
1808: Exception
1809: When Others Then
1810: vp_retcode := sqlcode ;
1811: VP_ERRBUF := sqlerrm||'[vl_appor_cursor]' ;

Line 1856: dbms_sql.Close_Cursor(vl_main_cursor);

1852:
1853:
1854: -- Close the Main Cursor
1855: Begin
1856: dbms_sql.Close_Cursor(vl_main_cursor);
1857: Exception
1858: When Others Then
1859: vp_retcode := sqlcode ;
1860: VP_ERRBUF := sqlerrm||'[vl_main_cursor]' ;

Line 2237: vl_bal_cursor := DBMS_SQL.OPEN_CURSOR ;

2233: das_where VARCHAR2(600);
2234:
2235: BEGIN
2236: Begin
2237: vl_bal_cursor := DBMS_SQL.OPEN_CURSOR ;
2238: Exception
2239: When Others Then
2240: vp_retcode := sqlcode ;
2241: vp_errbuf := sqlerrm || ' [CALC_BALANCE - Open Cursor] ' ;

Line 2289: dbms_sql.parse(vl_bal_cursor, vl_bal_select, DBMS_SQL.V7) ;

2285: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'mg calc '||vl_bal_select) ;
2286: END IF;
2287:
2288: Begin
2289: dbms_sql.parse(vl_bal_cursor, vl_bal_select, DBMS_SQL.V7) ;
2290: Exception
2291: When Others Then
2292: vp_retcode := sqlcode ;
2293: vp_errbuf := sqlerrm || ' [CALC_BALANCE - Parse] ' ;

Line 2299: dbms_sql.bind_variable(vl_bal_cursor,':ccid', ccid);

2295: return;
2296: End ;
2297:
2298: -- Bind the variables
2299: dbms_sql.bind_variable(vl_bal_cursor,':ccid', ccid);
2300: dbms_sql.bind_variable(vl_bal_cursor,':actual_flag', 'A');
2301: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2302: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2303: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);

Line 2300: dbms_sql.bind_variable(vl_bal_cursor,':actual_flag', 'A');

2296: End ;
2297:
2298: -- Bind the variables
2299: dbms_sql.bind_variable(vl_bal_cursor,':ccid', ccid);
2300: dbms_sql.bind_variable(vl_bal_cursor,':actual_flag', 'A');
2301: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2302: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2303: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2304: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);

Line 2301: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);

2297:
2298: -- Bind the variables
2299: dbms_sql.bind_variable(vl_bal_cursor,':ccid', ccid);
2300: dbms_sql.bind_variable(vl_bal_cursor,':actual_flag', 'A');
2301: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2302: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2303: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2304: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2305: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);

Line 2302: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);

2298: -- Bind the variables
2299: dbms_sql.bind_variable(vl_bal_cursor,':ccid', ccid);
2300: dbms_sql.bind_variable(vl_bal_cursor,':actual_flag', 'A');
2301: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2302: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2303: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2304: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2305: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);
2306: dbms_sql.bind_variable(vl_bal_cursor,':period_year', period_year);

Line 2303: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);

2299: dbms_sql.bind_variable(vl_bal_cursor,':ccid', ccid);
2300: dbms_sql.bind_variable(vl_bal_cursor,':actual_flag', 'A');
2301: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2302: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2303: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2304: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2305: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);
2306: dbms_sql.bind_variable(vl_bal_cursor,':period_year', period_year);
2307: dbms_sql.bind_variable(vl_bal_cursor,':currency_code', vp_currency_code);

Line 2304: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);

2300: dbms_sql.bind_variable(vl_bal_cursor,':actual_flag', 'A');
2301: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2302: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2303: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2304: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2305: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);
2306: dbms_sql.bind_variable(vl_bal_cursor,':period_year', period_year);
2307: dbms_sql.bind_variable(vl_bal_cursor,':currency_code', vp_currency_code);
2308:

Line 2305: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);

2301: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2302: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2303: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2304: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2305: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);
2306: dbms_sql.bind_variable(vl_bal_cursor,':period_year', period_year);
2307: dbms_sql.bind_variable(vl_bal_cursor,':currency_code', vp_currency_code);
2308:
2309:

Line 2306: dbms_sql.bind_variable(vl_bal_cursor,':period_year', period_year);

2302: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2303: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2304: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2305: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);
2306: dbms_sql.bind_variable(vl_bal_cursor,':period_year', period_year);
2307: dbms_sql.bind_variable(vl_bal_cursor,':currency_code', vp_currency_code);
2308:
2309:
2310:

Line 2307: dbms_sql.bind_variable(vl_bal_cursor,':currency_code', vp_currency_code);

2303: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2304: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2305: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);
2306: dbms_sql.bind_variable(vl_bal_cursor,':period_year', period_year);
2307: dbms_sql.bind_variable(vl_bal_cursor,':currency_code', vp_currency_code);
2308:
2309:
2310:
2311: dbms_sql.define_column(vl_bal_cursor, 1, amount);

Line 2311: dbms_sql.define_column(vl_bal_cursor, 1, amount);

2307: dbms_sql.bind_variable(vl_bal_cursor,':currency_code', vp_currency_code);
2308:
2309:
2310:
2311: dbms_sql.define_column(vl_bal_cursor, 1, amount);
2312: dbms_sql.define_column(vl_bal_cursor, 2, period_activity);
2313: dbms_sql.define_column(vl_bal_cursor, 3, v_period_dr);
2314: dbms_sql.define_column(vl_bal_cursor, 4, v_period_cr);
2315: Begin

Line 2312: dbms_sql.define_column(vl_bal_cursor, 2, period_activity);

2308:
2309:
2310:
2311: dbms_sql.define_column(vl_bal_cursor, 1, amount);
2312: dbms_sql.define_column(vl_bal_cursor, 2, period_activity);
2313: dbms_sql.define_column(vl_bal_cursor, 3, v_period_dr);
2314: dbms_sql.define_column(vl_bal_cursor, 4, v_period_cr);
2315: Begin
2316: vl_exec_ret := dbms_sql.execute(vl_bal_cursor);

Line 2313: dbms_sql.define_column(vl_bal_cursor, 3, v_period_dr);

2309:
2310:
2311: dbms_sql.define_column(vl_bal_cursor, 1, amount);
2312: dbms_sql.define_column(vl_bal_cursor, 2, period_activity);
2313: dbms_sql.define_column(vl_bal_cursor, 3, v_period_dr);
2314: dbms_sql.define_column(vl_bal_cursor, 4, v_period_cr);
2315: Begin
2316: vl_exec_ret := dbms_sql.execute(vl_bal_cursor);
2317: Exception

Line 2314: dbms_sql.define_column(vl_bal_cursor, 4, v_period_cr);

2310:
2311: dbms_sql.define_column(vl_bal_cursor, 1, amount);
2312: dbms_sql.define_column(vl_bal_cursor, 2, period_activity);
2313: dbms_sql.define_column(vl_bal_cursor, 3, v_period_dr);
2314: dbms_sql.define_column(vl_bal_cursor, 4, v_period_cr);
2315: Begin
2316: vl_exec_ret := dbms_sql.execute(vl_bal_cursor);
2317: Exception
2318: When Others Then

Line 2316: vl_exec_ret := dbms_sql.execute(vl_bal_cursor);

2312: dbms_sql.define_column(vl_bal_cursor, 2, period_activity);
2313: dbms_sql.define_column(vl_bal_cursor, 3, v_period_dr);
2314: dbms_sql.define_column(vl_bal_cursor, 4, v_period_cr);
2315: Begin
2316: vl_exec_ret := dbms_sql.execute(vl_bal_cursor);
2317: Exception
2318: When Others Then
2319: vp_retcode := sqlcode ;
2320: vp_errbuf := sqlerrm || ' [CALC_BALANCE - Execute Cursor] ' ;

Line 2324: if dbms_sql.fetch_rows(vl_bal_cursor) = 0 then

2320: vp_errbuf := sqlerrm || ' [CALC_BALANCE - Execute Cursor] ' ;
2321: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.execute_vl_bal_cursor', vp_errbuf) ;
2322: End ;
2323: Loop
2324: if dbms_sql.fetch_rows(vl_bal_cursor) = 0 then
2325: exit;
2326: else
2327: -- Fetch the Records into Variables
2328: dbms_sql.column_value(vl_bal_cursor, 1, amount);

Line 2328: dbms_sql.column_value(vl_bal_cursor, 1, amount);

2324: if dbms_sql.fetch_rows(vl_bal_cursor) = 0 then
2325: exit;
2326: else
2327: -- Fetch the Records into Variables
2328: dbms_sql.column_value(vl_bal_cursor, 1, amount);
2329: dbms_sql.column_value(vl_bal_cursor, 2, period_activity);
2330: dbms_sql.column_value(vl_bal_cursor, 3, v_period_dr);
2331: dbms_sql.column_value(vl_bal_cursor, 4, v_period_cr);
2332: end if;

Line 2329: dbms_sql.column_value(vl_bal_cursor, 2, period_activity);

2325: exit;
2326: else
2327: -- Fetch the Records into Variables
2328: dbms_sql.column_value(vl_bal_cursor, 1, amount);
2329: dbms_sql.column_value(vl_bal_cursor, 2, period_activity);
2330: dbms_sql.column_value(vl_bal_cursor, 3, v_period_dr);
2331: dbms_sql.column_value(vl_bal_cursor, 4, v_period_cr);
2332: end if;
2333: End Loop ;

Line 2330: dbms_sql.column_value(vl_bal_cursor, 3, v_period_dr);

2326: else
2327: -- Fetch the Records into Variables
2328: dbms_sql.column_value(vl_bal_cursor, 1, amount);
2329: dbms_sql.column_value(vl_bal_cursor, 2, period_activity);
2330: dbms_sql.column_value(vl_bal_cursor, 3, v_period_dr);
2331: dbms_sql.column_value(vl_bal_cursor, 4, v_period_cr);
2332: end if;
2333: End Loop ;
2334: -- Close the Balance Cursor

Line 2331: dbms_sql.column_value(vl_bal_cursor, 4, v_period_cr);

2327: -- Fetch the Records into Variables
2328: dbms_sql.column_value(vl_bal_cursor, 1, amount);
2329: dbms_sql.column_value(vl_bal_cursor, 2, period_activity);
2330: dbms_sql.column_value(vl_bal_cursor, 3, v_period_dr);
2331: dbms_sql.column_value(vl_bal_cursor, 4, v_period_cr);
2332: end if;
2333: End Loop ;
2334: -- Close the Balance Cursor
2335: Begin

Line 2336: dbms_sql.Close_Cursor(vl_bal_cursor);

2332: end if;
2333: End Loop ;
2334: -- Close the Balance Cursor
2335: Begin
2336: dbms_sql.Close_Cursor(vl_bal_cursor);
2337: Exception
2338: When Others Then
2339: vp_retcode := sqlcode ;
2340: VP_ERRBUF := sqlerrm ;

Line 2997: vl_rollup_cursor := DBMS_SQL.OPEN_CURSOR;

2993: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2994: 'Group by ' || vl_group_by);
2995: END IF;
2996:
2997: vl_rollup_cursor := DBMS_SQL.OPEN_CURSOR;
2998:
2999: vl_rollup := '
3000: INSERT INTO FV_FACTS_TEMP
3001: (TREASURY_SYMBOL_ID ,

Line 3103: dbms_sql.parse(vl_rollup_cursor, vl_rollup, DBMS_SQL.V7) ;

3099:
3100: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3101: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, vl_rollup);
3102: END IF;
3103: dbms_sql.parse(vl_rollup_cursor, vl_rollup, DBMS_SQL.V7) ;
3104: vl_exec_ret := dbms_sql.execute(vl_rollup_cursor);
3105: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3106: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' No of records rolled up '
3107: || vl_exec_ret);

Line 3104: vl_exec_ret := dbms_sql.execute(vl_rollup_cursor);

3100: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3101: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, vl_rollup);
3102: END IF;
3103: dbms_sql.parse(vl_rollup_cursor, vl_rollup, DBMS_SQL.V7) ;
3104: vl_exec_ret := dbms_sql.execute(vl_rollup_cursor);
3105: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3106: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' No of records rolled up '
3107: || vl_exec_ret);
3108: END IF;