10: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
11:
12:
13: l_rowid VARCHAR2(25);
14: old_references igi_exp_ar_trans_all%ROWTYPE;
15: new_references igi_exp_ar_trans_all%ROWTYPE;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,
11:
12:
13: l_rowid VARCHAR2(25);
14: old_references igi_exp_ar_trans_all%ROWTYPE;
15: new_references igi_exp_ar_trans_all%ROWTYPE;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,
19: x_rowid IN VARCHAR2 ,
53: */
54:
55: CURSOR cur_old_ref_values IS
56: SELECT *
57: FROM IGI_EXP_AR_TRANS_ALL
58: WHERE rowid = x_rowid;
59:
60: BEGIN
61:
160: || (reverse chronological order - newest change first)
161: */
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM igi_exp_ar_trans_all
165: WHERE ar_tran_id = x_ar_tran_id
166: FOR UPDATE NOWAIT;
167:
168: lv_rowid cur_rowid%RowType;
195: || (reverse chronological order - newest change first)
196: */
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM igi_exp_ar_trans_all
200: WHERE ((du_id = x_du_id));
201:
202: lv_rowid cur_rowid%RowType;
203:
363: || (reverse chronological order - newest change first)
364: */
365: CURSOR c IS
366: SELECT rowid
367: FROM igi_exp_ar_trans_all
368: WHERE ar_tran_id = x_ar_tran_id;
369:
370: x_last_update_date DATE;
371: x_last_updated_by NUMBER;
430: x_last_updated_by => x_last_updated_by,
431: x_last_update_login => x_last_update_login
432: );
433:
434: INSERT INTO igi_exp_ar_trans_all (
435: ar_tran_id,
436: customer_trx_id,
437: du_id,
438: org_id,
548: attribute12,
549: attribute13,
550: attribute14,
551: attribute15
552: FROM igi_exp_ar_trans_all
553: WHERE rowid = x_rowid
554: FOR UPDATE NOWAIT;
555:
556: tlinfo c1%ROWTYPE;
702: x_last_updated_by => x_last_updated_by,
703: x_last_update_login => x_last_update_login
704: );
705:
706: UPDATE igi_exp_ar_trans_all
707: SET
708: customer_trx_id = new_references.customer_trx_id,
709: du_id = new_references.du_id,
710: org_id = new_references.org_id,
769: || (reverse chronological order - newest change first)
770: */
771: CURSOR c1 IS
772: SELECT rowid
773: FROM igi_exp_ar_trans_all
774: WHERE ar_tran_id = x_ar_tran_id;
775:
776: BEGIN
777:
854: p_action => 'DELETE',
855: x_rowid => x_rowid
856: );
857:
858: DELETE FROM igi_exp_ar_trans_all
859: WHERE rowid = x_rowid;
860:
861: IF (SQL%NOTFOUND) THEN
862: RAISE NO_DATA_FOUND;