APPS.IGF_AP_CLASS_STD_MAP_PKG dependencies on IGF_AP_CLASS_STD_MAP

Line 1: PACKAGE BODY igf_ap_class_std_map_pkg AS

1: PACKAGE BODY igf_ap_class_std_map_pkg AS
2: /* $Header: IGFAI45B.pls 115.4 2002/11/28 14:02:19 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_class_std_map%ROWTYPE;

Line 5: old_references igf_ap_class_std_map%ROWTYPE;

1: PACKAGE BODY igf_ap_class_std_map_pkg AS
2: /* $Header: IGFAI45B.pls 115.4 2002/11/28 14:02:19 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_class_std_map%ROWTYPE;
6: new_references igf_ap_class_std_map%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_ap_class_std_map%ROWTYPE;

2: /* $Header: IGFAI45B.pls 115.4 2002/11/28 14:02:19 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_class_std_map%ROWTYPE;
6: new_references igf_ap_class_std_map%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 35: FROM IGF_AP_CLASS_STD_MAP

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

Line 117: FROM igf_ap_class_std_map

113: || (reverse chronological order - newest change first)
114: */
115: CURSOR cur_rowid IS
116: SELECT rowid
117: FROM igf_ap_class_std_map
118: WHERE ipcs_id = x_ipcs_id
119: FOR UPDATE NOWAIT;
120:
121: lv_rowid cur_rowid%RowType;

Line 152: FROM igf_ap_class_std_map

148: || (reverse chronological order - newest change first)
149: */
150: CURSOR cur_rowid IS
151: SELECT rowid
152: FROM igf_ap_class_std_map
153: WHERE igs_pr_css_class_std_id = x_igs_pr_css_class_std_id
154: AND ppt_id=x_ppt_id
155: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
156:

Line 213: FROM igf_ap_class_std_map

209: || (reverse chronological order - newest change first)
210: */
211: CURSOR cur_rowid IS
212: SELECT rowid
213: FROM igf_ap_class_std_map
214: WHERE ((igs_pr_css_class_std_id = x_igs_pr_css_class_std_id));
215:
216: lv_rowid cur_rowid%RowType;
217:

Line 247: FROM igf_ap_class_std_map

243: || (reverse chronological order - newest change first)
244: */
245: CURSOR cur_rowid IS
246: SELECT rowid
247: FROM igf_ap_class_std_map
248: WHERE ((ppt_id= x_ppt_id));
249:
250: lv_rowid cur_rowid%RowType;
251:

Line 364: FROM igf_ap_class_std_map

360: || (reverse chronological order - newest change first)
361: */
362: CURSOR c IS
363: SELECT rowid
364: FROM igf_ap_class_std_map
365: WHERE ipcs_id = x_ipcs_id;
366:
367: x_last_update_date DATE;
368: x_last_updated_by NUMBER;

Line 392: SELECT igf_ap_class_std_map_s.NEXTVAL

388: igs_ge_msg_stack.add;
389: app_exception.raise_exception;
390: END IF;
391:
392: SELECT igf_ap_class_std_map_s.NEXTVAL
393: INTO x_ipcs_id
394: FROM dual;
395:
396: before_dml(

Line 412: INSERT INTO igf_ap_class_std_map (

408: x_last_updated_by => x_last_updated_by,
409: x_last_update_login => x_last_update_login
410: );
411:
412: INSERT INTO igf_ap_class_std_map (
413: ipcs_id,
414: igs_pr_css_class_std_id,
415: ap_std_code,
416: dl_std_code,

Line 475: FROM igf_ap_class_std_map

471: ap_std_code,
472: dl_std_code,
473: cl_std_code,
474: ppt_id
475: FROM igf_ap_class_std_map
476: WHERE rowid = x_rowid
477: FOR UPDATE NOWAIT;
478:
479: tlinfo c1%ROWTYPE;

Line 573: UPDATE igf_ap_class_std_map

569: x_last_updated_by => x_last_updated_by,
570: x_last_update_login => x_last_update_login
571: );
572:
573: UPDATE igf_ap_class_std_map
574: SET
575: igs_pr_css_class_std_id = new_references.igs_pr_css_class_std_id,
576: ap_std_code = new_references.ap_std_code,
577: dl_std_code = new_references.dl_std_code,

Line 613: FROM igf_ap_class_std_map

609: || (reverse chronological order - newest change first)
610: */
611: CURSOR c1 IS
612: SELECT rowid
613: FROM igf_ap_class_std_map
614: WHERE ipcs_id = x_ipcs_id;
615:
616: BEGIN
617:

Line 670: DELETE FROM igf_ap_class_std_map

666: p_action => 'DELETE',
667: x_rowid => x_rowid
668: );
669:
670: DELETE FROM igf_ap_class_std_map
671: WHERE rowid = x_rowid;
672:
673: IF (SQL%NOTFOUND) THEN
674: RAISE NO_DATA_FOUND;

Line 680: END igf_ap_class_std_map_pkg;

676:
677: END delete_row;
678:
679:
680: END igf_ap_class_std_map_pkg;