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 824: vl_main_cursor := DBMS_SQL.OPEN_CURSOR ;

820: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
821: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Selecting FACTS Transactions.....') ;
822: END IF;
823: Begin
824: vl_main_cursor := DBMS_SQL.OPEN_CURSOR ;
825: Exception
826: When Others Then
827: vp_retcode := sqlcode ;
828: VP_ERRBUF := sqlerrm ;

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

881: || v_segment ||v_cohort_select ||
882: ' ORDER BY GLCC.' || v_acc_seg_name ;
883:
884: Begin
885: dbms_sql.parse(vl_main_cursor, vl_main_select, DBMS_SQL.V7) ;
886: Exception
887: When Others Then
888: vp_retcode := sqlcode ;
889: VP_ERRBUF := sqlerrm ;

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

892: Return ;
893: End ;
894:
895: -- Bind the variables
896: dbms_sql.bind_variable(vl_main_cursor,':actual_flag', 'A');
897: dbms_sql.bind_variable(vl_main_cursor,':fund_value', v_fund_value);
898: dbms_sql.bind_variable(vl_main_cursor,':set_of_books_id', vp_set_of_books_id);
899: dbms_sql.bind_variable(vl_main_cursor,':report_fiscal_yr', vp_report_fiscal_yr);
900: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);

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

893: End ;
894:
895: -- Bind the variables
896: dbms_sql.bind_variable(vl_main_cursor,':actual_flag', 'A');
897: dbms_sql.bind_variable(vl_main_cursor,':fund_value', v_fund_value);
898: dbms_sql.bind_variable(vl_main_cursor,':set_of_books_id', vp_set_of_books_id);
899: dbms_sql.bind_variable(vl_main_cursor,':report_fiscal_yr', vp_report_fiscal_yr);
900: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);
901:

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

894:
895: -- Bind the variables
896: dbms_sql.bind_variable(vl_main_cursor,':actual_flag', 'A');
897: dbms_sql.bind_variable(vl_main_cursor,':fund_value', v_fund_value);
898: dbms_sql.bind_variable(vl_main_cursor,':set_of_books_id', vp_set_of_books_id);
899: dbms_sql.bind_variable(vl_main_cursor,':report_fiscal_yr', vp_report_fiscal_yr);
900: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);
901:
902: fv_utility.log_mesg('fund_value :: vp_set_of_books_id::vp_report_fiscal_yr::'||v_fund_value||'|'||vp_set_of_books_id||'|'||vp_report_fiscal_yr);

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

895: -- Bind the variables
896: dbms_sql.bind_variable(vl_main_cursor,':actual_flag', 'A');
897: dbms_sql.bind_variable(vl_main_cursor,':fund_value', v_fund_value);
898: dbms_sql.bind_variable(vl_main_cursor,':set_of_books_id', vp_set_of_books_id);
899: dbms_sql.bind_variable(vl_main_cursor,':report_fiscal_yr', vp_report_fiscal_yr);
900: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);
901:
902: fv_utility.log_mesg('fund_value :: vp_set_of_books_id::vp_report_fiscal_yr::'||v_fund_value||'|'||vp_set_of_books_id||'|'||vp_report_fiscal_yr);
903: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);

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

896: dbms_sql.bind_variable(vl_main_cursor,':actual_flag', 'A');
897: dbms_sql.bind_variable(vl_main_cursor,':fund_value', v_fund_value);
898: dbms_sql.bind_variable(vl_main_cursor,':set_of_books_id', vp_set_of_books_id);
899: dbms_sql.bind_variable(vl_main_cursor,':report_fiscal_yr', vp_report_fiscal_yr);
900: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);
901:
902: fv_utility.log_mesg('fund_value :: vp_set_of_books_id::vp_report_fiscal_yr::'||v_fund_value||'|'||vp_set_of_books_id||'|'||vp_report_fiscal_yr);
903: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);
904: dbms_sql.define_column(vl_main_cursor, 2, vl_acct_num, 25);

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

899: dbms_sql.bind_variable(vl_main_cursor,':report_fiscal_yr', vp_report_fiscal_yr);
900: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);
901:
902: fv_utility.log_mesg('fund_value :: vp_set_of_books_id::vp_report_fiscal_yr::'||v_fund_value||'|'||vp_set_of_books_id||'|'||vp_report_fiscal_yr);
903: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);
904: dbms_sql.define_column(vl_main_cursor, 2, vl_acct_num, 25);
905: dbms_sql.define_column(vl_main_cursor, 3, vl_fund_value, 25);
906: dbms_sql.define_column(vl_main_cursor, 4, v_fiscal_yr, 25);
907: dbms_sql.define_column(vl_main_cursor, 5, vg_amount);

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

900: dbms_sql.bind_variable(vl_main_cursor,':currency_code', vp_currency_code);
901:
902: fv_utility.log_mesg('fund_value :: vp_set_of_books_id::vp_report_fiscal_yr::'||v_fund_value||'|'||vp_set_of_books_id||'|'||vp_report_fiscal_yr);
903: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);
904: dbms_sql.define_column(vl_main_cursor, 2, vl_acct_num, 25);
905: dbms_sql.define_column(vl_main_cursor, 3, vl_fund_value, 25);
906: dbms_sql.define_column(vl_main_cursor, 4, v_fiscal_yr, 25);
907: dbms_sql.define_column(vl_main_cursor, 5, vg_amount);
908: -- Added by 7324248

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

901:
902: fv_utility.log_mesg('fund_value :: vp_set_of_books_id::vp_report_fiscal_yr::'||v_fund_value||'|'||vp_set_of_books_id||'|'||vp_report_fiscal_yr);
903: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);
904: dbms_sql.define_column(vl_main_cursor, 2, vl_acct_num, 25);
905: dbms_sql.define_column(vl_main_cursor, 3, vl_fund_value, 25);
906: dbms_sql.define_column(vl_main_cursor, 4, v_fiscal_yr, 25);
907: dbms_sql.define_column(vl_main_cursor, 5, vg_amount);
908: -- Added by 7324248
909: l_counter := 6;

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

902: fv_utility.log_mesg('fund_value :: vp_set_of_books_id::vp_report_fiscal_yr::'||v_fund_value||'|'||vp_set_of_books_id||'|'||vp_report_fiscal_yr);
903: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);
904: dbms_sql.define_column(vl_main_cursor, 2, vl_acct_num, 25);
905: dbms_sql.define_column(vl_main_cursor, 3, vl_fund_value, 25);
906: dbms_sql.define_column(vl_main_cursor, 4, v_fiscal_yr, 25);
907: dbms_sql.define_column(vl_main_cursor, 5, vg_amount);
908: -- Added by 7324248
909: l_counter := 6;
910:

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

