APPS.IGS_FI_LOCKBOX_INTS_PKG dependencies on IGS_FI_LOCKBOX_INTS

Line 1: PACKAGE BODY igs_fi_lockbox_ints_pkg AS

1: PACKAGE BODY igs_fi_lockbox_ints_pkg AS
2: /* $Header: IGSSID7B.pls 115.0 2003/06/19 06:38:00 agairola noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_lockbox_ints%ROWTYPE;

Line 5: old_references igs_fi_lockbox_ints%ROWTYPE;

1: PACKAGE BODY igs_fi_lockbox_ints_pkg AS
2: /* $Header: IGSSID7B.pls 115.0 2003/06/19 06:38:00 agairola noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_lockbox_ints%ROWTYPE;
6: new_references igs_fi_lockbox_ints%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_lockbox_ints%ROWTYPE;

2: /* $Header: IGSSID7B.pls 115.0 2003/06/19 06:38:00 agairola noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_lockbox_ints%ROWTYPE;
6: new_references igs_fi_lockbox_ints%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 87: FROM igs_fi_lockbox_ints

83: */
84:
85: CURSOR cur_old_ref_values IS
86: SELECT *
87: FROM igs_fi_lockbox_ints
88: WHERE rowid = x_rowid;
89:
90: BEGIN
91:

Line 196: FROM igs_fi_lockbox_ints

192: || (reverse chronological order - newest change first)
193: */
194: CURSOR cur_rowid IS
195: SELECT rowid
196: FROM igs_fi_lockbox_ints
197: WHERE lockbox_interface_id = x_lockbox_interface_id
198: FOR UPDATE NOWAIT;
199:
200: lv_rowid cur_rowid%RowType;

Line 498: fnd_message.set_token ('ROUTINE', 'IGS_FI_LOCKBOX_INTS_PKG.INSERT_ROW');

494: x_program_update_date := SYSDATE;
495: END IF;
496: ELSE
497: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
498: fnd_message.set_token ('ROUTINE', 'IGS_FI_LOCKBOX_INTS_PKG.INSERT_ROW');
499: igs_ge_msg_stack.add;
500: app_exception.raise_exception;
501: END IF;
502:

Line 573: INSERT INTO igs_fi_lockbox_ints (

569: x_last_updated_by => x_last_updated_by,
570: x_last_update_login => x_last_update_login
571: );
572:
573: INSERT INTO igs_fi_lockbox_ints (
574: lockbox_interface_id,
575: record_identifier_cd,
576: record_status,
577: deposit_date,

Line 642: igs_fi_lockbox_ints_s.NEXTVAL,

638: program_id,
639: program_application_id,
640: program_update_date
641: ) VALUES (
642: igs_fi_lockbox_ints_s.NEXTVAL,
643: new_references.record_identifier_cd,
644: new_references.record_status,
645: new_references.deposit_date,
646: new_references.transmission_record_count,

Line 843: FROM igs_fi_lockbox_ints

839: attribute17,
840: attribute18,
841: attribute19,
842: attribute20
843: FROM igs_fi_lockbox_ints
844: WHERE rowid = x_rowid
845: FOR UPDATE NOWAIT;
846:
847: tlinfo c1%ROWTYPE;

Line 1029: fnd_message.set_token ('ROUTINE', 'IGS_FI_LOCKBOX_INTS_PKG.UPDATE_ROW');

1025: x_last_update_login := -1;
1026: END IF;
1027: ELSE
1028: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1029: fnd_message.set_token ('ROUTINE', 'IGS_FI_LOCKBOX_INTS_PKG.UPDATE_ROW');
1030: igs_ge_msg_stack.add;
1031: app_exception.raise_exception;
1032: END IF;
1033:

Line 1116: UPDATE igs_fi_lockbox_ints

1112: x_program_update_date := SYSDATE;
1113: END IF;
1114: END IF;
1115:
1116: UPDATE igs_fi_lockbox_ints
1117: SET
1118: record_identifier_cd = new_references.record_identifier_cd,
1119: record_status = new_references.record_status,
1120: deposit_date = new_references.deposit_date,

Line 1264: FROM igs_fi_lockbox_ints

1260: || (reverse chronological order - newest change first)
1261: */
1262: CURSOR c1 IS
1263: SELECT rowid
1264: FROM igs_fi_lockbox_ints
1265: WHERE lockbox_interface_id = x_lockbox_interface_id;
1266:
1267: BEGIN
1268:

Line 1425: DELETE FROM igs_fi_lockbox_ints

1421: p_action => 'DELETE',
1422: x_rowid => x_rowid
1423: );
1424:
1425: DELETE FROM igs_fi_lockbox_ints
1426: WHERE rowid = x_rowid;
1427:
1428: IF (SQL%NOTFOUND) THEN
1429: RAISE NO_DATA_FOUND;

Line 1435: END igs_fi_lockbox_ints_pkg;

1431:
1432: END delete_row;
1433:
1434:
1435: END igs_fi_lockbox_ints_pkg;