APPS.IGI_EXP_DUS_PKG dependencies on IGI_EXP_DUS_ALL

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

Line 15: new_references igi_exp_dus_all%ROWTYPE;

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

Line 70: FROM IGI_EXP_DUS_ALL

66: */
67:
68: CURSOR cur_old_ref_values IS
69: SELECT *
70: FROM IGI_EXP_DUS_ALL
71: WHERE rowid = x_rowid;
72:
73: BEGIN
74:

Line 240: FROM igi_exp_dus_all

236: || (reverse chronological order - newest change first)
237: */
238: CURSOR cur_rowid IS
239: SELECT rowid
240: FROM igi_exp_dus_all
241: WHERE du_id = x_du_id
242: FOR UPDATE NOWAIT;
243:
244: lv_rowid cur_rowid%RowType;

Line 275: FROM igi_exp_dus_all

271: || (reverse chronological order - newest change first)
272: */
273: CURSOR cur_rowid IS
274: SELECT rowid
275: FROM igi_exp_dus_all
276: WHERE ((du_type_header_id = x_du_type_header_id));
277:
278: lv_rowid cur_rowid%RowType;
279:

Line 315: FROM igi_exp_dus_all

311: || (reverse chronological order - newest change first)
312: */
313: CURSOR cur_rowid IS
314: SELECT rowid
315: FROM igi_exp_dus_all
316: WHERE ((tu_id = x_tu_id));
317:
318: lv_rowid cur_rowid%RowType;
319:

Line 355: FROM igi_exp_dus_all

351: || (reverse chronological order - newest change first)
352: */
353: CURSOR cur_rowid IS
354: SELECT rowid
355: FROM igi_exp_dus_all
356: WHERE ((du_stp_id = x_vendor_id));
357:
358: lv_rowid cur_rowid%RowType;
359:

Line 567: FROM igi_exp_dus_all

563: || (reverse chronological order - newest change first)
564: */
565: CURSOR c IS
566: SELECT rowid
567: FROM igi_exp_dus_all
568: WHERE du_id = x_du_id;
569:
570: x_last_update_date DATE;
571: x_last_updated_by NUMBER;

Line 647: INSERT INTO igi_exp_dus_all (

643: x_last_updated_by => x_last_updated_by,
644: x_last_update_login => x_last_update_login
645: );
646:
647: INSERT INTO igi_exp_dus_all (
648: du_id,
649: du_type_header_id,
650: du_order_number,
651: du_legal_number,

Line 817: FROM igi_exp_dus_all

813: attribute12,
814: attribute13,
815: attribute14,
816: attribute15
817: FROM igi_exp_dus_all
818: WHERE rowid = x_rowid
819: FOR UPDATE NOWAIT;
820:
821: tlinfo c1%ROWTYPE;

Line 1010: UPDATE igi_exp_dus_all

1006: x_last_updated_by => x_last_updated_by,
1007: x_last_update_login => x_last_update_login
1008: );
1009:
1010: UPDATE igi_exp_dus_all
1011: SET
1012: du_type_header_id = new_references.du_type_header_id,
1013: du_order_number = new_references.du_order_number,
1014: du_legal_number = new_references.du_legal_number,

Line 1103: FROM igi_exp_dus_all

1099: || (reverse chronological order - newest change first)
1100: */
1101: CURSOR c1 IS
1102: SELECT rowid
1103: FROM igi_exp_dus_all
1104: WHERE du_id = x_du_id;
1105:
1106: BEGIN
1107:

Line 1214: DELETE FROM igi_exp_dus_all

1210: p_action => 'DELETE',
1211: x_rowid => x_rowid
1212: );
1213:
1214: DELETE FROM igi_exp_dus_all
1215: WHERE rowid = x_rowid;
1216:
1217: IF (SQL%NOTFOUND) THEN
1218: RAISE NO_DATA_FOUND;