APPS.IGF_SP_UNIT_PKG dependencies on IGF_SP_UNIT_ALL

Line 5: old_references igf_sp_unit_all%ROWTYPE;

1: PACKAGE BODY igf_sp_unit_pkg AS
2: /* $Header: IGFPI03B.pls 115.2 2003/03/19 08:49:57 smadathi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sp_unit_all%ROWTYPE;
6: new_references igf_sp_unit_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_sp_unit_all%ROWTYPE;

2: /* $Header: IGFPI03B.pls 115.2 2003/03/19 08:49:57 smadathi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sp_unit_all%ROWTYPE;
6: new_references igf_sp_unit_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM igf_sp_unit_all

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

Line 156: FROM igf_sp_unit_all

152: || (reverse chronological order - newest change first)
153: */
154: CURSOR cur_rowid IS
155: SELECT rowid
156: FROM igf_sp_unit_all
157: WHERE fee_cls_unit_id = x_fee_cls_unit_id
158: FOR UPDATE NOWAIT;
159:
160: lv_rowid cur_rowid%RowType;

Line 193: FROM igf_sp_unit_all

189: || (reverse chronological order - newest change first)
190: */
191: CURSOR cur_rowid IS
192: SELECT rowid
193: FROM igf_sp_unit_all
194: WHERE fee_cls_prg_id = x_fee_cls_prg_id
195: AND unit_cd = x_unit_cd
196: AND version_number = x_version_number
197: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 230: FROM igf_sp_unit_all

226: || (reverse chronological order - newest change first)
227: */
228: CURSOR cur_rowid IS
229: SELECT rowid
230: FROM igf_sp_unit_all
231: WHERE ((fee_cls_prg_id = x_fee_cls_prg_id));
232:
233: lv_rowid cur_rowid%RowType;
234:

Line 266: FROM igf_sp_unit_all

262: || (reverse chronological order - newest change first)
263: */
264: CURSOR cur_rowid IS
265: SELECT rowid
266: FROM igf_sp_unit_all
267: WHERE ((unit_cd = x_unit_cd
268: AND version_number = x_version_number));
269:
270: lv_rowid cur_rowid%RowType;

Line 385: FROM igf_sp_unit_all

381: || (reverse chronological order - newest change first)
382: */
383: CURSOR c IS
384: SELECT rowid
385: FROM igf_sp_unit_all
386: WHERE fee_cls_unit_id = x_fee_cls_unit_id;
387:
388: x_last_update_date DATE;
389: x_last_updated_by NUMBER;

Line 434: INSERT INTO igf_sp_unit_all (

430: x_last_updated_by => x_last_updated_by,
431: x_last_update_login => x_last_update_login
432: );
433:
434: INSERT INTO igf_sp_unit_all (
435: fee_cls_unit_id,
436: fee_cls_prg_id,
437: unit_cd,
438: version_number,

Line 494: FROM igf_sp_unit_all

490: fee_cls_prg_id,
491: unit_cd,
492: version_number,
493: max_amount
494: FROM igf_sp_unit_all
495: WHERE rowid = x_rowid
496: FOR UPDATE NOWAIT;
497:
498: tlinfo c1%ROWTYPE;

Line 589: UPDATE igf_sp_unit_all

585: x_last_updated_by => x_last_updated_by,
586: x_last_update_login => x_last_update_login
587: );
588:
589: UPDATE igf_sp_unit_all
590: SET
591: fee_cls_prg_id = new_references.fee_cls_prg_id,
592: unit_cd = new_references.unit_cd,
593: version_number = new_references.version_number,

Line 627: FROM igf_sp_unit_all

623: || (reverse chronological order - newest change first)
624: */
625: CURSOR c1 IS
626: SELECT rowid
627: FROM igf_sp_unit_all
628: WHERE fee_cls_unit_id = x_fee_cls_unit_id;
629:
630: BEGIN
631:

Line 682: DELETE FROM igf_sp_unit_all

678: p_action => 'DELETE',
679: x_rowid => x_rowid
680: );
681:
682: DELETE FROM igf_sp_unit_all
683: WHERE rowid = x_rowid;
684:
685: IF (SQL%NOTFOUND) THEN
686: RAISE NO_DATA_FOUND;