PACKAGE: APPS.IGS_AD_APPL_NOTES_PKG

Source

1 PACKAGE igs_ad_appl_notes_pkg AS
2 /* $Header: IGSAIA6S.pls 120.0 2005/06/01 21:30:08 appldev noship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_APPL_NOTES_ID IN OUT NOCOPY NUMBER,
6        x_PERSON_ID IN NUMBER,
7        x_ADMISSION_APPL_NUMBER IN NUMBER,
8        x_NOMINATED_COURSE_CD IN VARCHAR2,
9        x_SEQUENCE_NUMBER IN NUMBER,
10        x_NOTE_TYPE_ID IN NUMBER,
11        x_REF_NOTES_ID IN OUT NOCOPY  NUMBER,
12       X_MODE in VARCHAR2 default NULL
13   );
14 
15  procedure LOCK_ROW (
16       X_ROWID in  VARCHAR2,
17        x_APPL_NOTES_ID IN NUMBER,
18        x_PERSON_ID IN NUMBER,
19        x_ADMISSION_APPL_NUMBER IN NUMBER,
20        x_NOMINATED_COURSE_CD IN VARCHAR2,
21        x_SEQUENCE_NUMBER IN NUMBER,
22        x_NOTE_TYPE_ID IN NUMBER,
23        x_REF_NOTES_ID IN NUMBER  );
24  procedure UPDATE_ROW (
25       X_ROWID in  VARCHAR2,
26        x_APPL_NOTES_ID IN NUMBER,
27        x_PERSON_ID IN NUMBER,
28        x_ADMISSION_APPL_NUMBER IN NUMBER,
29        x_NOMINATED_COURSE_CD IN VARCHAR2,
30        x_SEQUENCE_NUMBER IN NUMBER,
31        x_NOTE_TYPE_ID IN NUMBER,
32        x_REF_NOTES_ID IN NUMBER,
33       X_MODE in VARCHAR2 default NULL
34   );
35 
36  procedure ADD_ROW (
37       X_ROWID in out NOCOPY VARCHAR2,
38        x_APPL_NOTES_ID IN OUT NOCOPY NUMBER,
39        x_PERSON_ID IN NUMBER,
40        x_ADMISSION_APPL_NUMBER IN NUMBER,
41        x_NOMINATED_COURSE_CD IN VARCHAR2,
42        x_SEQUENCE_NUMBER IN NUMBER,
43        x_NOTE_TYPE_ID IN NUMBER,
44        x_REF_NOTES_ID IN OUT NOCOPY NUMBER,
45       X_MODE in VARCHAR2 default NULL
46   ) ;
47 
48 procedure DELETE_ROW (
49   X_ROWID in VARCHAR2,
50   x_mode IN VARCHAR2 DEFAULT 'R'
51 ) ;
52   FUNCTION Get_PK_For_Validation (
53     x_appl_notes_id IN NUMBER
54     ) RETURN BOOLEAN ;
55 
56   FUNCTION Get_UK_For_Validation (
57     x_admission_appl_number IN NUMBER,
58     x_nominated_course_cd IN VARCHAR2,
59     x_note_type_id IN NUMBER,
60     x_person_id IN NUMBER,
61     x_sequence_number IN NUMBER
62     ) RETURN BOOLEAN;
63 
64   PROCEDURE Get_FK_Igs_Ad_Ps_Appl_Inst (
65     x_person_id IN NUMBER,
66     x_admission_appl_number IN NUMBER,
67     x_nominated_course_cd IN VARCHAR2,
68     x_sequence_number IN NUMBER
69     );
70 
71   PROCEDURE Get_FK_Igs_Ad_Note_Types (
72     x_notes_type_id IN NUMBER
73     );
74 
75   PROCEDURE Check_Constraints (
76 		 Column_Name IN VARCHAR2  DEFAULT NULL,
77 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
78   PROCEDURE Before_DML (
79     p_action IN VARCHAR2,
80     x_rowid IN VARCHAR2 DEFAULT NULL,
81     x_appl_notes_id IN NUMBER DEFAULT NULL,
82     x_person_id IN NUMBER DEFAULT NULL,
83     x_admission_appl_number IN NUMBER DEFAULT NULL,
84     x_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
85     x_sequence_number IN NUMBER DEFAULT NULL,
86     x_note_type_id IN NUMBER DEFAULT NULL,
87     x_ref_notes_id IN NUMBER DEFAULT NULL,
88     x_creation_date IN DATE DEFAULT NULL,
89     x_created_by IN NUMBER DEFAULT NULL,
90     x_last_update_date IN DATE DEFAULT NULL,
91     x_last_updated_by IN NUMBER DEFAULT NULL,
92     x_last_update_login IN NUMBER DEFAULT NULL
93  );
94 END igs_ad_appl_notes_pkg;