APPS.IGI_EXP_DU_TYPE_HEADERS_PKG dependencies on IGI_EXP_DU_TYPE_HEADERS_ALL

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

Line 15: new_references igi_exp_du_type_headers_all%ROWTYPE;

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

Line 46: FROM IGI_EXP_DU_TYPE_HEADERS_ALL

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

Line 135: FROM igi_exp_du_type_headers_all

131: || (reverse chronological order - newest change first)
132: */
133: CURSOR cur_rowid IS
134: SELECT rowid
135: FROM igi_exp_du_type_headers_all
136: WHERE du_type_header_id = x_du_type_header_id
137: FOR UPDATE NOWAIT;
138:
139: lv_rowid cur_rowid%RowType;

Line 267: FROM igi_exp_du_type_headers_all

263: || (reverse chronological order - newest change first)
264: */
265: CURSOR c IS
266: SELECT rowid
267: FROM igi_exp_du_type_headers_all
268: WHERE du_type_header_id = x_du_type_header_id;
269:
270: x_last_update_date DATE;
271: x_last_updated_by NUMBER;

Line 323: INSERT INTO igi_exp_du_type_headers_all (

319: x_last_updated_by => x_last_updated_by,
320: x_last_update_login => x_last_update_login
321: );
322:
323: INSERT INTO igi_exp_du_type_headers_all (
324: du_type_header_id,
325: du_type_name,
326: du_type_desc,
327: application_id,

Line 397: FROM igi_exp_du_type_headers_all

393: stp_site_only,
394: start_date,
395: end_date,
396: org_id
397: FROM igi_exp_du_type_headers_all
398: WHERE rowid = x_rowid
399: FOR UPDATE NOWAIT;
400:
401: tlinfo c1%ROWTYPE;

Line 518: UPDATE igi_exp_du_type_headers_all

514: x_last_updated_by => x_last_updated_by,
515: x_last_update_login => x_last_update_login
516: );
517:
518: UPDATE igi_exp_du_type_headers_all
519: SET
520: du_type_name = new_references.du_type_name,
521: du_type_desc = new_references.du_type_desc,
522: application_id = new_references.application_id,

Line 563: FROM igi_exp_du_type_headers_all

559: || (reverse chronological order - newest change first)
560: */
561: CURSOR c1 IS
562: SELECT rowid
563: FROM igi_exp_du_type_headers_all
564: WHERE du_type_header_id = x_du_type_header_id;
565:
566: BEGIN
567:

Line 626: DELETE FROM igi_exp_du_type_headers_all

622: p_action => 'DELETE',
623: x_rowid => x_rowid
624: );
625:
626: DELETE FROM igi_exp_du_type_headers_all
627: WHERE rowid = x_rowid;
628:
629: IF (SQL%NOTFOUND) THEN
630: RAISE NO_DATA_FOUND;