APPS.IGS_PR_ORG_STAT_REF_PKG dependencies on IGS_PR_ORG_STAT_REF

Line 1: PACKAGE BODY igs_pr_org_stat_ref_pkg AS

1: PACKAGE BODY igs_pr_org_stat_ref_pkg AS
2: /* $Header: IGSQI37B.pls 115.3 2002/11/29 03:24:13 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_org_stat_ref%ROWTYPE;

Line 5: old_references igs_pr_org_stat_ref%ROWTYPE;

1: PACKAGE BODY igs_pr_org_stat_ref_pkg AS
2: /* $Header: IGSQI37B.pls 115.3 2002/11/29 03:24:13 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_org_stat_ref%ROWTYPE;
6: new_references igs_pr_org_stat_ref%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pr_org_stat_ref%ROWTYPE;

2: /* $Header: IGSQI37B.pls 115.3 2002/11/29 03:24:13 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pr_org_stat_ref%ROWTYPE;
6: new_references igs_pr_org_stat_ref%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM igs_pr_org_stat_ref

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

Line 119: FROM igs_pr_org_stat_ref

115: || (reverse chronological order - newest change first)
116: */
117: CURSOR cur_rowid IS
118: SELECT rowid
119: FROM igs_pr_org_stat_ref
120: WHERE org_unit_cd = x_org_unit_cd
121: AND stat_type = x_stat_type
122: AND unit_ref_cd = x_unit_ref_cd
123: FOR UPDATE NOWAIT;

Line 157: FROM igs_pr_org_stat_ref

153: || (reverse chronological order - newest change first)
154: */
155: CURSOR cur_rowid IS
156: SELECT rowid
157: FROM igs_pr_org_stat_ref
158: WHERE ((org_unit_cd = x_org_unit_cd) AND
159: (stat_type = x_stat_type));
160:
161: lv_rowid cur_rowid%RowType;

Line 270: FROM igs_pr_org_stat_ref

266: || (reverse chronological order - newest change first)
267: */
268: CURSOR c IS
269: SELECT rowid
270: FROM igs_pr_org_stat_ref
271: WHERE org_unit_cd = x_org_unit_cd
272: AND stat_type = x_stat_type
273: AND unit_ref_cd = x_unit_ref_cd;
274: CURSOR c1 IS

Line 276: FROM igs_pr_org_stat_ref

272: AND stat_type = x_stat_type
273: AND unit_ref_cd = x_unit_ref_cd;
274: CURSOR c1 IS
275: SELECT include_or_exclude
276: FROM igs_pr_org_stat_ref
277: WHERE org_unit_cd = x_org_unit_cd
278: AND stat_type = x_stat_type;
279:
280: x_last_update_date DATE;

Line 283: l_include_or_exclude igs_pr_org_stat_ref.include_or_exclude%TYPE;

279:
280: x_last_update_date DATE;
281: x_last_updated_by NUMBER;
282: x_last_update_login NUMBER;
283: l_include_or_exclude igs_pr_org_stat_ref.include_or_exclude%TYPE;
284: l_c1 c1%ROWTYPE;
285: BEGIN
286:
287: x_last_update_date := SYSDATE;

Line 334: INSERT INTO igs_pr_org_stat_ref (

330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: END IF;
333: END LOOP;
334: INSERT INTO igs_pr_org_stat_ref (
335: stat_type,
336: org_unit_cd,
337: unit_ref_cd,
338: include_or_exclude,

Line 386: FROM igs_pr_org_stat_ref

382: */
383: CURSOR c1 IS
384: SELECT
385: include_or_exclude
386: FROM igs_pr_org_stat_ref
387: WHERE rowid = x_rowid
388: FOR UPDATE NOWAIT;
389:
390: tlinfo c1%ROWTYPE;

Line 476: UPDATE igs_pr_org_stat_ref

472: x_last_updated_by => x_last_updated_by,
473: x_last_update_login => x_last_update_login
474: );
475:
476: UPDATE igs_pr_org_stat_ref
477: SET
478: include_or_exclude = new_references.include_or_exclude,
479: last_update_date = x_last_update_date,
480: last_updated_by = x_last_updated_by,

Line 510: FROM igs_pr_org_stat_ref

506: || (reverse chronological order - newest change first)
507: */
508: CURSOR c1 IS
509: SELECT rowid
510: FROM igs_pr_org_stat_ref
511: WHERE org_unit_cd = x_org_unit_cd
512: AND stat_type = x_stat_type
513: AND unit_ref_cd = x_unit_ref_cd;
514:

Line 565: DELETE FROM igs_pr_org_stat_ref

561: p_action => 'DELETE',
562: x_rowid => x_rowid
563: );
564:
565: DELETE FROM igs_pr_org_stat_ref
566: WHERE rowid = x_rowid;
567:
568: IF (SQL%NOTFOUND) THEN
569: RAISE NO_DATA_FOUND;

Line 575: END igs_pr_org_stat_ref_pkg;

571:
572: END delete_row;
573:
574:
575: END igs_pr_org_stat_ref_pkg;