APPS.IGS_FI_1098T_BATCHS_PKG dependencies on IGS_FI_1098T_BATCHS

Line 1: PACKAGE BODY igs_fi_1098t_batchs_pkg AS

1: PACKAGE BODY igs_fi_1098t_batchs_pkg AS
2: /* $Header: IGSSIF0B.pls 120.0 2005/09/09 19:58:45 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_1098t_batchs%ROWTYPE;

Line 5: old_references igs_fi_1098t_batchs%ROWTYPE;

1: PACKAGE BODY igs_fi_1098t_batchs_pkg AS
2: /* $Header: IGSSIF0B.pls 120.0 2005/09/09 19:58:45 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_1098t_batchs%ROWTYPE;
6: new_references igs_fi_1098t_batchs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_1098t_batchs%ROWTYPE;

2: /* $Header: IGSSIF0B.pls 120.0 2005/09/09 19:58:45 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_1098t_batchs%ROWTYPE;
6: new_references igs_fi_1098t_batchs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 35: FROM igs_fi_1098t_batchs

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

Line 116: FROM igs_fi_1098t_batchs

112: || (reverse chronological order - newest change first)
113: */
114: CURSOR cur_rowid IS
115: SELECT rowid
116: FROM igs_fi_1098t_batchs
117: WHERE batch_id = x_batch_id
118: FOR UPDATE NOWAIT;
119:
120: lv_rowid cur_rowid%RowType;

Line 152: FROM igs_fi_1098t_batchs

148: || (reverse chronological order - newest change first)
149: */
150: CURSOR cur_rowid IS
151: SELECT rowid
152: FROM igs_fi_1098t_batchs
153: WHERE batch_name = x_batch_name
154: AND tax_year_name = x_tax_year_name
155: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
156:

Line 306: fnd_message.set_token ('ROUTINE', 'IGS_FI_1098T_BATCHS_PKG.INSERT_ROW');

302: x_program_update_date := SYSDATE;
303: END IF;
304: ELSE
305: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
306: fnd_message.set_token ('ROUTINE', 'IGS_FI_1098T_BATCHS_PKG.INSERT_ROW');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: END IF;
310:

Line 329: INSERT INTO igs_fi_1098t_batchs (

325: x_last_updated_by => x_last_updated_by,
326: x_last_update_login => x_last_update_login
327: );
328:
329: INSERT INTO igs_fi_1098t_batchs (
330: batch_id,
331: tax_year_name,
332: batch_name,
333: file_name,

Line 346: igs_fi_1098t_batchs_s.NEXTVAL,

342: program_id,
343: program_application_id,
344: program_update_date
345: ) VALUES (
346: igs_fi_1098t_batchs_s.NEXTVAL,
347: new_references.tax_year_name,
348: new_references.batch_name,
349: new_references.file_name,
350: new_references.filling_mode,

Line 390: FROM igs_fi_1098t_batchs

386: batch_name,
387: file_name,
388: filling_mode,
389: object_version_number
390: FROM igs_fi_1098t_batchs
391: WHERE rowid = x_rowid
392: FOR UPDATE NOWAIT;
393:
394: tlinfo c1%ROWTYPE;

Line 455: FROM igs_fi_1098t_batchs

451: x_program_update_date DATE;
452:
453: CURSOR cur_1098t_batchs(cp_rowid varchar2) IS
454: SELECT object_version_number
455: FROM igs_fi_1098t_batchs
456: WHERE rowid = cp_rowid
457: FOR UPDATE NOWAIT;
458:
459: l_v_object_version_number igs_fi_1098t_batchs.object_version_number%TYPE;

Line 459: l_v_object_version_number igs_fi_1098t_batchs.object_version_number%TYPE;

455: FROM igs_fi_1098t_batchs
456: WHERE rowid = cp_rowid
457: FOR UPDATE NOWAIT;
458:
459: l_v_object_version_number igs_fi_1098t_batchs.object_version_number%TYPE;
460:
461: BEGIN
462:
463: OPEN cur_1098t_batchs(x_rowid);

Line 482: fnd_message.set_token ('ROUTINE', 'IGS_FI_1098T_BATCHS_PKG.UPDATE_ROW');

478: x_last_update_login := -1;
479: END IF;
480: ELSE
481: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
482: fnd_message.set_token ('ROUTINE', 'IGS_FI_1098T_BATCHS_PKG.UPDATE_ROW');
483: igs_ge_msg_stack.add;
484: app_exception.raise_exception;
485: END IF;
486:

Line 519: UPDATE igs_fi_1098t_batchs

515: x_program_update_date := SYSDATE;
516: END IF;
517: END IF;
518:
519: UPDATE igs_fi_1098t_batchs
520: SET
521: tax_year_name = new_references.tax_year_name,
522: batch_name = new_references.batch_name,
523: file_name = new_references.file_name,

Line 562: FROM igs_fi_1098t_batchs

558: || (reverse chronological order - newest change first)
559: */
560: CURSOR c1 IS
561: SELECT rowid
562: FROM igs_fi_1098t_batchs
563: WHERE batch_id = x_batch_id;
564:
565: BEGIN
566:

Line 617: DELETE FROM igs_fi_1098t_batchs

613: p_action => 'DELETE',
614: x_rowid => x_rowid
615: );
616:
617: DELETE FROM igs_fi_1098t_batchs
618: WHERE rowid = x_rowid;
619:
620: IF (SQL%NOTFOUND) THEN
621: RAISE NO_DATA_FOUND;

Line 627: END igs_fi_1098t_batchs_pkg;

623:
624: END delete_row;
625:
626:
627: END igs_fi_1098t_batchs_pkg;