APPS.IGI_EXP_APPRV_PROFILES_PKG dependencies on IGI_EXP_APPRV_PROFILES_ALL

Line 5: old_references igi_exp_apprv_profiles_all%ROWTYPE;

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

Line 6: new_references igi_exp_apprv_profiles_all%ROWTYPE;

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

Line 35: FROM IGI_EXP_APPRV_PROFILES_ALL

31: */
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM IGI_EXP_APPRV_PROFILES_ALL
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 93: FROM igi_exp_apprv_profiles_all

89: || (reverse chronological order - newest change first)
90: */
91: CURSOR cur_rowid IS
92: SELECT rowid
93: FROM igi_exp_apprv_profiles_all
94: WHERE apprv_profile_id = x_apprv_profile_id
95: FOR UPDATE NOWAIT;
96:
97: lv_rowid cur_rowid%RowType;

Line 204: FROM igi_exp_apprv_profiles_all

200: || (reverse chronological order - newest change first)
201: */
202: CURSOR c IS
203: SELECT rowid
204: FROM igi_exp_apprv_profiles_all
205: WHERE apprv_profile_id = x_apprv_profile_id;
206:
207: x_last_update_date DATE;
208: x_last_updated_by NUMBER;

Line 253: INSERT INTO igi_exp_apprv_profiles_all (

249: x_last_updated_by => x_last_updated_by,
250: x_last_update_login => x_last_update_login
251: );
252:
253: INSERT INTO igi_exp_apprv_profiles_all (
254: apprv_profile_id,
255: apprv_profile_name,
256: profile_enabled,
257: pos_hierarchy_id,

Line 319: FROM igi_exp_apprv_profiles_all

315: pos_hierarchy_id,
316: final_apprv_pos_id,
317: legal_num_pos_id,
318: org_id
319: FROM igi_exp_apprv_profiles_all
320: WHERE rowid = x_rowid
321: FOR UPDATE NOWAIT;
322:
323: tlinfo c1%ROWTYPE;

Line 419: UPDATE igi_exp_apprv_profiles_all

415: x_last_updated_by => x_last_updated_by,
416: x_last_update_login => x_last_update_login
417: );
418:
419: UPDATE igi_exp_apprv_profiles_all
420: SET
421: apprv_profile_name = new_references.apprv_profile_name,
422: profile_enabled = new_references.profile_enabled,
423: pos_hierarchy_id = new_references.pos_hierarchy_id,

Line 460: FROM igi_exp_apprv_profiles_all

456: || (reverse chronological order - newest change first)
457: */
458: CURSOR c1 IS
459: SELECT rowid
460: FROM igi_exp_apprv_profiles_all
461: WHERE apprv_profile_id = x_apprv_profile_id;
462:
463: BEGIN
464:

Line 519: DELETE FROM igi_exp_apprv_profiles_all

515: p_action => 'DELETE',
516: x_rowid => x_rowid
517: );
518:
519: DELETE FROM igi_exp_apprv_profiles_all
520: WHERE rowid = x_rowid;
521:
522: IF (SQL%NOTFOUND) THEN
523: RAISE NO_DATA_FOUND;