APPS.IGS_GR_SPECIAL_AWARD_PKG dependencies on IGS_GR_SPECIAL_AWARD_ALL

Line 4: old_references IGS_GR_SPECIAL_AWARD_ALL%RowType;

1: package body IGS_GR_SPECIAL_AWARD_PKG as
2: /* $Header: IGSGI16B.pls 120.1 2005/07/06 23:31:02 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_SPECIAL_AWARD_ALL%RowType;
5: new_references IGS_GR_SPECIAL_AWARD_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_GR_SPECIAL_AWARD_ALL%RowType;

1: package body IGS_GR_SPECIAL_AWARD_PKG as
2: /* $Header: IGSGI16B.pls 120.1 2005/07/06 23:31:02 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_SPECIAL_AWARD_ALL%RowType;
5: new_references IGS_GR_SPECIAL_AWARD_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_GR_SPECIAL_AWARD_ALL

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

Line 69: -- ON IGS_GR_SPECIAL_AWARD_ALL

65:
66: -- Trigger description :-
67: -- "OSS_TST".trg_spa_br_iu
68: -- BEFORE INSERT OR UPDATE
69: -- ON IGS_GR_SPECIAL_AWARD_ALL
70: -- FOR EACH ROW
71:
72: PROCEDURE BeforeRowInsertUpdate1(
73: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 143: FROM IGS_GR_SPECIAL_AWARD_ALL

139: ) RETURN BOOLEAN AS
140:
141: CURSOR cur_rowid IS
142: SELECT rowid
143: FROM IGS_GR_SPECIAL_AWARD_ALL
144: WHERE person_id = x_person_id
145: AND course_cd = x_course_cd
146: AND award_cd = x_award_cd
147: AND award_dt = x_award_dt

Line 219: FROM IGS_GR_SPECIAL_AWARD_ALL

215: ) AS
216:
217: CURSOR cur_rowid IS
218: SELECT rowid
219: FROM IGS_GR_SPECIAL_AWARD_ALL
220: WHERE person_id = x_person_id
221: AND course_cd = x_course_cd ;
222:
223: lv_rowid cur_rowid%RowType;

Line 325: cursor C is select ROWID from IGS_GR_SPECIAL_AWARD_ALL

321: X_COMMENTS in VARCHAR2,
322: X_MODE in VARCHAR2 default 'R',
323: X_ORG_ID in NUMBER
324: ) AS
325: cursor C is select ROWID from IGS_GR_SPECIAL_AWARD_ALL
326: where PERSON_ID = X_PERSON_ID
327: and COURSE_CD = X_COURSE_CD
328: and AWARD_CD = X_AWARD_CD
329: and AWARD_DT = X_AWARD_DT;

Line 372: insert into IGS_GR_SPECIAL_AWARD_ALL (

368:
369: IF (x_mode = 'S') THEN
370: igs_sc_gen_001.set_ctx('R');
371: END IF;
372: insert into IGS_GR_SPECIAL_AWARD_ALL (
373: PERSON_ID,
374: COURSE_CD,
375: AWARD_CD,
376: AWARD_DT,

Line 439: from IGS_GR_SPECIAL_AWARD_ALL

435: ) AS
436: cursor c1 is select
437: CEREMONY_ANNOUNCED_IND,
438: COMMENTS
439: from IGS_GR_SPECIAL_AWARD_ALL
440: where ROWID = X_ROWID for update nowait;
441: tlinfo c1%rowtype;
442:
443: begin

Line 518: update IGS_GR_SPECIAL_AWARD_ALL set

514:
515: IF (x_mode = 'S') THEN
516: igs_sc_gen_001.set_ctx('R');
517: END IF;
518: update IGS_GR_SPECIAL_AWARD_ALL set
519: CEREMONY_ANNOUNCED_IND = NEW_REFERENCES.CEREMONY_ANNOUNCED_IND,
520: COMMENTS = NEW_REFERENCES.COMMENTS,
521: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
522: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 563: cursor c1 is select rowid from IGS_GR_SPECIAL_AWARD_ALL

559: X_COMMENTS in VARCHAR2,
560: X_MODE in VARCHAR2 default 'R',
561: X_ORG_ID in NUMBER
562: ) AS
563: cursor c1 is select rowid from IGS_GR_SPECIAL_AWARD_ALL
564: where PERSON_ID = X_PERSON_ID
565: and COURSE_CD = X_COURSE_CD
566: and AWARD_CD = X_AWARD_CD
567: and AWARD_DT = X_AWARD_DT

Line 610: delete from IGS_GR_SPECIAL_AWARD_ALL

606:
607: IF (x_mode = 'S') THEN
608: igs_sc_gen_001.set_ctx('R');
609: END IF;
610: delete from IGS_GR_SPECIAL_AWARD_ALL
611: where ROWID = X_ROWID;
612: if (sql%notfound) then
613: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
614: igs_ge_msg_stack.add;