APPS.IGS_UC_SYS_DECISION_PKG dependencies on IGS_UC_SYS_DECISION

Line 1: PACKAGE BODY igs_uc_sys_decision_pkg AS

1: PACKAGE BODY igs_uc_sys_decision_pkg AS
2: /* $Header: IGSXI44B.pls 115.6 2003/12/07 15:32:48 pmarada noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_sys_decision%ROWTYPE;

Line 5: old_references igs_uc_sys_decision%ROWTYPE;

1: PACKAGE BODY igs_uc_sys_decision_pkg AS
2: /* $Header: IGSXI44B.pls 115.6 2003/12/07 15:32:48 pmarada noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_sys_decision%ROWTYPE;
6: new_references igs_uc_sys_decision%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_sys_decision%ROWTYPE;

2: /* $Header: IGSXI44B.pls 115.6 2003/12/07 15:32:48 pmarada noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_sys_decision%ROWTYPE;
6: new_references igs_uc_sys_decision%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 30: FROM igs_uc_sys_decision

26: */
27:
28: CURSOR cur_old_ref_values IS
29: SELECT *
30: FROM igs_uc_sys_decision
31: WHERE rowid = x_rowid;
32:
33: BEGIN
34:

Line 72: igs_uc_map_off_resp_pkg.get_fk_igs_uc_sys_decision (

68: || (reverse chronological order - newest change first)
69: */
70: BEGIN
71:
72: igs_uc_map_off_resp_pkg.get_fk_igs_uc_sys_decision (
73: old_references.system_code,
74: old_references.decision_code
75: );
76:

Line 77: igs_uc_map_out_stat_pkg.get_fk_igs_uc_sys_decision (

73: old_references.system_code,
74: old_references.decision_code
75: );
76:
77: igs_uc_map_out_stat_pkg.get_fk_igs_uc_sys_decision (
78: old_references.system_code,
79: old_references.decision_code
80: );
81:

Line 99: FROM igs_uc_sys_decision

95: || (reverse chronological order - newest change first)
96: */
97: CURSOR cur_rowid IS
98: SELECT rowid
99: FROM igs_uc_sys_decision
100: WHERE system_code = x_system_code
101: AND decision_code = x_decision_code ;
102:
103: lv_rowid cur_rowid%RowType;

Line 245: INSERT INTO igs_uc_sys_decision (

241: x_closed_ind => x_closed_ind ,
242: x_decision_type => x_decision_type
243: );
244:
245: INSERT INTO igs_uc_sys_decision (
246: system_code,
247: decision_code,
248: s_adm_outcome_status,
249: closed_ind ,

Line 284: FROM igs_uc_sys_decision

280: SELECT
281: s_adm_outcome_status,
282: closed_ind,
283: decision_type
284: FROM igs_uc_sys_decision
285: WHERE rowid = x_rowid
286: FOR UPDATE NOWAIT;
287:
288: tlinfo c1%ROWTYPE;

Line 373: UPDATE igs_uc_sys_decision

369: x_closed_ind => x_closed_ind,
370: x_decision_type => x_decision_type
371: );
372:
373: UPDATE igs_uc_sys_decision
374: SET
375: s_adm_outcome_status = new_references.s_adm_outcome_status,
376: closed_ind = new_references.closed_ind ,
377: decision_type = new_references.decision_type

Line 407: FROM igs_uc_sys_decision

403: || (reverse chronological order - newest change first)
404: */
405: CURSOR c1 IS
406: SELECT rowid
407: FROM igs_uc_sys_decision
408: WHERE system_code = x_system_code
409: AND decision_code = x_decision_code;
410:
411: BEGIN

Line 463: DELETE FROM igs_uc_sys_decision

459: p_action => 'DELETE',
460: x_rowid => x_rowid
461: );
462:
463: DELETE FROM igs_uc_sys_decision
464: WHERE rowid = x_rowid;
465:
466: IF (SQL%NOTFOUND) THEN
467: RAISE NO_DATA_FOUND;

Line 473: END igs_uc_sys_decision_pkg;

469:
470: END delete_row;
471:
472:
473: END igs_uc_sys_decision_pkg;