PACKAGE: APPS.IGS_AS_SC_ATMPT_NOTE_PKG

Source

1 package  IGS_AS_SC_ATMPT_NOTE_PKG AS
2 /* $Header: IGSDI20S.pls 120.0 2005/07/05 11:48:04 appldev noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_PERSON_ID in NUMBER,
7   X_COURSE_CD in VARCHAR2,
8   X_REFERENCE_NUMBER in NUMBER,
9   X_ENR_NOTE_TYPE in VARCHAR2,
10   X_MODE in VARCHAR2 default 'R'
11   );
12 procedure LOCK_ROW (
13   X_ROWID in VARCHAR2,
14   X_PERSON_ID in NUMBER,
15   X_COURSE_CD in VARCHAR2,
16   X_REFERENCE_NUMBER in NUMBER,
17   X_ENR_NOTE_TYPE in VARCHAR2
18 );
19 procedure UPDATE_ROW (
20   X_ROWID in VARCHAR2,
21   X_PERSON_ID in NUMBER,
22   X_COURSE_CD in VARCHAR2,
23   X_REFERENCE_NUMBER in NUMBER,
24   X_ENR_NOTE_TYPE in VARCHAR2,
25   X_MODE in VARCHAR2 default 'R'
26   );
27 procedure ADD_ROW (
28   X_ROWID in out NOCOPY VARCHAR2,
29   X_PERSON_ID in NUMBER,
30   X_COURSE_CD in VARCHAR2,
31   X_REFERENCE_NUMBER in NUMBER,
32   X_ENR_NOTE_TYPE in VARCHAR2,
33   X_MODE in VARCHAR2 default 'R'
34   );
35 procedure DELETE_ROW (
36   X_ROWID in VARCHAR2,
37   x_mode IN VARCHAR2 DEFAULT 'R'
38   );
39 
40 FUNCTION Get_PK_For_Validation (
41     x_person_id IN NUMBER,
42     x_course_cd IN VARCHAR2,
43     x_reference_number IN NUMBER
44     ) RETURN BOOLEAN;
45 
46   PROCEDURE GET_FK_IGS_EN_NOTE_TYPE (
47     x_enr_note_type IN VARCHAR2
48     );
49 
50   PROCEDURE GET_FK_IGS_GE_NOTE (
51     x_reference_number IN NUMBER
52     );
53 
54   PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
55     x_person_id IN NUMBER,
56     x_course_cd IN VARCHAR2
57     );
58 
59  PROCEDURE Check_Constraints (
60  	Column_Name	IN	VARCHAR2	DEFAULT NULL,
61  	Column_Value 	IN	VARCHAR2	DEFAULT NULL
62  );
63   PROCEDURE Before_DML (
64     p_action IN VARCHAR2,
65     x_rowid IN  VARCHAR2 DEFAULT NULL,
66     x_person_id IN NUMBER DEFAULT NULL,
67     x_course_cd IN VARCHAR2 DEFAULT NULL,
68     x_reference_number IN NUMBER DEFAULT NULL,
69     x_enr_note_type IN VARCHAR2 DEFAULT NULL,
70     x_creation_date IN DATE DEFAULT NULL,
71     x_created_by IN NUMBER DEFAULT NULL,
72     x_last_update_date IN DATE DEFAULT NULL,
73     x_last_updated_by IN NUMBER DEFAULT NULL,
74     x_last_update_login IN NUMBER DEFAULT NULL
75   );
76 
77 end IGS_AS_SC_ATMPT_NOTE_PKG;