PACKAGE: APPS.IGS_PS_FACLTY_DEGRS_PKG

Source

1 PACKAGE igs_ps_faclty_degrs_pkg AS
2 /* $Header: IGSPI0OS.pls 120.0 2005/06/02 03:52:47 appldev noship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_FACLTY_DEGRD_ID IN OUT NOCOPY NUMBER,
6        x_PERSON_ID IN NUMBER,
7        x_DEGREE_CD IN VARCHAR2,
8        x_PROGRAM IN VARCHAR2,
9        x_INSTITUTION_CD IN VARCHAR2,
10        x_DEGREE_DATE IN DATE,
11       X_MODE in VARCHAR2 default 'R'
12   );
13 
14  procedure LOCK_ROW (
15       X_ROWID in  VARCHAR2,
16        x_FACLTY_DEGRD_ID IN NUMBER,
17        x_PERSON_ID IN NUMBER,
18        x_DEGREE_CD IN VARCHAR2,
19        x_PROGRAM IN VARCHAR2,
20        x_INSTITUTION_CD IN VARCHAR2,
21        x_DEGREE_DATE IN DATE  );
22  procedure UPDATE_ROW (
23       X_ROWID in  VARCHAR2,
24        x_FACLTY_DEGRD_ID IN NUMBER,
25        x_PERSON_ID IN NUMBER,
26        x_DEGREE_CD IN VARCHAR2,
27        x_PROGRAM IN VARCHAR2,
28        x_INSTITUTION_CD IN VARCHAR2,
29        x_DEGREE_DATE IN DATE,
30       X_MODE in VARCHAR2 default 'R'
31   );
32 
33  procedure ADD_ROW (
34       X_ROWID in out NOCOPY VARCHAR2,
35        x_FACLTY_DEGRD_ID IN OUT NOCOPY NUMBER,
36        x_PERSON_ID IN NUMBER,
37        x_DEGREE_CD IN VARCHAR2,
38        x_PROGRAM IN VARCHAR2,
39        x_INSTITUTION_CD IN VARCHAR2,
40        x_DEGREE_DATE IN DATE,
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_faclty_degrd_id IN NUMBER
50     ) RETURN BOOLEAN;
51 
52   FUNCTION get_uk_for_validation (
53     x_degree_cd IN VARCHAR2,
54     x_person_id IN NUMBER,
55     x_program   IN VARCHAR2  --bug:2082568
56     ) RETURN BOOLEAN;
57 
58   PROCEDURE Get_FK_Igs_Ps_Degrees (
59     x_degree_cd IN VARCHAR2
60     );
61 
62   PROCEDURE Get_FK_Igs_Or_Institution (
63     x_institution_cd IN VARCHAR2
64     );
65 
66   PROCEDURE Get_FK_Igs_Pe_Person (
67     x_person_id IN NUMBER
68     );
69 
70   PROCEDURE Check_Constraints (
71 		 Column_Name IN VARCHAR2  DEFAULT NULL,
72 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
73   PROCEDURE Before_DML (
74     p_action IN VARCHAR2,
75     x_rowid IN VARCHAR2 DEFAULT NULL,
76     x_faclty_degrd_id IN NUMBER DEFAULT NULL,
77     x_person_id IN NUMBER DEFAULT NULL,
78     x_degree_cd IN VARCHAR2 DEFAULT NULL,
79     x_program IN VARCHAR2 DEFAULT NULL,
80     x_institution_cd IN VARCHAR2 DEFAULT NULL,
81     x_degree_date IN DATE DEFAULT NULL,
82     x_creation_date IN DATE DEFAULT NULL,
83     x_created_by IN NUMBER DEFAULT NULL,
84     x_last_update_date IN DATE DEFAULT NULL,
85     x_last_updated_by IN NUMBER DEFAULT NULL,
86     x_last_update_login IN NUMBER DEFAULT NULL
87  );
88 END igs_ps_faclty_degrs_pkg;