APPS.IGI_IAC_PRICE_INDEXES_PKG dependencies on IGI_IAC_PRICE_INDEXES

Line 1: PACKAGE BODY igi_iac_price_indexes_pkg AS

1: PACKAGE BODY igi_iac_price_indexes_pkg AS
2: /* $Header: igiiprib.pls 120.3.12000000.1 2007/08/01 16:22:29 npandya ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igi_iac_price_indexes%ROWTYPE;

Line 5: old_references igi_iac_price_indexes%ROWTYPE;

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

Line 6: new_references igi_iac_price_indexes%ROWTYPE;

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

Line 32: FROM igi_iac_price_indexes

28: */
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM igi_iac_price_indexes
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 83: igi_iac_cal_price_indexes_pkg.get_fk_igi_iac_price_indexes (

79: || (reverse chronological order - newest change first)
80: */
81: BEGIN
82:
83: igi_iac_cal_price_indexes_pkg.get_fk_igi_iac_price_indexes (
84: old_references.price_index_id
85: );
86:
87: END check_child_existance;

Line 104: FROM igi_iac_price_indexes

100: || (reverse chronological order - newest change first)
101: */
102: CURSOR cur_rowid IS
103: SELECT rowid
104: FROM igi_iac_price_indexes
105: WHERE price_index_id = x_price_index_id
106: FOR UPDATE NOWAIT;
107:
108: lv_rowid cur_rowid%RowType;

Line 208: FROM igi_iac_price_indexes

204: || (reverse chronological order - newest change first)
205: */
206: CURSOR c IS
207: SELECT rowid
208: FROM igi_iac_price_indexes
209: WHERE price_index_id = x_price_index_id;
210:
211: x_last_update_date DATE;
212: x_last_updated_by NUMBER;

Line 235: SELECT igi_iac_price_indexes_s.NEXTVAL

231: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
232: app_exception.raise_exception;
233: END IF;
234:
235: SELECT igi_iac_price_indexes_s.NEXTVAL
236: INTO x_price_index_id
237: FROM dual;
238:
239: before_dml(

Line 252: INSERT INTO igi_iac_price_indexes (

248: x_last_updated_by => x_last_updated_by,
249: x_last_update_login => x_last_update_login
250: );
251:
252: INSERT INTO igi_iac_price_indexes (
253: price_index_id,
254: price_index_name,
255: attribute_name,
256: creation_date,

Line 302: FROM igi_iac_price_indexes

298: CURSOR c1 IS
299: SELECT
300: price_index_name,
301: attribute_name
302: FROM igi_iac_price_indexes
303: WHERE rowid = x_rowid
304: FOR UPDATE NOWAIT;
305:
306: tlinfo c1%ROWTYPE;

Line 388: UPDATE igi_iac_price_indexes

384: x_last_updated_by => x_last_updated_by,
385: x_last_update_login => x_last_update_login
386: );
387:
388: UPDATE igi_iac_price_indexes
389: SET
390: price_index_name = new_references.price_index_name,
391: attribute_name = new_references.attribute_name,
392: last_update_date = x_last_update_date,

Line 422: FROM igi_iac_price_indexes

418: || (reverse chronological order - newest change first)
419: */
420: CURSOR c1 IS
421: SELECT rowid
422: FROM igi_iac_price_indexes
423: WHERE price_index_id = x_price_index_id;
424:
425: BEGIN
426:

Line 473: DELETE FROM igi_iac_price_indexes

469: p_action => 'DELETE',
470: x_rowid => x_rowid
471: );
472:
473: DELETE FROM igi_iac_price_indexes
474: WHERE rowid = x_rowid;
475:
476: IF (SQL%NOTFOUND) THEN
477: RAISE NO_DATA_FOUND;

Line 483: END igi_iac_price_indexes_pkg;

479:
480: END delete_row;
481:
482:
483: END igi_iac_price_indexes_pkg;