PACKAGE: APPS.IGS_EN_OR_UNIT_WLST_PKG

Source

1 PACKAGE igs_en_or_unit_wlst_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSEI33S.pls 115.9 2003/09/18 03:39:07 svanukur ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_ORG_UNIT_WLST_ID IN OUT NOCOPY NUMBER,
6        x_ORG_UNIT_CD IN VARCHAR2,
7        x_START_DT IN DATE,
8        x_CAL_TYPE IN VARCHAR2,
9        x_MAX_STUD_PER_WLST IN NUMBER,
10        x_SMTANUS_WLST_UNIT_ENR_ALWD IN VARCHAR2,
11        x_ASSES_CHRG_FOR_WLST_STUD IN VARCHAR2,
12        x_MODE in VARCHAR2 default 'R'  ,
13        x_org_id IN NUMBER,
14       x_CLOSED_FLAG IN VARCHAR2 DEFAULT 'N'
15   );
16 
17  procedure LOCK_ROW (
18       X_ROWID in  VARCHAR2,
19        x_ORG_UNIT_WLST_ID IN NUMBER,
20        x_ORG_UNIT_CD IN VARCHAR2,
21        x_START_DT IN DATE,
22        x_CAL_TYPE IN VARCHAR2,
23        x_MAX_STUD_PER_WLST IN NUMBER,
24        x_SMTANUS_WLST_UNIT_ENR_ALWD IN VARCHAR2,
25        x_ASSES_CHRG_FOR_WLST_STUD IN VARCHAR2,
26        x_CLOSED_FLAG IN VARCHAR2 DEFAULT 'N'
27          );
28  procedure UPDATE_ROW (
29       X_ROWID in  VARCHAR2,
30        x_ORG_UNIT_WLST_ID IN NUMBER,
31        x_ORG_UNIT_CD IN VARCHAR2,
32        x_START_DT IN DATE,
33        x_CAL_TYPE IN VARCHAR2,
34        x_MAX_STUD_PER_WLST IN NUMBER,
35        x_SMTANUS_WLST_UNIT_ENR_ALWD IN VARCHAR2,
36        x_ASSES_CHRG_FOR_WLST_STUD IN VARCHAR2,
37        X_MODE in VARCHAR2 default 'R',
38        x_CLOSED_FLAG IN VARCHAR2 DEFAULT 'N'
39   );
40 
41  procedure ADD_ROW (
42       X_ROWID in out NOCOPY VARCHAR2,
43        x_ORG_UNIT_WLST_ID IN OUT NOCOPY NUMBER,
44        x_ORG_UNIT_CD IN VARCHAR2,
45        x_START_DT IN DATE,
46        x_CAL_TYPE IN VARCHAR2,
47        x_MAX_STUD_PER_WLST IN NUMBER,
48        x_SMTANUS_WLST_UNIT_ENR_ALWD IN VARCHAR2,
49        x_ASSES_CHRG_FOR_WLST_STUD IN VARCHAR2,
50        X_MODE in VARCHAR2 default 'R'  ,
51        x_org_id IN NUMBER,
52        x_CLOSED_FLAG IN VARCHAR2 DEFAULT 'N'
53   ) ;
54 
55 procedure DELETE_ROW (
56   X_ROWID in VARCHAR2
57 ) ;
58   FUNCTION Get_PK_For_Validation (
59     x_org_unit_wlst_id IN NUMBER
60     ) RETURN BOOLEAN ;
61 
62   FUNCTION Get_UK_For_Validation (
63     x_cal_type IN VARCHAR2,
64     x_org_unit_cd IN VARCHAR2,
65     x_start_dt IN DATE
66     ) RETURN BOOLEAN;
67 
68   PROCEDURE Get_FK_Igs_Or_Unit (
69     x_org_unit_cd IN VARCHAR2,
70     x_start_dt IN DATE
71     );
72 
73   PROCEDURE Get_FK_Igs_Ca_Inst (
74     x_cal_type IN VARCHAR2,
75     x_sequence_number IN NUMBER
76     );
77 
78   PROCEDURE Get_FK_Igs_Ca_Type (
79     x_cal_type IN VARCHAR2
80        );
81   PROCEDURE Check_Constraints (
82 		 Column_Name IN VARCHAR2  DEFAULT NULL,
83 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
84   PROCEDURE Before_DML (
85     p_action IN VARCHAR2,
86     x_rowid IN VARCHAR2 DEFAULT NULL,
87     x_org_unit_wlst_id IN NUMBER DEFAULT NULL,
88     x_org_unit_cd IN VARCHAR2 DEFAULT NULL,
89     x_start_dt IN DATE DEFAULT NULL,
90     x_cal_type IN VARCHAR2 DEFAULT NULL,
91     x_max_stud_per_wlst IN NUMBER DEFAULT NULL,
92     x_smtanus_wlst_unit_enr_alwd IN VARCHAR2 DEFAULT NULL,
93     x_asses_chrg_for_wlst_stud IN VARCHAR2 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     x_org_id IN NUMBER DEFAULT NULL,
100     x_closed_flag IN VARCHAR2 DEFAULT 'N'
101  );
102 END igs_en_or_unit_wlst_pkg;