APPS.IGS_PS_RU_PKG dependencies on IGS_PS_RU

Line 1: package body IGS_PS_RU_PKG as

1: package body IGS_PS_RU_PKG as
2: /* $Header: IGSPI31B.pls 115.5 2002/11/29 02:21:31 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_RU%RowType;

Line 5: old_references IGS_PS_RU%RowType;

1: package body IGS_PS_RU_PKG as
2: /* $Header: IGSPI31B.pls 115.5 2002/11/29 02:21:31 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_RU%RowType;
6: new_references IGS_PS_RU%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_RU%RowType;

2: /* $Header: IGSPI31B.pls 115.5 2002/11/29 02:21:31 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_RU%RowType;
6: new_references IGS_PS_RU%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_PS_RU

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

Line 145: FROM IGS_PS_RU

141: ) RETURN BOOLEAN AS
142:
143: CURSOR cur_rowid IS
144: SELECT rowid
145: FROM IGS_PS_RU
146: WHERE course_cd = x_course_cd
147: AND s_rule_call_cd = x_s_rule_call_cd
148: FOR UPDATE NOWAIT;
149:

Line 172: FROM IGS_PS_RU

168: ) AS
169:
170: CURSOR cur_rowid IS
171: SELECT rowid
172: FROM IGS_PS_RU
173: WHERE course_cd = x_course_cd ;
174:
175: lv_rowid cur_rowid%RowType;
176:

Line 198: FROM IGS_PS_RU

194: ) AS
195:
196: CURSOR cur_rowid IS
197: SELECT rowid
198: FROM IGS_PS_RU
199: WHERE rul_sequence_number = x_sequence_number ;
200:
201: lv_rowid cur_rowid%RowType;
202:

Line 224: FROM IGS_PS_RU

220: ) AS
221:
222: CURSOR cur_rowid IS
223: SELECT rowid
224: FROM IGS_PS_RU
225: WHERE s_rule_call_cd = x_s_rule_call_cd ;
226:
227: lv_rowid cur_rowid%RowType;
228:

Line 323: cursor C is select ROWID from IGS_PS_RU

319: X_S_RULE_CALL_CD in VARCHAR2,
320: X_RUL_SEQUENCE_NUMBER in NUMBER,
321: X_MODE in VARCHAR2 default 'R'
322: ) AS
323: cursor C is select ROWID from IGS_PS_RU
324: where COURSE_CD = X_COURSE_CD
325: and S_RULE_CALL_CD = X_S_RULE_CALL_CD;
326: X_LAST_UPDATE_DATE DATE;
327: X_LAST_UPDATED_BY NUMBER;

Line 361: insert into IGS_PS_RU (

357: x_last_updated_by => X_LAST_UPDATED_BY ,
358: x_last_update_login => X_LAST_UPDATE_LOGIN
359: );
360:
361: insert into IGS_PS_RU (
362: COURSE_CD,
363: S_RULE_CALL_CD,
364: RUL_SEQUENCE_NUMBER,
365: CREATION_DATE,

Line 402: from IGS_PS_RU

398: X_RUL_SEQUENCE_NUMBER in NUMBER
399: ) AS
400: cursor c1 is select
401: RUL_SEQUENCE_NUMBER
402: from IGS_PS_RU
403: where ROWID = X_ROWID
404: for update nowait;
405: tlinfo c1%rowtype;
406:

Line 472: update IGS_PS_RU set

468: x_last_updated_by => X_LAST_UPDATED_BY ,
469: x_last_update_login => X_LAST_UPDATE_LOGIN
470: );
471:
472: update IGS_PS_RU set
473: RUL_SEQUENCE_NUMBER = NEW_REFERENCES.RUL_SEQUENCE_NUMBER,
474: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
475: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
476: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 495: cursor c1 is select rowid from IGS_PS_RU

491: X_S_RULE_CALL_CD in VARCHAR2,
492: X_RUL_SEQUENCE_NUMBER in NUMBER,
493: X_MODE in VARCHAR2 default 'R'
494: ) AS
495: cursor c1 is select rowid from IGS_PS_RU
496: where COURSE_CD = X_COURSE_CD
497: and S_RULE_CALL_CD = X_S_RULE_CALL_CD
498: ;
499: begin

Line 529: delete from IGS_PS_RU

525: Before_DML (
526: p_action => 'DELETE',
527: x_rowid => X_ROWID
528: );
529: delete from IGS_PS_RU
530: where ROWID = X_ROWID;
531: if (sql%notfound) then
532: raise no_data_found;
533: end if;

Line 540: end IGS_PS_RU_PKG;

536: x_rowid => X_ROWID
537: );
538: end DELETE_ROW;
539:
540: end IGS_PS_RU_PKG;