APPS.IGF_AP_PR_PRG_TYPE_PKG dependencies on IGF_AP_PR_PRG_TYPE

Line 1: PACKAGE BODY igf_ap_pr_prg_type_pkg AS

1: PACKAGE BODY igf_ap_pr_prg_type_pkg AS
2: /* $Header: IGFAI75B.pls 115.2 2002/11/28 14:06:52 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_pr_prg_type%ROWTYPE;

Line 5: old_references igf_ap_pr_prg_type%ROWTYPE;

1: PACKAGE BODY igf_ap_pr_prg_type_pkg AS
2: /* $Header: IGFAI75B.pls 115.2 2002/11/28 14:06:52 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_pr_prg_type%ROWTYPE;
6: new_references igf_ap_pr_prg_type%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_ap_pr_prg_type%ROWTYPE;

2: /* $Header: IGFAI75B.pls 115.2 2002/11/28 14:06:52 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_ap_pr_prg_type%ROWTYPE;
6: new_references igf_ap_pr_prg_type%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 33: FROM igf_ap_pr_prg_type

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

Line 115: igf_ap_class_std_map_pkg.get_fk_igf_ap_pr_prg_type (

111: || (reverse chronological order - newest change first)
112: */
113: BEGIN
114:
115: igf_ap_class_std_map_pkg.get_fk_igf_ap_pr_prg_type (
116: old_references.ppt_id
117: );
118:
119: END check_child_existance;

Line 136: FROM igf_ap_pr_prg_type

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

Line 172: FROM igf_ap_pr_prg_type

168: || (reverse chronological order - newest change first)
169: */
170: CURSOR cur_rowid IS
171: SELECT rowid
172: FROM igf_ap_pr_prg_type
173: WHERE igs_pr_cs_schdl_id = x_igs_pr_cs_schdl_id
174: AND cal_type =x_caL_type
175: AND sequence_number=x_sequence_number
176: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 236: FROM igf_ap_pr_prg_type

232: || (reverse chronological order - newest change first)
233: */
234: CURSOR cur_rowid IS
235: SELECT rowid
236: FROM igf_ap_pr_prg_type
237: WHERE ((cal_type = x_cal_type) AND
238: (sequence_number = x_sequence_number));
239:
240: lv_rowid cur_rowid%RowType;

Line 391: INSERT INTO igf_ap_pr_prg_type (

387: x_last_updated_by => x_last_updated_by,
388: x_last_update_login => x_last_update_login
389: );
390:
391: INSERT INTO igf_ap_pr_prg_type (
392: ppt_id,
393: igs_pr_cs_schdl_id,
394: cal_type,
395: sequence_number,

Line 402: igf_ap_pr_prg_type_s.NEXTVAL,

398: last_update_date,
399: last_updated_by,
400: last_update_login
401: ) VALUES (
402: igf_ap_pr_prg_type_s.NEXTVAL,
403: new_references.igs_pr_cs_schdl_id,
404: new_references.cal_type,
405: new_references.sequence_number,
406: x_last_update_date,

Line 437: FROM igf_ap_pr_prg_type

433: SELECT
434: igs_pr_cs_schdl_id,
435: cal_type,
436: sequence_number
437: FROM igf_ap_pr_prg_type
438: WHERE rowid = x_rowid
439: FOR UPDATE NOWAIT;
440:
441: tlinfo c1%ROWTYPE;

Line 529: UPDATE igf_ap_pr_prg_type

525: x_last_updated_by => x_last_updated_by,
526: x_last_update_login => x_last_update_login
527: );
528:
529: UPDATE igf_ap_pr_prg_type
530: SET
531: igs_pr_cs_schdl_id = new_references.igs_pr_cs_schdl_id,
532: cal_type = new_references.cal_type,
533: sequence_number = new_references.sequence_number,

Line 565: FROM igf_ap_pr_prg_type

561: || (reverse chronological order - newest change first)
562: */
563: CURSOR c1 IS
564: SELECT rowid
565: FROM igf_ap_pr_prg_type
566: WHERE ppt_id = x_ppt_id;
567:
568: BEGIN
569:

Line 618: DELETE FROM igf_ap_pr_prg_type

614: p_action => 'DELETE',
615: x_rowid => x_rowid
616: );
617:
618: DELETE FROM igf_ap_pr_prg_type
619: WHERE rowid = x_rowid;
620:
621: IF (SQL%NOTFOUND) THEN
622: RAISE NO_DATA_FOUND;

Line 628: END igf_ap_pr_prg_type_pkg;

624:
625: END delete_row;
626:
627:
628: END igf_ap_pr_prg_type_pkg;