DBA Data[Home] [Help]

PACKAGE: APPS.IGS_AD_TER_ED_UNI_AT_PKG

Source


1 package IGS_AD_TER_ED_UNI_AT_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSAI51S.pls 115.3 2002/11/28 22:08:14 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_PERSON_ID in NUMBER,
7   X_TE_SEQUENCE_NUMBER in NUMBER,
8   X_UNIT_CD in VARCHAR2,
9   X_SEQUENCE_NUMBER in NUMBER,
10   X_ENROLLED_YR in NUMBER,
11   X_RESULT_TYPE in VARCHAR2,
12   X_TITLE in VARCHAR2,
13   X_CREDIT_POINTS in NUMBER,
14   X_GRADE in VARCHAR2,
15   X_DISCIPLINE_GROUP_CD 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_TE_SEQUENCE_NUMBER in NUMBER,
22   X_UNIT_CD in VARCHAR2,
23   X_SEQUENCE_NUMBER in NUMBER,
24   X_ENROLLED_YR in NUMBER,
25   X_RESULT_TYPE in VARCHAR2,
26   X_TITLE in VARCHAR2,
27   X_CREDIT_POINTS in NUMBER,
28   X_GRADE in VARCHAR2,
29   X_DISCIPLINE_GROUP_CD in VARCHAR2
30 );
31 procedure UPDATE_ROW (
32   X_ROWID in VARCHAR2,
33   X_PERSON_ID in NUMBER,
34   X_TE_SEQUENCE_NUMBER in NUMBER,
35   X_UNIT_CD in VARCHAR2,
36   X_SEQUENCE_NUMBER in NUMBER,
37   X_ENROLLED_YR in NUMBER,
38   X_RESULT_TYPE in VARCHAR2,
39   X_TITLE in VARCHAR2,
40   X_CREDIT_POINTS in NUMBER,
41   X_GRADE in VARCHAR2,
42   X_DISCIPLINE_GROUP_CD 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_TE_SEQUENCE_NUMBER in NUMBER,
49   X_UNIT_CD in VARCHAR2,
50   X_SEQUENCE_NUMBER in NUMBER,
51   X_ENROLLED_YR in NUMBER,
52   X_RESULT_TYPE in VARCHAR2,
53   X_TITLE in VARCHAR2,
54   X_CREDIT_POINTS in NUMBER,
55   X_GRADE in VARCHAR2,
56   X_DISCIPLINE_GROUP_CD in VARCHAR2,
57   X_MODE in VARCHAR2 default 'R'
58   );
59 procedure DELETE_ROW (
60   X_ROWID in VARCHAR2
61   );
62 function Get_PK_For_Validation (
63     x_person_id IN NUMBER,
64     x_te_sequence_number IN NUMBER,
65     x_unit_cd IN VARCHAR2,
66     x_sequence_number IN NUMBER
67 )return BOOLEAN;
68 
69 procedure Check_Constraints (
70   Column_Name IN VARCHAR2 DEFAULT NULL,
71   Column_Value IN VARCHAR2 DEFAULT NULL
72 );
73 
74   PROCEDURE GET_FK_IGS_PS_DSCP (
75     x_discipline_group_cd IN VARCHAR2
76     );
77 
78   PROCEDURE GET_FK_IGS_AD_TER_EDU (
79     x_person_id IN NUMBER,
80     x_sequence_number IN NUMBER
81     );
82 
83   PROCEDURE Before_DML (
84     p_action IN VARCHAR2,
85     x_rowid IN VARCHAR2 DEFAULT NULL,
86     x_person_id IN NUMBER DEFAULT NULL,
87     x_te_sequence_number IN NUMBER DEFAULT NULL,
88     x_unit_cd IN VARCHAR2 DEFAULT NULL,
89     x_sequence_number IN NUMBER DEFAULT NULL,
90     x_enrolled_yr IN NUMBER DEFAULT NULL,
91     x_result_type IN VARCHAR2 DEFAULT NULL,
92     x_title IN VARCHAR2 DEFAULT NULL,
93     x_credit_points IN NUMBER DEFAULT NULL,
94     x_grade IN VARCHAR2 DEFAULT NULL,
95     x_discipline_group_cd IN VARCHAR2 DEFAULT NULL,
96     x_creation_date IN DATE DEFAULT NULL,
97     x_created_by IN NUMBER DEFAULT NULL,
98     x_last_update_date IN DATE DEFAULT NULL,
99     x_last_updated_by IN NUMBER DEFAULT NULL,
100     x_last_update_login IN NUMBER DEFAULT NULL
101   );
102 
103 end IGS_AD_TER_ED_UNI_AT_PKG;