PACKAGE: APPS.IGS_PS_USEC_LIM_WLST_PKG

Source

1 PACKAGE igs_ps_usec_lim_wlst_pkg AS
2 /* $Header: IGSPI1LS.pls 120.1 2005/10/04 00:36:57 appldev ship $ */
3  procedure INSERT_ROW (
4        X_ROWID in out NOCOPY VARCHAR2,
5        x_unit_section_limit_wlst_id IN OUT NOCOPY NUMBER,
6        x_UOO_ID IN NUMBER,
7        x_ENROLLMENT_EXPECTED IN NUMBER,
8        x_ENROLLMENT_MINIMUM IN NUMBER,
9        x_ENROLLMENT_MAXIMUM IN NUMBER,
10        x_ADVANCE_MAXIMUM IN NUMBER,
11        x_WAITLIST_ALLOWED IN VARCHAR2,
12        x_MAX_STUDENTS_PER_WAITLIST IN NUMBER,
13        X_OVERRIDE_ENROLLMENT_MAX IN NUMBER DEFAULT NULL,
14        x_max_auditors_allowed IN NUMBER DEFAULT NULL,
15        X_MODE in VARCHAR2 default 'R'
16   );
17 
18  procedure LOCK_ROW (
19        X_ROWID in  VARCHAR2,
20        x_unit_section_limit_wlst_id IN NUMBER,
21        x_UOO_ID IN NUMBER,
22        x_ENROLLMENT_EXPECTED IN NUMBER,
23        x_ENROLLMENT_MINIMUM IN NUMBER,
24        x_ENROLLMENT_MAXIMUM IN NUMBER,
25        x_ADVANCE_MAXIMUM IN NUMBER,
26        x_WAITLIST_ALLOWED IN VARCHAR2,
27        x_MAX_STUDENTS_PER_WAITLIST IN NUMBER,
28        X_OVERRIDE_ENROLLMENT_MAX IN NUMBER DEFAULT NULL,
29        x_max_auditors_allowed IN NUMBER DEFAULT NULL
30        );
31  procedure UPDATE_ROW (
32        X_ROWID in  VARCHAR2,
33        x_unit_section_limit_wlst_id IN NUMBER,
34        x_UOO_ID IN NUMBER,
35        x_ENROLLMENT_EXPECTED IN NUMBER,
36        x_ENROLLMENT_MINIMUM IN NUMBER,
37        x_ENROLLMENT_MAXIMUM IN NUMBER,
38        x_ADVANCE_MAXIMUM IN NUMBER,
39        x_WAITLIST_ALLOWED IN VARCHAR2,
40        x_MAX_STUDENTS_PER_WAITLIST IN NUMBER,
41        X_OVERRIDE_ENROLLMENT_MAX IN NUMBER DEFAULT NULL,
42        x_max_auditors_allowed IN NUMBER DEFAULT NULL,
43        X_MODE in VARCHAR2 default 'R'
44   );
45 
46  procedure ADD_ROW (
47        X_ROWID in out NOCOPY VARCHAR2,
48        x_unit_section_limit_wlst_id IN OUT NOCOPY NUMBER,
49        x_UOO_ID IN NUMBER,
50        x_ENROLLMENT_EXPECTED IN NUMBER,
51        x_ENROLLMENT_MINIMUM IN NUMBER,
52        x_ENROLLMENT_MAXIMUM IN NUMBER,
53        x_ADVANCE_MAXIMUM IN NUMBER,
54        x_WAITLIST_ALLOWED IN VARCHAR2,
55        x_MAX_STUDENTS_PER_WAITLIST IN NUMBER,
56        X_OVERRIDE_ENROLLMENT_MAX IN NUMBER DEFAULT NULL,
57        x_max_auditors_allowed IN NUMBER DEFAULT NULL,
58        X_MODE in VARCHAR2 default 'R'
59   ) ;
60 
61 procedure DELETE_ROW (
62   X_ROWID in VARCHAR2
63 ) ;
64   FUNCTION Get_PK_For_Validation (
65     x_unit_section_limit_wlst_id IN NUMBER
66     ) RETURN BOOLEAN ;
67 
68   FUNCTION Get_UK_For_Validation (
69     x_uoo_id IN NUMBER
70     ) RETURN BOOLEAN;
71 
72   PROCEDURE Get_UFK_Igs_Ps_Unit_Ofr_Opt (
73     x_uoo_id IN NUMBER
74     );
75 
76   PROCEDURE Check_Constraints (
77 		 Column_Name IN VARCHAR2  DEFAULT NULL,
78 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
79   PROCEDURE Before_DML (
80     p_action IN VARCHAR2,
81     x_rowid IN VARCHAR2 DEFAULT NULL,
82     x_unit_section_limit_wlst_id IN NUMBER DEFAULT NULL,
83     x_uoo_id IN NUMBER DEFAULT NULL,
84     x_enrollment_expected IN NUMBER DEFAULT NULL,
85     x_enrollment_minimum IN NUMBER DEFAULT NULL,
86     x_enrollment_maximum IN NUMBER DEFAULT NULL,
87     x_advance_maximum IN NUMBER DEFAULT NULL,
88     x_waitlist_allowed IN VARCHAR2 DEFAULT NULL,
89     x_max_students_per_waitlist IN NUMBER DEFAULT NULL,
90     X_OVERRIDE_ENROLLMENT_MAX IN NUMBER DEFAULT NULL,
91     x_max_auditors_allowed IN NUMBER DEFAULT NULL,
92     x_creation_date IN DATE DEFAULT NULL,
93     x_created_by IN NUMBER DEFAULT NULL,
94     x_last_update_date IN DATE DEFAULT NULL,
95     x_last_updated_by IN NUMBER DEFAULT NULL,
96     x_last_update_login IN NUMBER DEFAULT NULL
97  );
98 END igs_ps_usec_lim_wlst_pkg;