APPS.IGS_FI_PARTY_VENDRS_PKG dependencies on IGS_FI_PARTY_VENDRS

Line 1: PACKAGE BODY igs_fi_party_vendrs_pkg AS

1: PACKAGE BODY igs_fi_party_vendrs_pkg AS
2: /* $Header: IGSSIC8B.pls 115.1 2003/02/25 14:24:15 agairola noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_party_vendrs%ROWTYPE;

Line 5: old_references igs_fi_party_vendrs%ROWTYPE;

1: PACKAGE BODY igs_fi_party_vendrs_pkg AS
2: /* $Header: IGSSIC8B.pls 115.1 2003/02/25 14:24:15 agairola noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_party_vendrs%ROWTYPE;
6: new_references igs_fi_party_vendrs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_party_vendrs%ROWTYPE;

2: /* $Header: IGSSIC8B.pls 115.1 2003/02/25 14:24:15 agairola noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_party_vendrs%ROWTYPE;
6: new_references igs_fi_party_vendrs%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 32: FROM igs_fi_party_vendrs

28: */
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM igs_fi_party_vendrs
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 166: FROM igs_fi_party_vendrs

162: || (reverse chronological order - newest change first)
163: */
164: CURSOR cur_rowid IS
165: SELECT rowid
166: FROM igs_fi_party_vendrs
167: WHERE party_id = x_party_id
168: FOR UPDATE NOWAIT;
169:
170: lv_rowid cur_rowid%RowType;

Line 309: fnd_message.set_token ('ROUTINE', 'IGS_FI_PARTY_VENDRS_PKG.INSERT_ROW');

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

Line 327: INSERT INTO igs_fi_party_vendrs (

323: x_last_updated_by => x_last_updated_by,
324: x_last_update_login => x_last_update_login
325: );
326:
327: INSERT INTO igs_fi_party_vendrs (
328: party_id,
329: vendor_id,
330: vendor_site_id,
331: creation_date,

Line 377: FROM igs_fi_party_vendrs

373: CURSOR c1 IS
374: SELECT party_id,
375: vendor_id,
376: vendor_site_id
377: FROM igs_fi_party_vendrs
378: WHERE rowid = x_rowid
379: FOR UPDATE NOWAIT;
380:
381: tlinfo c1%ROWTYPE;

Line 453: fnd_message.set_token ('ROUTINE', 'IGS_FI_PARTY_VENDRS_PKG.UPDATE_ROW');

449: x_last_update_login := -1;
450: END IF;
451: ELSE
452: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
453: fnd_message.set_token ('ROUTINE', 'IGS_FI_PARTY_VENDRS_PKG.UPDATE_ROW');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: END IF;
457:

Line 485: UPDATE igs_fi_party_vendrs

481: x_program_update_date := SYSDATE;
482: END IF;
483: END IF;
484:
485: UPDATE igs_fi_party_vendrs
486: SET
487: vendor_id = new_references.vendor_id,
488: vendor_site_id = new_references.vendor_site_id,
489: last_update_date = x_last_update_date,

Line 526: DELETE FROM igs_fi_party_vendrs

522: p_action => 'DELETE',
523: x_rowid => x_rowid
524: );
525:
526: DELETE FROM igs_fi_party_vendrs
527: WHERE rowid = x_rowid;
528:
529: IF (SQL%NOTFOUND) THEN
530: RAISE NO_DATA_FOUND;

Line 536: END igs_fi_party_vendrs_pkg;

532:
533: END delete_row;
534:
535:
536: END igs_fi_party_vendrs_pkg;