PACKAGE: APPS.IGS_EN_TIMESLOT_STUP_PKG

Source

1 PACKAGE igs_en_timeslot_stup_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSEI38S.pls 115.4 2002/11/28 23:41:36 nsidana ship $ */
3  PROCEDURE insert_row (
4    x_rowid IN OUT NOCOPY VARCHAR2,
5    x_sequence_number IN NUMBER,
6    x_student_type IN VARCHAR2,
7    x_assign_randomly IN VARCHAR2,
8    x_surname_alphabet IN VARCHAR2,
9    x_cal_type IN VARCHAR2,
10    x_igs_en_timeslot_stup_id IN OUT NOCOPY NUMBER,
11    x_program_type_group_cd IN VARCHAR2,
12    x_mode IN VARCHAR2 DEFAULT 'R' ,
13    X_ORG_ID in NUMBER
14    );
15 
16  PROCEDURE lock_row (
17    x_rowid IN VARCHAR2,
18    x_sequence_number IN NUMBER,
19    x_student_type IN VARCHAR2,
20    x_assign_randomly IN VARCHAR2,
21    x_surname_alphabet IN VARCHAR2,
22    x_cal_type IN VARCHAR2,
23    x_igs_en_timeslot_stup_id IN NUMBER,
24    x_program_type_group_cd IN VARCHAR2  );
25 
26  PROCEDURE update_row (
27    x_rowid IN VARCHAR2,
28    x_sequence_number IN NUMBER,
29    x_student_type IN VARCHAR2,
30    x_assign_randomly IN VARCHAR2,
31    x_surname_alphabet IN VARCHAR2,
32    x_cal_type IN VARCHAR2,
33    x_igs_en_timeslot_stup_id IN NUMBER,
34    x_program_type_group_cd IN VARCHAR2,
35    x_mode IN VARCHAR2 DEFAULT 'R'
36   );
37 
38  PROCEDURE add_row (
39    x_rowid IN OUT NOCOPY VARCHAR2,
40    x_sequence_number IN NUMBER,
41    x_student_type IN VARCHAR2,
42    x_assign_randomly IN VARCHAR2,
43    x_surname_alphabet IN VARCHAR2,
44    x_cal_type IN VARCHAR2,
45    x_igs_en_timeslot_stup_id IN OUT NOCOPY NUMBER,
46    x_program_type_group_cd IN VARCHAR2,
47    x_mode IN VARCHAR2 DEFAULT 'R' ,
48    X_ORG_ID in NUMBER
49    );
50 
51  PROCEDURE delete_row (
52    x_rowid IN VARCHAR2
53  ) ;
54  FUNCTION get_pk_for_validation (
55    x_igs_en_timeslot_stup_id IN NUMBER
56    ) RETURN BOOLEAN ;
57 
58  FUNCTION get_uk_for_validation (
59    x_program_type_group_cd IN VARCHAR2,
60     x_cal_type IN VARCHAR2,
61     x_sequence_number IN NUMBER,
62     x_student_type IN VARCHAR2
63    ) RETURN BOOLEAN;
64 
65  PROCEDURE get_fk_igs_ca_inst (
66    x_cal_type IN VARCHAR2,
67    x_sequence_number IN NUMBER
68     );
69 
70  PROCEDURE get_fk_igs_ps_type_grp (
71    x_course_type_group_cd IN VARCHAR2
72     );
73 
74  PROCEDURE check_constraints (
75    column_name IN VARCHAR2  DEFAULT NULL,
76    column_value IN VARCHAR2  DEFAULT NULL ) ;
77  PROCEDURE before_dml (
78     p_action IN VARCHAR2,
79     x_rowid IN VARCHAR2 DEFAULT NULL,
80     x_sequence_number IN NUMBER DEFAULT NULL,
81     x_student_type IN VARCHAR2 DEFAULT NULL,
82     x_assign_randomly IN VARCHAR2 DEFAULT NULL,
83     x_surname_alphabet IN VARCHAR2 DEFAULT NULL,
84     x_cal_type IN VARCHAR2 DEFAULT NULL,
85     x_igs_en_timeslot_stup_id IN NUMBER DEFAULT NULL,
86     x_program_type_group_cd IN VARCHAR2 DEFAULT NULL,
87     x_creation_date IN DATE DEFAULT NULL,
88     x_created_by IN NUMBER DEFAULT NULL,
89     x_last_update_date IN DATE DEFAULT NULL,
90     x_last_updated_by IN NUMBER DEFAULT NULL,
91     x_last_update_login IN NUMBER DEFAULT NULL,
92     X_ORG_ID in NUMBER DEFAULT NULL);
93 
94 END igs_en_timeslot_stup_pkg;