APPS.IGS_UC_MAP_OUT_STAT_PKG dependencies on IGS_UC_MAP_OUT_STAT

Line 1: PACKAGE BODY igs_uc_map_out_stat_pkg AS

1: PACKAGE BODY igs_uc_map_out_stat_pkg AS
2: /* $Header: IGSXI45B.pls 115.8 2003/10/30 13:32:48 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_map_out_stat%ROWTYPE;

Line 5: old_references igs_uc_map_out_stat%ROWTYPE;

1: PACKAGE BODY igs_uc_map_out_stat_pkg AS
2: /* $Header: IGSXI45B.pls 115.8 2003/10/30 13:32:48 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_map_out_stat%ROWTYPE;
6: new_references igs_uc_map_out_stat%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_map_out_stat%ROWTYPE;

2: /* $Header: IGSXI45B.pls 115.8 2003/10/30 13:32:48 rghosh noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_map_out_stat%ROWTYPE;
6: new_references igs_uc_map_out_stat%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igs_uc_map_out_stat

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

Line 158: FROM igs_uc_map_out_stat

154: || (reverse chronological order - newest change first)
155: */
156: CURSOR cur_rowid IS
157: SELECT rowid
158: FROM igs_uc_map_out_stat
159: WHERE system_code = x_system_code
160: AND decision_code = x_decision_code
161: AND adm_outcome_status = x_adm_outcome_status ;
162:

Line 198: FROM igs_uc_map_out_stat

194: -- smaddali modified this cursor to add the check that closed_ind = 'N' and removed rowid check
195: -- for bug 2624102
196: CURSOR cur_rowid IS
197: SELECT count(*)
198: FROM igs_uc_map_out_stat
199: WHERE system_code = x_system_code
200: AND adm_outcome_status = x_adm_outcome_status
201: AND NVL(closed_ind,'N') = 'N' ;
202:

Line 234: FROM igs_uc_map_out_stat

230: || (reverse chronological order - newest change first)
231: */
232: CURSOR cur_rowid IS
233: SELECT rowid
234: FROM igs_uc_map_out_stat
235: WHERE ((decision_code = x_decision_code) AND
236: (system_code = x_system_code));
237:
238: lv_rowid cur_rowid%RowType;

Line 270: FROM igs_uc_map_out_stat

266: || (reverse chronological order - newest change first)
267: */
268: CURSOR cur_rowid IS
269: SELECT rowid
270: FROM igs_uc_map_out_stat
271: WHERE ((adm_outcome_status = x_adm_outcome_status));
272:
273: lv_rowid cur_rowid%RowType;
274:

Line 442: INSERT INTO igs_uc_map_out_stat (

438: x_last_updated_by => x_last_updated_by,
439: x_last_update_login => x_last_update_login
440: );
441:
442: INSERT INTO igs_uc_map_out_stat (
443: system_code,
444: decision_code,
445: adm_outcome_status,
446: default_ind,

Line 495: FROM igs_uc_map_out_stat

491: CURSOR c1 IS
492: SELECT
493: default_ind,
494: closed_ind
495: FROM igs_uc_map_out_stat
496: WHERE rowid = x_rowid
497: FOR UPDATE NOWAIT;
498:
499: tlinfo c1%ROWTYPE;

Line 585: UPDATE igs_uc_map_out_stat

581: x_last_updated_by => x_last_updated_by,
582: x_last_update_login => x_last_update_login
583: );
584:
585: UPDATE igs_uc_map_out_stat
586: SET
587: default_ind = new_references.default_ind,
588: closed_ind = new_references.closed_ind,
589: last_update_date = x_last_update_date,

Line 626: FROM igs_uc_map_out_stat

622: || (reverse chronological order - newest change first)
623: */
624: CURSOR c1 IS
625: SELECT rowid
626: FROM igs_uc_map_out_stat
627: WHERE system_code = x_system_code
628: AND decision_code = x_decision_code
629: AND adm_outcome_status = x_adm_outcome_status;
630:

Line 683: DELETE FROM igs_uc_map_out_stat

679: p_action => 'DELETE',
680: x_rowid => x_rowid
681: );
682:
683: DELETE FROM igs_uc_map_out_stat
684: WHERE rowid = x_rowid;
685:
686: IF (SQL%NOTFOUND) THEN
687: RAISE NO_DATA_FOUND;

Line 693: END igs_uc_map_out_stat_pkg;

689:
690: END delete_row;
691:
692:
693: END igs_uc_map_out_stat_pkg;