APPS.CN_RULESET_PVT dependencies on CN_RULESETS_S

Line 232: (p_start_date IN cn_rulesets.start_date%TYPE,

228: -- Desc : Validate the start and end dates for the ruleset
229: --
230: --=========================================================================
231: FUNCTION check_ruleset_dates
232: (p_start_date IN cn_rulesets.start_date%TYPE,
233: p_end_date IN cn_rulesets.end_date%TYPE,
234: p_module_type IN cn_rulesets.module_type%TYPE,
235: p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
236: p_org_id IN cn_rulesets.org_id%TYPE,

Line 482: --else use cn_rulesets_s.nextval

478: END IF;
479:
480: --Now check if the ruleset exists.
481: --If it does, then raise error
482: --else use cn_rulesets_s.nextval
483: SELECT count(1)
484: INTO l_count
485: FROM cn_rulesets
486: WHERE name = p_ruleset_rec.ruleset_name

Line 506: SELECT Decode(p_ruleset_rec.ruleset_id, NULL, cn_rulesets_s.NEXTVAL,

502: RAISE FND_API.G_EXC_ERROR;
503:
504: END IF;
505:
506: SELECT Decode(p_ruleset_rec.ruleset_id, NULL, cn_rulesets_s.NEXTVAL,
507: p_ruleset_rec.ruleset_id)
508: INTO l_ruleset_id
509: FROM dual;
510:

Line 789: --else use cn_rulesets_s.nextval

785:
786:
787: --Now check if the ruleset exists.
788: --If it does, then raise error
789: --else use cn_rulesets_s.nextval
790: SELECT count(1)
791: INTO l_count
792: FROM cn_rulesets
793: WHERE ruleset_id = p_old_ruleset_rec.ruleset_id and