APPS.IGS_PS_STDNT_SPL_REQ_PKG dependencies on IGS_PS_STDNT_SPL_REQ

Line 1: package body IGS_PS_STDNT_SPL_REQ_PKG as

1: package body IGS_PS_STDNT_SPL_REQ_PKG as
2: /* $Header: IGSPI66B.pls 120.1 2005/07/04 00:19:45 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_STDNT_SPL_REQ%RowType;
5: new_references IGS_PS_STDNT_SPL_REQ%RowType;

Line 4: old_references IGS_PS_STDNT_SPL_REQ%RowType;

1: package body IGS_PS_STDNT_SPL_REQ_PKG as
2: /* $Header: IGSPI66B.pls 120.1 2005/07/04 00:19:45 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_STDNT_SPL_REQ%RowType;
5: new_references IGS_PS_STDNT_SPL_REQ%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_STDNT_SPL_REQ%RowType;

1: package body IGS_PS_STDNT_SPL_REQ_PKG as
2: /* $Header: IGSPI66B.pls 120.1 2005/07/04 00:19:45 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_STDNT_SPL_REQ%RowType;
5: new_references IGS_PS_STDNT_SPL_REQ%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_PS_STDNT_SPL_REQ

22: ) AS
23:
24: CURSOR cur_old_ref_values IS
25: SELECT *
26: FROM IGS_PS_STDNT_SPL_REQ
27: WHERE rowid = x_rowid;
28:
29: BEGIN
30:

Line 245: FROM IGS_PS_STDNT_SPL_REQ

241: ) RETURN BOOLEAN AS
242:
243: CURSOR cur_rowid IS
244: SELECT rowid
245: FROM IGS_PS_STDNT_SPL_REQ
246: WHERE person_id = x_person_id
247: AND course_cd = x_course_cd
248: AND special_requirement_cd = x_special_requirement_cd
249: AND completed_dt = x_completed_dt

Line 274: FROM IGS_PS_STDNT_SPL_REQ

270: ) AS
271:
272: CURSOR cur_rowid IS
273: SELECT rowid
274: FROM IGS_PS_STDNT_SPL_REQ
275: WHERE person_id = x_person_id
276: AND course_cd = x_course_cd ;
277:
278: lv_rowid cur_rowid%RowType;

Line 301: FROM IGS_PS_STDNT_SPL_REQ

297: ) AS
298:
299: CURSOR cur_rowid IS
300: SELECT rowid
301: FROM IGS_PS_STDNT_SPL_REQ
302: WHERE special_requirement_cd = x_special_requirement_cd ;
303:
304: lv_rowid cur_rowid%RowType;
305:

Line 428: cursor C is select ROWID from IGS_PS_STDNT_SPL_REQ

424: X_REFERENCE in VARCHAR2,
425: X_COMMENTS in VARCHAR2,
426: X_MODE in VARCHAR2 default 'R'
427: ) as
428: cursor C is select ROWID from IGS_PS_STDNT_SPL_REQ
429: where PERSON_ID = X_PERSON_ID
430: and SPECIAL_REQUIREMENT_CD = X_SPECIAL_REQUIREMENT_CD
431: and COMPLETED_DT = X_COMPLETED_DT
432: and COURSE_CD = X_COURSE_CD;

Line 477: insert into IGS_PS_STDNT_SPL_REQ (

473:
474: IF (x_mode = 'S') THEN
475: igs_sc_gen_001.set_ctx('R');
476: END IF;
477: insert into IGS_PS_STDNT_SPL_REQ (
478: PERSON_ID,
479: COURSE_CD,
480: SPECIAL_REQUIREMENT_CD,
481: COMPLETED_DT,

Line 551: from IGS_PS_STDNT_SPL_REQ

547: cursor c1 is select
548: EXPIRY_DT,
549: REFERENCE,
550: COMMENTS
551: from IGS_PS_STDNT_SPL_REQ
552: where ROWID = X_ROWID
553: for update nowait;
554: tlinfo c1%rowtype;
555:

Line 641: update IGS_PS_STDNT_SPL_REQ set

637:
638: IF (x_mode = 'S') THEN
639: igs_sc_gen_001.set_ctx('R');
640: END IF;
641: update IGS_PS_STDNT_SPL_REQ set
642: EXPIRY_DT = NEW_REFERENCES.EXPIRY_DT,
643: REFERENCE = NEW_REFERENCES.REFERENCE,
644: COMMENTS = NEW_REFERENCES.COMMENTS,
645: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 691: cursor c1 is select rowid from IGS_PS_STDNT_SPL_REQ

687: X_REFERENCE in VARCHAR2,
688: X_COMMENTS in VARCHAR2,
689: X_MODE in VARCHAR2 default 'R'
690: ) as
691: cursor c1 is select rowid from IGS_PS_STDNT_SPL_REQ
692: where PERSON_ID = X_PERSON_ID
693: and SPECIAL_REQUIREMENT_CD = X_SPECIAL_REQUIREMENT_CD
694: and COMPLETED_DT = X_COMPLETED_DT
695: and COURSE_CD = X_COURSE_CD

Line 740: delete from IGS_PS_STDNT_SPL_REQ

736:
737: IF (x_mode = 'S') THEN
738: igs_sc_gen_001.set_ctx('R');
739: END IF;
740: delete from IGS_PS_STDNT_SPL_REQ
741: where ROWID = X_ROWID;
742: if (sql%notfound) then
743: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
744: igs_ge_msg_stack.add;

Line 760: end IGS_PS_STDNT_SPL_REQ_PKG;

756: );
757:
758: end DELETE_ROW;
759:
760: end IGS_PS_STDNT_SPL_REQ_PKG;