1 package IGS_AD_APPL_LTR_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSAI06S.pls 115.3 2002/11/28 21:54:18 nsidana ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_PERSON_ID in NUMBER,
6 X_ADMISSION_APPL_NUMBER in NUMBER,
7 X_CORRESPONDENCE_TYPE in VARCHAR2,
8 X_SEQUENCE_NUMBER in NUMBER,
9 X_COMPOSED_IND in VARCHAR2,
10 X_LETTER_REFERENCE_NUMBER in NUMBER,
11 X_SPL_SEQUENCE_NUMBER in NUMBER,
12 X_MODE in VARCHAR2 default 'R'
13 );
14 procedure LOCK_ROW (
15 X_ROWID in VARCHAR2,
16 X_PERSON_ID in NUMBER,
17 X_ADMISSION_APPL_NUMBER in NUMBER,
18 X_CORRESPONDENCE_TYPE in VARCHAR2,
19 X_SEQUENCE_NUMBER in NUMBER,
20 X_COMPOSED_IND in VARCHAR2,
21 X_LETTER_REFERENCE_NUMBER in NUMBER,
22 X_SPL_SEQUENCE_NUMBER in NUMBER
23 );
24 procedure UPDATE_ROW (
25 X_ROWID in VARCHAR2,
26 X_PERSON_ID in NUMBER,
27 X_ADMISSION_APPL_NUMBER in NUMBER,
28 X_CORRESPONDENCE_TYPE in VARCHAR2,
29 X_SEQUENCE_NUMBER in NUMBER,
30 X_COMPOSED_IND in VARCHAR2,
31 X_LETTER_REFERENCE_NUMBER in NUMBER,
32 X_SPL_SEQUENCE_NUMBER in NUMBER,
33 X_MODE in VARCHAR2 default 'R'
34 );
35 procedure ADD_ROW (
36 X_ROWID in out NOCOPY VARCHAR2,
37 X_PERSON_ID in NUMBER,
38 X_ADMISSION_APPL_NUMBER in NUMBER,
39 X_CORRESPONDENCE_TYPE in VARCHAR2,
40 X_SEQUENCE_NUMBER in NUMBER,
41 X_COMPOSED_IND in VARCHAR2,
42 X_LETTER_REFERENCE_NUMBER in NUMBER,
43 X_SPL_SEQUENCE_NUMBER in NUMBER,
44 X_MODE in VARCHAR2 default 'R'
45 );
46 procedure DELETE_ROW (
47 X_ROWID in VARCHAR2
48 );
49
50 FUNCTION Get_PK_For_Validation (
51 x_person_id IN NUMBER,
52 x_admission_appl_number IN NUMBER,
53 x_correspondence_type IN VARCHAR2,
54 x_sequence_number IN NUMBER
55 )
56 RETURN BOOLEAN;
57
58 PROCEDURE GET_FK_IGS_AD_APPL (
59 x_person_id IN NUMBER,
60 x_admission_appl_number IN NUMBER
61 );
62
63 PROCEDURE GET_FK_IGS_CO_TYPE (
64 x_correspondence_type IN VARCHAR2
65 );
66
67 PROCEDURE GET_FK_IGS_CO_S_PER_LTR (
68 x_person_id IN NUMBER,
69 x_correspondence_type IN VARCHAR2,
70 x_letter_reference_number IN NUMBER,
71 x_sequence_number IN NUMBER
72 );
73 -- added to take care of check constraints
74 PROCEDURE CHECK_CONSTRAINTS(
75 column_name IN VARCHAR2 DEFAULT NULL,
76 column_value IN VARCHAR2 DEFAULT NULL
77 );
78
79 PROCEDURE Before_DML (
80 p_action IN VARCHAR2,
81 x_rowid IN VARCHAR2 DEFAULT NULL,
82 x_person_id IN NUMBER DEFAULT NULL,
83 x_admission_appl_number IN NUMBER DEFAULT NULL,
84 x_correspondence_type IN VARCHAR2 DEFAULT NULL,
85 x_sequence_number IN NUMBER DEFAULT NULL,
86 x_composed_ind IN VARCHAR2 DEFAULT NULL,
87 x_letter_reference_number IN NUMBER DEFAULT NULL,
88 x_spl_sequence_number IN NUMBER DEFAULT NULL,
89 x_creation_date IN DATE DEFAULT NULL,
90 x_created_by IN NUMBER DEFAULT NULL,
91 x_last_update_date IN DATE DEFAULT NULL,
92 x_last_updated_by IN NUMBER DEFAULT NULL,
93 x_last_update_login IN NUMBER DEFAULT NULL
94 );
95 end IGS_AD_APPL_LTR_PKG;