1 PACKAGE IGS_AZ_ADVISING_RELS_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSHI04S.pls 115.1 2003/06/12 11:40:38 kdande noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_group_advising_rel_id IN OUT NOCOPY NUMBER,
7 x_group_name IN VARCHAR2,
8 x_group_advisor_id IN NUMBER,
9 x_group_student_id IN NUMBER,
10 x_START_DATE IN DATE,
11 x_END_DATE IN DATE,
12 x_mode IN VARCHAR2 DEFAULT 'R',
13 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
14 X_MSG_DATA OUT NOCOPY VARCHAR2,
15 X_MSG_COUNT OUT NOCOPY NUMBER
16 );
17
18 PROCEDURE lock_row (
19 x_rowid IN VARCHAR2,
20 x_group_advising_rel_id IN NUMBER,
21 x_group_name IN VARCHAR2,
22 x_group_advisor_id IN NUMBER,
23 x_group_student_id IN NUMBER,
24 x_START_DATE IN DATE,
25 x_END_DATE IN DATE,
26 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
27 X_MSG_DATA OUT NOCOPY VARCHAR2,
28 X_MSG_COUNT OUT NOCOPY NUMBER
29 );
30
31 PROCEDURE update_row (
32 x_rowid IN VARCHAR2,
33 x_group_advising_rel_id IN NUMBER,
34 x_group_name IN VARCHAR2,
35 x_group_advisor_id IN NUMBER,
36 x_group_student_id IN NUMBER,
37 x_START_DATE IN DATE,
38 x_END_DATE IN DATE,
39 x_mode IN VARCHAR2 DEFAULT 'R',
40 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
41 X_MSG_DATA OUT NOCOPY VARCHAR2,
42 X_MSG_COUNT OUT NOCOPY NUMBER
43 );
44
45 PROCEDURE add_row (
46 x_rowid IN OUT NOCOPY VARCHAR2,
47 x_group_advising_rel_id IN OUT NOCOPY NUMBER,
48 x_group_name IN VARCHAR2,
49 x_group_advisor_id IN NUMBER,
50 x_group_student_id IN NUMBER,
51 x_START_DATE IN DATE,
52 x_END_DATE IN DATE,
53 x_mode IN VARCHAR2 DEFAULT 'R'
54 );
55
56 PROCEDURE delete_row (
57 x_rowid IN VARCHAR2,
58 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
59 X_MSG_DATA OUT NOCOPY VARCHAR2,
60 X_MSG_COUNT OUT NOCOPY NUMBER
61 );
62
63 FUNCTION get_pk_for_validation (
64 x_group_advising_rel_id IN NUMBER
65 ) RETURN BOOLEAN;
66
67 FUNCTION get_uk_for_validation (
68 x_group_name IN VARCHAR2,
69 x_group_advisor_id IN NUMBER,
70 x_group_student_id IN NUMBER
71 ) RETURN BOOLEAN;
72
73 PROCEDURE get_fk_IGS_AZ_GROUPS (
74 x_group_name IN VARCHAR2
75 );
76
77 PROCEDURE get_fk_IGS_AZ_STUDENTS (
78 x_group_student_id IN NUMBER
79 );
80
81 PROCEDURE get_fk_IGS_AZ_ADVISORS (
82 x_group_advisor_id IN NUMBER
83 );
84
85 PROCEDURE before_dml (
86 p_action IN VARCHAR2,
87 x_rowid IN VARCHAR2 DEFAULT NULL,
88 x_group_advising_rel_id IN NUMBER DEFAULT NULL,
89 x_group_name IN VARCHAR2 DEFAULT NULL,
90 x_group_advisor_id IN NUMBER DEFAULT NULL,
91 x_group_student_id IN NUMBER DEFAULT NULL,
92 x_START_DATE IN DATE DEFAULT NULL,
93 x_END_DATE IN DATE DEFAULT NULL,
94 x_creation_date IN DATE DEFAULT NULL,
95 x_created_by IN NUMBER DEFAULT NULL,
96 x_last_update_date IN DATE DEFAULT NULL,
97 x_last_updated_by IN NUMBER DEFAULT NULL,
98 x_last_update_login IN NUMBER DEFAULT NULL
99 );
100
101 END IGS_AZ_ADVISING_RELS_pkg;