PACKAGE: APPS.IGS_AD_OTHER_INST_PKG

Source

1 PACKAGE igs_ad_other_inst_pkg AS
2 /* $Header: IGSAI99S.pls 120.2 2005/12/06 02:39:57 appldev ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_OTHER_INST_ID IN OUT NOCOPY NUMBER,
6        x_PERSON_ID IN NUMBER,
7        x_ADMISSION_APPL_NUMBER IN NUMBER,
8        x_INSTITUTION_CODE IN VARCHAR2,
9        X_MODE in VARCHAR2 default 'R',
10        x_new_institution IN VARCHAR2 DEFAULT NULL
11   );
12 
13  procedure LOCK_ROW (
14        X_ROWID in  VARCHAR2,
15        x_OTHER_INST_ID IN NUMBER,
16        x_PERSON_ID IN NUMBER,
17        x_ADMISSION_APPL_NUMBER IN NUMBER,
18        x_INSTITUTION_CODE IN VARCHAR2,
19        x_new_institution IN VARCHAR2 DEFAULT NULL  );
20  procedure UPDATE_ROW (
21        X_ROWID in  VARCHAR2,
22        x_OTHER_INST_ID IN NUMBER,
23        x_PERSON_ID IN NUMBER,
24        x_ADMISSION_APPL_NUMBER IN NUMBER,
25        x_INSTITUTION_CODE IN VARCHAR2,
26        X_MODE in VARCHAR2 default 'R',
27        x_new_institution IN VARCHAR2 DEFAULT NULL
28   );
29 
30  procedure ADD_ROW (
31        X_ROWID in out NOCOPY VARCHAR2,
32        x_OTHER_INST_ID IN OUT NOCOPY NUMBER,
33        x_PERSON_ID IN NUMBER,
34        x_ADMISSION_APPL_NUMBER IN NUMBER,
35        x_INSTITUTION_CODE IN VARCHAR2,
36        X_MODE in VARCHAR2 default 'R',
37        x_new_institution IN VARCHAR2 DEFAULT NULL
38   ) ;
39 
40 procedure DELETE_ROW (
41   X_ROWID in VARCHAR2,
42   x_mode IN VARCHAR2 DEFAULT 'R'
43 ) ;
44   FUNCTION Get_PK_For_Validation (
45     x_other_inst_id IN NUMBER
46     ) RETURN BOOLEAN ;
47 
48   FUNCTION Get_UK_For_Validation (
49     x_admission_appl_number IN NUMBER,
50     x_institution_code IN VARCHAR2,
51     x_person_id IN NUMBER,
52     x_new_institution IN VARCHAR2
53     ) RETURN BOOLEAN;
54 
55   PROCEDURE get_fk_igs_ad_appl (
56     x_person_id IN NUMBER,
57     x_admission_appl_number IN NUMBER
58     );
59 
60   PROCEDURE Get_FK_Igs_Or_Institution (
61     x_institution_cd IN VARCHAR2
62     );
63 
64   PROCEDURE Check_Constraints (
65 		 Column_Name IN VARCHAR2  DEFAULT NULL,
66 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
67   PROCEDURE Before_DML (
68     p_action IN VARCHAR2,
69     x_rowid IN VARCHAR2 DEFAULT NULL,
70     x_other_inst_id IN NUMBER DEFAULT NULL,
71     x_person_id IN NUMBER DEFAULT NULL,
72     x_admission_appl_number IN NUMBER DEFAULT NULL,
73     x_institution_code IN VARCHAR2 DEFAULT NULL,
74     x_creation_date IN DATE DEFAULT NULL,
75     x_created_by IN NUMBER DEFAULT NULL,
76     x_last_update_date IN DATE DEFAULT NULL,
77     x_last_updated_by IN NUMBER DEFAULT NULL,
78     x_last_update_login IN NUMBER DEFAULT NULL,
79     x_new_institution IN VARCHAR2 DEFAULT NULL
80  );
81 END igs_ad_other_inst_pkg;