APPS.IGI_IAC_CAL_IDX_VALUES_PKG dependencies on IGI_IAC_CAL_IDX_VALUES

Line 1: PACKAGE BODY igi_iac_cal_idx_values_pkg AS

1: PACKAGE BODY igi_iac_cal_idx_values_pkg AS
2: /* $Header: igiicpvb.pls 120.3.12000000.1 2007/08/01 16:20:47 npandya ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igi_iac_cal_idx_values%ROWTYPE;

Line 5: old_references igi_iac_cal_idx_values%ROWTYPE;

1: PACKAGE BODY igi_iac_cal_idx_values_pkg AS
2: /* $Header: igiicpvb.pls 120.3.12000000.1 2007/08/01 16:20:47 npandya ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igi_iac_cal_idx_values%ROWTYPE;
6: new_references igi_iac_cal_idx_values%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igi_iac_cal_idx_values%ROWTYPE;

2: /* $Header: igiicpvb.pls 120.3.12000000.1 2007/08/01 16:20:47 npandya ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igi_iac_cal_idx_values%ROWTYPE;
6: new_references igi_iac_cal_idx_values%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 34: FROM igi_iac_cal_idx_values

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

Line 116: FROM igi_iac_cal_idx_values

112: || (reverse chronological order - newest change first)
113: */
114: CURSOR cur_rowid IS
115: SELECT rowid
116: FROM igi_iac_cal_idx_values
117: WHERE cal_price_index_link_id = x_cal_price_index_link_id
118: AND date_from = x_date_from
119: AND date_to = x_date_to
120: FOR UPDATE NOWAIT;

Line 153: FROM igi_iac_cal_idx_values

149: || (reverse chronological order - newest change first)
150: */
151: CURSOR cur_rowid IS
152: SELECT rowid
153: FROM igi_iac_cal_idx_values
154: WHERE ((cal_price_index_link_id = x_cal_price_index_link_id));
155:
156: lv_rowid cur_rowid%RowType;
157:

Line 265: FROM igi_iac_cal_idx_values

261: || (reverse chronological order - newest change first)
262: */
263: CURSOR c IS
264: SELECT rowid
265: FROM igi_iac_cal_idx_values
266: WHERE cal_price_index_link_id = x_cal_price_index_link_id
267: AND date_from = x_date_from
268: AND date_to = x_date_to;
269:

Line 309: INSERT INTO igi_iac_cal_idx_values (

305: x_last_updated_by => x_last_updated_by,
306: x_last_update_login => x_last_update_login
307: );
308:
309: INSERT INTO igi_iac_cal_idx_values (
310: cal_price_index_link_id,
311: date_from,
312: date_to,
313: original_price_index_value,

Line 365: FROM igi_iac_cal_idx_values

361: CURSOR c1 IS
362: SELECT
363: original_price_index_value,
364: current_price_index_value
365: FROM igi_iac_cal_idx_values
366: WHERE rowid = x_rowid
367: FOR UPDATE NOWAIT;
368:
369: tlinfo c1%ROWTYPE;

Line 455: UPDATE igi_iac_cal_idx_values

451: x_last_updated_by => x_last_updated_by,
452: x_last_update_login => x_last_update_login
453: );
454:
455: UPDATE igi_iac_cal_idx_values
456: SET
457: original_price_index_value = new_references.original_price_index_value,
458: current_price_index_value = new_references.current_price_index_value,
459: last_update_date = x_last_update_date,

Line 491: FROM igi_iac_cal_idx_values

487: || (reverse chronological order - newest change first)
488: */
489: CURSOR c1 IS
490: SELECT rowid
491: FROM igi_iac_cal_idx_values
492: WHERE cal_price_index_link_id = x_cal_price_index_link_id
493: AND date_from = x_date_from
494: AND date_to = x_date_to;
495:

Line 548: DELETE FROM igi_iac_cal_idx_values

544: p_action => 'DELETE',
545: x_rowid => x_rowid
546: );
547:
548: DELETE FROM igi_iac_cal_idx_values
549: WHERE rowid = x_rowid;
550:
551: IF (SQL%NOTFOUND) THEN
552: RAISE NO_DATA_FOUND;

Line 558: END igi_iac_cal_idx_values_pkg;

554:
555: END delete_row;
556:
557:
558: END igi_iac_cal_idx_values_pkg;