APPS.IGS_PR_S_PRG_CAL_PKG dependencies on IGS_PR_S_PRG_CAL

Line 1: package body IGS_PR_S_PRG_CAL_PKG as

1: package body IGS_PR_S_PRG_CAL_PKG as
2: /* $Header: IGSQI25B.pls 115.4 2002/11/29 03:20:32 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_PRG_CAL%RowType;

Line 5: old_references IGS_PR_S_PRG_CAL%RowType;

1: package body IGS_PR_S_PRG_CAL_PKG as
2: /* $Header: IGSQI25B.pls 115.4 2002/11/29 03:20:32 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_PRG_CAL%RowType;
6: new_references IGS_PR_S_PRG_CAL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PR_S_PRG_CAL%RowType;

2: /* $Header: IGSQI25B.pls 115.4 2002/11/29 03:20:32 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_PRG_CAL%RowType;
6: new_references IGS_PR_S_PRG_CAL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_PR_S_PRG_CAL

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

Line 68: -- ON IGS_PR_S_PRG_CAL

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

Line 153: FROM IGS_PR_S_PRG_CAL

149: ) RETURN BOOLEAN AS
150:
151: CURSOR cur_rowid IS
152: SELECT rowid
153: FROM IGS_PR_S_PRG_CAL
154: WHERE s_control_num = x_s_control_num
155: AND prg_cal_type = x_prg_cal_type
156: FOR UPDATE NOWAIT;
157:

Line 180: FROM IGS_PR_S_PRG_CAL

176: ) AS
177:
178: CURSOR cur_rowid IS
179: SELECT rowid
180: FROM IGS_PR_S_PRG_CAL
181: WHERE prg_cal_type = x_cal_type ;
182:
183: lv_rowid cur_rowid%RowType;
184:

Line 207: FROM IGS_PR_S_PRG_CAL

203: ) AS
204:
205: CURSOR cur_rowid IS
206: SELECT rowid
207: FROM IGS_PR_S_PRG_CAL
208: WHERE s_control_num = x_s_control_num ;
209:
210: lv_rowid cur_rowid%RowType;
211:

Line 305: cursor C is select ROWID from IGS_PR_S_PRG_CAL

301: X_SHOW_CAUSE_LENGTH in NUMBER,
302: X_APPEAL_LENGTH in NUMBER,
303: X_MODE in VARCHAR2 default 'R'
304: ) as
305: cursor C is select ROWID from IGS_PR_S_PRG_CAL
306: where S_CONTROL_NUM = NEW_REFERENCES.S_CONTROL_NUM
307: and PRG_CAL_TYPE = X_PRG_CAL_TYPE;
308: X_LAST_UPDATE_DATE DATE;
309: X_LAST_UPDATED_BY NUMBER;

Line 346: insert into IGS_PR_S_PRG_CAL (

342: x_last_updated_by=>X_LAST_UPDATED_BY,
343: x_last_update_login=>X_LAST_UPDATE_LOGIN
344: );
345:
346: insert into IGS_PR_S_PRG_CAL (
347: S_CONTROL_NUM,
348: PRG_CAL_TYPE,
349: STREAM_NUM,
350: SHOW_CAUSE_LENGTH,

Line 392: from IGS_PR_S_PRG_CAL

388: cursor c1 is select
389: STREAM_NUM,
390: SHOW_CAUSE_LENGTH,
391: APPEAL_LENGTH
392: from IGS_PR_S_PRG_CAL
393: where ROWID = X_ROWID
394: for update nowait;
395: tlinfo c1%rowtype;
396:

Line 474: update IGS_PR_S_PRG_CAL set

470: x_last_updated_by=>X_LAST_UPDATED_BY,
471: x_last_update_login=>X_LAST_UPDATE_LOGIN
472: );
473:
474: update IGS_PR_S_PRG_CAL set
475: STREAM_NUM = NEW_REFERENCES.STREAM_NUM,
476: SHOW_CAUSE_LENGTH = NEW_REFERENCES.SHOW_CAUSE_LENGTH,
477: APPEAL_LENGTH = NEW_REFERENCES.APPEAL_LENGTH,
478: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 498: cursor c1 is select rowid from IGS_PR_S_PRG_CAL

494: X_SHOW_CAUSE_LENGTH in NUMBER,
495: X_APPEAL_LENGTH in NUMBER,
496: X_MODE in VARCHAR2 default 'R'
497: ) as
498: cursor c1 is select rowid from IGS_PR_S_PRG_CAL
499: where S_CONTROL_NUM = NVL(S_CONTROL_NUM,1)
500: and PRG_CAL_TYPE = X_PRG_CAL_TYPE
501: ;
502: begin

Line 539: delete from IGS_PR_S_PRG_CAL

535: x_rowid => X_ROWID
536: );
537:
538:
539: delete from IGS_PR_S_PRG_CAL
540: where ROWID = X_ROWID;
541:
542: if (sql%notfound) then
543: raise no_data_found;

Line 620: end IGS_PR_S_PRG_CAL_PKG;

616: END IF ;
617:
618: END Check_Constraints;
619:
620: end IGS_PR_S_PRG_CAL_PKG;