1 PACKAGE igs_ad_edugoal_pkg AS
2 /* $Header: IGSAIA1S.pls 120.0 2005/06/01 22:57:10 appldev noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 x_POST_EDUGOAL_ID IN OUT NOCOPY NUMBER,
6 x_PERSON_ID IN NUMBER,
7 x_ADMISSION_APPL_NUMBER IN NUMBER,
8 x_NOMINATED_COURSE_CD IN VARCHAR2,
9 x_SEQUENCE_NUMBER IN NUMBER,
10 x_EDU_GOAL_ID IN NUMBER,
11 X_MODE in VARCHAR2 default 'R'
12 );
13
14 procedure LOCK_ROW (
15 X_ROWID in VARCHAR2,
16 x_POST_EDUGOAL_ID IN NUMBER,
17 x_PERSON_ID IN NUMBER,
18 x_ADMISSION_APPL_NUMBER IN NUMBER,
19 x_NOMINATED_COURSE_CD IN VARCHAR2,
20 x_SEQUENCE_NUMBER IN NUMBER,
21 x_EDU_GOAL_ID IN NUMBER );
22 procedure UPDATE_ROW (
23 X_ROWID in VARCHAR2,
24 x_POST_EDUGOAL_ID IN NUMBER,
25 x_PERSON_ID IN NUMBER,
26 x_ADMISSION_APPL_NUMBER IN NUMBER,
27 x_NOMINATED_COURSE_CD IN VARCHAR2,
28 x_SEQUENCE_NUMBER IN NUMBER,
29 x_EDU_GOAL_ID IN NUMBER,
30 X_MODE in VARCHAR2 default 'R'
31 );
32
33 procedure ADD_ROW (
34 X_ROWID in out NOCOPY VARCHAR2,
35 x_POST_EDUGOAL_ID IN OUT NOCOPY NUMBER,
36 x_PERSON_ID IN NUMBER,
37 x_ADMISSION_APPL_NUMBER IN NUMBER,
38 x_NOMINATED_COURSE_CD IN VARCHAR2,
39 x_SEQUENCE_NUMBER IN NUMBER,
40 x_EDU_GOAL_ID IN NUMBER,
41 X_MODE in VARCHAR2 default 'R'
42 ) ;
43
44 procedure DELETE_ROW (
45 X_ROWID in VARCHAR2,
46 x_mode IN VARCHAR2 DEFAULT 'R'
47 ) ;
48 FUNCTION Get_PK_For_Validation (
49 x_post_edugoal_id IN NUMBER
50 ) RETURN BOOLEAN ;
51
52 FUNCTION Get_UK_For_Validation (
53 x_admission_appl_number IN NUMBER,
54 x_edu_goal_id IN NUMBER,
55 x_nominated_course_cd IN VARCHAR2,
56 x_person_id IN NUMBER,
57 x_sequence_number IN NUMBER
58 ) RETURN BOOLEAN;
59
60 PROCEDURE Get_FK_Igs_Ad_Ps_Appl_Inst (
61 x_person_id IN NUMBER,
62 x_admission_appl_number IN NUMBER,
63 x_nominated_course_cd IN VARCHAR2,
64 x_sequence_number IN NUMBER
65 );
66
67 PROCEDURE Get_FK_Igs_Ad_Code_Classes (
68 x_code_id IN NUMBER
69 );
70
71 PROCEDURE Check_Constraints (
72 Column_Name IN VARCHAR2 DEFAULT NULL,
73 Column_Value IN VARCHAR2 DEFAULT NULL ) ;
74 PROCEDURE Before_DML (
75 p_action IN VARCHAR2,
76 x_rowid IN VARCHAR2 DEFAULT NULL,
77 x_post_edugoal_id IN NUMBER DEFAULT NULL,
78 x_person_id IN NUMBER DEFAULT NULL,
79 x_admission_appl_number IN NUMBER DEFAULT NULL,
80 x_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
81 x_sequence_number IN NUMBER DEFAULT NULL,
82 x_edu_goal_id IN NUMBER DEFAULT NULL,
83 x_creation_date IN DATE DEFAULT NULL,
84 x_created_by IN NUMBER DEFAULT NULL,
85 x_last_update_date IN DATE DEFAULT NULL,
86 x_last_updated_by IN NUMBER DEFAULT NULL,
87 x_last_update_login IN NUMBER DEFAULT NULL
88 );
89 END igs_ad_edugoal_pkg;