903: dbms_sql.define_column(vl_main_cursor, 1, vl_ccid);
904: dbms_sql.define_column(vl_main_cursor, 2, vl_acct_num, 25);
905: dbms_sql.define_column(vl_main_cursor, 3, vl_fund_value, 25);
906: dbms_sql.define_column(vl_main_cursor, 4, v_fiscal_yr, 25);
907: dbms_sql.define_column(vl_main_cursor, 5, vg_amount);
908: -- Added by 7324248
909: l_counter := 6;
910:
911: IF v_cohort_seg_name IS NOT NULL THEN

Line 912: dbms_sql.define_column(vl_main_cursor, l_counter, vl_cohort_yr, 25);

908: -- Added by 7324248
909: l_counter := 6;
910:
911: IF v_cohort_seg_name IS NOT NULL THEN
912: dbms_sql.define_column(vl_main_cursor, l_counter, vl_cohort_yr, 25);
913: l_counter:=l_counter+1;
914: END IF;
915:
916: Begin

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

913: l_counter:=l_counter+1;
914: END IF;
915:
916: Begin
917: vl_exec_ret := dbms_sql.execute(vl_main_cursor);
918: Exception
919: When Others Then
920: vp_retcode := sqlcode ;
921: VP_ERRBUF := sqlerrm ;

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

965:
966: v_period_dr := 0;
967: v_period_cr := 0;
968:
969: vl_main_fetch := dbms_sql.fetch_rows(vl_main_cursor) ;
970:
971: IF (VL_MAIN_FETCH = 0) then
972: exit;
973: End if;

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

976: -- Increase the counter for number of records
977: vl_row_count := vl_row_count + 1 ;
978:
979: -- Fetch the Records into Variables
980: dbms_sql.column_value(vl_main_cursor, 1, vl_ccid);
981: dbms_sql.column_value(vl_main_cursor, 2, vl_acct_num);
982: dbms_sql.column_value(vl_main_cursor, 3, vl_fund_value);
983: dbms_sql.column_value(vl_main_cursor, 4, v_fiscal_yr);
984: dbms_sql.column_value(vl_main_cursor, 5, vg_amount);

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

977: vl_row_count := vl_row_count + 1 ;
978:
979: -- Fetch the Records into Variables
980: dbms_sql.column_value(vl_main_cursor, 1, vl_ccid);
981: dbms_sql.column_value(vl_main_cursor, 2, vl_acct_num);
982: dbms_sql.column_value(vl_main_cursor, 3, vl_fund_value);
983: dbms_sql.column_value(vl_main_cursor, 4, v_fiscal_yr);
984: dbms_sql.column_value(vl_main_cursor, 5, vg_amount);
985:

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

978:
979: -- Fetch the Records into Variables
980: dbms_sql.column_value(vl_main_cursor, 1, vl_ccid);
981: dbms_sql.column_value(vl_main_cursor, 2, vl_acct_num);
982: dbms_sql.column_value(vl_main_cursor, 3, vl_fund_value);
983: dbms_sql.column_value(vl_main_cursor, 4, v_fiscal_yr);
984: dbms_sql.column_value(vl_main_cursor, 5, vg_amount);
985:
986: -- Added by 7324248

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

979: -- Fetch the Records into Variables
980: dbms_sql.column_value(vl_main_cursor, 1, vl_ccid);
981: dbms_sql.column_value(vl_main_cursor, 2, vl_acct_num);
982: dbms_sql.column_value(vl_main_cursor, 3, vl_fund_value);
983: dbms_sql.column_value(vl_main_cursor, 4, v_fiscal_yr);
984: dbms_sql.column_value(vl_main_cursor, 5, vg_amount);
985:
986: -- Added by 7324248
987: l_counter := 6;

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

980: dbms_sql.column_value(vl_main_cursor, 1, vl_ccid);
981: dbms_sql.column_value(vl_main_cursor, 2, vl_acct_num);
982: dbms_sql.column_value(vl_main_cursor, 3, vl_fund_value);
983: dbms_sql.column_value(vl_main_cursor, 4, v_fiscal_yr);
984: dbms_sql.column_value(vl_main_cursor, 5, vg_amount);
985:
986: -- Added by 7324248
987: l_counter := 6;
988:

Line 990: dbms_sql.column_value(vl_main_cursor, l_counter, vl_cohort_yr);

986: -- Added by 7324248
987: l_counter := 6;
988:
989: IF v_cohort_seg_name IS NOT NULL THEN
990: dbms_sql.column_value(vl_main_cursor, l_counter, vl_cohort_yr);
991: l_counter:=l_counter+1;
992: END IF;
993:
994: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1301: vl_legis_cursor := DBMS_SQL.OPEN_CURSOR ;

1297: -- derived from Budget Execution tables and store them in a
1298: -- cursor. Then roll them up and insert the summarized record
1299: -- into the temp table. Dynamic SQL used for implementation.
1300: Begin
1301: vl_legis_cursor := DBMS_SQL.OPEN_CURSOR ;
1302: Exception
1303: When Others Then
1304: vp_retcode := sqlcode ;
1305: VP_ERRBUF := sqlerrm ;

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

1375: END IF;
1376:
1377:
1378: Begin
1379: dbms_sql.parse(vl_legis_cursor,vl_legis_select,DBMS_SQL.V7);
1380: Exception
1381: When Others Then
1382: vp_retcode := sqlcode ;
1383: VP_ERRBUF := sqlerrm ;

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

