APPS.IGI_EXP_TU_TYPE_DETAILS_PKG dependencies on IGI_EXP_TU_TYPE_DETAILS_ALL

Line 14: old_references igi_exp_tu_type_details_all%ROWTYPE;

10: l_error_level number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
12:
13: l_rowid VARCHAR2(25);
14: old_references igi_exp_tu_type_details_all%ROWTYPE;
15: new_references igi_exp_tu_type_details_all%ROWTYPE;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,

Line 15: new_references igi_exp_tu_type_details_all%ROWTYPE;

11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
12:
13: l_rowid VARCHAR2(25);
14: old_references igi_exp_tu_type_details_all%ROWTYPE;
15: new_references igi_exp_tu_type_details_all%ROWTYPE;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,
19: x_rowid IN VARCHAR2 ,

Line 41: FROM IGI_EXP_TU_TYPE_DETAILS_ALL

37: */
38:
39: CURSOR cur_old_ref_values IS
40: SELECT *
41: FROM IGI_EXP_TU_TYPE_DETAILS_ALL
42: WHERE rowid = x_rowid;
43:
44: BEGIN
45:

Line 148: FROM igi_exp_tu_type_details_all

144: || (reverse chronological order - newest change first)
145: */
146: CURSOR cur_rowid IS
147: SELECT rowid
148: FROM igi_exp_tu_type_details_all
149: WHERE tu_type_detail_id = x_tu_type_detail_id
150: FOR UPDATE NOWAIT;
151:
152: lv_rowid cur_rowid%RowType;

Line 183: FROM igi_exp_tu_type_details_all

179: || (reverse chronological order - newest change first)
180: */
181: CURSOR cur_rowid IS
182: SELECT rowid
183: FROM igi_exp_tu_type_details_all
184: WHERE ((du_type_header_id = x_du_type_header_id));
185:
186: lv_rowid cur_rowid%RowType;
187:

Line 223: FROM igi_exp_tu_type_details_all

219: || (reverse chronological order - newest change first)
220: */
221: CURSOR cur_rowid IS
222: SELECT rowid
223: FROM igi_exp_tu_type_details_all
224: WHERE ((tu_type_header_id = x_tu_type_header_id));
225:
226: lv_rowid cur_rowid%RowType;
227:

Line 344: FROM igi_exp_tu_type_details_all

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

Line 395: INSERT INTO igi_exp_tu_type_details_all (

391: x_last_updated_by => x_last_updated_by,
392: x_last_update_login => x_last_update_login
393: );
394:
395: INSERT INTO igi_exp_tu_type_details_all (
396: tu_type_detail_id,
397: tu_type_header_id,
398: du_type_header_id,
399: org_id,

Line 449: FROM igi_exp_tu_type_details_all

445: SELECT
446: tu_type_header_id,
447: du_type_header_id,
448: org_id
449: FROM igi_exp_tu_type_details_all
450: WHERE rowid = x_rowid
451: FOR UPDATE NOWAIT;
452:
453: tlinfo c1%ROWTYPE;

Line 555: UPDATE igi_exp_tu_type_details_all

551: x_last_updated_by => x_last_updated_by,
552: x_last_update_login => x_last_update_login
553: );
554:
555: UPDATE igi_exp_tu_type_details_all
556: SET
557: tu_type_header_id = new_references.tu_type_header_id,
558: du_type_header_id = new_references.du_type_header_id,
559: org_id = new_references.org_id,

Line 590: FROM igi_exp_tu_type_details_all

586: || (reverse chronological order - newest change first)
587: */
588: CURSOR c1 IS
589: SELECT rowid
590: FROM igi_exp_tu_type_details_all
591: WHERE tu_type_detail_id = x_tu_type_detail_id;
592:
593: BEGIN
594:

Line 643: DELETE FROM igi_exp_tu_type_details_all

639: p_action => 'DELETE',
640: x_rowid => x_rowid
641: );
642:
643: DELETE FROM igi_exp_tu_type_details_all
644: WHERE rowid = x_rowid;
645:
646: IF (SQL%NOTFOUND) THEN
647: RAISE NO_DATA_FOUND;