PACKAGE: APPS.IGS_AD_SPL_ADM_CAT_PKG

Source

1 PACKAGE igs_ad_spl_adm_cat_pkg AS
2 /* $Header: IGSAIA3S.pls 120.0 2005/06/01 16:11:40 appldev noship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_SPL_ADM_CAT_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_SPL_ADM_CAT IN NUMBER,
11       X_MODE in VARCHAR2 default 'R'
12   );
13 
14  procedure LOCK_ROW (
15       X_ROWID in  VARCHAR2,
16        x_SPL_ADM_CAT_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_SPL_ADM_CAT IN NUMBER  );
22  procedure UPDATE_ROW (
23       X_ROWID in  VARCHAR2,
24        x_SPL_ADM_CAT_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_SPL_ADM_CAT IN NUMBER,
30       X_MODE in VARCHAR2 default 'R'
31   );
32 
33  procedure ADD_ROW (
34       X_ROWID in out NOCOPY VARCHAR2,
35        x_SPL_ADM_CAT_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_SPL_ADM_CAT 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_spl_adm_cat_id IN NUMBER
50     ) RETURN BOOLEAN ;
51 
52   FUNCTION Get_UK_For_Validation (
53     x_admission_appl_number IN NUMBER,
54     x_nominated_course_cd IN VARCHAR2,
55     x_person_id IN NUMBER,
56     x_sequence_number IN NUMBER,
57     x_spl_adm_cat 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_spl_adm_cat_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_spl_adm_cat 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_spl_adm_cat_pkg;