DBA Data[Home] [Help]

APPS.AMS_PS_RULE_PVT dependencies on AMS_IBA_PS_RL_ST_PARAMS

Line 1729: SELECT AMS_IBA_PS_RL_ST_PARAMS_s.NEXTVAL

1725: l_index NUMBER;
1726: l_dummy NUMBER;
1727:
1728: CURSOR c_id IS
1729: SELECT AMS_IBA_PS_RL_ST_PARAMS_s.NEXTVAL
1730: FROM dual;
1731:
1732: CURSOR c_id_exists (l_id IN NUMBER) IS
1733: SELECT 1

Line 1734: FROM AMS_IBA_PS_RL_ST_PARAMS

1730: FROM dual;
1731:
1732: CURSOR c_id_exists (l_id IN NUMBER) IS
1733: SELECT 1
1734: FROM AMS_IBA_PS_RL_ST_PARAMS
1735: WHERE RULE_STRAT_PARAM_ID = l_id;
1736:
1737: BEGIN
1738: x_return_status := FND_API.g_ret_sts_success;

Line 1750: DELETE FROM AMS_IBA_PS_RL_ST_PARAMS

1746: AMS_UTILITY_PVT.debug_message('Private API: - deleting existing strategy parameters');
1747:
1748: END IF;
1749:
1750: DELETE FROM AMS_IBA_PS_RL_ST_PARAMS
1751: WHERE rulegroup_id = p_rulegroup_id;
1752:
1753: IF (AMS_DEBUG_HIGH_ON) THEN
1754:

Line 1794: INSERT INTO AMS_IBA_PS_RL_ST_PARAMS(

1790: CLOSE c_id_exists;
1791: EXIT WHEN l_dummy IS NULL;
1792: END LOOP;
1793:
1794: INSERT INTO AMS_IBA_PS_RL_ST_PARAMS(
1795: created_by,
1796: creation_date,
1797: last_updated_by,
1798: last_update_date,