PACKAGE: APPS.IGS_PE_ACAD_HONORS_PKG

Source

1 PACKAGE IGS_PE_ACAD_HONORS_PKG AS
2 /* $Header: IGSNI99S.pls 120.0 2005/06/01 20:15:04 appldev noship $ */
3  procedure INSERT_ROW (
4        X_ROWID in out NOCOPY VARCHAR2,
5        x_ACAD_HONOR_ID IN OUT NOCOPY NUMBER,
6        x_PERSON_ID IN NUMBER,
7        x_COMMENTS IN VARCHAR2,
8        x_HONOR_DATE IN DATE,
9        X_MODE in VARCHAR2 default 'R',
10        X_ACAD_HONOR_TYPE IN VARCHAR2
11   );
12 
13  procedure LOCK_ROW (
14       X_ROWID in  VARCHAR2,
15        x_ACAD_HONOR_ID IN NUMBER,
16        x_PERSON_ID IN NUMBER,
17        x_COMMENTS IN VARCHAR2,
18        x_HONOR_DATE IN DATE,
19        X_ACAD_HONOR_TYPE IN VARCHAR2);
20 
21  procedure UPDATE_ROW (
22       X_ROWID in  VARCHAR2,
23       x_ACAD_HONOR_ID IN NUMBER,
24       x_PERSON_ID IN NUMBER,
25       x_COMMENTS IN VARCHAR2,
26       x_HONOR_DATE IN DATE,
27       X_MODE in VARCHAR2 default 'R',
28       X_ACAD_HONOR_TYPE IN VARCHAR2
29   );
30 
31  procedure ADD_ROW (
32       X_ROWID in out NOCOPY VARCHAR2,
33       x_ACAD_HONOR_ID IN OUT NOCOPY NUMBER,
34       x_PERSON_ID IN NUMBER,
35       x_COMMENTS IN VARCHAR2,
36       x_HONOR_DATE IN DATE,
37       X_MODE in VARCHAR2 default 'R',
38       X_ACAD_HONOR_TYPE IN VARCHAR2
39   ) ;
40 
41   procedure DELETE_ROW (
42     X_ROWID in VARCHAR2,
43   x_mode IN VARCHAR2 DEFAULT 'R'
44      );
45 
46   FUNCTION Get_PK_For_Validation (
47     x_acad_honor_id IN NUMBER
48   ) RETURN BOOLEAN ;
49 
50   FUNCTION Get_UK_For_Validation (
51     x_acad_honor_type IN VARCHAR2, --change id to cd
52     x_honor_date IN DATE,
53     x_person_id IN NUMBER
54 
55   ) RETURN BOOLEAN;
56 
57   PROCEDURE Check_Constraints (
58     Column_Name IN VARCHAR2  DEFAULT NULL,
59     Column_Value IN VARCHAR2  DEFAULT NULL
60   );
61 
62   PROCEDURE Before_DML (
63     p_action IN VARCHAR2,
64     x_rowid IN VARCHAR2 DEFAULT NULL,
65     x_acad_honor_id IN NUMBER DEFAULT NULL,
66     x_person_id IN NUMBER DEFAULT NULL,
67     x_comments IN VARCHAR2 DEFAULT NULL,
68     x_honor_date IN DATE DEFAULT NULL,
69     x_creation_date IN DATE DEFAULT NULL,
70     x_created_by IN NUMBER DEFAULT NULL,
71     x_last_update_date IN DATE DEFAULT NULL,
72     x_last_updated_by IN NUMBER DEFAULT NULL,
73     x_last_update_login IN NUMBER DEFAULT NULL,
74     x_acad_honor_type IN VARCHAR2 DEFAULT NULL
75  );
76 
77 END IGS_PE_ACAD_HONORS_PKG;