1 package IGS_PS_OFR_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSPI19S.pls 115.5 2002/11/29 02:04:24 nsidana ship $ */
3 /*************************************************************
4 Created By :
5 Date Created By :
6 Purpose :
7 Know limitations, enhancements or remarks
8 Change History
9 Who When What
10 sbeerell 10-MAY-2000
11 (reverse chronological order - newest change first)
12 ***************************************************************/
13
14
15 procedure INSERT_ROW (
16 X_ROWID in out NOCOPY VARCHAR2,
17 X_COURSE_CD in VARCHAR2,
18 X_VERSION_NUMBER in NUMBER,
19 X_CAL_TYPE in VARCHAR2,
20 x_ATTRIBUTE_CATEGORY IN VARCHAR2,
21 x_ATTRIBUTE1 IN VARCHAR2,
22 x_ATTRIBUTE2 IN VARCHAR2,
23 x_ATTRIBUTE3 IN VARCHAR2,
24 x_ATTRIBUTE4 IN VARCHAR2,
25 x_ATTRIBUTE5 IN VARCHAR2,
26 x_ATTRIBUTE6 IN VARCHAR2,
27 x_ATTRIBUTE7 IN VARCHAR2,
28 x_ATTRIBUTE8 IN VARCHAR2,
29 x_ATTRIBUTE9 IN VARCHAR2,
30 x_ATTRIBUTE10 IN VARCHAR2,
31 x_ATTRIBUTE11 IN VARCHAR2,
32 x_ATTRIBUTE12 IN VARCHAR2,
33 x_ATTRIBUTE13 IN VARCHAR2,
34 x_ATTRIBUTE14 IN VARCHAR2,
35 x_ATTRIBUTE15 IN VARCHAR2,
36 x_ATTRIBUTE16 IN VARCHAR2,
37 x_ATTRIBUTE17 IN VARCHAR2,
38 x_ATTRIBUTE18 IN VARCHAR2,
39 x_ATTRIBUTE19 IN VARCHAR2,
40 x_ATTRIBUTE20 IN VARCHAR2,
41 X_MODE in VARCHAR2 default 'R',
42 X_ORG_ID IN NUMBER
43 );
44 procedure LOCK_ROW (
45 X_ROWID IN VARCHAR2,
46 X_COURSE_CD in VARCHAR2,
47 X_VERSION_NUMBER in NUMBER,
48 X_CAL_TYPE in VARCHAR2,
49 x_ATTRIBUTE_CATEGORY IN VARCHAR2,
50 x_ATTRIBUTE1 IN VARCHAR2,
51 x_ATTRIBUTE2 IN VARCHAR2,
52 x_ATTRIBUTE3 IN VARCHAR2,
53 x_ATTRIBUTE4 IN VARCHAR2,
54 x_ATTRIBUTE5 IN VARCHAR2,
55 x_ATTRIBUTE6 IN VARCHAR2,
56 x_ATTRIBUTE7 IN VARCHAR2,
57 x_ATTRIBUTE8 IN VARCHAR2,
58 x_ATTRIBUTE9 IN VARCHAR2,
59 x_ATTRIBUTE10 IN VARCHAR2,
60 x_ATTRIBUTE11 IN VARCHAR2,
61 x_ATTRIBUTE12 IN VARCHAR2,
62 x_ATTRIBUTE13 IN VARCHAR2,
63 x_ATTRIBUTE14 IN VARCHAR2,
64 x_ATTRIBUTE15 IN VARCHAR2,
65 x_ATTRIBUTE16 IN VARCHAR2,
66 x_ATTRIBUTE17 IN VARCHAR2,
67 x_ATTRIBUTE18 IN VARCHAR2,
68 x_ATTRIBUTE19 IN VARCHAR2,
69 x_ATTRIBUTE20 IN VARCHAR2
70 );
71
72
73 procedure DELETE_ROW (
74 X_ROWID IN VARCHAR2
75 );
76
77 FUNCTION Get_PK_For_Validation (
78 x_course_cd IN VARCHAR2,
79 x_version_number IN NUMBER,
80 x_cal_type IN VARCHAR2
81 )
82 RETURN BOOLEAN;
83
84 PROCEDURE GET_FK_IGS_CA_TYPE (
85 x_cal_type IN VARCHAR2
86 );
87
88 PROCEDURE GET_FK_IGS_PS_VER (
89 x_course_cd IN VARCHAR2,
90 x_version_number IN NUMBER
91 );
92
93 PROCEDURE Check_Constraints (
94 Column_Name IN VARCHAR2 DEFAULT NULL,
95 Column_Value IN VARCHAR2 DEFAULT NULL
96 );
97
98 PROCEDURE Before_DML (
99 p_action IN VARCHAR2,
100 x_rowid IN VARCHAR2 DEFAULT NULL,
101 x_course_cd IN VARCHAR2 DEFAULT NULL,
102 x_version_number IN NUMBER DEFAULT NULL,
103 x_cal_type IN VARCHAR2 DEFAULT NULL,
104 x_attribute_category IN VARCHAR2 DEFAULT NULL,
105 x_attribute1 IN VARCHAR2 DEFAULT NULL,
106 x_attribute2 IN VARCHAR2 DEFAULT NULL,
107 x_attribute3 IN VARCHAR2 DEFAULT NULL,
108 x_attribute4 IN VARCHAR2 DEFAULT NULL,
109 x_attribute5 IN VARCHAR2 DEFAULT NULL,
110 x_attribute6 IN VARCHAR2 DEFAULT NULL,
111 x_attribute7 IN VARCHAR2 DEFAULT NULL,
112 x_attribute8 IN VARCHAR2 DEFAULT NULL,
113 x_attribute9 IN VARCHAR2 DEFAULT NULL,
114 x_attribute10 IN VARCHAR2 DEFAULT NULL,
115 x_attribute11 IN VARCHAR2 DEFAULT NULL,
116 x_attribute12 IN VARCHAR2 DEFAULT NULL,
117 x_attribute13 IN VARCHAR2 DEFAULT NULL,
118 x_attribute14 IN VARCHAR2 DEFAULT NULL,
119 x_attribute15 IN VARCHAR2 DEFAULT NULL,
120 x_attribute16 IN VARCHAR2 DEFAULT NULL,
121 x_attribute17 IN VARCHAR2 DEFAULT NULL,
122 x_attribute18 IN VARCHAR2 DEFAULT NULL,
123 x_attribute19 IN VARCHAR2 DEFAULT NULL,
124 x_attribute20 IN VARCHAR2 DEFAULT NULL,
125 x_creation_date IN DATE DEFAULT NULL,
126 x_created_by IN NUMBER DEFAULT NULL,
127 x_last_update_date IN DATE DEFAULT NULL,
128 x_last_updated_by IN NUMBER DEFAULT NULL,
129 x_last_update_login IN NUMBER DEFAULT NULL,
130 X_ORG_ID IN NUMBER DEFAULT NULL
131 ) ;
132
133 end IGS_PS_OFR_PKG;