APPS.IGS_AD_HZ_EXTRACURR_ACT_PKG dependencies on IGS_AD_HZ_EXTRACURR_ACT

Line 1: PACKAGE BODY igs_ad_hz_extracurr_act_pkg AS

1: PACKAGE BODY igs_ad_hz_extracurr_act_pkg AS
2: /* $Header: IGSAIB9B.pls 120.1 2005/06/28 04:33:16 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_hz_extracurr_act%ROWTYPE;

Line 5: old_references igs_ad_hz_extracurr_act%ROWTYPE;

1: PACKAGE BODY igs_ad_hz_extracurr_act_pkg AS
2: /* $Header: IGSAIB9B.pls 120.1 2005/06/28 04:33:16 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_hz_extracurr_act%ROWTYPE;
6: new_references igs_ad_hz_extracurr_act%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_ad_hz_extracurr_act%ROWTYPE;

2: /* $Header: IGSAIB9B.pls 120.1 2005/06/28 04:33:16 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_ad_hz_extracurr_act%ROWTYPE;
6: new_references igs_ad_hz_extracurr_act%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_AD_HZ_EXTRACURR_ACT

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

Line 138: FROM igs_ad_hz_extracurr_act

134: || (reverse chronological order - newest change first)
135: */
136: CURSOR cur_rowid IS
137: SELECT ROWID
138: FROM igs_ad_hz_extracurr_act
139: WHERE hz_extracurr_act_id = x_hz_extracurr_act_id
140: FOR UPDATE NOWAIT;
141:
142: lv_rowid cur_rowid%ROWTYPE;

Line 172: FROM igs_ad_hz_extracurr_act

168: || (reverse chronological order - newest change first)
169: */
170: CURSOR cur_rowid IS
171: SELECT ROWID
172: FROM igs_ad_hz_extracurr_act
173: WHERE ((person_interest_id = x_person_interest_id ));
174:
175: lv_rowid cur_rowid%ROWTYPE;
176:

Line 293: FROM igs_ad_hz_extracurr_act

289: || (reverse chronological order - newest change first)
290: */
291: CURSOR c IS
292: SELECT ROWID
293: FROM igs_ad_hz_extracurr_act
294: WHERE hz_extracurr_act_id = x_hz_extracurr_act_id;
295:
296: x_last_update_date DATE;
297: x_last_updated_by NUMBER;

Line 356: INSERT INTO igs_ad_hz_extracurr_act (

352:
353: IF (x_mode = 'S') THEN
354: igs_sc_gen_001.set_ctx('R');
355: END IF;
356: INSERT INTO igs_ad_hz_extracurr_act (
357: hz_extracurr_act_id,
358: person_interest_id,
359: end_date,
360: hours_per_week,

Line 373: IGS_AD_HZ_EXTRACURR_ACT_S.NEXTVAL,

369: program_application_id,
370: program_update_date,
371: program_id
372: ) VALUES (
373: IGS_AD_HZ_EXTRACURR_ACT_S.NEXTVAL,
374: new_references.person_interest_id,
375: new_references.end_date,
376: new_references.hours_per_week,
377: new_references.weeks_per_year,

Line 444: FROM igs_ad_hz_extracurr_act

440: end_date,
441: hours_per_week,
442: weeks_per_year,
443: activity_source_cd
444: FROM igs_ad_hz_extracurr_act
445: WHERE ROWID = x_rowid
446: FOR UPDATE NOWAIT;
447:
448: tlinfo c1%ROWTYPE;

Line 565: UPDATE igs_ad_hz_extracurr_act

561:
562: IF (x_mode = 'S') THEN
563: igs_sc_gen_001.set_ctx('R');
564: END IF;
565: UPDATE igs_ad_hz_extracurr_act
566: SET
567: hz_extracurr_act_id = new_references.hz_extracurr_act_id,
568: person_interest_id = new_references.person_interest_id,
569: end_date = new_references.end_date,

Line 630: FROM igs_ad_hz_extracurr_act

626: || (reverse chronological order - newest change first)
627: */
628: CURSOR c1 IS
629: SELECT ROWID
630: FROM igs_ad_hz_extracurr_act
631: WHERE hz_extracurr_act_id = x_hz_extracurr_act_id;
632:
633: BEGIN
634:

Line 691: DELETE FROM igs_ad_hz_extracurr_act

687:
688: IF (x_mode = 'S') THEN
689: igs_sc_gen_001.set_ctx('R');
690: END IF;
691: DELETE FROM igs_ad_hz_extracurr_act
692: WHERE ROWID = x_rowid;
693:
694: IF (SQL%NOTFOUND) THEN
695: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 764: END igs_ad_hz_extracurr_act_pkg;

760:
761: END Check_Constraints;
762:
763:
764: END igs_ad_hz_extracurr_act_pkg;