APPS.AMS_PS_RULE_PVT dependencies on AMS_IBA_PS_RL_ST_FLTRS

Line 1615: SELECT AMS_IBA_PS_RL_ST_FLTRS_s.NEXTVAL

1611: l_index NUMBER;
1612: l_dummy NUMBER;
1613:
1614: CURSOR c_id IS
1615: SELECT AMS_IBA_PS_RL_ST_FLTRS_s.NEXTVAL
1616: FROM dual;
1617:
1618: CURSOR c_id_exists (l_id IN NUMBER) IS
1619: SELECT 1

Line 1620: FROM AMS_IBA_PS_RL_ST_FLTRS

1616: FROM dual;
1617:
1618: CURSOR c_id_exists (l_id IN NUMBER) IS
1619: SELECT 1
1620: FROM AMS_IBA_PS_RL_ST_FLTRS
1621: WHERE RULE_STRAT_FILTER_ID = l_id;
1622:
1623: BEGIN
1624: x_return_status := FND_API.g_ret_sts_success;

Line 1636: DELETE FROM AMS_IBA_PS_RL_ST_FLTRS

1632: AMS_UTILITY_PVT.debug_message('Private API: - deleting existing filters');
1633:
1634: END IF;
1635:
1636: DELETE FROM AMS_IBA_PS_RL_ST_FLTRS
1637: WHERE rulegroup_id = p_rulegroup_id;
1638:
1639: IF (AMS_DEBUG_HIGH_ON) THEN
1640:

Line 1678: INSERT INTO AMS_IBA_PS_RL_ST_FLTRS(

1674: CLOSE c_id_exists;
1675: EXIT WHEN l_dummy IS NULL;
1676: END LOOP;
1677:
1678: INSERT INTO AMS_IBA_PS_RL_ST_FLTRS(
1679: created_by,
1680: creation_date,
1681: last_updated_by,
1682: last_update_date,