APPS.IGI_EXP_TU_TYPE_HEADERS_PKG dependencies on IGI_EXP_TU_TYPE_HEADERS_ALL

Line 14: old_references igi_exp_tu_type_headers_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_headers_all%ROWTYPE;
15: new_references igi_exp_tu_type_headers_all%ROWTYPE;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,

Line 15: new_references igi_exp_tu_type_headers_all%ROWTYPE;

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

Line 45: FROM IGI_EXP_TU_TYPE_HEADERS_ALL

41: */
42:
43: CURSOR cur_old_ref_values IS
44: SELECT *
45: FROM IGI_EXP_TU_TYPE_HEADERS_ALL
46: WHERE rowid = x_rowid;
47:
48: BEGIN
49:

Line 159: FROM igi_exp_tu_type_headers_all

155: || (reverse chronological order - newest change first)
156: */
157: CURSOR cur_rowid IS
158: SELECT rowid
159: FROM igi_exp_tu_type_headers_all
160: WHERE tu_type_header_id = x_tu_type_header_id
161: FOR UPDATE NOWAIT;
162:
163: lv_rowid cur_rowid%RowType;

Line 194: FROM igi_exp_tu_type_headers_all

190: || (reverse chronological order - newest change first)
191: */
192: CURSOR cur_rowid IS
193: SELECT rowid
194: FROM igi_exp_tu_type_headers_all
195: WHERE ((apprv_profile_id = x_apprv_profile_id));
196:
197: lv_rowid cur_rowid%RowType;
198:

Line 332: FROM igi_exp_tu_type_headers_all

328: || (reverse chronological order - newest change first)
329: */
330: CURSOR c IS
331: SELECT rowid
332: FROM igi_exp_tu_type_headers_all
333: WHERE tu_type_header_id = x_tu_type_header_id;
334:
335: x_last_update_date DATE;
336: x_last_updated_by NUMBER;

Line 387: INSERT INTO igi_exp_tu_type_headers_all (

383: x_last_updated_by => x_last_updated_by,
384: x_last_update_login => x_last_update_login
385: );
386:
387: INSERT INTO igi_exp_tu_type_headers_all (
388: tu_type_header_id,
389: tu_type_name,
390: tu_type_desc,
391: apprv_profile_id,

Line 457: FROM igi_exp_tu_type_headers_all

453: allow_override,
454: start_date,
455: end_date,
456: org_id
457: FROM igi_exp_tu_type_headers_all
458: WHERE rowid = x_rowid
459: FOR UPDATE NOWAIT;
460:
461: tlinfo c1%ROWTYPE;

Line 575: UPDATE igi_exp_tu_type_headers_all

571: x_last_updated_by => x_last_updated_by,
572: x_last_update_login => x_last_update_login
573: );
574:
575: UPDATE igi_exp_tu_type_headers_all
576: SET
577: tu_type_name = new_references.tu_type_name,
578: tu_type_desc = new_references.tu_type_desc,
579: apprv_profile_id = new_references.apprv_profile_id,

Line 618: FROM igi_exp_tu_type_headers_all

614: || (reverse chronological order - newest change first)
615: */
616: CURSOR c1 IS
617: SELECT rowid
618: FROM igi_exp_tu_type_headers_all
619: WHERE tu_type_header_id = x_tu_type_header_id;
620:
621: BEGIN
622:

Line 679: DELETE FROM igi_exp_tu_type_headers_all

675: p_action => 'DELETE',
676: x_rowid => x_rowid
677: );
678:
679: DELETE FROM igi_exp_tu_type_headers_all
680: WHERE rowid = x_rowid;
681:
682: IF (SQL%NOTFOUND) THEN
683: RAISE NO_DATA_FOUND;