APPS.IGS_AV_STD_ULVLBASIS_PKG dependencies on IGS_AV_STD_ULVLBASIS_ALL

Line 4: old_references IGS_AV_STD_ULVLBASIS_ALL%RowType;

1: package body IGS_AV_STD_ULVLBASIS_PKG AS
2: /* $Header: IGSBI02B.pls 120.0 2005/07/05 11:44:14 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AV_STD_ULVLBASIS_ALL%RowType;
5: new_references IGS_AV_STD_ULVLBASIS_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_AV_STD_ULVLBASIS_ALL%RowType;

1: package body IGS_AV_STD_ULVLBASIS_PKG AS
2: /* $Header: IGSBI02B.pls 120.0 2005/07/05 11:44:14 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AV_STD_ULVLBASIS_ALL%RowType;
5: new_references IGS_AV_STD_ULVLBASIS_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_av_stnd_unit_lvl_id IN NUMBER DEFAULT NULL,

Line 22: FROM IGS_AV_STD_ULVLBASIS_ALL

18: x_org_id IN NUMBER DEFAULT NULL
19: ) AS
20: CURSOR cur_old_ref_values IS
21: SELECT *
22: FROM IGS_AV_STD_ULVLBASIS_ALL
23: WHERE rowid = x_rowid;
24: BEGIN
25: l_rowid := x_rowid;
26: -- Code for setting the Old and New Reference Values.

Line 60: -- ON IGS_AV_STD_ULVLBASIS_ALL

56:
57: -- Trigger description :-
58: -- "OSS_TST".trg_asuleb_br_iu
59: -- BEFORE INSERT OR UPDATE
60: -- ON IGS_AV_STD_ULVLBASIS_ALL
61: -- FOR EACH ROW
62:
63:
64: PROCEDURE BeforeRowInsertUpdate1(

Line 195: FROM IGS_AV_STD_ULVLBASIS_ALL

191: ) RETURN BOOLEAN AS
192:
193: CURSOR cur_rowid IS
194: SELECT rowid
195: FROM IGS_AV_STD_ULVLBASIS_ALL
196: WHERE av_stnd_unit_lvl_id = x_av_stnd_unit_lvl_id
197: FOR UPDATE NOWAIT;
198: lv_rowid cur_rowid%RowType;
199:

Line 219: FROM IGS_AV_STD_ULVLBASIS_ALL

215: x_av_stnd_unit_lvl_id IN NUMBER
216: ) AS
217: CURSOR cur_rowid IS
218: SELECT rowid
219: FROM IGS_AV_STD_ULVLBASIS_ALL
220: WHERE av_stnd_unit_lvl_id = x_av_stnd_unit_lvl_id;
221: lv_rowid cur_rowid%RowType;
222: BEGIN
223: Open cur_rowid;

Line 315: cursor C is select ROWID from IGS_AV_STD_ULVLBASIS_ALL

311: X_BASIS_COMPLETION_IND in VARCHAR2,
312: X_MODE in VARCHAR2 default 'R',
313: X_ORG_ID in NUMBER
314: ) AS
315: cursor C is select ROWID from IGS_AV_STD_ULVLBASIS_ALL
316: where av_stnd_unit_lvl_id =x_av_stnd_unit_lvl_id;
317: X_LAST_UPDATE_DATE DATE;
318: X_LAST_UPDATED_BY NUMBER;
319: X_LAST_UPDATE_LOGIN NUMBER;

Line 356: insert into IGS_AV_STD_ULVLBASIS_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_ULVLBASIS_ALL (
357: AV_STND_UNIT_LVL_ID,
358: BASIS_COURSE_TYPE,
359: BASIS_YEAR,
360: BASIS_COMPLETION_IND,

Line 417: from IGS_AV_STD_ULVLBASIS_ALL

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

Line 493: update IGS_AV_STD_ULVLBASIS_ALL set

489:
490: IF (x_mode = 'S') THEN
491: igs_sc_gen_001.set_ctx('R');
492: END IF;
493: update IGS_AV_STD_ULVLBASIS_ALL set
494: BASIS_COURSE_TYPE = NEW_REFERENCES.BASIS_COURSE_TYPE,
495: BASIS_YEAR = NEW_REFERENCES.BASIS_YEAR,
496: BASIS_COMPLETION_IND = NEW_REFERENCES.BASIS_COMPLETION_IND,
497: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 537: cursor c1 is select rowid from IGS_AV_STD_ULVLBASIS_ALL

533: X_BASIS_COMPLETION_IND in VARCHAR2,
534: X_MODE in VARCHAR2 default 'R',
535: X_ORG_ID in NUMBER
536: ) AS
537: cursor c1 is select rowid from IGS_AV_STD_ULVLBASIS_ALL
538: where AV_STND_UNIT_LVL_ID=X_AV_STND_UNIT_LVL_ID
539: ;
540: begin
541: open c1;

Line 576: delete from IGS_AV_STD_ULVLBASIS_ALL

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