APPS.IGS_PS_USEC_RU_PKG dependencies on IGS_PS_USEC_RU

Line 1: PACKAGE BODY igs_ps_usec_ru_pkg AS

1: PACKAGE BODY igs_ps_usec_ru_pkg AS
2: /* $Header: IGSPI2VB.pls 115.4 2002/11/29 02:20:10 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_ru%ROWTYPE;

Line 5: old_references igs_ps_usec_ru%ROWTYPE;

1: PACKAGE BODY igs_ps_usec_ru_pkg AS
2: /* $Header: IGSPI2VB.pls 115.4 2002/11/29 02:20:10 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_ru%ROWTYPE;
6: new_references igs_ps_usec_ru%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_usec_ru%ROWTYPE;

2: /* $Header: IGSPI2VB.pls 115.4 2002/11/29 02:20:10 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_usec_ru%ROWTYPE;
6: new_references igs_ps_usec_ru%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM IGS_PS_USEC_RU

29: */
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM IGS_PS_USEC_RU
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 159: FROM igs_ps_usec_ru

155: || (reverse chronological order - newest change first)
156: */
157: CURSOR cur_rowid IS
158: SELECT rowid
159: FROM igs_ps_usec_ru
160: WHERE usecru_id = x_usecru_id
161: FOR UPDATE NOWAIT;
162:
163: lv_rowid cur_rowid%RowType;

Line 194: FROM igs_ps_usec_ru

190: || (reverse chronological order - newest change first)
191: */
192: CURSOR cur_rowid IS
193: SELECT rowid
194: FROM igs_ps_usec_ru
195: WHERE uoo_id = x_uoo_id
196: AND s_rule_call_cd = x_s_rule_call_cd
197: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
198:

Line 230: FROM igs_ps_usec_ru

226: || (reverse chronological order - newest change first)
227: */
228: CURSOR cur_rowid IS
229: SELECT rowid
230: FROM igs_ps_usec_ru
231: WHERE ((uoo_id = x_uoo_id));
232:
233: lv_rowid cur_rowid%RowType;
234:

Line 265: FROM igs_ps_usec_ru

261: || (reverse chronological order - newest change first)
262: */
263: CURSOR cur_rowid IS
264: SELECT rowid
265: FROM igs_ps_usec_ru
266: WHERE ((s_rule_call_cd = x_s_rule_call_cd));
267:
268: lv_rowid cur_rowid%RowType;
269:

Line 300: FROM igs_ps_usec_ru

296: || (reverse chronological order - newest change first)
297: */
298: CURSOR cur_rowid IS
299: SELECT rowid
300: FROM igs_ps_usec_ru
301: WHERE ((rul_sequence_number = x_rul_sequence_number));
302:
303: lv_rowid cur_rowid%RowType;
304:

Line 413: FROM igs_ps_usec_ru

409: || (reverse chronological order - newest change first)
410: */
411: CURSOR c IS
412: SELECT rowid
413: FROM igs_ps_usec_ru
414: WHERE usecru_id = x_usecru_id;
415:
416: x_last_update_date DATE;
417: x_last_updated_by NUMBER;

Line 441: SELECT igs_ps_usec_ru_s.NEXTVAL

437: igs_ge_msg_stack.add;
438: app_exception.raise_exception;
439: END IF;
440:
441: SELECT igs_ps_usec_ru_s.NEXTVAL
442: INTO x_usecru_id
443: FROM dual;
444:
445: before_dml(

Line 459: INSERT INTO igs_ps_usec_ru (

455: x_last_updated_by => x_last_updated_by,
456: x_last_update_login => x_last_update_login
457: );
458:
459: INSERT INTO igs_ps_usec_ru (
460: usecru_id,
461: uoo_id,
462: s_rule_call_cd,
463: rul_sequence_number,

Line 513: FROM igs_ps_usec_ru

509: SELECT
510: uoo_id,
511: s_rule_call_cd,
512: rul_sequence_number
513: FROM igs_ps_usec_ru
514: WHERE rowid = x_rowid
515: FOR UPDATE NOWAIT;
516:
517: tlinfo c1%ROWTYPE;

Line 605: UPDATE igs_ps_usec_ru

601: x_last_updated_by => x_last_updated_by,
602: x_last_update_login => x_last_update_login
603: );
604:
605: UPDATE igs_ps_usec_ru
606: SET
607: uoo_id = new_references.uoo_id,
608: s_rule_call_cd = new_references.s_rule_call_cd,
609: rul_sequence_number = new_references.rul_sequence_number,

Line 641: FROM igs_ps_usec_ru

637: || (reverse chronological order - newest change first)
638: */
639: CURSOR c1 IS
640: SELECT rowid
641: FROM igs_ps_usec_ru
642: WHERE usecru_id = x_usecru_id;
643:
644: BEGIN
645:

Line 694: DELETE FROM igs_ps_usec_ru

690: p_action => 'DELETE',
691: x_rowid => x_rowid
692: );
693:
694: DELETE FROM igs_ps_usec_ru
695: WHERE rowid = x_rowid;
696:
697: IF (SQL%NOTFOUND) THEN
698: RAISE NO_DATA_FOUND;

Line 704: END igs_ps_usec_ru_pkg;

700:
701: END delete_row;
702:
703:
704: END igs_ps_usec_ru_pkg;