PACKAGE: APPS.IGS_AD_AUS_SEC_ED_SU_PKG

Source

1 package IGS_AD_AUS_SEC_ED_SU_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSAI68S.pls 115.4 2002/11/28 22:13:21 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_PERSON_ID in NUMBER,
7   X_ASE_SEQUENCE_NUMBER in NUMBER,
8   X_SUBJECT_RESULT_YR in NUMBER,
9   X_SUBJECT_CD in VARCHAR2,
10   X_SUBJECT_DESC in VARCHAR2,
11   X_SUBJECT_MARK in VARCHAR2,
12   X_SUBJECT_MARK_LEVEL in VARCHAR2,
13   X_SUBJECT_WEIGHTING in VARCHAR2,
14   X_SUBJECT_ASS_TYPE in VARCHAR2,
15   X_NOTES in VARCHAR2,
16   X_MODE in VARCHAR2 default 'R'
17   );
18 procedure LOCK_ROW (
19   X_ROWID in VARCHAR2,
20   X_PERSON_ID in NUMBER,
21   X_ASE_SEQUENCE_NUMBER in NUMBER,
22   X_SUBJECT_RESULT_YR in NUMBER,
23   X_SUBJECT_CD in VARCHAR2,
24   X_SUBJECT_DESC in VARCHAR2,
25   X_SUBJECT_MARK in VARCHAR2,
26   X_SUBJECT_MARK_LEVEL in VARCHAR2,
27   X_SUBJECT_WEIGHTING in VARCHAR2,
28   X_SUBJECT_ASS_TYPE in VARCHAR2,
29   X_NOTES in VARCHAR2
30 );
31 procedure UPDATE_ROW (
32   X_ROWID in VARCHAR2,
33   X_PERSON_ID in NUMBER,
34   X_ASE_SEQUENCE_NUMBER in NUMBER,
35   X_SUBJECT_RESULT_YR in NUMBER,
36   X_SUBJECT_CD in VARCHAR2,
37   X_SUBJECT_DESC in VARCHAR2,
38   X_SUBJECT_MARK in VARCHAR2,
39   X_SUBJECT_MARK_LEVEL in VARCHAR2,
40   X_SUBJECT_WEIGHTING in VARCHAR2,
41   X_SUBJECT_ASS_TYPE in VARCHAR2,
42   X_NOTES in VARCHAR2,
43   X_MODE in VARCHAR2 default 'R'
44   );
45 procedure ADD_ROW (
46   X_ROWID in out NOCOPY VARCHAR2,
47   X_PERSON_ID in NUMBER,
48   X_ASE_SEQUENCE_NUMBER in NUMBER,
49   X_SUBJECT_RESULT_YR in NUMBER,
50   X_SUBJECT_CD in VARCHAR2,
51   X_SUBJECT_DESC in VARCHAR2,
52   X_SUBJECT_MARK in VARCHAR2,
53   X_SUBJECT_MARK_LEVEL in VARCHAR2,
54   X_SUBJECT_WEIGHTING in VARCHAR2,
55   X_SUBJECT_ASS_TYPE in VARCHAR2,
56   X_NOTES in VARCHAR2,
57   X_MODE in VARCHAR2 default 'R'
58   );
59 procedure DELETE_ROW (
60   X_ROWID in VARCHAR2
61 );
62 
63 FUNCTION Get_PK_For_Validation (
64     x_person_id IN NUMBER,
65     x_ase_sequence_number IN NUMBER,
66     x_subject_result_yr IN NUMBER,
67     x_subject_cd IN VARCHAR2
68 )return BOOLEAN;
69 
70 PROCEDURE Check_Constraints (
71   Column_Name IN VARCHAR2 DEFAULT NULL,
72   Column_Value IN VARCHAR2 DEFAULT NULL
73 );
74 
75 PROCEDURE get_fk_igs_ad_ause_ed_as_ty (
76     x_aus_scndry_edu_ass_type IN VARCHAR2
77     );
78 
79 PROCEDURE GET_FK_IGS_AD_AUS_SEC_EDU (
80     x_person_id IN NUMBER,
81     x_sequence_number IN NUMBER
82     );
83 
84   PROCEDURE Before_DML (
85     p_action IN VARCHAR2,
86     x_rowid IN VARCHAR2 DEFAULT NULL,
87     x_person_id IN NUMBER DEFAULT NULL,
88     x_ase_sequence_number IN NUMBER DEFAULT NULL,
89     x_subject_result_yr IN NUMBER DEFAULT NULL,
90     x_subject_cd IN VARCHAR2 DEFAULT NULL,
91     x_subject_desc IN VARCHAR2 DEFAULT NULL,
92     x_subject_mark IN VARCHAR2 DEFAULT NULL,
93     x_subject_mark_level IN VARCHAR2 DEFAULT NULL,
94     x_subject_weighting IN VARCHAR2 DEFAULT NULL,
95     x_subject_ass_type IN VARCHAR2 DEFAULT NULL,
96     x_notes IN VARCHAR2 DEFAULT NULL,
97     x_creation_date IN DATE DEFAULT NULL,
98     x_created_by IN NUMBER DEFAULT NULL,
99     x_last_update_date IN DATE DEFAULT NULL,
100     x_last_updated_by IN NUMBER DEFAULT NULL,
101     x_last_update_login IN NUMBER DEFAULT NULL
102   );
103 end IGS_AD_AUS_SEC_ED_SU_PKG;