1386: Return ;
1387: End ;
1388:
1389: -- Bind the variables
1390: dbms_sql.bind_variable(vl_legis_cursor,':ccid', vl_ccid);
1391: dbms_sql.bind_variable(vl_legis_cursor,':je_status', 'P');
1392: dbms_sql.bind_variable(vl_legis_cursor,':begin_period_start_dt',
1393: v_begin_period_start_dt);
1394: dbms_sql.bind_variable(vl_legis_cursor,':period_end_dt',

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

1387: End ;
1388:
1389: -- Bind the variables
1390: dbms_sql.bind_variable(vl_legis_cursor,':ccid', vl_ccid);
1391: dbms_sql.bind_variable(vl_legis_cursor,':je_status', 'P');
1392: dbms_sql.bind_variable(vl_legis_cursor,':begin_period_start_dt',
1393: v_begin_period_start_dt);
1394: dbms_sql.bind_variable(vl_legis_cursor,':period_end_dt',
1395: v_period_end_dt);

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

1388:
1389: -- Bind the variables
1390: dbms_sql.bind_variable(vl_legis_cursor,':ccid', vl_ccid);
1391: dbms_sql.bind_variable(vl_legis_cursor,':je_status', 'P');
1392: dbms_sql.bind_variable(vl_legis_cursor,':begin_period_start_dt',
1393: v_begin_period_start_dt);
1394: dbms_sql.bind_variable(vl_legis_cursor,':period_end_dt',
1395: v_period_end_dt);
1396: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',

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

1390: dbms_sql.bind_variable(vl_legis_cursor,':ccid', vl_ccid);
1391: dbms_sql.bind_variable(vl_legis_cursor,':je_status', 'P');
1392: dbms_sql.bind_variable(vl_legis_cursor,':begin_period_start_dt',
1393: v_begin_period_start_dt);
1394: dbms_sql.bind_variable(vl_legis_cursor,':period_end_dt',
1395: v_period_end_dt);
1396: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1397: vp_set_of_books_id);
1398: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);

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

1392: dbms_sql.bind_variable(vl_legis_cursor,':begin_period_start_dt',
1393: v_begin_period_start_dt);
1394: dbms_sql.bind_variable(vl_legis_cursor,':period_end_dt',
1395: v_period_end_dt);
1396: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1397: vp_set_of_books_id);
1398: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);
1399: dbms_sql.bind_variable(vl_legis_cursor,':fund_value', vl_fund_value);
1400: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);

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

1394: dbms_sql.bind_variable(vl_legis_cursor,':period_end_dt',
1395: v_period_end_dt);
1396: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1397: vp_set_of_books_id);
1398: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);
1399: dbms_sql.bind_variable(vl_legis_cursor,':fund_value', vl_fund_value);
1400: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);
1401: dbms_sql.bind_variable(vl_legis_cursor,':currency_code', vp_currency_code);
1402: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',

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

1395: v_period_end_dt);
1396: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1397: vp_set_of_books_id);
1398: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);
1399: dbms_sql.bind_variable(vl_legis_cursor,':fund_value', vl_fund_value);
1400: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);
1401: dbms_sql.bind_variable(vl_legis_cursor,':currency_code', vp_currency_code);
1402: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1403: vp_set_of_books_id);

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

1396: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1397: vp_set_of_books_id);
1398: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);
1399: dbms_sql.bind_variable(vl_legis_cursor,':fund_value', vl_fund_value);
1400: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);
1401: dbms_sql.bind_variable(vl_legis_cursor,':currency_code', vp_currency_code);
1402: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1403: vp_set_of_books_id);
1404: dbms_sql.bind_variable(vl_legis_cursor,':report_fiscal_yr',

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

1397: vp_set_of_books_id);
1398: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);
1399: dbms_sql.bind_variable(vl_legis_cursor,':fund_value', vl_fund_value);
1400: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);
1401: dbms_sql.bind_variable(vl_legis_cursor,':currency_code', vp_currency_code);
1402: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1403: vp_set_of_books_id);
1404: dbms_sql.bind_variable(vl_legis_cursor,':report_fiscal_yr',
1405: vp_report_fiscal_yr);

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

1398: dbms_sql.bind_variable(vl_legis_cursor,':acct_num', vl_acct_num);
1399: dbms_sql.bind_variable(vl_legis_cursor,':fund_value', vl_fund_value);
1400: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);
1401: dbms_sql.bind_variable(vl_legis_cursor,':currency_code', vp_currency_code);
1402: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1403: vp_set_of_books_id);
1404: dbms_sql.bind_variable(vl_legis_cursor,':report_fiscal_yr',
1405: vp_report_fiscal_yr);
1406: dbms_sql.bind_variable(vl_legis_cursor,':period_num', v_period_num);

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

1400: dbms_sql.bind_variable(vl_legis_cursor,':fiscal_yr', v_fiscal_yr);
1401: dbms_sql.bind_variable(vl_legis_cursor,':currency_code', vp_currency_code);
1402: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1403: vp_set_of_books_id);
1404: dbms_sql.bind_variable(vl_legis_cursor,':report_fiscal_yr',
1405: vp_report_fiscal_yr);
1406: dbms_sql.bind_variable(vl_legis_cursor,':period_num', v_period_num);
1407:
1408:

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

1402: dbms_sql.bind_variable(vl_legis_cursor,':set_of_books_id',
1403: vp_set_of_books_id);
1404: dbms_sql.bind_variable(vl_legis_cursor,':report_fiscal_yr',
1405: vp_report_fiscal_yr);
1406: dbms_sql.bind_variable(vl_legis_cursor,':period_num', v_period_num);
1407:
1408:
1409: dbms_sql.define_column(vl_legis_cursor, 1, vl_legis_ref, 240);
1410: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );

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

1405: vp_report_fiscal_yr);
1406: dbms_sql.bind_variable(vl_legis_cursor,':period_num', v_period_num);
1407:
1408:
1409: dbms_sql.define_column(vl_legis_cursor, 1, vl_legis_ref, 240);
1410: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );
1411: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1412: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1413: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );

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

1406: dbms_sql.bind_variable(vl_legis_cursor,':period_num', v_period_num);
1407:
1408:
1409: dbms_sql.define_column(vl_legis_cursor, 1, vl_legis_ref, 240);
1410: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );
1411: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1412: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1413: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1414: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );

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

1407:
1408:
1409: dbms_sql.define_column(vl_legis_cursor, 1, vl_legis_ref, 240);
1410: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );
1411: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1412: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1413: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1414: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1415: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );

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

1408:
1409: dbms_sql.define_column(vl_legis_cursor, 1, vl_legis_ref, 240);
1410: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );
1411: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1412: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1413: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1414: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1415: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1416: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );

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

1409: dbms_sql.define_column(vl_legis_cursor, 1, vl_legis_ref, 240);
1410: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );
1411: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1412: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1413: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1414: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1415: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1416: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1417: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );

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

1410: dbms_sql.define_column(vl_legis_cursor, 2, vl_legis_amount );
1411: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1412: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1413: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1414: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1415: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1416: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1417: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );
1418: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_batch_id );

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

