APPS.IGF_AW_FISAP_REP_PKG dependencies on IGF_AW_FISAP_REP

Line 1: PACKAGE BODY igf_aw_fisap_rep_pkg AS

1: PACKAGE BODY igf_aw_fisap_rep_pkg AS
2: /* $Header: IGFWI74B.pls 120.0 2005/09/13 09:52:46 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fisap_rep%ROWTYPE;

Line 5: old_references igf_aw_fisap_rep%ROWTYPE;

1: PACKAGE BODY igf_aw_fisap_rep_pkg AS
2: /* $Header: IGFWI74B.pls 120.0 2005/09/13 09:52:46 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fisap_rep%ROWTYPE;
6: new_references igf_aw_fisap_rep%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_fisap_rep%ROWTYPE;

2: /* $Header: IGFWI74B.pls 120.0 2005/09/13 09:52:46 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fisap_rep%ROWTYPE;
6: new_references igf_aw_fisap_rep%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 42: FROM igf_aw_fisap_rep

38: */
39:
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM igf_aw_fisap_rep
43: WHERE rowid = x_rowid;
44:
45: BEGIN
46:

Line 132: FROM igf_aw_fisap_rep

128: || (reverse chronological order - newest change first)
129: */
130: CURSOR cur_rowid IS
131: SELECT rowid
132: FROM igf_aw_fisap_rep
133: WHERE fisap_dtls_id = x_fisap_dtls_id
134: FOR UPDATE NOWAIT;
135:
136: lv_rowid cur_rowid%RowType;

Line 167: FROM igf_aw_fisap_rep

163: || (reverse chronological order - newest change first)
164: */
165: CURSOR cur_rowid IS
166: SELECT rowid
167: FROM igf_aw_fisap_rep
168: WHERE ((batch_id = x_batch_id));
169:
170: lv_rowid cur_rowid%RowType;
171:

Line 338: fnd_message.set_token ('ROUTINE', 'IGF_AW_FISAP_REP_PKG.INSERT_ROW');

334: x_program_update_date := SYSDATE;
335: END IF;
336: ELSE
337: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
338: fnd_message.set_token ('ROUTINE', 'IGF_AW_FISAP_REP_PKG.INSERT_ROW');
339: igs_ge_msg_stack.add;
340: app_exception.raise_exception;
341: END IF;
342:

Line 368: INSERT INTO igf_aw_fisap_rep (

364: x_last_updated_by => x_last_updated_by,
365: x_last_update_login => x_last_update_login
366: );
367:
368: INSERT INTO igf_aw_fisap_rep (
369: fisap_dtls_id,
370: batch_id,
371: isir_id,
372: dependency_status,

Line 392: igf_aw_fisap_rep_s.NEXTVAL,

388: program_id,
389: program_application_id,
390: program_update_date
391: ) VALUES (
392: igf_aw_fisap_rep_s.NEXTVAL,
393: new_references.batch_id,
394: new_references.isir_id,
395: new_references.dependency_status,
396: new_references.career_level,

Line 458: FROM igf_aw_fisap_rep

454: fws_disb_amt,
455: fseog_disb_amt,
456: part_ii_section_f_flag,
457: part_vi_section_a_flag
458: FROM igf_aw_fisap_rep
459: WHERE rowid = x_rowid
460: FOR UPDATE NOWAIT;
461:
462: tlinfo c1%ROWTYPE;

Line 554: fnd_message.set_token ('ROUTINE', 'IGF_AW_FISAP_REP_PKG.UPDATE_ROW');

550: x_last_update_login := -1;
551: END IF;
552: ELSE
553: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
554: fnd_message.set_token ('ROUTINE', 'IGF_AW_FISAP_REP_PKG.UPDATE_ROW');
555: igs_ge_msg_stack.add;
556: app_exception.raise_exception;
557: END IF;
558:

Line 596: UPDATE igf_aw_fisap_rep

592: x_program_update_date := SYSDATE;
593: END IF;
594: END IF;
595:
596: UPDATE igf_aw_fisap_rep
597: SET
598: batch_id = new_references.batch_id,
599: isir_id = new_references.isir_id,
600: dependency_status = new_references.dependency_status,

Line 654: FROM igf_aw_fisap_rep

650: || (reverse chronological order - newest change first)
651: */
652: CURSOR c1 IS
653: SELECT rowid
654: FROM igf_aw_fisap_rep
655: WHERE fisap_dtls_id = x_fisap_dtls_id;
656:
657: BEGIN
658:

Line 725: DELETE FROM igf_aw_fisap_rep

721: p_action => 'DELETE',
722: x_rowid => x_rowid
723: );
724:
725: DELETE FROM igf_aw_fisap_rep
726: WHERE rowid = x_rowid;
727:
728: IF (SQL%NOTFOUND) THEN
729: RAISE NO_DATA_FOUND;

Line 735: END igf_aw_fisap_rep_pkg;

731:
732: END delete_row;
733:
734:
735: END igf_aw_fisap_rep_pkg;