1 package IGS_AS_SPL_CONS_APPL_PKG AS
2 /* $Header: IGSDI10S.pls 120.0 2005/07/05 11:32:52 appldev noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_PERSON_ID in NUMBER,
7 X_COURSE_CD in VARCHAR2,
8 X_UNIT_CD in VARCHAR2,
9 X_CAL_TYPE in VARCHAR2,
10 X_CI_SEQUENCE_NUMBER in NUMBER,
11 X_ASS_ID in NUMBER,
12 X_CREATION_DT in DATE,
13 X_RECEIVED_DT in DATE,
14 X_SPCL_CONSIDERATION_CAT in VARCHAR2,
15 X_SOUGHT_OUTCOME in VARCHAR2,
16 X_SPCL_CONSIDERATION_OUTCOME in VARCHAR2,
17 X_ESTIMATED_PROCESSING_DAYS in NUMBER,
18 X_TRACKING_ID in NUMBER,
19 X_COMMENTS in VARCHAR2,
20 X_MODE in VARCHAR2 default 'R',
21 X_UOO_ID in NUMBER,
22 X_NOTIFIED_DATE in DATE
23 );
24 procedure LOCK_ROW (
25 X_ROWID in VARCHAR2,
26 X_PERSON_ID in NUMBER,
27 X_COURSE_CD in VARCHAR2,
28 X_UNIT_CD in VARCHAR2,
29 X_CAL_TYPE in VARCHAR2,
30 X_CI_SEQUENCE_NUMBER in NUMBER,
31 X_ASS_ID in NUMBER,
32 X_CREATION_DT in DATE,
33 X_RECEIVED_DT in DATE,
34 X_SPCL_CONSIDERATION_CAT in VARCHAR2,
35 X_SOUGHT_OUTCOME in VARCHAR2,
36 X_SPCL_CONSIDERATION_OUTCOME in VARCHAR2,
37 X_ESTIMATED_PROCESSING_DAYS in NUMBER,
38 X_TRACKING_ID in NUMBER,
39 X_COMMENTS in VARCHAR2,
40 X_UOO_ID in NUMBER,
41 X_NOTIFIED_DATE in DATE
42 );
43 procedure UPDATE_ROW (
44 X_ROWID in VARCHAR2,
45 X_PERSON_ID in NUMBER,
46 X_COURSE_CD in VARCHAR2,
47 X_UNIT_CD in VARCHAR2,
48 X_CAL_TYPE in VARCHAR2,
49 X_CI_SEQUENCE_NUMBER in NUMBER,
50 X_ASS_ID in NUMBER,
51 X_CREATION_DT in DATE,
52 X_RECEIVED_DT in DATE,
53 X_SPCL_CONSIDERATION_CAT in VARCHAR2,
54 X_SOUGHT_OUTCOME in VARCHAR2,
55 X_SPCL_CONSIDERATION_OUTCOME in VARCHAR2,
56 X_ESTIMATED_PROCESSING_DAYS in NUMBER,
57 X_TRACKING_ID in NUMBER,
58 X_COMMENTS in VARCHAR2,
59 X_MODE in VARCHAR2 default 'R',
60 X_UOO_ID in NUMBER,
61 X_NOTIFIED_DATE in DATE
62 );
63 procedure ADD_ROW (
64 X_ROWID in out NOCOPY VARCHAR2,
65 X_PERSON_ID in NUMBER,
66 X_COURSE_CD in VARCHAR2,
67 X_UNIT_CD in VARCHAR2,
68 X_CAL_TYPE in VARCHAR2,
69 X_CI_SEQUENCE_NUMBER in NUMBER,
70 X_ASS_ID in NUMBER,
71 X_CREATION_DT in DATE,
72 X_RECEIVED_DT in DATE,
73 X_SPCL_CONSIDERATION_CAT in VARCHAR2,
74 X_SOUGHT_OUTCOME in VARCHAR2,
75 X_SPCL_CONSIDERATION_OUTCOME in VARCHAR2,
76 X_ESTIMATED_PROCESSING_DAYS in NUMBER,
77 X_TRACKING_ID in NUMBER,
78 X_COMMENTS in VARCHAR2,
79 X_MODE in VARCHAR2 default 'R',
80 X_UOO_ID in NUMBER,
81 X_NOTIFIED_DATE in DATE
82 );
83
84 procedure DELETE_ROW (
85 X_ROWID in VARCHAR2,
86 x_mode IN VARCHAR2 DEFAULT 'R'
87 );
88
89 FUNCTION Get_PK_For_Validation (
90 x_person_id IN NUMBER,
91 x_course_cd IN VARCHAR2,
92 x_ass_id IN NUMBER,
93 x_creation_dt IN DATE,
94 x_received_dt IN DATE,
95 x_uoo_id IN NUMBER
96 )RETURN BOOLEAN ;
97
98 PROCEDURE GET_FK_IGS_AS_SPCL_CONS_OUT (
99 x_spcl_consideration_outcome IN VARCHAR2
100 );
101 PROCEDURE GET_FK_IGS_AS_SU_ATMPT_ITM (
102 x_course_cd IN VARCHAR2,
103 x_person_id IN NUMBER,
104 x_ass_id IN NUMBER,
105 x_creation_dt IN DATE,
106 x_uoo_id in NUMBER
107 );
108
109 PROCEDURE Check_Constraints (
110 Column_Name IN VARCHAR2 DEFAULT NULL,
111 Column_Value IN VARCHAR2 DEFAULT NULL
112 );
113
114 PROCEDURE Before_DML (
115 p_action IN VARCHAR2,
116 x_rowid IN VARCHAR2 DEFAULT NULL,
117 x_person_id IN NUMBER DEFAULT NULL,
118 x_course_cd IN VARCHAR2 DEFAULT NULL,
119 x_unit_cd IN VARCHAR2 DEFAULT NULL,
120 x_cal_type IN VARCHAR2 DEFAULT NULL,
121 x_ci_sequence_number IN NUMBER DEFAULT NULL,
122 x_ass_id IN NUMBER DEFAULT NULL,
123 x_creation_dt IN DATE DEFAULT NULL,
124 x_received_dt IN DATE DEFAULT NULL,
125 x_spcl_consideration_cat IN VARCHAR2 DEFAULT NULL,
126 x_sought_outcome IN VARCHAR2 DEFAULT NULL,
127 x_spcl_consideration_outcome IN VARCHAR2 DEFAULT NULL,
128 x_estimated_processing_days IN NUMBER DEFAULT NULL,
129 x_tracking_id IN NUMBER DEFAULT NULL,
130 x_comments IN VARCHAR2 DEFAULT NULL,
131 x_creation_date IN DATE DEFAULT NULL,
132 x_created_by IN NUMBER DEFAULT NULL,
133 x_last_update_date IN DATE DEFAULT NULL,
134 x_last_updated_by IN NUMBER DEFAULT NULL,
135 x_last_update_login IN NUMBER DEFAULT NULL,
136 x_uoo_id IN NUMBER DEFAULT NULL,
137 x_notified_date IN DATE DEFAULT NULL
138 );
139 end IGS_AS_SPL_CONS_APPL_PKG;