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

Line 1462: l_fund_cur_id := DBMS_SQL.OPEN_CURSOR;

1458: -- get the ccid that contains this fund in its balancing segment
1459: -- and this anticipated account in Natural account segment
1460: -- assumption is federal would set up summary template for the anticpated account
1461:
1462: l_fund_cur_id := DBMS_SQL.OPEN_CURSOR;
1463:
1464: --Build the Select statement for getting the fund values and ccids
1465: l_fund_select := 'SELECT code_combination_id ' ||
1466: ' FROM gl_code_Combinations g, ' ||

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

1478:
1479: -------------------------------------------------------------------------
1480: trace(C_STATE_LEVEL, l_procedure_name, 'parse');
1481: -------------------------------------------------------------------------
1482: DBMS_SQL.PARSE(l_fund_cur_id, l_fund_select, DBMS_SQL.Native);
1483: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_coaid', l_ledger_info.coaid);
1484: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_treasury_symbol_id', p_treasury_symbol_id);
1485: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_ledger_id', p_ledger_id);
1486: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_template_id', l_template_id);

Line 1483: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_coaid', l_ledger_info.coaid);

1479: -------------------------------------------------------------------------
1480: trace(C_STATE_LEVEL, l_procedure_name, 'parse');
1481: -------------------------------------------------------------------------
1482: DBMS_SQL.PARSE(l_fund_cur_id, l_fund_select, DBMS_SQL.Native);
1483: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_coaid', l_ledger_info.coaid);
1484: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_treasury_symbol_id', p_treasury_symbol_id);
1485: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_ledger_id', p_ledger_id);
1486: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_template_id', l_template_id);
1487:

Line 1484: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_treasury_symbol_id', p_treasury_symbol_id);

1480: trace(C_STATE_LEVEL, l_procedure_name, 'parse');
1481: -------------------------------------------------------------------------
1482: DBMS_SQL.PARSE(l_fund_cur_id, l_fund_select, DBMS_SQL.Native);
1483: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_coaid', l_ledger_info.coaid);
1484: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_treasury_symbol_id', p_treasury_symbol_id);
1485: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_ledger_id', p_ledger_id);
1486: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_template_id', l_template_id);
1487:
1488: -------------------------------------------------------------------------

Line 1485: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_ledger_id', p_ledger_id);

1481: -------------------------------------------------------------------------
1482: DBMS_SQL.PARSE(l_fund_cur_id, l_fund_select, DBMS_SQL.Native);
1483: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_coaid', l_ledger_info.coaid);
1484: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_treasury_symbol_id', p_treasury_symbol_id);
1485: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_ledger_id', p_ledger_id);
1486: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_template_id', l_template_id);
1487:
1488: -------------------------------------------------------------------------
1489: trace(C_STATE_LEVEL, l_procedure_name, 'DEFINE_COLUMN');

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

1482: DBMS_SQL.PARSE(l_fund_cur_id, l_fund_select, DBMS_SQL.Native);
1483: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_coaid', l_ledger_info.coaid);
1484: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_treasury_symbol_id', p_treasury_symbol_id);
1485: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_ledger_id', p_ledger_id);
1486: DBMS_SQL.BIND_VARIABLE(l_fund_cur_id, ':p_template_id', l_template_id);
1487:
1488: -------------------------------------------------------------------------
1489: trace(C_STATE_LEVEL, l_procedure_name, 'DEFINE_COLUMN');
1490: -------------------------------------------------------------------------

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

1487:
1488: -------------------------------------------------------------------------
1489: trace(C_STATE_LEVEL, l_procedure_name, 'DEFINE_COLUMN');
1490: -------------------------------------------------------------------------
1491: DBMS_SQL.DEFINE_COLUMN(l_fund_cur_id,1,l_ccid);
1492:
1493: l_fund_ret := DBMS_SQL.EXECUTE(l_fund_cur_id);
1494:
1495: LOOP

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

1489: trace(C_STATE_LEVEL, l_procedure_name, 'DEFINE_COLUMN');
1490: -------------------------------------------------------------------------
1491: DBMS_SQL.DEFINE_COLUMN(l_fund_cur_id,1,l_ccid);
1492:
1493: l_fund_ret := DBMS_SQL.EXECUTE(l_fund_cur_id);
1494:
1495: LOOP
1496: -- Fetch the ccid's from Gl_Code_Combinations
1497: trace(C_STATE_LEVEL, l_procedure_name, 'FETCH_ROWS');

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

1494:
1495: LOOP
1496: -- Fetch the ccid's from Gl_Code_Combinations
1497: trace(C_STATE_LEVEL, l_procedure_name, 'FETCH_ROWS');
1498: IF DBMS_SQL.FETCH_ROWS(l_fund_cur_id) = 0 THEN
1499: trace(C_STATE_LEVEL, l_procedure_name, 'EXIT');
1500: EXIT;
1501: ELSE
1502: trace(C_STATE_LEVEL, l_procedure_name, 'COLUMN_VALUE');

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

1499: trace(C_STATE_LEVEL, l_procedure_name, 'EXIT');
1500: EXIT;
1501: ELSE
1502: trace(C_STATE_LEVEL, l_procedure_name, 'COLUMN_VALUE');
1503: DBMS_SQL.COLUMN_VALUE(l_fund_cur_id, 1,l_ccid);
1504: END IF;
1505:
1506: trace(C_PROC_LEVEL, l_procedure_name, 'Before calling calc_funds');
1507: trace(C_STATE_LEVEL, l_procedure_name, 'l_ccid='||l_ccid);

Line 1547: dbms_sql.close_cursor (l_fund_cur_id);

1543: l_tot_amount := l_tot_amount + NVL(l_amount, 0);
1544:
1545: trace(C_STATE_LEVEL, l_procedure_name, ' gl_bc_packets l_tot_amount='||l_tot_amount);
1546: END LOOP;
1547: dbms_sql.close_cursor (l_fund_cur_id);
1548: END IF;
1549:
1550: p_anticipated_amt := l_tot_amount;
1551: trace(C_PROC_LEVEL, l_procedure_name, 'p_anticipated_amt='||p_anticipated_amt);