APPS.IGS_PE_ACT_SITE_PKG dependencies on IGS_PE_ACT_SITE

Line 1: PACKAGE BODY igs_pe_act_site_pkg AS

1: PACKAGE BODY igs_pe_act_site_pkg AS
2: /* $Header: IGSNIA5B.pls 120.2 2006/02/17 06:55:23 gmaheswa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_act_site%ROWTYPE;

Line 5: old_references igs_pe_act_site%ROWTYPE;

1: PACKAGE BODY igs_pe_act_site_pkg AS
2: /* $Header: IGSNIA5B.pls 120.2 2006/02/17 06:55:23 gmaheswa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_act_site%ROWTYPE;
6: new_references igs_pe_act_site%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_act_site%ROWTYPE;

2: /* $Header: IGSNIA5B.pls 120.2 2006/02/17 06:55:23 gmaheswa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_act_site%ROWTYPE;
6: new_references igs_pe_act_site%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 36: FROM igs_pe_act_site

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

Line 133: FROM igs_pe_act_site

129: || (reverse chronological order - newest change first)
130: */
131: CURSOR cur_rowid IS
132: SELECT rowid
133: FROM igs_pe_act_site
134: WHERE person_id = x_person_id
135: AND activity_site_cd = x_activity_site_cd
136: AND start_date = x_start_date
137: FOR UPDATE NOWAIT;

Line 170: FROM igs_pe_act_site

166: || (reverse chronological order - newest change first)
167: */
168: CURSOR cur_rowid IS
169: SELECT rowid
170: FROM igs_pe_act_site
171: WHERE ((activity_site_cd = x_location_cd));
172:
173: lv_rowid cur_rowid%RowType;
174:

Line 335: INSERT INTO igs_pe_act_site (

331:
332: IF (x_mode = 'S') THEN
333: igs_sc_gen_001.set_ctx('R');
334: END IF;
335: INSERT INTO igs_pe_act_site (
336: person_id,
337: activity_site_cd,
338: location_id,
339: start_date,

Line 406: FROM igs_pe_act_site

402: SELECT
403: location_id,
404: end_date,
405: remarks
406: FROM igs_pe_act_site
407: WHERE rowid = x_rowid
408: FOR UPDATE NOWAIT;
409:
410: tlinfo c1%ROWTYPE;

Line 507: UPDATE igs_pe_act_site

503:
504: IF (x_mode = 'S') THEN
505: igs_sc_gen_001.set_ctx('R');
506: END IF;
507: UPDATE igs_pe_act_site
508: SET
509: location_id = new_references.location_id,
510: end_date = new_references.end_date,
511: last_update_date = x_last_update_date,

Line 567: FROM igs_pe_act_site

563: || (reverse chronological order - newest change first)
564: */
565: CURSOR c1 IS
566: SELECT rowid
567: FROM igs_pe_act_site
568: WHERE person_id = x_person_id
569: AND activity_site_cd = x_activity_site_cd
570: AND start_date = x_start_date
571: AND remarks = x_remarks;

Line 633: DELETE FROM igs_pe_act_site

629:
630: IF (x_mode = 'S') THEN
631: igs_sc_gen_001.set_ctx('R');
632: END IF;
633: DELETE FROM igs_pe_act_site
634: WHERE rowid = x_rowid;
635:
636: IF (SQL%NOTFOUND) THEN
637: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 650: END igs_pe_act_site_pkg;

646:
647: END delete_row;
648:
649:
650: END igs_pe_act_site_pkg;