1411: dbms_sql.define_column(vl_legis_cursor, 3, vl_effective_date );
1412: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1413: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1414: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1415: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1416: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1417: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );
1418: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_batch_id );
1419: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_sla_flag,1 );

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

1412: dbms_sql.define_column(vl_legis_cursor, 4, vl_period_name, 15 );
1413: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1414: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1415: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1416: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1417: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );
1418: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_batch_id );
1419: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_sla_flag,1 );
1420:

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

1413: dbms_sql.define_column(vl_legis_cursor, 5, v_period_dr );
1414: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1415: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1416: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1417: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );
1418: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_batch_id );
1419: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_sla_flag,1 );
1420:
1421: vl_count := 12;

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

1414: dbms_sql.define_column(vl_legis_cursor, 6, v_period_cr );
1415: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1416: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1417: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );
1418: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_batch_id );
1419: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_sla_flag,1 );
1420:
1421: vl_count := 12;
1422:

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

1415: dbms_sql.define_column(vl_legis_cursor, 7, vl_je_source, 25 );
1416: dbms_sql.define_column(vl_legis_cursor, 8, vl_je_header_id );
1417: dbms_sql.define_column(vl_legis_cursor, 9, vl_je_line_num );
1418: dbms_sql.define_column(vl_legis_cursor, 10, vl_je_batch_id );
1419: dbms_sql.define_column(vl_legis_cursor, 11, vl_je_sla_flag,1 );
1420:
1421: vl_count := 12;
1422:
1423: IF va_pl_code_col IS NOT NULL THEN

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

1420:
1421: vl_count := 12;
1422:
1423: IF va_pl_code_col IS NOT NULL THEN
1424: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_pl_code, 150);
1425: vl_count := vl_count + 1;
1426: END IF;
1427:
1428: IF va_tr_main_acct_col IS NOT NULL THEN

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

1425: vl_count := vl_count + 1;
1426: END IF;
1427:
1428: IF va_tr_main_acct_col IS NOT NULL THEN
1429: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_tr_main_acct, 150);
1430: vl_count := vl_count + 1;
1431: END IF;
1432:
1433: IF va_tr_dept_id_col IS NOT NULL THEN

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

1430: vl_count := vl_count + 1;
1431: END IF;
1432:
1433: IF va_tr_dept_id_col IS NOT NULL THEN
1434: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_tr_dept_id, 150);
1435: vl_count := vl_count + 1;
1436: END IF;
1437:
1438: IF va_advance_type_col IS NOT NULL THEN

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

1435: vl_count := vl_count + 1;
1436: END IF;
1437:
1438: IF va_advance_type_col IS NOT NULL THEN
1439: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_advance_type, 150);
1440: END IF;
1441:
1442: Begin
1443: vl_exec_ret := dbms_sql.execute(vl_legis_cursor);

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

1439: dbms_sql.define_column(vl_legis_cursor, vl_count, vl_advance_type, 150);
1440: END IF;
1441:
1442: Begin
1443: vl_exec_ret := dbms_sql.execute(vl_legis_cursor);
1444: Exception
1445: When Others Then
1446: vp_retcode := sqlcode ;
1447: VP_ERRBUF := sqlerrm ;

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

1451: End ;
1452: va_account_ctr := 0;
1453: Loop
1454: vl_exception_cat := 0;
1455: if dbms_sql.fetch_rows(vl_legis_cursor) = 0 then
1456: exit;
1457: End if;
1458:
1459: -- Fetch the Records into Variables

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

1456: exit;
1457: End if;
1458:
1459: -- Fetch the Records into Variables
1460: dbms_sql.column_value(vl_legis_cursor,1,vl_legis_ref);
1461: dbms_sql.column_value(vl_legis_cursor,2,vl_legis_amount);
1462: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1463: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1464: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);

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

1457: End if;
1458:
1459: -- Fetch the Records into Variables
1460: dbms_sql.column_value(vl_legis_cursor,1,vl_legis_ref);
1461: dbms_sql.column_value(vl_legis_cursor,2,vl_legis_amount);
1462: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1463: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1464: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1465: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);

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

1458:
1459: -- Fetch the Records into Variables
1460: dbms_sql.column_value(vl_legis_cursor,1,vl_legis_ref);
1461: dbms_sql.column_value(vl_legis_cursor,2,vl_legis_amount);
1462: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1463: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1464: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1465: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1466: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);

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

1459: -- Fetch the Records into Variables
1460: dbms_sql.column_value(vl_legis_cursor,1,vl_legis_ref);
1461: dbms_sql.column_value(vl_legis_cursor,2,vl_legis_amount);
1462: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1463: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1464: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1465: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1466: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1467:

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

1460: dbms_sql.column_value(vl_legis_cursor,1,vl_legis_ref);
1461: dbms_sql.column_value(vl_legis_cursor,2,vl_legis_amount);
1462: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1463: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1464: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1465: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1466: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1467:
1468: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );

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

1461: dbms_sql.column_value(vl_legis_cursor,2,vl_legis_amount);
1462: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1463: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1464: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1465: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1466: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1467:
1468: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );
1469: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_line_num );

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

1462: dbms_sql.column_value(vl_legis_cursor,3,vl_effective_date);
1463: dbms_sql.column_value(vl_legis_cursor,4,vl_period_name);
1464: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1465: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1466: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1467:
1468: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );
1469: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_line_num );
1470: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_batch_id );

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

1464: dbms_sql.column_value(vl_legis_cursor,5,v_period_dr);
1465: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1466: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1467:
1468: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );
1469: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_line_num );
1470: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_batch_id );
1471: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_sla_flag );
1472:

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

1465: dbms_sql.column_value(vl_legis_cursor,6,v_period_cr);
1466: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1467:
1468: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );
1469: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_line_num );
1470: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_batch_id );
1471: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_sla_flag );
1472:
1473: vl_count := 12;

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

1466: dbms_sql.column_value(vl_legis_cursor,7,vl_je_source);
1467:
1468: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );
1469: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_line_num );
1470: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_batch_id );
1471: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_sla_flag );
1472:
1473: vl_count := 12;
1474:

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

1467:
1468: dbms_sql.column_value(vl_legis_cursor, 8, vl_je_header_id );
1469: dbms_sql.column_value(vl_legis_cursor, 9, vl_je_line_num );
1470: dbms_sql.column_value(vl_legis_cursor, 10, vl_je_batch_id );
1471: dbms_sql.column_value(vl_legis_cursor, 11, vl_je_sla_flag );
1472:
1473: vl_count := 12;
1474:
1475: IF va_pl_code_col IS NOT NULL THEN

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

