1 PACKAGE IGS_RU_GEN_005 AUTHID CURRENT_USER AS
2 /* $Header: IGSRU11S.pls 115.9 2002/11/29 03:41:08 nsidana ship $ */
3 -- svenkata 14-MAR-2002 The procedures CHECK_CHILD_EXISTANCE_RU_RULE and CHECK_CHILD_EXISTANCE_RU_CALL have been
4 -- moved to the package IGS_RU_GEN_005. This procedure is being called (from the table handlers
5 -- IGS_RU_CALL_PKG and IGS_RU_RULE_PKG) only when the user is NOT DATA MERGE .Bug # 2233951.
6
7 FUNCTION RULP_VAL_SCA_COMP(
8 p_person_id IN NUMBER ,
9 p_sca_course_cd VARCHAR2 ,
10 p_sca_course_version NUMBER ,
11 p_course_cd IN VARCHAR2 ,
12 p_course_version NUMBER ,
13 p_predicted_ind VARCHAR2 DEFAULT 'N',
14 p_message_text OUT NOCOPY VARCHAR2 )
15 RETURN BOOLEAN;
16
17 FUNCTION RULP_VAL_SCA_PRG(
18 p_rul_sequence_number NUMBER ,
19 p_person_id IN NUMBER ,
20 p_course_cd IN VARCHAR2 ,
21 p_course_version NUMBER ,
22 p_prg_cal_type IN VARCHAR2 ,
23 p_prg_ci_sequence_number IN NUMBER ,
24 p_message_text OUT NOCOPY VARCHAR2 )
25 RETURN BOOLEAN;
26
27 FUNCTION RULP_VAL_STG_COMP(
28 p_person_id IN NUMBER ,
29 p_sca_course_cd VARCHAR2 ,
30 p_sca_course_version NUMBER ,
31 p_course_cd IN VARCHAR2 ,
32 p_course_version NUMBER ,
33 p_cst_sequence_number NUMBER ,
34 p_predicted_ind VARCHAR2 DEFAULT 'N',
35 p_message_text OUT NOCOPY VARCHAR2 )
36 RETURN BOOLEAN;
37
38 FUNCTION RULP_VAL_SUSA_COMP(
39 p_person_id IN NUMBER ,
40 p_sca_course_cd VARCHAR2 ,
41 p_sca_course_version NUMBER ,
42 p_course_cd IN VARCHAR2 ,
43 p_course_version NUMBER ,
44 p_unit_set_cd IN VARCHAR2 ,
45 p_unit_set_version NUMBER ,
46 p_predicted_ind VARCHAR2 DEFAULT 'N',
47 p_message_text OUT NOCOPY VARCHAR2 )
48 RETURN BOOLEAN;
49
50 PROCEDURE CHECK_CHILD_EXISTANCE_RU_RULE(
51 p_sequence_number IN NUMBER );
52
53 PROCEDURE CHECK_CHILD_EXISTANCE_RU_CALL (
54 p_rud_sequence_number IN NUMBER,
55 p_s_rule_call_cd IN VARCHAR2 );
56
57 END IGS_RU_GEN_005;