APPS.IGS_PE_EV_FORM_STAT_PKG dependencies on IGS_PE_EV_FORM_STAT

Line 1: PACKAGE BODY igs_pe_ev_form_stat_pkg AS

1: PACKAGE BODY igs_pe_ev_form_stat_pkg AS
2: /* $Header: IGSNIA6B.pls 120.2 2006/02/17 06:57:13 gmaheswa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_ev_form_stat%ROWTYPE;

Line 5: old_references igs_pe_ev_form_stat%ROWTYPE;

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

Line 6: new_references igs_pe_ev_form_stat%ROWTYPE;

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

Line 38: FROM igs_pe_ev_form_stat

34: */
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM igs_pe_ev_form_stat
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 268: FROM igs_pe_ev_form_stat

264: || (reverse chronological order - newest change first)
265: */
266: CURSOR cur_rowid IS
267: SELECT rowid
268: FROM igs_pe_ev_form_stat
269: WHERE ev_form_stat_id = x_ev_form_stat_id
270: FOR UPDATE NOWAIT;
271:
272: lv_rowid cur_rowid%RowType;

Line 305: FROM igs_pe_ev_form_stat

301: || (reverse chronological order - newest change first)
302: */
303: CURSOR cur_rowid IS
304: SELECT rowid
305: FROM igs_pe_ev_form_stat
306: WHERE ev_form_id = x_ev_form_id
307: AND action_date = x_action_date
308: AND action_type = x_action_type
309: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 342: FROM igs_pe_ev_form_stat

338: || (reverse chronological order - newest change first)
339: */
340: CURSOR cur_rowid IS
341: SELECT rowid
342: FROM igs_pe_ev_form_stat
343: WHERE ((ev_form_id = x_ev_form_id));
344:
345: lv_rowid cur_rowid%RowType;
346:

Line 516: INSERT INTO igs_pe_ev_form_stat (

512:
513: IF (x_mode = 'S') THEN
514: igs_sc_gen_001.set_ctx('R');
515: END IF;
516: INSERT INTO igs_pe_ev_form_stat (
517: ev_form_stat_id,
518: ev_form_id,
519: action_date,
520: action_type,

Line 532: igs_pe_ev_form_stat_s.NEXTVAL,

528: last_update_date,
529: last_updated_by,
530: last_update_login
531: ) VALUES (
532: igs_pe_ev_form_stat_s.NEXTVAL,
533: new_references.ev_form_id,
534: new_references.action_date,
535: new_references.action_type,
536: new_references.prgm_start_date,

Line 601: FROM igs_pe_ev_form_stat

597: prgm_end_date,
598: remarks,
599: termination_reason,
600: end_program_reason
601: FROM igs_pe_ev_form_stat
602: WHERE rowid = x_rowid
603: FOR UPDATE NOWAIT;
604:
605: tlinfo c1%ROWTYPE;

Line 711: UPDATE igs_pe_ev_form_stat

707:
708: IF (x_mode = 'S') THEN
709: igs_sc_gen_001.set_ctx('R');
710: END IF;
711: UPDATE igs_pe_ev_form_stat
712: SET
713: ev_form_id = new_references.ev_form_id,
714: action_date = new_references.action_date,
715: action_type = new_references.action_type,

Line 777: FROM igs_pe_ev_form_stat

773: || (reverse chronological order - newest change first)
774: */
775: CURSOR c1 IS
776: SELECT rowid
777: FROM igs_pe_ev_form_stat
778: WHERE ev_form_stat_id = x_ev_form_stat_id;
779:
780: BEGIN
781:

Line 844: DELETE FROM igs_pe_ev_form_stat

840:
841: IF (x_mode = 'S') THEN
842: igs_sc_gen_001.set_ctx('R');
843: END IF;
844: DELETE FROM igs_pe_ev_form_stat
845: WHERE rowid = x_rowid;
846:
847: IF (SQL%NOTFOUND) THEN
848: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 861: END igs_pe_ev_form_stat_pkg;

857:
858: END delete_row;
859:
860:
861: END igs_pe_ev_form_stat_pkg;