1472:
1473: vl_count := 12;
1474:
1475: IF va_pl_code_col IS NOT NULL THEN
1476: dbms_sql.column_value(vl_legis_cursor, vl_count, vl_pl_code);
1477: vl_count := vl_count + 1;
1478: END IF;
1479:
1480: IF va_tr_main_acct_col IS NOT NULL THEN

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

1477: vl_count := vl_count + 1;
1478: END IF;
1479:
1480: IF va_tr_main_acct_col IS NOT NULL THEN
1481: dbms_sql.column_value(vl_legis_cursor, vl_count, vl_tr_main_acct);
1482: vl_count := vl_count + 1;
1483: END IF;
1484:
1485: IF va_tr_dept_id_col IS NOT NULL THEN

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

1482: vl_count := vl_count + 1;
1483: END IF;
1484:
1485: IF va_tr_dept_id_col IS NOT NULL THEN
1486: dbms_sql.column_value(vl_legis_cursor, vl_count, vl_tr_dept_id);
1487: vl_count := vl_count + 1;
1488: END IF;
1489:
1490: IF va_advance_type_col IS NOT NULL THEN

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

1487: vl_count := vl_count + 1;
1488: END IF;
1489:
1490: IF va_advance_type_col IS NOT NULL THEN
1491: dbms_sql.column_value(vl_legis_cursor, vl_count, vl_advance_type);
1492: END IF;
1493:
1494: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 1698: dbms_sql.Close_Cursor(vl_legis_cursor);

1694: End Loop; -- legis cur ;
1695:
1696: -- Close the Legislative Indicator Cursor
1697: Begin
1698: dbms_sql.Close_Cursor(vl_legis_cursor);
1699: Exception
1700: When Others Then
1701: vp_retcode := sqlcode ;
1702: VP_ERRBUF := sqlerrm ;

Line 1754: vl_appor_cursor := DBMS_SQL.OPEN_CURSOR ;

1750:
1751: If v_catb_prg_seg_name IS NOT NULL OR
1752: v_prn_prg_seg_name IS NOT NULL Then
1753: Begin
1754: vl_appor_cursor := DBMS_SQL.OPEN_CURSOR ;
1755: Exception
1756: When Others Then
1757: vp_retcode := sqlcode ;
1758: VP_ERRBUF := sqlerrm ;

Line 1777: dbms_sql.parse(vl_appor_cursor,vl_appor_select,

1773: v_fiscal_yr,
1774: vl_appor_period,
1775: vl_appor_select) ;
1776: Begin
1777: dbms_sql.parse(vl_appor_cursor,vl_appor_select,
1778: DBMS_SQL.V7);
1779: Exception
1780: When Others Then
1781: vp_retcode := sqlcode ;

Line 1778: DBMS_SQL.V7);

1774: vl_appor_period,
1775: vl_appor_select) ;
1776: Begin
1777: dbms_sql.parse(vl_appor_cursor,vl_appor_select,
1778: DBMS_SQL.V7);
1779: Exception
1780: When Others Then
1781: vp_retcode := sqlcode ;
1782: vp_errbuf := sqlerrm || ' [MAIN - APPOR]' ;

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

1785: Return ;
1786: End ;
1787:
1788: -- Bind the variables
1789: dbms_sql.bind_variable(vl_appor_cursor, ':ccid', vl_ccid);
1790: dbms_sql.bind_variable(vl_appor_cursor, ':actual_flag', 'A');
1791: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1792: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1793: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);

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

1786: End ;
1787:
1788: -- Bind the variables
1789: dbms_sql.bind_variable(vl_appor_cursor, ':ccid', vl_ccid);
1790: dbms_sql.bind_variable(vl_appor_cursor, ':actual_flag', 'A');
1791: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1792: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1793: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1794: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);

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

1787:
1788: -- Bind the variables
1789: dbms_sql.bind_variable(vl_appor_cursor, ':ccid', vl_ccid);
1790: dbms_sql.bind_variable(vl_appor_cursor, ':actual_flag', 'A');
1791: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1792: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1793: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1794: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);
1795: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',

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

1788: -- Bind the variables
1789: dbms_sql.bind_variable(vl_appor_cursor, ':ccid', vl_ccid);
1790: dbms_sql.bind_variable(vl_appor_cursor, ':actual_flag', 'A');
1791: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1792: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1793: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1794: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);
1795: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',
1796: vp_report_fiscal_yr);

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

1789: dbms_sql.bind_variable(vl_appor_cursor, ':ccid', vl_ccid);
1790: dbms_sql.bind_variable(vl_appor_cursor, ':actual_flag', 'A');
1791: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1792: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1793: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1794: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);
1795: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',
1796: vp_report_fiscal_yr);
1797: dbms_sql.bind_variable(vl_appor_cursor, ':set_of_books_id',

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

1790: dbms_sql.bind_variable(vl_appor_cursor, ':actual_flag', 'A');
1791: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1792: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1793: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1794: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);
1795: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',
1796: vp_report_fiscal_yr);
1797: dbms_sql.bind_variable(vl_appor_cursor, ':set_of_books_id',
1798: vp_set_of_books_id);

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

1791: dbms_sql.bind_variable(vl_appor_cursor, ':fund_value', vl_fund_value);
1792: dbms_sql.bind_variable(vl_appor_cursor, ':acct_number', vl_acct_num);
1793: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1794: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);
1795: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',
1796: vp_report_fiscal_yr);
1797: dbms_sql.bind_variable(vl_appor_cursor, ':set_of_books_id',
1798: vp_set_of_books_id);
1799: dbms_sql.bind_variable(vl_appor_cursor, ':currency_code',

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

1793: dbms_sql.bind_variable(vl_appor_cursor, ':fiscal_year', v_fiscal_yr);
1794: dbms_sql.bind_variable(vl_appor_cursor, ':period_num', v_period_num);
1795: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',
1796: vp_report_fiscal_yr);
1797: dbms_sql.bind_variable(vl_appor_cursor, ':set_of_books_id',
1798: vp_set_of_books_id);
1799: dbms_sql.bind_variable(vl_appor_cursor, ':currency_code',
1800: vp_currency_code);
1801:

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

