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

Line 689: l_fund_cur_id := DBMS_SQL.OPEN_CURSOR;

685: -- get the ccid that contains this fund in its balancing segment
686: -- and this anticipated account in Natural account segment
687: -- assumption is federal would set up summary template for the anticpated account
688:
689: l_fund_cur_id := DBMS_SQL.OPEN_CURSOR;
690:
691: --Build the Select statement for getting the fund values and ccids
692: l_fund_select := 'SELECT code_combination_id ' ||
693: ' FROM Gl_Code_Combinations ' ||

Line 708: DBMS_SQL.PARSE(l_fund_cur_id, l_fund_select, DBMS_SQL.Native);

704:
705: -------------------------------------------------------------------------
706: trace(C_STATE_LEVEL, l_procedure_name, 'parse');
707: -------------------------------------------------------------------------
708: DBMS_SQL.PARSE(l_fund_cur_id, l_fund_select, DBMS_SQL.Native);
709: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_coaid', p_coaid);
710: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_fund_value', p_fund_value, 25);
711: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_template_id', l_template_id, 30);
712:

Line 709: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_coaid', p_coaid);

705: -------------------------------------------------------------------------
706: trace(C_STATE_LEVEL, l_procedure_name, 'parse');
707: -------------------------------------------------------------------------
708: DBMS_SQL.PARSE(l_fund_cur_id, l_fund_select, DBMS_SQL.Native);
709: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_coaid', p_coaid);
710: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_fund_value', p_fund_value, 25);
711: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_template_id', l_template_id, 30);
712:
713: -------------------------------------------------------------------------

Line 710: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_fund_value', p_fund_value, 25);

706: trace(C_STATE_LEVEL, l_procedure_name, 'parse');
707: -------------------------------------------------------------------------
708: DBMS_SQL.PARSE(l_fund_cur_id, l_fund_select, DBMS_SQL.Native);
709: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_coaid', p_coaid);
710: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_fund_value', p_fund_value, 25);
711: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_template_id', l_template_id, 30);
712:
713: -------------------------------------------------------------------------
714: trace(C_STATE_LEVEL, l_procedure_name, 'DEFINE_COLUMN');

Line 711: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_template_id', l_template_id, 30);

707: -------------------------------------------------------------------------
708: DBMS_SQL.PARSE(l_fund_cur_id, l_fund_select, DBMS_SQL.Native);
709: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_coaid', p_coaid);
710: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_fund_value', p_fund_value, 25);
711: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_template_id', l_template_id, 30);
712:
713: -------------------------------------------------------------------------
714: trace(C_STATE_LEVEL, l_procedure_name, 'DEFINE_COLUMN');
715: -------------------------------------------------------------------------

Line 716: DBMS_SQL.DEFINE_COLUMN(l_fund_cur_id,1,l_ccid);

712:
713: -------------------------------------------------------------------------
714: trace(C_STATE_LEVEL, l_procedure_name, 'DEFINE_COLUMN');
715: -------------------------------------------------------------------------
716: DBMS_SQL.DEFINE_COLUMN(l_fund_cur_id,1,l_ccid);
717:
718: l_fund_ret := DBMS_SQL.EXECUTE(l_fund_cur_id);
719:
720: LOOP

Line 718: l_fund_ret := DBMS_SQL.EXECUTE(l_fund_cur_id);

714: trace(C_STATE_LEVEL, l_procedure_name, 'DEFINE_COLUMN');
715: -------------------------------------------------------------------------
716: DBMS_SQL.DEFINE_COLUMN(l_fund_cur_id,1,l_ccid);
717:
718: l_fund_ret := DBMS_SQL.EXECUTE(l_fund_cur_id);
719:
720: LOOP
721: -- Fetch the ccid's from Gl_Code_Combinations
722: -------------------------------------------------------------------------

Line 725: IF DBMS_SQL.FETCH_ROWS(l_fund_cur_id) = 0 THEN

721: -- Fetch the ccid's from Gl_Code_Combinations
722: -------------------------------------------------------------------------
723: trace(C_STATE_LEVEL, l_procedure_name, 'FETCH_ROWS');
724: -------------------------------------------------------------------------
725: IF DBMS_SQL.FETCH_ROWS(l_fund_cur_id) = 0 THEN
726: -------------------------------------------------------------------------
727: trace(C_STATE_LEVEL, l_procedure_name, 'EXIT');
728: -------------------------------------------------------------------------
729: EXIT;

Line 734: DBMS_SQL.COLUMN_VALUE(l_fund_cur_id, 1,l_ccid);

730: ELSE
731: -------------------------------------------------------------------------
732: trace(C_STATE_LEVEL, l_procedure_name, 'COLUMN_VALUE');
733: -------------------------------------------------------------------------
734: DBMS_SQL.COLUMN_VALUE(l_fund_cur_id, 1,l_ccid);
735: END IF;
736:
737:
738: /*SELECT SUM((begin_balance_dr - begin_balance_cr) +

Line 807: dbms_sql.close_cursor (l_fund_cur_id);

803: l_tot_amount := l_tot_amount + NVL(l_amount, 0);
804:
805: trace(C_STATE_LEVEL, l_procedure_name, ' gl_bc_packets l_tot_amount='||l_tot_amount);
806: END LOOP;
807: dbms_sql.close_cursor (l_fund_cur_id);
808: RETURN l_tot_amount;
809: -------------------------------------------------------------------------
810: l_debug_info := 'End of procedure '||l_procedure_name;
811: trace(C_PROC_LEVEL, l_procedure_name, l_debug_info);