APPS.IGS_UC_OFFER_CONDS_PKG dependencies on IGS_UC_OFFER_CONDS

Line 1: PACKAGE BODY igs_uc_offer_conds_pkg AS

1: PACKAGE BODY igs_uc_offer_conds_pkg AS
2: /* $Header: IGSXI22B.pls 115.6 2003/11/02 18:00:53 ayedubat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_offer_conds%ROWTYPE;

Line 5: old_references igs_uc_offer_conds%ROWTYPE;

1: PACKAGE BODY igs_uc_offer_conds_pkg AS
2: /* $Header: IGSXI22B.pls 115.6 2003/11/02 18:00:53 ayedubat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_offer_conds%ROWTYPE;
6: new_references igs_uc_offer_conds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_offer_conds%ROWTYPE;

2: /* $Header: IGSXI22B.pls 115.6 2003/11/02 18:00:53 ayedubat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_offer_conds%ROWTYPE;
6: new_references igs_uc_offer_conds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 38: FROM IGS_UC_OFFER_CONDS

34: */
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM IGS_UC_OFFER_CONDS
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 96: igs_uc_app_choices_pkg.get_fk_igs_uc_offer_conds (

92: || (reverse chronological order - newest change first)
93: */
94: BEGIN
95:
96: igs_uc_app_choices_pkg.get_fk_igs_uc_offer_conds (
97: old_references.condition_category,
98: old_references.condition_name
99: );
100:

Line 101: igs_uc_cond_details_pkg.get_fk_igs_uc_offer_conds (

97: old_references.condition_category,
98: old_references.condition_name
99: );
100:
101: igs_uc_cond_details_pkg.get_fk_igs_uc_offer_conds (
102: old_references.condition_category,
103: old_references.condition_name
104: );
105:

Line 124: FROM igs_uc_offer_conds

120: || (reverse chronological order - newest change first)
121: */
122: CURSOR cur_rowid IS
123: SELECT rowid
124: FROM igs_uc_offer_conds
125: WHERE condition_category = x_condition_category
126: AND condition_name = x_condition_name ;
127:
128: lv_rowid cur_rowid%RowType;

Line 250: FROM igs_uc_offer_conds

246: || (reverse chronological order - newest change first)
247: */
248: CURSOR c IS
249: SELECT rowid
250: FROM igs_uc_offer_conds
251: WHERE condition_category = x_condition_category
252: AND condition_name = x_condition_name;
253:
254: x_last_update_date DATE;

Line 298: INSERT INTO igs_uc_offer_conds (

294: x_last_update_login => x_last_update_login ,
295: x_decision => x_decision
296: );
297:
298: INSERT INTO igs_uc_offer_conds (
299: condition_category,
300: condition_name,
301: effective_from,
302: effective_to,

Line 371: FROM igs_uc_offer_conds

367: marvin_code,
368: summ_of_cond,
369: letter_text,
370: decision
371: FROM igs_uc_offer_conds
372: WHERE rowid = x_rowid
373: FOR UPDATE NOWAIT;
374:
375: tlinfo c1%ROWTYPE;

Line 477: UPDATE igs_uc_offer_conds

473: x_last_update_login => x_last_update_login,
474: x_decision => x_decision
475: );
476:
477: UPDATE igs_uc_offer_conds
478: SET
479: effective_from = new_references.effective_from,
480: effective_to = new_references.effective_to,
481: status = new_references.status,

Line 522: FROM igs_uc_offer_conds

518: || (reverse chronological order - newest change first)
519: */
520: CURSOR c1 IS
521: SELECT rowid
522: FROM igs_uc_offer_conds
523: WHERE condition_category = x_condition_category
524: AND condition_name = x_condition_name;
525:
526: BEGIN

Line 586: DELETE FROM igs_uc_offer_conds

582: p_action => 'DELETE',
583: x_rowid => x_rowid
584: );
585:
586: DELETE FROM igs_uc_offer_conds
587: WHERE rowid = x_rowid;
588:
589: IF (SQL%NOTFOUND) THEN
590: RAISE NO_DATA_FOUND;

Line 596: END igs_uc_offer_conds_pkg;

592:
593: END delete_row;
594:
595:
596: END igs_uc_offer_conds_pkg;