1795: dbms_sql.bind_variable(vl_appor_cursor, ':report_fiscal_yr',
1796: vp_report_fiscal_yr);
1797: dbms_sql.bind_variable(vl_appor_cursor, ':set_of_books_id',
1798: vp_set_of_books_id);
1799: dbms_sql.bind_variable(vl_appor_cursor, ':currency_code',
1800: vp_currency_code);
1801:
1802:
1803: dbms_sql.define_column(vl_appor_cursor,1,vl_acct_num,25);

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

1799: dbms_sql.bind_variable(vl_appor_cursor, ':currency_code',
1800: vp_currency_code);
1801:
1802:
1803: dbms_sql.define_column(vl_appor_cursor,1,vl_acct_num,25);
1804: dbms_sql.define_column(vl_appor_cursor,2,vl_fund_value,25);
1805: vl_counter := 3;
1806:
1807: IF v_catb_prg_seg_name IS NOT NULL THEN

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

1800: vp_currency_code);
1801:
1802:
1803: dbms_sql.define_column(vl_appor_cursor,1,vl_acct_num,25);
1804: dbms_sql.define_column(vl_appor_cursor,2,vl_fund_value,25);
1805: vl_counter := 3;
1806:
1807: IF v_catb_prg_seg_name IS NOT NULL THEN
1808: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_catb_program,25);

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

1804: dbms_sql.define_column(vl_appor_cursor,2,vl_fund_value,25);
1805: vl_counter := 3;
1806:
1807: IF v_catb_prg_seg_name IS NOT NULL THEN
1808: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_catb_program,25);
1809: vl_counter := vl_counter + 1;
1810: END IF;
1811:
1812: IF v_prn_prg_seg_name IS NOT NULL THEN

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

1809: vl_counter := vl_counter + 1;
1810: END IF;
1811:
1812: IF v_prn_prg_seg_name IS NOT NULL THEN
1813: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_prn_program,25);
1814: vl_counter := vl_counter + 1;
1815: END IF;
1816:
1817: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_amount);

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

1813: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_prn_program,25);
1814: vl_counter := vl_counter + 1;
1815: END IF;
1816:
1817: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_amount);
1818: vl_counter := vl_counter + 1;
1819: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_period_activity);
1820: vl_counter := vl_counter + 1;
1821: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_dr);

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

1815: END IF;
1816:
1817: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_amount);
1818: vl_counter := vl_counter + 1;
1819: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_period_activity);
1820: vl_counter := vl_counter + 1;
1821: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_dr);
1822: vl_counter := vl_counter + 1;
1823: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_cr);

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

1817: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_amount);
1818: vl_counter := vl_counter + 1;
1819: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_period_activity);
1820: vl_counter := vl_counter + 1;
1821: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_dr);
1822: vl_counter := vl_counter + 1;
1823: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_cr);
1824: vl_counter := vl_counter + 1;
1825:

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

1819: dbms_sql.define_column(vl_appor_cursor,vl_counter,vl_period_activity);
1820: vl_counter := vl_counter + 1;
1821: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_dr);
1822: vl_counter := vl_counter + 1;
1823: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_cr);
1824: vl_counter := vl_counter + 1;
1825:
1826: If v_cohort_Seg_name is not null Then
1827: dbms_sql.define_column(vl_appor_cursor, vl_counter, vl_cohort_yr, 25);

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

1823: dbms_sql.define_column(vl_appor_cursor,vl_counter,v_period_cr);
1824: vl_counter := vl_counter + 1;
1825:
1826: If v_cohort_Seg_name is not null Then
1827: dbms_sql.define_column(vl_appor_cursor, vl_counter, vl_cohort_yr, 25);
1828: end If ;
1829:
1830: Begin
1831: vl_exec_ret := dbms_sql.execute(vl_appor_cursor);

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

1827: dbms_sql.define_column(vl_appor_cursor, vl_counter, vl_cohort_yr, 25);
1828: end If ;
1829:
1830: Begin
1831: vl_exec_ret := dbms_sql.execute(vl_appor_cursor);
1832: Exception
1833: When Others Then
1834: vp_retcode := sqlcode ;
1835: vp_errbuf := sqlerrm||'[execute_vl_appor_cursor]' ;

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

1841: --------------------------------------------------------------------------
1842: -- Reset the counter for apportionment cat b Dtl
1843: -- vl_appor_ctr := 0 ;
1844: LOOP
1845: if dbms_sql.fetch_rows(vl_appor_cursor) = 0 then
1846: exit;
1847: else
1848: -- Fetch the Records into Variables
1849: dbms_sql.column_value(vl_appor_cursor,1,vl_acct_num);

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

1845: if dbms_sql.fetch_rows(vl_appor_cursor) = 0 then
1846: exit;
1847: else
1848: -- Fetch the Records into Variables
1849: dbms_sql.column_value(vl_appor_cursor,1,vl_acct_num);
1850: dbms_sql.column_value(vl_appor_cursor,2,vl_fund_value);
1851:
1852: vl_counter := 3;
1853: IF v_catb_prg_seg_name IS NOT NULL THEN

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

1846: exit;
1847: else
1848: -- Fetch the Records into Variables
1849: dbms_sql.column_value(vl_appor_cursor,1,vl_acct_num);
1850: dbms_sql.column_value(vl_appor_cursor,2,vl_fund_value);
1851:
1852: vl_counter := 3;
1853: IF v_catb_prg_seg_name IS NOT NULL THEN
1854: dbms_sql.column_value(vl_appor_cursor,vl_counter,vl_catb_program);

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

1850: dbms_sql.column_value(vl_appor_cursor,2,vl_fund_value);
1851:
1852: vl_counter := 3;
1853: IF v_catb_prg_seg_name IS NOT NULL THEN
1854: dbms_sql.column_value(vl_appor_cursor,vl_counter,vl_catb_program);
1855: vl_counter := vl_counter + 1;
1856: END IF;
1857:
1858: IF v_prn_prg_seg_name IS NOT NULL THEN

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

1855: vl_counter := vl_counter + 1;
1856: END IF;
1857:
1858: IF v_prn_prg_seg_name IS NOT NULL THEN
1859: dbms_sql.column_value(vl_appor_cursor,vl_counter,vl_prn_program);
1860: vl_counter := vl_counter + 1;
1861: END IF;
1862:
1863: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_amount);

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

1859: dbms_sql.column_value(vl_appor_cursor,vl_counter,vl_prn_program);
1860: vl_counter := vl_counter + 1;
1861: END IF;
1862:
1863: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_amount);
1864: vl_counter := vl_counter + 1;
1865:
1866: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_activity);
1867: vl_counter := vl_counter + 1;

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

