PACKAGE: APPS.IGS_EN_CAREER_MODEL

Source

1 PACKAGE IGS_EN_CAREER_MODEL AUTHID CURRENT_USER AS
2 /* $Header: IGSEN86S.pls 115.4 2002/11/29 00:12:09 nsidana noship $ */
3 
4   FUNCTION ENRP_GET_SEC_SCA_STATUS(
5     p_person_id IN NUMBER ,
6     p_course_cd IN VARCHAR2 ,
7     p_course_attempt_status IN VARCHAR2 ,
8     p_primary_program_type IN VARCHAR2,
9     p_primary_prog_type_source IN VARCHAR2,
10     p_course_type IN VARCHAR2 ,
11     p_new_primary_course_cd  IN VARCHAR2 DEFAULT NULL
12   )RETURN VARCHAR2;
13 
14 
15   PROCEDURE SCA_TBH_BEFORE_DML(
16     p_person_id IN NUMBER,
17     p_course_cd IN VARCHAR2,
18     p_version_number IN NUMBER,
19     p_old_course_attempt_status IN VARCHAR2 ,
20     p_new_course_attempt_status IN OUT NOCOPY VARCHAR2 ,
21     p_primary_program_type IN OUT NOCOPY VARCHAR2,
22     p_primary_prog_type_source IN OUT NOCOPY VARCHAR2,
23     p_new_key_program  IN OUT NOCOPY VARCHAR2
24   );
25 
26   PROCEDURE SCA_TBH_AFTER_DML(
27     p_person_id IN NUMBER,
28     p_course_cd IN VARCHAR2,
29     p_version_number IN NUMBER,
30     p_old_course_attempt_status IN VARCHAR2 ,
31     p_new_course_attempt_status IN VARCHAR2 ,
32     p_primary_prog_type_source IN VARCHAR2,
33     p_old_pri_prog_type IN VARCHAR2,
34     p_new_pri_prog_type IN VARCHAR2 ,
35     p_old_key_program  IN  VARCHAR2
36    );
37 
38   FUNCTION ENRP_CHECK_FOR_ONE_PRIMARY (
39     p_person_id IN NUMBER,
40 	p_course_type IN VARCHAR2,
41     p_message_name OUT NOCOPY VARCHAR2
42   ) RETURN BOOLEAN;
43 
44 END IGS_EN_CAREER_MODEL;