1 PACKAGE IGS_PS_GEN_007 AUTHID CURRENT_USER AS
2 /* $Header: IGSPS07S.pls 115.6 2003/11/05 18:44:00 ijeddy ship $ */
3
4 FUNCTION crsp_get_rct_srct(
5 p_reference_cd_type IN IGS_GE_REF_CD_TYPE_ALL.reference_cd_type%TYPE ,
6 p_message_name OUT NOCOPY VARCHAR2)
7 RETURN VARCHAR2
8 ;
9
10 PROCEDURE crsp_ins_cow_hist(
11 p_course_cd IN VARCHAR2 ,
12 p_version_number IN NUMBER ,
13 p_org_unit_cd IN VARCHAR2 ,
14 p_ou_start_dt IN DATE ,
15 p_last_update_on IN DATE ,
16 p_update_on IN DATE ,
17 p_last_update_who IN VARCHAR2 ,
18 p_percentage IN NUMBER )
19 ;
20
21 PROCEDURE crsp_ins_crc_hist(
22 p_course_cd IN VARCHAR2 ,
23 p_version_number IN NUMBER ,
24 p_reference_cd_type IN VARCHAR2 ,
25 p_reference_cd IN VARCHAR2 ,
26 p_last_update_on IN DATE ,
27 p_update_on IN DATE ,
28 p_last_update_who IN VARCHAR2 ,
29 p_description IN VARCHAR2 )
30 ;
31
32 PROCEDURE crsp_ins_cul_hist(
33 p_unit_cd IN VARCHAR2 ,
34 p_version_number IN NUMBER ,
35 p_course_type VARCHAR2 DEFAULT NULL,
36 p_last_update_on IN DATE ,
37 p_update_on IN DATE ,
38 p_last_update_who IN VARCHAR2 ,
39 p_unit_level IN VARCHAR2 ,
40 p_wam_weighting IN NUMBER ,
41 p_course_cd VARCHAR2,
42 p_course_version_number NUMBER )
43 ;
44
45 END IGS_PS_GEN_007;