1862:
1863: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_amount);
1864: vl_counter := vl_counter + 1;
1865:
1866: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_activity);
1867: vl_counter := vl_counter + 1;
1868:
1869: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_dr);
1870: vl_counter := vl_counter + 1;

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

1865:
1866: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_activity);
1867: vl_counter := vl_counter + 1;
1868:
1869: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_dr);
1870: vl_counter := vl_counter + 1;
1871:
1872: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_cr);
1873: vl_counter := vl_counter + 1;

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

1868:
1869: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_dr);
1870: vl_counter := vl_counter + 1;
1871:
1872: dbms_sql.column_value(vl_appor_cursor,vl_counter,v_period_cr);
1873: vl_counter := vl_counter + 1;
1874:
1875: If v_cohort_Seg_name is not null Then
1876: -- vl_counter := vl_counter + 1;

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

1873: vl_counter := vl_counter + 1;
1874:
1875: If v_cohort_Seg_name is not null Then
1876: -- vl_counter := vl_counter + 1;
1877: dbms_sql.column_value(vl_appor_cursor,vl_counter, vl_cohort_yr);
1878: end If ;
1879: -- vl_appor_ctr := vl_appor_ctr + 1 ;
1880: -- Get_Appor_Cat_B_Text(vl_program) ;
1881:

Line 1928: dbms_sql.Close_Cursor(vl_appor_cursor);

1924: -------------------------------------------------------------------
1925:
1926: -- Close the Apportionment Category Cursor
1927: Begin
1928: dbms_sql.Close_Cursor(vl_appor_cursor);
1929: Exception
1930: When Others Then
1931: vp_retcode := sqlcode ;
1932: VP_ERRBUF := sqlerrm||'[vl_appor_cursor]' ;

Line 1977: dbms_sql.Close_Cursor(vl_main_cursor);

1973:
1974:
1975: -- Close the Main Cursor
1976: Begin
1977: dbms_sql.Close_Cursor(vl_main_cursor);
1978: Exception
1979: When Others Then
1980: vp_retcode := sqlcode ;
1981: VP_ERRBUF := sqlerrm||'[vl_main_cursor]' ;

Line 2372: vl_bal_cursor := DBMS_SQL.OPEN_CURSOR ;

2368: das_where VARCHAR2(600);
2369:
2370: BEGIN
2371: Begin
2372: vl_bal_cursor := DBMS_SQL.OPEN_CURSOR ;
2373: Exception
2374: When Others Then
2375: vp_retcode := sqlcode ;
2376: vp_errbuf := sqlerrm || ' [CALC_BALANCE - Open Cursor] ' ;

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

2420: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'mg calc '||vl_bal_select) ;
2421: END IF;
2422:
2423: Begin
2424: dbms_sql.parse(vl_bal_cursor, vl_bal_select, DBMS_SQL.V7) ;
2425: Exception
2426: When Others Then
2427: vp_retcode := sqlcode ;
2428: vp_errbuf := sqlerrm || ' [CALC_BALANCE - Parse] ' ;

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

2430: return;
2431: End ;
2432:
2433: -- Bind the variables
2434: dbms_sql.bind_variable(vl_bal_cursor,':ccid', ccid);
2435: dbms_sql.bind_variable(vl_bal_cursor,':actual_flag', 'A');
2436: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2437: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2438: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);

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

2431: End ;
2432:
2433: -- Bind the variables
2434: dbms_sql.bind_variable(vl_bal_cursor,':ccid', ccid);
2435: dbms_sql.bind_variable(vl_bal_cursor,':actual_flag', 'A');
2436: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2437: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2438: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2439: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);

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

2432:
2433: -- Bind the variables
2434: dbms_sql.bind_variable(vl_bal_cursor,':ccid', ccid);
2435: dbms_sql.bind_variable(vl_bal_cursor,':actual_flag', 'A');
2436: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2437: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2438: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2439: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2440: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);

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

2433: -- Bind the variables
2434: dbms_sql.bind_variable(vl_bal_cursor,':ccid', ccid);
2435: dbms_sql.bind_variable(vl_bal_cursor,':actual_flag', 'A');
2436: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2437: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2438: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2439: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2440: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);
2441: dbms_sql.bind_variable(vl_bal_cursor,':period_year', period_year);

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

2434: dbms_sql.bind_variable(vl_bal_cursor,':ccid', ccid);
2435: dbms_sql.bind_variable(vl_bal_cursor,':actual_flag', 'A');
2436: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2437: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2438: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2439: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2440: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);
2441: dbms_sql.bind_variable(vl_bal_cursor,':period_year', period_year);
2442: dbms_sql.bind_variable(vl_bal_cursor,':currency_code', vp_currency_code);

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

2435: dbms_sql.bind_variable(vl_bal_cursor,':actual_flag', 'A');
2436: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2437: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2438: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2439: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2440: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);
2441: dbms_sql.bind_variable(vl_bal_cursor,':period_year', period_year);
2442: dbms_sql.bind_variable(vl_bal_cursor,':currency_code', vp_currency_code);
2443:

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

2436: dbms_sql.bind_variable(vl_bal_cursor,':fund_value', fund_value);
2437: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2438: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2439: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2440: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);
2441: dbms_sql.bind_variable(vl_bal_cursor,':period_year', period_year);
2442: dbms_sql.bind_variable(vl_bal_cursor,':currency_code', vp_currency_code);
2443:
2444:

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

2437: dbms_sql.bind_variable(vl_bal_cursor,':acct_num', acct_num);
2438: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2439: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2440: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);
2441: dbms_sql.bind_variable(vl_bal_cursor,':period_year', period_year);
2442: dbms_sql.bind_variable(vl_bal_cursor,':currency_code', vp_currency_code);
2443:
2444:
2445:

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

2438: dbms_sql.bind_variable(vl_bal_cursor,':fiscal_year', fiscal_year);
2439: dbms_sql.bind_variable(vl_bal_cursor,':set_of_books_id', vp_set_of_books_id);
2440: dbms_sql.bind_variable(vl_bal_cursor,':period_num', period_num);
2441: dbms_sql.bind_variable(vl_bal_cursor,':period_year', period_year);
2442: dbms_sql.bind_variable(vl_bal_cursor,':currency_code', vp_currency_code);
2443:
2444:
2445:
2446: dbms_sql.define_column(vl_bal_cursor, 1, amount);

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

