APPS.IGS_PS_RPT_FMLY_PKG dependencies on IGS_PS_RPT_FMLY

Line 1: PACKAGE BODY igs_ps_rpt_fmly_pkg AS

1: PACKAGE BODY igs_ps_rpt_fmly_pkg AS
2: /* $Header: IGSPI2CB.pls 115.7 2003/03/21 08:00:47 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rpt_fmly_all%ROWTYPE;

Line 5: old_references igs_ps_rpt_fmly_all%ROWTYPE;

1: PACKAGE BODY igs_ps_rpt_fmly_pkg AS
2: /* $Header: IGSPI2CB.pls 115.7 2003/03/21 08:00:47 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rpt_fmly_all%ROWTYPE;
6: new_references igs_ps_rpt_fmly_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ps_rpt_fmly_all%ROWTYPE;

2: /* $Header: IGSPI2CB.pls 115.7 2003/03/21 08:00:47 sarakshi ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ps_rpt_fmly_all%ROWTYPE;
6: new_references igs_ps_rpt_fmly_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGS_PS_RPT_FMLY_ALL

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

Line 111: igs_ps_unit_ver_pkg.get_fk_igs_ps_rpt_fmly_all (

107: || (reverse chronological order - newest change first)
108: */
109: BEGIN
110:
111: igs_ps_unit_ver_pkg.get_fk_igs_ps_rpt_fmly_all (
112: old_references.rpt_fmly_id
113: );
114:
115: END check_child_existance;

Line 132: FROM igs_ps_rpt_fmly_all

128: || (reverse chronological order - newest change first)
129: */
130: CURSOR cur_rowid IS
131: SELECT rowid
132: FROM igs_ps_rpt_fmly_all
133: WHERE rpt_fmly_id = x_rpt_fmly_id
134: FOR UPDATE NOWAIT;
135:
136: lv_rowid cur_rowid%RowType;

Line 168: FROM igs_ps_rpt_fmly

164: || (reverse chronological order - newest change first)
165: */
166: CURSOR cur_rowid IS
167: SELECT rowid
168: FROM igs_ps_rpt_fmly
169: WHERE repeat_code = x_repeat_code
170: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
171:
172: lv_rowid cur_rowid%RowType;

Line 286: FROM igs_ps_rpt_fmly_all

282: || (reverse chronological order - newest change first)
283: */
284: CURSOR c IS
285: SELECT rowid
286: FROM igs_ps_rpt_fmly_all
287: WHERE rpt_fmly_id = x_rpt_fmly_id;
288:
289: x_last_update_date DATE;
290: x_last_updated_by NUMBER;

Line 316: select igs_ps_rpt_fmly_all_s.NEXTVAL

312: END IF;
313:
314:
315: new_references.org_id := igs_ge_gen_003.get_org_id;
316: select igs_ps_rpt_fmly_all_s.NEXTVAL
317: into x_rpt_fmly_id
318: from dual;
319:
320: before_dml(

Line 334: INSERT INTO igs_ps_rpt_fmly_all (

330: x_last_updated_by => x_last_updated_by,
331: x_last_update_login => x_last_update_login
332: );
333:
334: INSERT INTO igs_ps_rpt_fmly_all (
335: rpt_fmly_id,
336: repeat_code,
337: description,
338: closed_ind,

Line 390: FROM igs_ps_rpt_fmly_all

386: SELECT
387: repeat_code,
388: description,
389: closed_ind
390: FROM igs_ps_rpt_fmly_all
391: WHERE rowid = x_rowid
392: FOR UPDATE NOWAIT;
393:
394: tlinfo c1%ROWTYPE;

Line 482: UPDATE igs_ps_rpt_fmly_all

478: x_last_updated_by => x_last_updated_by,
479: x_last_update_login => x_last_update_login
480: );
481:
482: UPDATE igs_ps_rpt_fmly_all
483: SET
484: repeat_code = new_references.repeat_code,
485: description = new_references.description,
486: closed_ind = new_references.closed_ind,

Line 518: FROM igs_ps_rpt_fmly_all

514: || (reverse chronological order - newest change first)
515: */
516: CURSOR c1 IS
517: SELECT rowid
518: FROM igs_ps_rpt_fmly_all
519: WHERE rpt_fmly_id = x_rpt_fmly_id;
520:
521: BEGIN
522:

Line 571: DELETE FROM igs_ps_rpt_fmly_all

567: p_action => 'DELETE',
568: x_rowid => x_rowid
569: );
570:
571: DELETE FROM igs_ps_rpt_fmly_all
572: WHERE rowid = x_rowid;
573:
574: IF (SQL%NOTFOUND) THEN
575: RAISE NO_DATA_FOUND;

Line 581: END igs_ps_rpt_fmly_pkg;

577:
578: END delete_row;
579:
580:
581: END igs_ps_rpt_fmly_pkg;