APPS.IGS_FI_LB_RECT_ERRS_PKG dependencies on IGS_FI_LB_RECT_ERRS

Line 1: PACKAGE BODY igs_fi_lb_rect_errs_pkg AS

1: PACKAGE BODY igs_fi_lb_rect_errs_pkg AS
2: /* $Header: IGSSID5B.pls 115.0 2003/06/19 06:32:36 agairola noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_lb_rect_errs%ROWTYPE;

Line 5: old_references igs_fi_lb_rect_errs%ROWTYPE;

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

Line 6: new_references igs_fi_lb_rect_errs%ROWTYPE;

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

Line 79: FROM igs_fi_lb_rect_errs

75: */
76:
77: CURSOR cur_old_ref_values IS
78: SELECT *
79: FROM igs_fi_lb_rect_errs
80: WHERE rowid = x_rowid;
81:
82: BEGIN
83:

Line 204: igs_fi_lb_ovfl_errs_pkg.get_fk_igs_fi_lb_rect_errs (

200: || (reverse chronological order - newest change first)
201: */
202: BEGIN
203:
204: igs_fi_lb_ovfl_errs_pkg.get_fk_igs_fi_lb_rect_errs (
205: old_references.lockbox_receipt_error_id
206: );
207:
208: END check_child_existance;

Line 225: FROM igs_fi_lb_rect_errs

221: || (reverse chronological order - newest change first)
222: */
223: CURSOR cur_rowid IS
224: SELECT rowid
225: FROM igs_fi_lb_rect_errs
226: WHERE lockbox_receipt_error_id = x_lockbox_receipt_error_id
227: FOR UPDATE NOWAIT;
228:
229: lv_rowid cur_rowid%RowType;

Line 511: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_RECT_ERRS_PKG.INSERT_ROW');

507: x_program_update_date := SYSDATE;
508: END IF;
509: ELSE
510: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
511: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_RECT_ERRS_PKG.INSERT_ROW');
512: igs_ge_msg_stack.add;
513: app_exception.raise_exception;
514: END IF;
515:

Line 516: SELECT igs_fi_lb_rect_errs_s.NEXTVAL

512: igs_ge_msg_stack.add;
513: app_exception.raise_exception;
514: END IF;
515:
516: SELECT igs_fi_lb_rect_errs_s.NEXTVAL
517: INTO x_lockbox_receipt_error_id
518: FROM dual;
519:
520: before_dml(

Line 580: INSERT INTO igs_fi_lb_rect_errs (

576: x_last_updated_by => x_last_updated_by,
577: x_last_update_login => x_last_update_login
578: );
579:
580: INSERT INTO igs_fi_lb_rect_errs (
581: lockbox_receipt_error_id,
582: lockbox_interface_id,
583: item_number,
584: lockbox_name,

Line 818: FROM igs_fi_lb_rect_errs

814: attribute17,
815: attribute18,
816: attribute19,
817: attribute20
818: FROM igs_fi_lb_rect_errs
819: WHERE rowid = x_rowid
820: FOR UPDATE NOWAIT;
821:
822: tlinfo c1%ROWTYPE;

Line 988: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_RECT_ERRS_PKG.UPDATE_ROW');

984: x_last_update_login := -1;
985: END IF;
986: ELSE
987: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
988: fnd_message.set_token ('ROUTINE', 'IGS_FI_LB_RECT_ERRS_PKG.UPDATE_ROW');
989: igs_ge_msg_stack.add;
990: app_exception.raise_exception;
991: END IF;
992:

Line 1067: UPDATE igs_fi_lb_rect_errs

1063: x_program_update_date := SYSDATE;
1064: END IF;
1065: END IF;
1066:
1067: UPDATE igs_fi_lb_rect_errs
1068: SET
1069: lockbox_interface_id = new_references.lockbox_interface_id,
1070: item_number = new_references.item_number,
1071: lockbox_name = new_references.lockbox_name,

Line 1152: DELETE FROM igs_fi_lb_rect_errs

1148: p_action => 'DELETE',
1149: x_rowid => x_rowid
1150: );
1151:
1152: DELETE FROM igs_fi_lb_rect_errs
1153: WHERE rowid = x_rowid;
1154:
1155: IF (SQL%NOTFOUND) THEN
1156: RAISE NO_DATA_FOUND;

Line 1161: END igs_fi_lb_rect_errs_pkg;

1157: END IF;
1158:
1159: END delete_row;
1160:
1161: END igs_fi_lb_rect_errs_pkg;