1 PACKAGE CZ_RULES_SEQ AUTHID CURRENT_USER AS
2 /* $Header: czrseqs.pls 115.10 2002/12/03 14:53:34 askhacha ship $ */
3
4 NULL_ CONSTANT INTEGER:=-1;
5 YES_FLAG CONSTANT VARCHAR2(1):='1';
6 NO_FLAG CONSTANT VARCHAR2(1):='0';
7
8 PROCEDURE RemoveFromSequence
9 (p_rule_sequence_id IN INTEGER, --ID of the rule sequence
10 p_model_id IN INTEGER, --ID of the model
11 p_rule_id IN INTEGER, --ID of the rule which was removed
12 p_out_err OUT NOCOPY INTEGER , --err flag
13 deleted_flag IN VARCHAR2 -- DEFAULT '0'); -- flag if the rule was logically deleted
14 );
15
16 PROCEDURE MoveInSequence
17 (p_rule_sequence_id IN INTEGER, --ID of the rule sequence
18 p_model_id IN INTEGER, --ID of the model
19 p_rule_id IN INTEGER, --ID of the rule which is moved within the sequence
20 p_new_sequence IN INTEGER, --New sequence number of the moved rule
21 p_out_err OUT NOCOPY INTEGER); --err flag
22
23 PROCEDURE ChangeEffectivity
24 (p_rule_sequence_id IN INTEGER, --ID of the rule sequence
25 p_model_id IN INTEGER, --ID of the model
26 p_rule_id IN INTEGER, --ID of the rule whose effectivity changed
27 p_out_err OUT NOCOPY INTEGER, --err flag
28 p_eff_start_date IN DATE DEFAULT NULL, -- New start date
29 p_eff_end_date IN DATE DEFAULT NULL, --New end date
30 p_eff_set_id IN INTEGER -- DEFAULT -1); --New effectivity set ID
31 );
32
33 PROCEDURE PropagateEffectivitySetChange
34 (p_effectivity_set_id IN INTEGER, --ID of the effectivity set
35 p_new_start_date IN DATE, --new start date
36 p_new_end_date IN DATE, --new end date
37 p_out_err OUT NOCOPY INTEGER); --Err flag
38
39 END;