2442: dbms_sql.bind_variable(vl_bal_cursor,':currency_code', vp_currency_code);
2443:
2444:
2445:
2446: dbms_sql.define_column(vl_bal_cursor, 1, amount);
2447: dbms_sql.define_column(vl_bal_cursor, 2, period_activity);
2448: dbms_sql.define_column(vl_bal_cursor, 3, v_period_dr);
2449: dbms_sql.define_column(vl_bal_cursor, 4, v_period_cr);
2450: Begin

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

2443:
2444:
2445:
2446: dbms_sql.define_column(vl_bal_cursor, 1, amount);
2447: dbms_sql.define_column(vl_bal_cursor, 2, period_activity);
2448: dbms_sql.define_column(vl_bal_cursor, 3, v_period_dr);
2449: dbms_sql.define_column(vl_bal_cursor, 4, v_period_cr);
2450: Begin
2451: vl_exec_ret := dbms_sql.execute(vl_bal_cursor);

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

2444:
2445:
2446: dbms_sql.define_column(vl_bal_cursor, 1, amount);
2447: dbms_sql.define_column(vl_bal_cursor, 2, period_activity);
2448: dbms_sql.define_column(vl_bal_cursor, 3, v_period_dr);
2449: dbms_sql.define_column(vl_bal_cursor, 4, v_period_cr);
2450: Begin
2451: vl_exec_ret := dbms_sql.execute(vl_bal_cursor);
2452: Exception

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

2445:
2446: dbms_sql.define_column(vl_bal_cursor, 1, amount);
2447: dbms_sql.define_column(vl_bal_cursor, 2, period_activity);
2448: dbms_sql.define_column(vl_bal_cursor, 3, v_period_dr);
2449: dbms_sql.define_column(vl_bal_cursor, 4, v_period_cr);
2450: Begin
2451: vl_exec_ret := dbms_sql.execute(vl_bal_cursor);
2452: Exception
2453: When Others Then

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

2447: dbms_sql.define_column(vl_bal_cursor, 2, period_activity);
2448: dbms_sql.define_column(vl_bal_cursor, 3, v_period_dr);
2449: dbms_sql.define_column(vl_bal_cursor, 4, v_period_cr);
2450: Begin
2451: vl_exec_ret := dbms_sql.execute(vl_bal_cursor);
2452: Exception
2453: When Others Then
2454: vp_retcode := sqlcode ;
2455: vp_errbuf := sqlerrm || ' [CALC_BALANCE - Execute Cursor] ' ;

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

2455: vp_errbuf := sqlerrm || ' [CALC_BALANCE - Execute Cursor] ' ;
2456: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.execute_vl_bal_cursor', vp_errbuf) ;
2457: End ;
2458: Loop
2459: if dbms_sql.fetch_rows(vl_bal_cursor) = 0 then
2460: exit;
2461: else
2462: -- Fetch the Records into Variables
2463: dbms_sql.column_value(vl_bal_cursor, 1, amount);

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

2459: if dbms_sql.fetch_rows(vl_bal_cursor) = 0 then
2460: exit;
2461: else
2462: -- Fetch the Records into Variables
2463: dbms_sql.column_value(vl_bal_cursor, 1, amount);
2464: dbms_sql.column_value(vl_bal_cursor, 2, period_activity);
2465: dbms_sql.column_value(vl_bal_cursor, 3, v_period_dr);
2466: dbms_sql.column_value(vl_bal_cursor, 4, v_period_cr);
2467: end if;

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

2460: exit;
2461: else
2462: -- Fetch the Records into Variables
2463: dbms_sql.column_value(vl_bal_cursor, 1, amount);
2464: dbms_sql.column_value(vl_bal_cursor, 2, period_activity);
2465: dbms_sql.column_value(vl_bal_cursor, 3, v_period_dr);
2466: dbms_sql.column_value(vl_bal_cursor, 4, v_period_cr);
2467: end if;
2468: End Loop ;

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

2461: else
2462: -- Fetch the Records into Variables
2463: dbms_sql.column_value(vl_bal_cursor, 1, amount);
2464: dbms_sql.column_value(vl_bal_cursor, 2, period_activity);
2465: dbms_sql.column_value(vl_bal_cursor, 3, v_period_dr);
2466: dbms_sql.column_value(vl_bal_cursor, 4, v_period_cr);
2467: end if;
2468: End Loop ;
2469: -- Close the Balance Cursor

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

2462: -- Fetch the Records into Variables
2463: dbms_sql.column_value(vl_bal_cursor, 1, amount);
2464: dbms_sql.column_value(vl_bal_cursor, 2, period_activity);
2465: dbms_sql.column_value(vl_bal_cursor, 3, v_period_dr);
2466: dbms_sql.column_value(vl_bal_cursor, 4, v_period_cr);
2467: end if;
2468: End Loop ;
2469: -- Close the Balance Cursor
2470: Begin

Line 2471: dbms_sql.Close_Cursor(vl_bal_cursor);

2467: end if;
2468: End Loop ;
2469: -- Close the Balance Cursor
2470: Begin
2471: dbms_sql.Close_Cursor(vl_bal_cursor);
2472: Exception
2473: When Others Then
2474: vp_retcode := sqlcode ;
2475: VP_ERRBUF := sqlerrm ;

Line 3228: vl_rollup_cursor := DBMS_SQL.OPEN_CURSOR;

3224: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3225: 'Group by ' || vl_group_by);
3226: END IF;
3227:
3228: vl_rollup_cursor := DBMS_SQL.OPEN_CURSOR;
3229:
3230: vl_rollup := '
3231: INSERT INTO FV_FACTS_TEMP
3232: (TREASURY_SYMBOL_ID ,

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

3333:
3334: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3335: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, vl_rollup);
3336: END IF;
3337: dbms_sql.parse(vl_rollup_cursor, vl_rollup, DBMS_SQL.V7) ;
3338: vl_exec_ret := dbms_sql.execute(vl_rollup_cursor);
3339: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3340: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' No of records rolled up '
3341: || vl_exec_ret);

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

3334: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3335: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, vl_rollup);
3336: END IF;
3337: dbms_sql.parse(vl_rollup_cursor, vl_rollup, DBMS_SQL.V7) ;
3338: vl_exec_ret := dbms_sql.execute(vl_rollup_cursor);
3339: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3340: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' No of records rolled up '
3341: || vl_exec_ret);
3342: END IF;