APPS.IGS_AS_CAL_CONF_PKG dependencies on IGS_AS_CAL_CONF

Line 1: package body IGS_AS_CAL_CONF_PKG as

1: package body IGS_AS_CAL_CONF_PKG as
2: /* $Header: IGSDI45B.pls 115.8 2002/11/28 23:21:51 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_CAL_CONF%RowType;

Line 5: old_references IGS_AS_CAL_CONF%RowType;

1: package body IGS_AS_CAL_CONF_PKG as
2: /* $Header: IGSDI45B.pls 115.8 2002/11/28 23:21:51 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_CAL_CONF%RowType;
6: new_references IGS_AS_CAL_CONF%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_AS_CAL_CONF%RowType;

2: /* $Header: IGSDI45B.pls 115.8 2002/11/28 23:21:51 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_CAL_CONF%RowType;
6: new_references IGS_AS_CAL_CONF%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_s_control_num IN NUMBER DEFAULT NULL,

Line 26: FROM IGS_AS_CAL_CONF

22: x_last_update_login IN NUMBER DEFAULT NULL
23: ) as
24: CURSOR cur_old_ref_values IS
25: SELECT *
26: FROM IGS_AS_CAL_CONF
27: WHERE rowid = x_rowid;
28: BEGIN
29: l_rowid := x_rowid;
30: -- Code for setting the Old and New Reference Values.

Line 275: FROM IGS_AS_CAL_CONF

271: x_s_control_num IN NUMBER
272: ) RETURN BOOLEAN AS
273: CURSOR cur_rowid IS
274: SELECT rowid
275: FROM IGS_AS_CAL_CONF
276: WHERE s_control_num = x_s_control_num
277: FOR UPDATE NOWAIT;
278: lv_rowid cur_rowid%RowType;
279: BEGIN

Line 296: FROM IGS_AS_CAL_CONF

292: x_dt_alias IN VARCHAR2
293: ) as
294: CURSOR cur_rowid IS
295: SELECT rowid
296: FROM IGS_AS_CAL_CONF
297: WHERE ass_item_cutoff_dt_alias = x_dt_alias ;
298: lv_rowid cur_rowid%RowType;
299: BEGIN
300: Open cur_rowid;

Line 394: cursor C is select ROWID from IGS_AS_CAL_CONF

390: X_FINAL_MGS_START_DT_ALIAS in VARCHAR2,
391: X_FINAL_MGS_END_DT_ALIAS in VARCHAR2,
392: X_MODE in VARCHAR2 default 'R'
393: ) as
394: cursor C is select ROWID from IGS_AS_CAL_CONF
395: where S_CONTROL_NUM = new_references.S_CONTROL_NUM;
396: X_LAST_UPDATE_DATE DATE;
397: X_LAST_UPDATED_BY NUMBER;
398: X_LAST_UPDATE_LOGIN NUMBER;

Line 435: insert into IGS_AS_CAL_CONF (

431: x_last_update_date=>X_LAST_UPDATE_DATE,
432: x_last_updated_by=>X_LAST_UPDATED_BY,
433: x_last_update_login=>X_LAST_UPDATE_LOGIN
434: );
435: insert into IGS_AS_CAL_CONF (
436: S_CONTROL_NUM,
437: ASS_ITEM_CUTOFF_DT_ALIAS,
438: MID_MGS_START_DT_ALIAS,
439: MID_MGS_END_DT_ALIAS,

Line 491: from IGS_AS_CAL_CONF

487: EFINAL_MGS_START_DT_ALIAS,
488: EFINAL_MGS_END_DT_ALIAS,
489: FINAL_MGS_START_DT_ALIAS,
490: FINAL_MGS_END_DT_ALIAS
491: from IGS_AS_CAL_CONF
492: where ROWID = X_ROWID for update nowait;
493: tlinfo c1%rowtype;
494: begin
495: open c1;

Line 573: update IGS_AS_CAL_CONF set

569: x_last_update_date=>X_LAST_UPDATE_DATE,
570: x_last_updated_by=>X_LAST_UPDATED_BY,
571: x_last_update_login=>X_LAST_UPDATE_LOGIN
572: );
573: update IGS_AS_CAL_CONF set
574: ASS_ITEM_CUTOFF_DT_ALIAS = NEW_REFERENCES.ASS_ITEM_CUTOFF_DT_ALIAS,
575: MID_MGS_START_DT_ALIAS = NEW_REFERENCES.MID_MGS_START_DT_ALIAS,
576: MID_MGS_END_DT_ALIAS = NEW_REFERENCES.MID_MGS_END_DT_ALIAS,
577: EFINAL_MGS_START_DT_ALIAS = NEW_REFERENCES.EFINAL_MGS_START_DT_ALIAS,

Line 601: cursor c1 is select rowid from IGS_AS_CAL_CONF

597: X_FINAL_MGS_START_DT_ALIAS in VARCHAR2,
598: X_FINAL_MGS_END_DT_ALIAS in VARCHAR2,
599: X_MODE in VARCHAR2 default 'R'
600: ) as
601: cursor c1 is select rowid from IGS_AS_CAL_CONF
602: where S_CONTROL_NUM = nvl(X_S_CONTROL_NUM,1);
603: begin
604: open c1;
605: fetch c1 into X_ROWID;

Line 641: delete from IGS_AS_CAL_CONF

637: Before_DML(
638: p_action => 'DELETE',
639: x_rowid => X_ROWID
640: );
641: delete from IGS_AS_CAL_CONF
642: where ROWID = X_ROWID;
643: if (sql%notfound) then
644: raise no_data_found;
645: end if;

Line 647: end IGS_AS_CAL_CONF_PKG;

643: if (sql%notfound) then
644: raise no_data_found;
645: end if;
646: end DELETE_ROW;
647: end IGS_AS_CAL_CONF_PKG;