APPS.IGS_AS_SPL_CONS_APPL_PKG dependencies on IGS_AS_SPL_CONS_APPL

Line 1: package body IGS_AS_SPL_CONS_APPL_PKG AS

1: package body IGS_AS_SPL_CONS_APPL_PKG AS
2: /* $Header: IGSDI10B.pls 120.0 2005/07/05 12:02:13 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SPL_CONS_APPL%RowType;

Line 5: old_references IGS_AS_SPL_CONS_APPL%RowType;

1: package body IGS_AS_SPL_CONS_APPL_PKG AS
2: /* $Header: IGSDI10B.pls 120.0 2005/07/05 12:02:13 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SPL_CONS_APPL%RowType;
6: new_references IGS_AS_SPL_CONS_APPL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_AS_SPL_CONS_APPL%RowType;

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

Line 34: FROM IGS_AS_SPL_CONS_APPL

30: x_notified_date IN DATE DEFAULT NULL
31: ) IS
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM IGS_AS_SPL_CONS_APPL
35: WHERE rowid = x_rowid;
36: BEGIN
37: l_rowid := x_rowid;
38: -- Code for setting the Old and New Reference Values.

Line 262: FROM IGS_AS_SPL_CONS_APPL

258: x_uoo_id IN NUMBER
259: ) RETURN BOOLEAN AS
260: CURSOR cur_rowid IS
261: SELECT rowid
262: FROM IGS_AS_SPL_CONS_APPL
263: WHERE person_id = x_person_id
264: AND course_cd = x_course_cd
265: AND ass_id = x_ass_id
266: AND creation_dt = x_creation_dt

Line 290: FROM IGS_AS_SPL_CONS_APPL

286: x_spcl_consideration_outcome IN VARCHAR2
287: ) AS
288: CURSOR cur_rowid IS
289: SELECT rowid
290: FROM IGS_AS_SPL_CONS_APPL
291: WHERE sought_outcome = x_spcl_consideration_outcome OR
292: spcl_consideration_outcome= x_spcl_consideration_outcome ;
293: lv_rowid cur_rowid%RowType;
294: BEGIN

Line 321: FROM IGS_AS_SPL_CONS_APPL

317: x_uoo_id IN NUMBER
318: ) AS
319: CURSOR cur_rowid IS
320: SELECT rowid
321: FROM IGS_AS_SPL_CONS_APPL
322: WHERE person_id = x_person_id
323: AND course_cd = x_course_cd
324: AND ass_id = x_ass_id
325: AND creation_dt = x_creation_dt

Line 346: FROM IGS_AS_SPL_CONS_APPL

342: x_spcl_consideration_cat IN VARCHAR2
343: ) AS
344: CURSOR cur_rowid IS
345: SELECT rowid
346: FROM IGS_AS_SPL_CONS_APPL
347: WHERE spcl_consideration_cat= x_spcl_consideration_cat ;
348: lv_rowid cur_rowid%RowType;
349: BEGIN
350: Open cur_rowid;

Line 480: cursor C is select ROWID from IGS_AS_SPL_CONS_APPL

476: X_MODE in VARCHAR2 default 'R',
477: X_UOO_ID in NUMBER,
478: X_NOTIFIED_DATE DATE
479: ) AS
480: cursor C is select ROWID from IGS_AS_SPL_CONS_APPL
481: where PERSON_ID = X_PERSON_ID
482: and COURSE_CD = X_COURSE_CD
483: and ASS_ID = X_ASS_ID
484: and CREATION_DT = X_CREATION_DT

Line 537: insert into IGS_AS_SPL_CONS_APPL (

533: );
534: IF (x_mode = 'S') THEN
535: igs_sc_gen_001.set_ctx('R');
536: END IF;
537: insert into IGS_AS_SPL_CONS_APPL (
538: PERSON_ID,
539: COURSE_CD,
540: UNIT_CD,
541: CAL_TYPE,

Line 634: from IGS_AS_SPL_CONS_APPL

630: SPCL_CONSIDERATION_OUTCOME,
631: ESTIMATED_PROCESSING_DAYS,
632: TRACKING_ID,
633: COMMENTS
634: from IGS_AS_SPL_CONS_APPL
635: where ROWID = X_ROWID for update nowait;
636: tlinfo c1%rowtype;
637: begin
638: open c1;

Line 743: update IGS_AS_SPL_CONS_APPL set

739: );
740: IF (x_mode = 'S') THEN
741: igs_sc_gen_001.set_ctx('R');
742: END IF;
743: update IGS_AS_SPL_CONS_APPL set
744: SPCL_CONSIDERATION_CAT = NEW_REFERENCES.SPCL_CONSIDERATION_CAT,
745: SOUGHT_OUTCOME = NEW_REFERENCES.SOUGHT_OUTCOME,
746: SPCL_CONSIDERATION_OUTCOME = NEW_REFERENCES.SPCL_CONSIDERATION_OUTCOME,
747: ESTIMATED_PROCESSING_DAYS = NEW_REFERENCES.ESTIMATED_PROCESSING_DAYS,

Line 800: cursor c1 is select rowid from IGS_AS_SPL_CONS_APPL

796: X_MODE in VARCHAR2 default 'R',
797: X_UOO_ID in NUMBER,
798: X_NOTIFIED_DATE in DATE
799: ) AS
800: cursor c1 is select rowid from IGS_AS_SPL_CONS_APPL
801: where PERSON_ID = X_PERSON_ID
802: and COURSE_CD = X_COURSE_CD
803: and ASS_ID = X_ASS_ID
804: and CREATION_DT = X_CREATION_DT

Line 865: delete from IGS_AS_SPL_CONS_APPL

861: );
862: IF (x_mode = 'S') THEN
863: igs_sc_gen_001.set_ctx('R');
864: END IF;
865: delete from IGS_AS_SPL_CONS_APPL
866: where ROWID = X_ROWID;
867: if (sql%notfound) then
868: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
869: igs_ge_msg_stack.add;

Line 979: end IGS_AS_SPL_CONS_APPL_PKG;

975: END IF;
976: END IF;
977: END Check_Constraints;
978:
979: end IGS_AS_SPL_CONS_APPL_PKG;