APPS.IGF_AW_FISAP_BATCH_PKG dependencies on IGF_AW_FISAP_BATCH

Line 1: PACKAGE BODY igf_aw_fisap_batch_pkg AS

1: PACKAGE BODY igf_aw_fisap_batch_pkg AS
2: /* $Header: IGFWI73B.pls 120.0 2005/09/13 09:52:31 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fisap_batch%ROWTYPE;

Line 5: old_references igf_aw_fisap_batch%ROWTYPE;

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

Line 6: new_references igf_aw_fisap_batch%ROWTYPE;

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

Line 34: FROM igf_aw_fisap_batch

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM igf_aw_fisap_batch
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 88: igf_aw_fisap_rep_pkg.get_fk_igf_aw_fisap_batch (

84: || (reverse chronological order - newest change first)
85: */
86: BEGIN
87:
88: igf_aw_fisap_rep_pkg.get_fk_igf_aw_fisap_batch (
89: old_references.batch_id
90: );
91:
92: END check_child_existance;

Line 109: FROM igf_aw_fisap_batch

105: || (reverse chronological order - newest change first)
106: */
107: CURSOR cur_rowid IS
108: SELECT rowid
109: FROM igf_aw_fisap_batch
110: WHERE batch_id = x_batch_id
111: FOR UPDATE NOWAIT;
112:
113: lv_rowid cur_rowid%RowType;

Line 257: fnd_message.set_token ('ROUTINE', 'IGF_AW_FISAP_BATCH_PKG.INSERT_ROW');

253: x_program_update_date := SYSDATE;
254: END IF;
255: ELSE
256: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
257: fnd_message.set_token ('ROUTINE', 'IGF_AW_FISAP_BATCH_PKG.INSERT_ROW');
258: igs_ge_msg_stack.add;
259: app_exception.raise_exception;
260: END IF;
261:

Line 279: INSERT INTO igf_aw_fisap_batch (

275: x_last_updated_by => x_last_updated_by,
276: x_last_update_login => x_last_update_login
277: );
278:
279: INSERT INTO igf_aw_fisap_batch (
280: batch_id,
281: ci_cal_type,
282: ci_sequence_number,
283: description,

Line 295: igf_aw_fisap_batch_s.NEXTVAL,

291: program_id,
292: program_application_id,
293: program_update_date
294: ) VALUES (
295: igf_aw_fisap_batch_s.NEXTVAL,
296: new_references.ci_cal_type,
297: new_references.ci_sequence_number,
298: new_references.description,
299: new_references.reported_time_txt,

Line 337: FROM igf_aw_fisap_batch

333: ci_cal_type,
334: ci_sequence_number,
335: description,
336: reported_time_txt
337: FROM igf_aw_fisap_batch
338: WHERE rowid = x_rowid
339: FOR UPDATE NOWAIT;
340:
341: tlinfo c1%ROWTYPE;

Line 417: fnd_message.set_token ('ROUTINE', 'IGF_AW_FISAP_BATCH_PKG.UPDATE_ROW');

413: x_last_update_login := -1;
414: END IF;
415: ELSE
416: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
417: fnd_message.set_token ('ROUTINE', 'IGF_AW_FISAP_BATCH_PKG.UPDATE_ROW');
418: igs_ge_msg_stack.add;
419: app_exception.raise_exception;
420: END IF;
421:

Line 451: UPDATE igf_aw_fisap_batch

447: x_program_update_date := SYSDATE;
448: END IF;
449: END IF;
450:
451: UPDATE igf_aw_fisap_batch
452: SET
453: ci_cal_type = new_references.ci_cal_type,
454: ci_sequence_number = new_references.ci_sequence_number,
455: description = new_references.description,

Line 493: FROM igf_aw_fisap_batch

489: || (reverse chronological order - newest change first)
490: */
491: CURSOR c1 IS
492: SELECT rowid
493: FROM igf_aw_fisap_batch
494: WHERE batch_id = x_batch_id;
495:
496: BEGIN
497:

Line 548: DELETE FROM igf_aw_fisap_batch

544: p_action => 'DELETE',
545: x_rowid => x_rowid
546: );
547:
548: DELETE FROM igf_aw_fisap_batch
549: WHERE rowid = x_rowid;
550:
551: IF (SQL%NOTFOUND) THEN
552: RAISE NO_DATA_FOUND;

Line 558: END igf_aw_fisap_batch_pkg;

554:
555: END delete_row;
556:
557:
558: END igf_aw_fisap_batch_pkg;