APPS.IGS_HE_SUBMSN_AWD_PKG dependencies on IGS_HE_SUBMSN_AWD

Line 1: PACKAGE BODY igs_he_submsn_awd_pkg AS

1: PACKAGE BODY igs_he_submsn_awd_pkg AS
2: /* $Header: IGSWI49B.pls 120.0 2006/02/06 19:23:14 jtmathew noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_submsn_awd%ROWTYPE;

Line 5: old_references igs_he_submsn_awd%ROWTYPE;

1: PACKAGE BODY igs_he_submsn_awd_pkg AS
2: /* $Header: IGSWI49B.pls 120.0 2006/02/06 19:23:14 jtmathew noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_submsn_awd%ROWTYPE;
6: new_references igs_he_submsn_awd%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_submsn_awd%ROWTYPE;

2: /* $Header: IGSWI49B.pls 120.0 2006/02/06 19:23:14 jtmathew noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_submsn_awd%ROWTYPE;
6: new_references igs_he_submsn_awd%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 37: FROM igs_he_submsn_awd

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

Line 150: FROM igs_he_submsn_awd

146: || (reverse chronological order - newest change first)
147: */
148: CURSOR cur_rowid IS
149: SELECT rowid
150: FROM igs_he_submsn_awd
151: WHERE sub_awd_id = x_sub_awd_id
152: FOR UPDATE NOWAIT;
153:
154: lv_rowid cur_rowid%RowType;

Line 189: FROM igs_he_submsn_awd

185: || (reverse chronological order - newest change first)
186: */
187: CURSOR cur_rowid IS
188: SELECT rowid
189: FROM igs_he_submsn_awd
190: WHERE submission_name = x_submission_name
191: AND type = x_type
192: AND key1 = x_key1
193: AND ((key2 = x_key2) OR (key2 IS NULL AND x_key2 IS NULL))

Line 228: FROM igs_he_submsn_awd

224: || (reverse chronological order - newest change first)
225: */
226: CURSOR cur_rowid IS
227: SELECT rowid
228: FROM igs_he_submsn_awd
229: WHERE ((submission_name = x_submission_name));
230:
231: lv_rowid cur_rowid%RowType;
232:

Line 373: fnd_message.set_token ('ROUTINE', 'IGS_HE_SUBMSN_AWD_PKG.INSERT_ROW');

369: x_last_update_login := -1;
370: END IF;
371: ELSE
372: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
373: fnd_message.set_token ('ROUTINE', 'IGS_HE_SUBMSN_AWD_PKG.INSERT_ROW');
374: igs_ge_msg_stack.add;
375: app_exception.raise_exception;
376: END IF;
377:

Line 398: INSERT INTO igs_he_submsn_awd (

394: x_last_updated_by => x_last_updated_by,
395: x_last_update_login => x_last_update_login
396: );
397:
398: INSERT INTO igs_he_submsn_awd (
399: sub_awd_id,
400: submission_name,
401: type,
402: key1,

Line 413: igs_he_submsn_awd_s.NEXTVAL,

409: last_update_date,
410: last_updated_by,
411: last_update_login
412: ) VALUES (
413: igs_he_submsn_awd_s.NEXTVAL,
414: new_references.submission_name,
415: new_references.type,
416: new_references.key1,
417: new_references.key2,

Line 460: FROM igs_he_submsn_awd

456: key2,
457: key3,
458: award_start_date,
459: award_end_date
460: FROM igs_he_submsn_awd
461: WHERE rowid = x_rowid
462: FOR UPDATE NOWAIT;
463:
464: tlinfo c1%ROWTYPE;

Line 542: fnd_message.set_token ('ROUTINE', 'IGS_HE_SUBMSN_AWD_PKG.UPDATE_ROW');

538: x_last_update_login := -1;
539: END IF;
540: ELSE
541: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
542: fnd_message.set_token ('ROUTINE', 'IGS_HE_SUBMSN_AWD_PKG.UPDATE_ROW');
543: igs_ge_msg_stack.add;
544: app_exception.raise_exception;
545: END IF;
546:

Line 565: UPDATE igs_he_submsn_awd

561: x_last_updated_by => x_last_updated_by,
562: x_last_update_login => x_last_update_login
563: );
564:
565: UPDATE igs_he_submsn_awd
566: SET
567: submission_name = new_references.submission_name,
568: type = new_references.type,
569: key1 = new_references.key1,

Line 609: FROM igs_he_submsn_awd

605: || (reverse chronological order - newest change first)
606: */
607: CURSOR c1 IS
608: SELECT rowid
609: FROM igs_he_submsn_awd
610: WHERE sub_awd_id = x_sub_awd_id;
611:
612: BEGIN
613:

Line 670: DELETE FROM igs_he_submsn_awd

666: p_action => 'DELETE',
667: x_rowid => x_rowid
668: );
669:
670: DELETE FROM igs_he_submsn_awd
671: WHERE rowid = x_rowid;
672:
673: IF (SQL%NOTFOUND) THEN
674: RAISE NO_DATA_FOUND;

Line 680: END igs_he_submsn_awd_pkg;

676:
677: END delete_row;
678:
679:
680: END igs_he_submsn_awd_pkg;