APPS.IGS_PE_NONIMG_STAT_PKG dependencies on IGS_PE_NONIMG_STAT

Line 1: PACKAGE BODY igs_pe_nonimg_stat_pkg AS

1: PACKAGE BODY igs_pe_nonimg_stat_pkg AS
2: /* $Header: IGSNIA9B.pls 120.2 2006/02/17 06:56:30 gmaheswa ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_nonimg_stat%ROWTYPE;

Line 5: old_references igs_pe_nonimg_stat%ROWTYPE;

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

Line 6: new_references igs_pe_nonimg_stat%ROWTYPE;

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

Line 39: FROM igs_pe_nonimg_stat

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

Line 275: FROM igs_pe_nonimg_stat

271: || (reverse chronological order - newest change first)
272: */
273: CURSOR cur_rowid IS
274: SELECT rowid
275: FROM igs_pe_nonimg_stat
276: WHERE nonimg_stat_id = x_nonimg_stat_id
277: FOR UPDATE NOWAIT;
278:
279: lv_rowid cur_rowid%RowType;

Line 311: FROM igs_pe_nonimg_stat

307: || (reverse chronological order - newest change first)
308: */
309: CURSOR cur_rowid IS
310: SELECT rowid
311: FROM igs_pe_nonimg_stat
312: WHERE nonimg_form_id = x_nonimg_form_id
313: AND action_type = x_action_type
314: AND action_date = x_action_date
315: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 346: FROM igs_pe_nonimg_stat

342: || (reverse chronological order - newest change first)
343: */
344: CURSOR cur_rowid IS
345: SELECT rowid
346: FROM igs_pe_nonimg_stat
347: WHERE ((nonimg_form_id = x_nonimg_form_id));
348:
349: lv_rowid cur_rowid%RowType;
350:

Line 518: INSERT INTO igs_pe_nonimg_stat (

514:
515: IF (x_mode = 'S') THEN
516: igs_sc_gen_001.set_ctx('R');
517: END IF;
518: INSERT INTO igs_pe_nonimg_stat (
519: nonimg_stat_id,
520: nonimg_form_id,
521: action_date,
522: action_type,

Line 535: igs_pe_nonimg_stat_s.NEXTVAL,

531: last_update_login,
532: print_flag,
533: cancel_flag
534: ) VALUES (
535: igs_pe_nonimg_stat_s.NEXTVAL,
536: new_references.nonimg_form_id,
537: new_references.action_date,
538: new_references.action_type,
539: new_references.prgm_start_date,

Line 609: FROM igs_pe_nonimg_stat

605: remarks,
606: termination_reason,
607: print_flag,
608: cancel_flag
609: FROM igs_pe_nonimg_stat
610: WHERE rowid = x_rowid
611: FOR UPDATE NOWAIT;
612: tlinfo c1%ROWTYPE;
613:

Line 721: UPDATE igs_pe_nonimg_stat

717:
718: IF (x_mode = 'S') THEN
719: igs_sc_gen_001.set_ctx('R');
720: END IF;
721: UPDATE igs_pe_nonimg_stat
722: SET
723: nonimg_form_id = new_references.nonimg_form_id,
724: action_date = new_references.action_date,
725: action_type = new_references.action_type,

Line 789: FROM igs_pe_nonimg_stat

785: || (reverse chronological order - newest change first)
786: */
787: CURSOR c1 IS
788: SELECT rowid
789: FROM igs_pe_nonimg_stat
790: WHERE nonimg_stat_id = x_nonimg_stat_id;
791:
792: BEGIN
793:

Line 856: DELETE FROM igs_pe_nonimg_stat

852:
853: IF (x_mode = 'S') THEN
854: igs_sc_gen_001.set_ctx('R');
855: END IF;
856: DELETE FROM igs_pe_nonimg_stat
857: WHERE rowid = x_rowid;
858:
859: IF (SQL%NOTFOUND) THEN
860: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 873: END igs_pe_nonimg_stat_pkg;

869:
870: END delete_row;
871:
872:
873: END igs_pe_nonimg_stat_pkg;