APPS.IGS_PE_EV_FORM_STAT_PKG dependencies on IGS_PE_EV_FORM

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 86: CURSOR person_type(l_person_id igs_pe_ev_form.person_id%TYPE) IS

82:
83:
84: PROCEDURE afterrowinsertupdate(p_insert BOOLEAN ,p_update BOOLEAN) AS
85:
86: CURSOR person_type(l_person_id igs_pe_ev_form.person_id%TYPE) IS
87: SELECT typ.rowid,typ.* FROM
88: igs_pe_typ_instances_all typ , igs_pe_person_types per_typ
89: WHERE
90: typ.person_id = l_person_id AND

Line 105: SELECT a.rowid,a.* FROM IGS_PE_EV_FORM a

101: IF p_insert = TRUE THEN
102: IF new_references.action_type IN ('ED','TR') THEN
103: DECLARE
104: CURSOR ev_form IS
105: SELECT a.rowid,a.* FROM IGS_PE_EV_FORM a
106: WHERE a.ev_form_id = new_references.ev_form_id;
107: l_ev_form ev_form%ROWTYPE;
108: l_form_status igs_pe_ev_form.form_status%TYPE;
109: BEGIN

Line 108: l_form_status igs_pe_ev_form.form_status%TYPE;

104: CURSOR ev_form IS
105: SELECT a.rowid,a.* FROM IGS_PE_EV_FORM a
106: WHERE a.ev_form_id = new_references.ev_form_id;
107: l_ev_form ev_form%ROWTYPE;
108: l_form_status igs_pe_ev_form.form_status%TYPE;
109: BEGIN
110: OPEN ev_form;
111: FETCH ev_form INTO l_ev_form;
112: CLOSE ev_form;

Line 118: igs_pe_ev_form_pkg.update_row (

114: l_form_status := 'C';
115: ELSIF new_references.action_type = 'TR' THEN
116: l_form_status := 'T';
117: END IF;
118: igs_pe_ev_form_pkg.update_row (
119: x_rowid => l_ev_form.rowid ,
120: x_ev_form_id => l_ev_form.ev_form_id ,
121: x_person_id => l_ev_form.person_id ,
122: x_print_form => l_ev_form.print_form ,

Line 243: ELSIF NOT igs_pe_ev_form_pkg.get_pk_for_validation (

239:
240: IF (((old_references.ev_form_id = new_references.ev_form_id)) OR
241: ((new_references.ev_form_id IS NULL))) THEN
242: NULL;
243: ELSIF NOT igs_pe_ev_form_pkg.get_pk_for_validation (
244: new_references.ev_form_id
245: ) THEN
246: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
247: igs_ge_msg_stack.add;

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 328: PROCEDURE get_fk_igs_pe_ev_form (

324:
325: END get_uk_for_validation ;
326:
327:
328: PROCEDURE get_fk_igs_pe_ev_form (
329: x_ev_form_id IN NUMBER
330: ) AS
331: /*
332: || Created By : [email protected]

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 360: END get_fk_igs_pe_ev_form;

356: RETURN;
357: END IF;
358: CLOSE cur_rowid;
359:
360: END get_fk_igs_pe_ev_form;
361:
362:
363: PROCEDURE before_dml (
364: p_action IN VARCHAR2,

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;