APPS.IGS_PR_STDNT_PR_PS_PKG dependencies on IGS_PR_STDNT_PR_PS

Line 1: package body IGS_PR_STDNT_PR_PS_PKG AS

1: package body IGS_PR_STDNT_PR_PS_PKG AS
2: /* $Header: IGSQI16B.pls 120.0 2005/07/05 13:03:18 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_STDNT_PR_PS%RowType;

Line 5: old_references IGS_PR_STDNT_PR_PS%RowType;

1: package body IGS_PR_STDNT_PR_PS_PKG AS
2: /* $Header: IGSQI16B.pls 120.0 2005/07/05 13:03:18 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_STDNT_PR_PS%RowType;
6: new_references IGS_PR_STDNT_PR_PS%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PR_STDNT_PR_PS%RowType;

2: /* $Header: IGSQI16B.pls 120.0 2005/07/05 13:03:18 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_STDNT_PR_PS%RowType;
6: new_references IGS_PR_STDNT_PR_PS%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_PR_STDNT_PR_PS

20: ) AS
21:
22: CURSOR cur_old_ref_values IS
23: SELECT *
24: FROM IGS_PR_STDNT_PR_PS
25: WHERE rowid = x_rowid;
26:
27: BEGIN
28:

Line 112: FROM IGS_PR_STDNT_PR_PS

108: ) RETURN BOOLEAN AS
109:
110: CURSOR cur_rowid IS
111: SELECT rowid
112: FROM IGS_PR_STDNT_PR_PS
113: WHERE person_id = x_person_id
114: AND spo_course_cd = x_spo_course_cd
115: AND spo_sequence_number = x_spo_sequence_number
116: AND course_cd = x_course_cd

Line 141: FROM IGS_PR_STDNT_PR_PS

137: ) AS
138:
139: CURSOR cur_rowid IS
140: SELECT rowid
141: FROM IGS_PR_STDNT_PR_PS
142: WHERE course_cd = x_course_cd ;
143:
144: lv_rowid cur_rowid%RowType;
145:

Line 168: FROM IGS_PR_STDNT_PR_PS

164: ) AS
165:
166: CURSOR cur_rowid IS
167: SELECT rowid
168: FROM IGS_PR_STDNT_PR_PS
169: WHERE person_id = x_person_id
170: AND spo_course_cd = x_course_cd
171: AND spo_sequence_number = x_sequence_number ;
172:

Line 265: cursor C is select ROWID from IGS_PR_STDNT_PR_PS

261: X_SPO_SEQUENCE_NUMBER in NUMBER,
262: X_COURSE_CD in VARCHAR2,
263: X_MODE in VARCHAR2 default 'R'
264: ) AS
265: cursor C is select ROWID from IGS_PR_STDNT_PR_PS
266: where PERSON_ID = X_PERSON_ID
267: and SPO_COURSE_CD = X_SPO_COURSE_CD
268: and SPO_SEQUENCE_NUMBER = X_SPO_SEQUENCE_NUMBER
269: and COURSE_CD = X_COURSE_CD;

Line 308: insert into IGS_PR_STDNT_PR_PS (

304: ) ;
305: IF (x_mode = 'S') THEN
306: igs_sc_gen_001.set_ctx('R');
307: END IF;
308: insert into IGS_PR_STDNT_PR_PS (
309: PERSON_ID,
310: SPO_COURSE_CD,
311: SPO_SEQUENCE_NUMBER,
312: COURSE_CD,

Line 369: from IGS_PR_STDNT_PR_PS

365: PERSON_ID ,
366: SPO_COURSE_CD ,
367: SPO_SEQUENCE_NUMBER ,
368: COURSE_CD
369: from IGS_PR_STDNT_PR_PS
370: where ROWID = X_ROWID for update nowait;
371: tlinfo c1%rowtype;
372:
373: begin

Line 419: delete from IGS_PR_STDNT_PR_PS

415: );
416: IF (x_mode = 'S') THEN
417: igs_sc_gen_001.set_ctx('R');
418: END IF;
419: delete from IGS_PR_STDNT_PR_PS
420: where ROWID = X_ROWID;
421: if (sql%notfound) then
422: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
423: igs_ge_msg_stack.add;

Line 476: end IGS_PR_STDNT_PR_PS_PKG;

472:
473: END Check_Constraints;
474:
475:
476: end IGS_PR_STDNT_PR_PS_PKG;