1 PACKAGE IGS_PS_GEN_005 AUTHID CURRENT_USER AS
2 /* $Header: IGSPS05S.pls 115.4 2002/11/29 02:54:33 nsidana ship $ */
3
4 FUNCTION CRSP_DEL_TRO_HIST(
5 p_unit_cd IN VARCHAR2 ,
6 p_version_number IN NUMBER ,
7 p_cal_type IN VARCHAR2 ,
8 p_ci_sequence_number IN NUMBER ,
9 p_location_cd IN VARCHAR2 ,
10 p_unit_class IN VARCHAR2 ,
11 p_org_unit_cd IN VARCHAR2 ,
12 p_ou_start_dt IN DATE ,
13 p_message_name OUT NOCOPY VARCHAR2 )
14 RETURN BOOLEAN;
15
16
17 FUNCTION crsp_ins_calul(
18 p_course_cd IN VARCHAR2 ,
19 p_version_number IN NUMBER ,
20 p_yr_num IN NUMBER ,
21 p_effective_start_dt IN DATE ,
22 p_message_name OUT NOCOPY VARCHAR2 )
23 RETURN BOOLEAN;
24
25 PROCEDURE CRSP_INS_TRO_HIST(
26 p_unit_cd IN VARCHAR2 ,
27 p_version_number IN NUMBER ,
28 p_cal_type IN VARCHAR2 ,
29 p_ci_sequence_number IN NUMBER ,
30 p_location_cd IN VARCHAR2 ,
31 p_unit_class IN VARCHAR2 ,
32 p_org_unit_cd IN VARCHAR2 ,
33 p_ou_start_dt IN DATE ,
34 p_new_percentage IN NUMBER ,
35 p_old_percentage IN NUMBER ,
36 p_new_update_who IN VARCHAR2 ,
37 p_old_update_who IN VARCHAR2 ,
38 p_new_update_on IN DATE ,
39 p_old_update_on IN DATE )
40 ;
41
42 PROCEDURE crsp_ins_tr_hist(
43 p_unit_cd IN VARCHAR2 ,
44 p_version_number IN NUMBER ,
45 p_org_unit_cd IN VARCHAR2 ,
46 p_ou_start_dt IN DATE ,
47 p_last_update_on IN DATE ,
48 p_update_on IN DATE ,
49 p_last_update_who IN VARCHAR2 ,
50 p_percentage IN NUMBER )
51 ;
52
53 PROCEDURE crsp_ins_ud_hist(
54 p_unit_cd IN VARCHAR2 ,
55 p_version_number IN NUMBER ,
56 p_discipline_group_cd IN VARCHAR2 ,
57 p_last_update_on IN DATE ,
58 p_update_on IN DATE ,
59 p_last_update_who IN VARCHAR2 ,
60 p_percentage IN NUMBER )
61 ;
62
63 PROCEDURE crsp_ins_urc_hist(
64 p_unit_cd IN VARCHAR2 ,
65 p_version_number IN NUMBER ,
66 p_reference_cd_type IN VARCHAR2 ,
67 p_reference_cd IN VARCHAR2 ,
68 p_last_update_on IN DATE ,
69 p_update_on IN DATE ,
70 p_last_update_who IN VARCHAR2 ,
71 p_description IN VARCHAR2 )
72 ;
73
74 END IGS_PS_GEN_005;
[Home] [Help]