APPS.IGI_EXP_TUS_PKG dependencies on IGI_EXP_TUS_ALL

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

Line 15: new_references igi_exp_tus_all%ROWTYPE;

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

Line 66: FROM igi_exp_tus_all

62: */
63:
64: CURSOR cur_old_ref_values IS
65: SELECT *
66: FROM igi_exp_tus_all
67: WHERE rowid = x_rowid;
68:
69: BEGIN
70:

Line 213: FROM igi_exp_tus_all

209: || (reverse chronological order - newest change first)
210: */
211: CURSOR cur_rowid IS
212: SELECT rowid
213: FROM igi_exp_tus_all
214: WHERE tu_id = x_tu_id
215: FOR UPDATE NOWAIT;
216:
217: lv_rowid cur_rowid%RowType;

Line 248: FROM igi_exp_tus_all

244: || (reverse chronological order - newest change first)
245: */
246: CURSOR cur_rowid IS
247: SELECT rowid
248: FROM igi_exp_tus_all
249: WHERE ((apprv_profile_id = x_apprv_profile_id));
250:
251: lv_rowid cur_rowid%RowType;
252:

Line 287: FROM igi_exp_tus_all

283: || (reverse chronological order - newest change first)
284: */
285: CURSOR cur_rowid IS
286: SELECT rowid
287: FROM igi_exp_tus_all
288: WHERE ((tu_type_header_id = x_tu_type_header_id));
289:
290: lv_rowid cur_rowid%RowType;
291:

Line 481: FROM igi_exp_tus_all

477: || (reverse chronological order - newest change first)
478: */
479: CURSOR c IS
480: SELECT rowid
481: FROM igi_exp_tus_all
482: WHERE tu_id = x_tu_id;
483:
484: x_last_update_date DATE;
485: x_last_updated_by NUMBER;

Line 558: INSERT INTO igi_exp_tus_all (

554: x_last_updated_by => x_last_updated_by,
555: x_last_update_login => x_last_update_login
556: );
557:
558: INSERT INTO igi_exp_tus_all (
559: tu_id,
560: tu_type_header_id,
561: tu_order_number,
562: tu_legal_number,

Line 714: FROM igi_exp_tus_all

710: attribute12,
711: attribute13,
712: attribute14,
713: attribute15
714: FROM igi_exp_tus_all
715: WHERE rowid = x_rowid
716: FOR UPDATE NOWAIT;
717:
718: tlinfo c1%ROWTYPE;

Line 892: UPDATE igi_exp_tus_all

888: x_last_updated_by => x_last_updated_by,
889: x_last_update_login => x_last_update_login
890: );
891:
892: UPDATE igi_exp_tus_all
893: SET
894: tu_type_header_id = new_references.tu_type_header_id,
895: tu_order_number = new_references.tu_order_number,
896: tu_legal_number = new_references.tu_legal_number,

Line 978: FROM igi_exp_tus_all

974: || (reverse chronological order - newest change first)
975: */
976: CURSOR c1 IS
977: SELECT rowid
978: FROM igi_exp_tus_all
979: WHERE tu_id = x_tu_id;
980:
981: BEGIN
982:

Line 1083: DELETE FROM igi_exp_tus_all

1079: p_action => 'DELETE',
1080: x_rowid => x_rowid
1081: );
1082:
1083: DELETE FROM igi_exp_tus_all
1084: WHERE rowid = x_rowid;
1085:
1086: IF (SQL%NOTFOUND) THEN
1087: RAISE NO_DATA_FOUND;