APPS.IGS_FI_SPA_FEE_PRDS_PKG dependencies on IGS_FI_SPA_FEE_PRDS

Line 1: PACKAGE BODY igs_fi_spa_fee_prds_pkg AS

1: PACKAGE BODY igs_fi_spa_fee_prds_pkg AS
2: /* $Header: IGSSIE6B.pls 120.1 2006/05/25 10:06:24 akandreg noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_spa_fee_prds%ROWTYPE;

Line 5: old_references igs_fi_spa_fee_prds%ROWTYPE;

1: PACKAGE BODY igs_fi_spa_fee_prds_pkg AS
2: /* $Header: IGSSIE6B.pls 120.1 2006/05/25 10:06:24 akandreg noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_spa_fee_prds%ROWTYPE;
6: new_references igs_fi_spa_fee_prds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_spa_fee_prds%ROWTYPE;

2: /* $Header: IGSSIE6B.pls 120.1 2006/05/25 10:06:24 akandreg noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_spa_fee_prds%ROWTYPE;
6: new_references igs_fi_spa_fee_prds%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM igs_fi_spa_fee_prds

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

Line 138: FROM igs_fi_spa_fee_prds

134: || akandreg 17-May-2006 Bug 5134636 - Added transaction_type column
135: */
136: CURSOR cur_rowid IS
137: SELECT rowid
138: FROM igs_fi_spa_fee_prds
139: WHERE person_id = x_person_id
140: AND course_cd = x_course_cd
141: AND fee_cal_type = x_fee_cal_type
142: AND fee_ci_sequence_number = x_fee_ci_sequence_number

Line 294: fnd_message.set_token ('ROUTINE', 'IGS_FI_SPA_FEE_PRDS_PKG.INSERT_ROW');

290: x_program_update_date := SYSDATE;
291: END IF;
292: ELSE
293: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
294: fnd_message.set_token ('ROUTINE', 'IGS_FI_SPA_FEE_PRDS_PKG.INSERT_ROW');
295: igs_ge_msg_stack.add;
296: app_exception.raise_exception;
297: END IF;
298:

Line 314: INSERT INTO igs_fi_spa_fee_prds (

310: x_last_update_login => x_last_update_login,
311: x_transaction_type => x_transaction_type
312: );
313:
314: INSERT INTO igs_fi_spa_fee_prds (
315: person_id,
316: course_cd,
317: fee_cal_type,
318: fee_ci_sequence_number,

Line 369: FROM igs_fi_spa_fee_prds

365: */
366: CURSOR c1 IS
367: SELECT
368: rowid
369: FROM igs_fi_spa_fee_prds
370: WHERE rowid = x_rowid
371: FOR UPDATE NOWAIT;
372:
373: tlinfo c1%ROWTYPE;

Line 413: DELETE FROM igs_fi_spa_fee_prds

409: p_action => 'DELETE',
410: x_rowid => x_rowid
411: );
412:
413: DELETE FROM igs_fi_spa_fee_prds
414: WHERE rowid = x_rowid;
415:
416: IF (SQL%NOTFOUND) THEN
417: RAISE NO_DATA_FOUND;

Line 423: END igs_fi_spa_fee_prds_pkg;

419:
420: END delete_row;
421:
422:
423: END igs_fi_spa_fee_prds_pkg;