APPS.IGS_AV_ADV_STANDING_PKG dependencies on IGS_AV_ADV_STANDING_ALL

Line 4: old_references IGS_AV_ADV_STANDING_ALL%RowType;

1: package body IGS_AV_ADV_STANDING_PKG AS
2: /* $Header: IGSBI01B.pls 120.0 2005/07/05 16:04:58 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AV_ADV_STANDING_ALL%RowType;
5: new_references IGS_AV_ADV_STANDING_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AV_ADV_STANDING_ALL%RowType;

1: package body IGS_AV_ADV_STANDING_PKG AS
2: /* $Header: IGSBI01B.pls 120.0 2005/07/05 16:04:58 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AV_ADV_STANDING_ALL%RowType;
5: new_references IGS_AV_ADV_STANDING_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 27: FROM IGS_AV_ADV_STANDING_ALL

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

Line 73: -- ON IGS_AV_ADV_STANDING_ALL

69:
70: -- Trigger description :-
71: -- "OSS_TST".trg_as_br_iu
72: -- BEFORE INSERT OR UPDATE
73: -- ON IGS_AV_ADV_STANDING_ALL
74: -- FOR EACH ROW
75:
76: PROCEDURE BeforeRowInsertUpdate1(
77: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 264: FROM IGS_AV_ADV_STANDING_ALL

260: ) RETURN BOOLEAN AS
261:
262: CURSOR cur_rowid IS
263: SELECT rowid
264: FROM IGS_AV_ADV_STANDING_ALL
265: WHERE person_id = x_person_id
266: AND course_cd = x_course_cd
267: AND version_number = x_version_number
268: AND exemption_institution_cd =x_exemption_institution_cd

Line 295: FROM IGS_AV_ADV_STANDING_ALL

291: ) AS
292:
293: CURSOR cur_rowid IS
294: SELECT rowid
295: FROM IGS_AV_ADV_STANDING_ALL
296: WHERE course_cd = x_course_cd
297: AND version_number = x_version_number ;
298:
299: lv_rowid cur_rowid%RowType;

Line 320: FROM IGS_AV_ADV_STANDING_ALL

316: ) AS
317:
318: CURSOR cur_rowid IS
319: SELECT rowid
320: FROM IGS_AV_ADV_STANDING_ALL
321: WHERE person_id = x_person_id ;
322:
323: lv_rowid cur_rowid%RowType;
324:

Line 427: cursor C is select ROWID from IGS_AV_ADV_STANDING_ALL

423: X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
424: X_MODE in VARCHAR2 default 'R',
425: X_ORG_ID in NUMBER
426: ) AS
427: cursor C is select ROWID from IGS_AV_ADV_STANDING_ALL
428: where PERSON_ID = X_PERSON_ID
429: and COURSE_CD = X_COURSE_CD
430: and VERSION_NUMBER = X_VERSION_NUMBER;
431: X_LAST_UPDATE_DATE DATE;

Line 473: insert into IGS_AV_ADV_STANDING_ALL (

469: );
470: IF (x_mode = 'S') THEN
471: igs_sc_gen_001.set_ctx('R');
472: END IF;
473: insert into IGS_AV_ADV_STANDING_ALL (
474: PERSON_ID,
475: COURSE_CD,
476: VERSION_NUMBER,
477: TOTAL_EXMPTN_APPROVED,

Line 545: from IGS_AV_ADV_STANDING_ALL

541: TOTAL_EXMPTN_APPROVED,
542: TOTAL_EXMPTN_GRANTED,
543: TOTAL_EXMPTN_PERC_GRNTD,
544: EXEMPTION_INSTITUTION_CD
545: from IGS_AV_ADV_STANDING_ALL
546: where ROWID = X_ROWID for update nowait;
547: tlinfo c1%rowtype;
548:
549: begin

Line 627: update IGS_AV_ADV_STANDING_ALL set

623: );
624: IF (x_mode = 'S') THEN
625: igs_sc_gen_001.set_ctx('R');
626: END IF;
627: update IGS_AV_ADV_STANDING_ALL set
628: TOTAL_EXMPTN_APPROVED = NEW_REFERENCES.TOTAL_EXMPTN_APPROVED,
629: TOTAL_EXMPTN_GRANTED = NEW_REFERENCES.TOTAL_EXMPTN_GRANTED,
630: TOTAL_EXMPTN_PERC_GRNTD = NEW_REFERENCES.TOTAL_EXMPTN_PERC_GRNTD,
631: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 672: cursor c1 is select rowid from IGS_AV_ADV_STANDING_ALL

668: X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
669: X_MODE in VARCHAR2 default 'R',
670: X_ORG_ID in NUMBER
671: ) AS
672: cursor c1 is select rowid from IGS_AV_ADV_STANDING_ALL
673: where PERSON_ID = X_PERSON_ID
674: and COURSE_CD = X_COURSE_CD
675: and VERSION_NUMBER = X_VERSION_NUMBER
676: ;

Line 721: delete from IGS_AV_ADV_STANDING_ALL

717:
718: IF (x_mode = 'S') THEN
719: igs_sc_gen_001.set_ctx('R');
720: END IF;
721: delete from IGS_AV_ADV_STANDING_ALL
722: where ROWID = X_ROWID ;
723: if (sql%notfound) then
724: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
725: igs_ge_msg_stack.add;