APPS.IGS_UC_APP_CHO_CNDS_PKG dependencies on IGS_UC_APP_CHO_CNDS

Line 1: PACKAGE BODY igs_uc_app_cho_cnds_pkg AS

1: PACKAGE BODY igs_uc_app_cho_cnds_pkg AS
2: /* $Header: IGSXI03B.pls 115.6 2003/02/28 07:44:20 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_cho_cnds%ROWTYPE;

Line 5: old_references igs_uc_app_cho_cnds%ROWTYPE;

1: PACKAGE BODY igs_uc_app_cho_cnds_pkg AS
2: /* $Header: IGSXI03B.pls 115.6 2003/02/28 07:44:20 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_cho_cnds%ROWTYPE;
6: new_references igs_uc_app_cho_cnds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_app_cho_cnds%ROWTYPE;

2: /* $Header: IGSXI03B.pls 115.6 2003/02/28 07:44:20 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_app_cho_cnds%ROWTYPE;
6: new_references igs_uc_app_cho_cnds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 36: FROM IGS_UC_APP_CHO_CNDS

32: */
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGS_UC_APP_CHO_CNDS
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 146: FROM igs_uc_app_cho_cnds

142: || (reverse chronological order - newest change first)
143: */
144: CURSOR cur_rowid IS
145: SELECT rowid
146: FROM igs_uc_app_cho_cnds
147: WHERE app_choice_cond_id = x_app_choice_cond_id ;
148:
149: lv_rowid cur_rowid%RowType;
150:

Line 182: FROM igs_uc_app_cho_cnds

178: || (reverse chronological order - newest change first)
179: */
180: CURSOR cur_rowid IS
181: SELECT rowid
182: FROM igs_uc_app_cho_cnds
183: WHERE app_no = x_app_no
184: AND choice_no = x_choice_no
185: AND condition_type = x_condition_type
186: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 221: FROM igs_uc_app_cho_cnds

217: || message was replaced with IGS_UC_UCAPCC_UCAPCH_FK.
218: */
219: CURSOR cur_rowid IS
220: SELECT rowid
221: FROM igs_uc_app_cho_cnds
222: WHERE ((app_choice_id = x_app_choice_id));
223:
224: lv_rowid cur_rowid%RowType;
225:

Line 343: FROM igs_uc_app_cho_cnds

339: || (reverse chronological order - newest change first)
340: */
341: CURSOR c IS
342: SELECT rowid
343: FROM igs_uc_app_cho_cnds
344: WHERE app_choice_cond_id = x_app_choice_cond_id;
345:
346: x_last_update_date DATE;
347: x_last_updated_by NUMBER;

Line 371: SELECT igs_uc_app_cho_cnds_s.NEXTVAL

367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: END IF;
370:
371: SELECT igs_uc_app_cho_cnds_s.NEXTVAL
372: INTO x_app_choice_cond_id
373: FROM dual;
374:
375: before_dml(

Line 392: INSERT INTO igs_uc_app_cho_cnds (

388: x_last_updated_by => x_last_updated_by,
389: x_last_update_login => x_last_update_login
390: );
391:
392: INSERT INTO igs_uc_app_cho_cnds (
393: app_choice_cond_id,
394: app_choice_id,
395: app_no,
396: choice_no,

Line 458: FROM igs_uc_app_cho_cnds

454: choice_no,
455: condition_type,
456: condition_desc,
457: satisfied
458: FROM igs_uc_app_cho_cnds
459: WHERE rowid = x_rowid
460: FOR UPDATE NOWAIT;
461:
462: tlinfo c1%ROWTYPE;

Line 559: UPDATE igs_uc_app_cho_cnds

555: x_last_updated_by => x_last_updated_by,
556: x_last_update_login => x_last_update_login
557: );
558:
559: UPDATE igs_uc_app_cho_cnds
560: SET
561: app_choice_id = new_references.app_choice_id,
562: app_no = new_references.app_no,
563: choice_no = new_references.choice_no,

Line 601: FROM igs_uc_app_cho_cnds

597: || (reverse chronological order - newest change first)
598: */
599: CURSOR c1 IS
600: SELECT rowid
601: FROM igs_uc_app_cho_cnds
602: WHERE app_choice_cond_id = x_app_choice_cond_id;
603:
604: BEGIN
605:

Line 660: DELETE FROM igs_uc_app_cho_cnds

656: p_action => 'DELETE',
657: x_rowid => x_rowid
658: );
659:
660: DELETE FROM igs_uc_app_cho_cnds
661: WHERE rowid = x_rowid;
662:
663: IF (SQL%NOTFOUND) THEN
664: RAISE NO_DATA_FOUND;

Line 670: END igs_uc_app_cho_cnds_pkg;

666:
667: END delete_row;
668:
669:
670: END igs_uc_app_cho_cnds_pkg;