PACKAGE: APPS.IGS_AS_EXM_SUPRVISOR_PKG

Source

1 package IGS_AS_EXM_SUPRVISOR_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSDI42S.pls 115.5 2002/11/28 23:21:12 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_ORG_ID in NUMBER,
7   X_PERSON_ID in NUMBER,
8   X_EXAM_SUPERVISOR_TYPE in VARCHAR2,
9   X_PREVIOUS_SESSIONS in NUMBER,
10   X_RESPONSIBLE_ORG_UNIT_CD in VARCHAR2,
11   X_RESPONSIBLE_OU_START_DT in DATE,
12   X_COMMENTS in VARCHAR2,
13   X_MODE in VARCHAR2 default 'R'
14   );
15 procedure LOCK_ROW (
16   X_ROWID in VARCHAR2,
17   X_PERSON_ID in NUMBER,
18   X_EXAM_SUPERVISOR_TYPE in VARCHAR2,
19   X_PREVIOUS_SESSIONS in NUMBER,
20   X_RESPONSIBLE_ORG_UNIT_CD in VARCHAR2,
21   X_RESPONSIBLE_OU_START_DT in DATE,
22   X_COMMENTS in VARCHAR2
23 );
24 procedure UPDATE_ROW (
25   X_ROWID in VARCHAR2,
26   X_PERSON_ID in NUMBER,
27   X_EXAM_SUPERVISOR_TYPE in VARCHAR2,
28   X_PREVIOUS_SESSIONS in NUMBER,
29   X_RESPONSIBLE_ORG_UNIT_CD in VARCHAR2,
30   X_RESPONSIBLE_OU_START_DT in DATE,
31   X_COMMENTS in VARCHAR2,
32   X_MODE in VARCHAR2 default 'R'
33   );
34 procedure ADD_ROW (
35   X_ROWID in out NOCOPY VARCHAR2,
36   X_ORG_ID in NUMBER,
37   X_PERSON_ID in NUMBER,
38   X_EXAM_SUPERVISOR_TYPE in VARCHAR2,
39   X_PREVIOUS_SESSIONS in NUMBER,
40   X_RESPONSIBLE_ORG_UNIT_CD in VARCHAR2,
41   X_RESPONSIBLE_OU_START_DT in DATE,
42   X_COMMENTS in VARCHAR2,
43   X_MODE in VARCHAR2 default 'R'
44   );
45 procedure DELETE_ROW (
46   X_ROWID in VARCHAR2
47 );
48 
49 FUNCTION Get_PK_For_Validation (
50     x_person_id IN NUMBER
51     ) RETURN BOOLEAN;
52 
53   PROCEDURE GET_FK_IGS_AS_EXM_SPRVSRTYP (
54     x_exam_supervisor_type IN VARCHAR2
55     );
56 
57   PROCEDURE GET_FK_IGS_OR_UNIT (
58     x_org_unit_cd IN VARCHAR2,
59     x_start_dt IN VARCHAR2
60     );
61 
62   PROCEDURE GET_FK_IGS_PE_PERSON (
63     x_person_id IN NUMBER
64     );
65 
66  PROCEDURE Check_Constraints (
67  Column_Name	IN	VARCHAR2	DEFAULT NULL,
68  Column_Value 	IN	VARCHAR2	DEFAULT NULL
69  );
70 
71   PROCEDURE Before_DML (
72     p_action IN VARCHAR2,
73     x_rowid IN  VARCHAR2 DEFAULT NULL,
74     x_org_id in NUMBER DEFAULT NULL,
75     x_person_id IN NUMBER DEFAULT NULL,
76     x_exam_supervisor_type IN VARCHAR2 DEFAULT NULL,
77     x_previous_sessions IN NUMBER DEFAULT NULL,
78     x_responsible_org_unit_cd IN VARCHAR2 DEFAULT NULL,
79     x_responsible_ou_start_dt IN DATE DEFAULT NULL,
80     x_comments IN VARCHAR2 DEFAULT NULL,
81     x_creation_date IN DATE DEFAULT NULL,
82     x_created_by IN NUMBER DEFAULT NULL,
83     x_last_update_date IN DATE DEFAULT NULL,
84     x_last_updated_by IN NUMBER DEFAULT NULL,
85     x_last_update_login IN NUMBER DEFAULT NULL
86   ) ;
87 end IGS_AS_EXM_SUPRVISOR_PKG;