APPS.IGF_AW_CAREER_MAP_PKG dependencies on IGF_AW_CAREER_MAP_ALL

Line 5: old_references igf_aw_career_map_all%ROWTYPE;

1: PACKAGE BODY igf_aw_career_map_pkg AS
2: /* $Header: IGFWI46B.pls 115.4 2002/11/28 12:17:14 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_career_map_all%ROWTYPE;
6: new_references igf_aw_career_map_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_career_map_all%ROWTYPE;

2: /* $Header: IGFWI46B.pls 115.4 2002/11/28 12:17:14 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_career_map_all%ROWTYPE;
6: new_references igf_aw_career_map_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM igf_aw_career_map_all

28: */
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM igf_aw_career_map_all
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 137: FROM igf_aw_career_map_all

133: || (reverse chronological order - newest change first)
134: */
135: CURSOR cur_rowid IS
136: SELECT rowid
137: FROM igf_aw_career_map_all
138: WHERE career_level_id = x_career_level_id
139: FOR UPDATE NOWAIT;
140:
141: lv_rowid cur_rowid%RowType;

Line 173: FROM igf_aw_career_map_all

169: || (reverse chronological order - newest change first)
170: */
171: CURSOR cur_rowid IS
172: SELECT rowid
173: FROM igf_aw_career_map_all
174: WHERE program_type = x_program_type
175: AND class_standing = x_class_standing
176: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
177:

Line 209: FROM igf_aw_career_map_all

205: || (reverse chronological order - newest change first)
206: */
207: CURSOR cur_rowid IS
208: SELECT rowid
209: FROM igf_aw_career_map_all
210: WHERE ((program_type = x_course_type));
211:
212: lv_rowid cur_rowid%RowType;
213:

Line 319: FROM igf_aw_career_map_all

315: || (reverse chronological order - newest change first)
316: */
317: CURSOR c IS
318: SELECT rowid
319: FROM igf_aw_career_map_all
320: WHERE career_level_id = x_career_level_id;
321:
322: x_last_update_date DATE;
323: x_last_updated_by NUMBER;

Line 366: INSERT INTO igf_aw_career_map_all (

362: x_last_updated_by => x_last_updated_by,
363: x_last_update_login => x_last_update_login
364: );
365:
366: INSERT INTO igf_aw_career_map_all (
367: career_level_id,
368: program_type,
369: class_standing,
370: org_id,

Line 418: FROM igf_aw_career_map_all

414: CURSOR c1 IS
415: SELECT
416: program_type,
417: class_standing
418: FROM igf_aw_career_map_all
419: WHERE rowid = x_rowid
420: FOR UPDATE NOWAIT;
421:
422: tlinfo c1%ROWTYPE;

Line 507: UPDATE igf_aw_career_map_all

503: x_last_updated_by => x_last_updated_by,
504: x_last_update_login => x_last_update_login
505: );
506:
507: UPDATE igf_aw_career_map_all
508: SET
509: program_type = new_references.program_type,
510: class_standing = new_references.class_standing,
511: last_update_date = x_last_update_date,

Line 541: FROM igf_aw_career_map_all

537: || (reverse chronological order - newest change first)
538: */
539: CURSOR c1 IS
540: SELECT rowid
541: FROM igf_aw_career_map_all
542: WHERE career_level_id = x_career_level_id;
543:
544: BEGIN
545:

Line 592: DELETE FROM igf_aw_career_map_all

588: p_action => 'DELETE',
589: x_rowid => x_rowid
590: );
591:
592: DELETE FROM igf_aw_career_map_all
593: WHERE rowid = x_rowid;
594:
595: IF (SQL%NOTFOUND) THEN
596: RAISE NO_DATA_FOUND;