APPS.IGI_IAC_CAL_PRICE_INDEXES_PKG dependencies on IGI_IAC_CAL_PRICE_INDEXES

Line 1: PACKAGE BODY igi_iac_cal_price_indexes_pkg AS

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

Line 5: old_references igi_iac_cal_price_indexes%ROWTYPE;

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

Line 6: new_references igi_iac_cal_price_indexes%ROWTYPE;

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

Line 36: FROM igi_iac_cal_price_indexes

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

Line 137: FROM igi_iac_cal_price_indexes

133: || (reverse chronological order - newest change first)
134: */
135: CURSOR cur_rowid IS
136: SELECT rowid
137: FROM igi_iac_cal_price_indexes
138: WHERE cal_price_index_link_id = x_cal_price_index_link_id
139: FOR UPDATE NOWAIT;
140:
141: lv_rowid cur_rowid%RowType;

Line 172: FROM igi_iac_cal_price_indexes

168: || (reverse chronological order - newest change first)
169: */
170: CURSOR cur_rowid IS
171: SELECT rowid
172: FROM igi_iac_cal_price_indexes
173: WHERE ((price_index_id = x_price_index_id));
174:
175: lv_rowid cur_rowid%RowType;
176:

Line 291: FROM igi_iac_cal_price_indexes

287: || (reverse chronological order - newest change first)
288: */
289: CURSOR c IS
290: SELECT rowid
291: FROM igi_iac_cal_price_indexes
292: WHERE cal_price_index_link_id = x_cal_price_index_link_id;
293:
294: x_last_update_date DATE;
295: x_last_updated_by NUMBER;

Line 318: SELECT igi_iac_cal_price_indexes_s.NEXTVAL

314: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
315: app_exception.raise_exception;
316: END IF;
317:
318: SELECT igi_iac_cal_price_indexes_s.NEXTVAL
319: INTO x_cal_price_index_link_id
320: FROM dual;
321:
322: before_dml(

Line 339: INSERT INTO igi_iac_cal_price_indexes (

335: x_last_updated_by => x_last_updated_by,
336: x_last_update_login => x_last_update_login
337: );
338:
339: INSERT INTO igi_iac_cal_price_indexes (
340: cal_price_index_link_id,
341: price_index_id,
342: calendar_type,
343: previous_rebase_period_name,

Line 405: FROM igi_iac_cal_price_indexes

401: previous_rebase_period_name,
402: previous_rebase_date,
403: previous_rebase_index_before,
404: previous_rebase_index_after
405: FROM igi_iac_cal_price_indexes
406: WHERE rowid = x_rowid
407: FOR UPDATE NOWAIT;
408:
409: tlinfo c1%ROWTYPE;

Line 503: UPDATE igi_iac_cal_price_indexes

499: x_last_updated_by => x_last_updated_by,
500: x_last_update_login => x_last_update_login
501: );
502:
503: UPDATE igi_iac_cal_price_indexes
504: SET
505: price_index_id = new_references.price_index_id,
506: calendar_type = new_references.calendar_type,
507: previous_rebase_period_name = new_references.previous_rebase_period_name,

Line 545: FROM igi_iac_cal_price_indexes

541: || (reverse chronological order - newest change first)
542: */
543: CURSOR c1 IS
544: SELECT rowid
545: FROM igi_iac_cal_price_indexes
546: WHERE cal_price_index_link_id = x_cal_price_index_link_id;
547:
548: BEGIN
549:

Line 604: DELETE FROM igi_iac_cal_price_indexes

600: p_action => 'DELETE',
601: x_rowid => x_rowid
602: );
603:
604: DELETE FROM igi_iac_cal_price_indexes
605: WHERE rowid = x_rowid;
606:
607: IF (SQL%NOTFOUND) THEN
608: RAISE NO_DATA_FOUND;

Line 614: END igi_iac_cal_price_indexes_pkg;

610:
611: END delete_row;
612:
613:
614: END igi_iac_cal_price_indexes_pkg;