APPS.IGF_SP_STD_UNIT_PKG dependencies on IGF_SP_STD_UNIT_ALL

Line 5: old_references igf_sp_std_unit_all%ROWTYPE;

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

Line 6: new_references igf_sp_std_unit_all%ROWTYPE;

2: /* $Header: IGFPI07B.pls 115.2 2003/03/19 08:50:47 smadathi noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_sp_std_unit_all%ROWTYPE;
6: new_references igf_sp_std_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_std_unit_all

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

Line 156: FROM igf_sp_std_unit_all

152: || (reverse chronological order - newest change first)
153: */
154: CURSOR cur_rowid IS
155: SELECT rowid
156: FROM igf_sp_std_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_std_unit_all

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

Line 230: FROM igf_sp_std_unit_all

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

Line 265: FROM igf_sp_STD_unit_all

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

Line 382: FROM igf_sp_std_unit_all

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

Line 431: INSERT INTO igf_sp_std_unit_all (

427: x_last_updated_by => x_last_updated_by,
428: x_last_update_login => x_last_update_login
429: );
430:
431: INSERT INTO igf_sp_std_unit_all (
432: fee_cls_unit_id,
433: fee_cls_prg_id,
434: unit_cd,
435: version_number,

Line 491: FROM igf_sp_std_unit_all

487: fee_cls_prg_id,
488: unit_cd,
489: version_number,
490: max_amount
491: FROM igf_sp_std_unit_all
492: WHERE rowid = x_rowid
493: FOR UPDATE NOWAIT;
494:
495: tlinfo c1%ROWTYPE;

Line 586: UPDATE igf_sp_std_unit_all

582: x_last_updated_by => x_last_updated_by,
583: x_last_update_login => x_last_update_login
584: );
585:
586: UPDATE igf_sp_std_unit_all
587: SET
588: fee_cls_prg_id = new_references.fee_cls_prg_id,
589: unit_cd = new_references.unit_cd,
590: version_number = new_references.version_number,

Line 624: FROM igf_sp_std_unit_all

620: || (reverse chronological order - newest change first)
621: */
622: CURSOR c1 IS
623: SELECT rowid
624: FROM igf_sp_std_unit_all
625: WHERE fee_cls_unit_id = x_fee_cls_unit_id;
626:
627: BEGIN
628:

Line 679: DELETE FROM igf_sp_std_unit_all

675: p_action => 'DELETE',
676: x_rowid => x_rowid
677: );
678:
679: DELETE FROM igf_sp_std_unit_all
680: WHERE rowid = x_rowid;
681:
682: IF (SQL%NOTFOUND) THEN
683: RAISE NO_DATA_FOUND;