APPS.IGS_AV_STD_UNT_BASIS_PKG dependencies on IGS_AV_STD_UNT_BASIS_ALL

Line 4: old_references IGS_AV_STD_UNT_BASIS_ALL%RowType;

1: package body IGS_AV_STD_UNT_BASIS_PKG AS
2: /* $Header: IGSBI05B.pls 120.0 2005/07/05 12:08:37 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AV_STD_UNT_BASIS_ALL%RowType;
5: new_references IGS_AV_STD_UNT_BASIS_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AV_STD_UNT_BASIS_ALL%RowType;

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

Line 24: FROM IGS_AV_STD_UNT_BASIS_ALL

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

Line 65: -- ON IGS_AV_STD_UNT_BASIS_ALL

61:
62: -- Trigger description :-
63: -- "OSS_TST".trg_asub_br_iu
64: -- BEFORE INSERT OR UPDATE
65: -- ON IGS_AV_STD_UNT_BASIS_ALL
66: -- FOR EACH ROW
67:
68: PROCEDURE BeforeRowInsertUpdate1(
69: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 190: FROM IGS_AV_STD_UNT_BASIS_ALL

186: ) Return Boolean
187: AS
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM IGS_AV_STD_UNT_BASIS_ALL
191: WHERE av_stnd_unit_id = x_av_stnd_unit_id
192: FOR UPDATE NOWAIT;
193:
194: lv_rowid cur_rowid%RowType;

Line 215: FROM IGS_AV_STD_UNT_BASIS_ALL

211: ) AS
212:
213: CURSOR cur_rowid IS
214: SELECT rowid
215: FROM IGS_AV_STD_UNT_BASIS_ALL
216: WHERE av_stnd_unit_id=x_av_stnd_unit_id;
217:
218: lv_rowid cur_rowid%RowType;
219:

Line 313: cursor C is select ROWID from IGS_AV_STD_UNT_BASIS_ALL

309: X_BASIS_COMPLETION_IND in VARCHAR2,
310: X_MODE in VARCHAR2 default 'R',
311: X_ORG_ID in NUMBER
312: ) AS
313: cursor C is select ROWID from IGS_AV_STD_UNT_BASIS_ALL
314: where AV_STND_UNIT_ID=X_AV_STND_UNIT_ID;
315:
316: X_LAST_UPDATE_DATE DATE;
317: X_LAST_UPDATED_BY NUMBER;

Line 356: insert into IGS_AV_STD_UNT_BASIS_ALL (

352: );
353: IF (x_mode = 'S') THEN
354: igs_sc_gen_001.set_ctx('R');
355: END IF;
356: insert into IGS_AV_STD_UNT_BASIS_ALL (
357: AV_STND_UNIT_ID,
358: BASIS_COURSE_TYPE,
359: BASIS_YEAR,
360: BASIS_COMPLETION_IND,

Line 418: from IGS_AV_STD_UNT_BASIS_ALL

414: cursor c1 is select
415: BASIS_COURSE_TYPE,
416: BASIS_YEAR,
417: BASIS_COMPLETION_IND
418: from IGS_AV_STD_UNT_BASIS_ALL
419: where ROWID = X_ROWID
420: for update nowait;
421: tlinfo c1%rowtype;
422: begin

Line 498: update IGS_AV_STD_UNT_BASIS_ALL set

494: );
495: IF (x_mode = 'S') THEN
496: igs_sc_gen_001.set_ctx('R');
497: END IF;
498: update IGS_AV_STD_UNT_BASIS_ALL set
499: BASIS_COURSE_TYPE = NEW_REFERENCES.BASIS_COURSE_TYPE,
500: BASIS_YEAR = NEW_REFERENCES.BASIS_YEAR,
501: BASIS_COMPLETION_IND = NEW_REFERENCES.BASIS_COMPLETION_IND,
502: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 540: cursor c1 is select rowid from IGS_AV_STD_UNT_BASIS_ALL

536: X_BASIS_COMPLETION_IND in VARCHAR2,
537: X_MODE in VARCHAR2 default 'R',
538: X_ORG_ID in NUMBER
539: ) AS
540: cursor c1 is select rowid from IGS_AV_STD_UNT_BASIS_ALL
541: where AV_STND_UNIT_ID= X_AV_STND_UNIT_ID;
542: begin
543: open c1;
544: fetch c1 into X_ROWID ;

Line 579: delete from IGS_AV_STD_UNT_BASIS_ALL

575:
576: IF (x_mode = 'S') THEN
577: igs_sc_gen_001.set_ctx('R');
578: END IF;
579: delete from IGS_AV_STD_UNT_BASIS_ALL
580: where ROWID = X_ROWID ;
581: if (sql%notfound) then
582: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
583: igs_ge_msg_stack.add;