APPS.IGI_EXP_DU_TYPE_DETAILS_PKG dependencies on IGI_EXP_DU_TYPE_DETAILS_ALL

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

Line 15: new_references igi_exp_du_type_details_all%ROWTYPE;

11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
12:
13: l_rowid VARCHAR2(25);
14: old_references igi_exp_du_type_details_all%ROWTYPE;
15: new_references igi_exp_du_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_DU_TYPE_DETAILS_ALL

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

Line 132: FROM igi_exp_du_type_details_all

128: || (reverse chronological order - newest change first)
129: */
130: CURSOR cur_rowid IS
131: SELECT rowid
132: FROM igi_exp_du_type_details_all
133: WHERE du_type_detail_id = x_du_type_detail_id
134: FOR UPDATE NOWAIT;
135:
136: lv_rowid cur_rowid%RowType;

Line 167: FROM igi_exp_du_type_details_all

163: || (reverse chronological order - newest change first)
164: */
165: CURSOR cur_rowid IS
166: SELECT rowid
167: FROM igi_exp_du_type_details_all
168: WHERE ((du_type_header_id = x_du_type_header_id));
169:
170: lv_rowid cur_rowid%RowType;
171:

Line 288: FROM igi_exp_du_type_details_all

284: || (reverse chronological order - newest change first)
285: */
286: CURSOR c IS
287: SELECT rowid
288: FROM igi_exp_du_type_details_all
289: WHERE du_type_detail_id = x_du_type_detail_id;
290:
291: x_last_update_date DATE;
292: x_last_updated_by NUMBER;

Line 339: INSERT INTO igi_exp_du_type_details_all (

335: x_last_updated_by => x_last_updated_by,
336: x_last_update_login => x_last_update_login
337: );
338:
339: INSERT INTO igi_exp_du_type_details_all (
340: du_type_detail_id,
341: du_type_header_id,
342: transaction_type,
343: org_id,

Line 393: FROM igi_exp_du_type_details_all

389: SELECT
390: du_type_header_id,
391: transaction_type,
392: org_id
393: FROM igi_exp_du_type_details_all
394: WHERE rowid = x_rowid
395: FOR UPDATE NOWAIT;
396:
397: tlinfo c1%ROWTYPE;

Line 499: UPDATE igi_exp_du_type_details_all

495: x_last_updated_by => x_last_updated_by,
496: x_last_update_login => x_last_update_login
497: );
498:
499: UPDATE igi_exp_du_type_details_all
500: SET
501: du_type_header_id = new_references.du_type_header_id,
502: transaction_type = new_references.transaction_type,
503: org_id = new_references.org_id,

Line 534: FROM igi_exp_du_type_details_all

530: || (reverse chronological order - newest change first)
531: */
532: CURSOR c1 IS
533: SELECT rowid
534: FROM igi_exp_du_type_details_all
535: WHERE du_type_detail_id = x_du_type_detail_id;
536:
537: BEGIN
538:

Line 587: DELETE FROM igi_exp_du_type_details_all

583: p_action => 'DELETE',
584: x_rowid => x_rowid
585: );
586:
587: DELETE FROM igi_exp_du_type_details_all
588: WHERE rowid = x_rowid;
589:
590: IF (SQL%NOTFOUND) THEN
591: RAISE NO_DATA_FOUND;