APPS.IGI_EXP_NUM_SCHEMES_PKG dependencies on IGI_EXP_NUM_SCHEMES_ALL

Line 5: old_references igi_exp_num_schemes_all%ROWTYPE;

1: PACKAGE BODY igi_exp_num_schemes_pkg AS
2: /* $Header: igiexcb.pls 120.4.12000000.1 2007/09/13 04:24:05 mbremkum ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igi_exp_num_schemes_all%ROWTYPE;
6: new_references igi_exp_num_schemes_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igi_exp_num_schemes_all%ROWTYPE;

2: /* $Header: igiexcb.pls 120.4.12000000.1 2007/09/13 04:24:05 mbremkum ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igi_exp_num_schemes_all%ROWTYPE;
6: new_references igi_exp_num_schemes_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 37: FROM IGI_EXP_NUM_SCHEMES_ALL

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGI_EXP_NUM_SCHEMES_ALL
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 97: FROM igi_exp_num_schemes_all

93: || (reverse chronological order - newest change first)
94: */
95: CURSOR cur_rowid IS
96: SELECT rowid
97: FROM igi_exp_num_schemes_all
98: WHERE num_scheme_id = x_num_scheme_id
99: FOR UPDATE NOWAIT;
100:
101: lv_rowid cur_rowid%RowType;

Line 214: FROM igi_exp_num_schemes_all

210: || (reverse chronological order - newest change first)
211: */
212: CURSOR c IS
213: SELECT rowid
214: FROM igi_exp_num_schemes_all
215: WHERE num_scheme_id = x_num_scheme_id;
216:
217: x_last_update_date DATE;
218: x_last_updated_by NUMBER;

Line 265: INSERT INTO igi_exp_num_schemes_all (

261: x_last_updated_by => x_last_updated_by,
262: x_last_update_login => x_last_update_login
263: );
264:
265: INSERT INTO igi_exp_num_schemes_all (
266: num_scheme_id,
267: numbering_type,
268: numbering_class,
269: du_tu_type_id,

Line 339: FROM igi_exp_num_schemes_all

335: suffix,
336: fiscal_year,
337: next_seq_val,
338: org_id
339: FROM igi_exp_num_schemes_all
340: WHERE rowid = x_rowid
341: FOR UPDATE NOWAIT;
342:
343: tlinfo c1%ROWTYPE;

Line 445: UPDATE igi_exp_num_schemes_all

441: x_last_updated_by => x_last_updated_by,
442: x_last_update_login => x_last_update_login
443: );
444:
445: UPDATE igi_exp_num_schemes_all
446: SET
447: numbering_type = new_references.numbering_type,
448: numbering_class = new_references.numbering_class,
449: du_tu_type_id = new_references.du_tu_type_id,

Line 490: FROM igi_exp_num_schemes_all

486: || (reverse chronological order - newest change first)
487: */
488: CURSOR c1 IS
489: SELECT rowid
490: FROM igi_exp_num_schemes_all
491: WHERE num_scheme_id = x_num_scheme_id;
492:
493: BEGIN
494:

Line 553: DELETE FROM igi_exp_num_schemes_all

549: p_action => 'DELETE',
550: x_rowid => x_rowid
551: );
552:
553: DELETE FROM igi_exp_num_schemes_all
554: WHERE rowid = x_rowid;
555:
556: IF (SQL%NOTFOUND) THEN
557: RAISE NO_DATA_FOUND;