eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_FSEOG_MATCH_PKG dependencies on IGF_AW_FSEOG_MATCH

Line 1: PACKAGE BODY igf_aw_fseog_match_pkg AS

1: PACKAGE BODY igf_aw_fseog_match_pkg AS
2: /* $Header: IGFWI41B.pls 115.7 2002/11/28 12:31:47 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fseog_match_all%ROWTYPE;

Line 5: old_references igf_aw_fseog_match_all%ROWTYPE;

1: PACKAGE BODY igf_aw_fseog_match_pkg AS
2: /* $Header: IGFWI41B.pls 115.7 2002/11/28 12:31:47 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fseog_match_all%ROWTYPE;
6: new_references igf_aw_fseog_match_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_fseog_match_all%ROWTYPE;

2: /* $Header: IGFWI41B.pls 115.7 2002/11/28 12:31:47 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_fseog_match_all%ROWTYPE;
6: new_references igf_aw_fseog_match_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM IGF_AW_FSEOG_MATCH_ALL

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

Line 146: FROM igf_aw_fseog_match_all

142: || (reverse chronological order - newest change first)
143: */
144: CURSOR cur_rowid IS
145: SELECT rowid
146: FROM igf_aw_fseog_match_all
147: WHERE fund_id = x_fund_id
148: AND ci_cal_type = x_ci_cal_type
149: AND ci_sequence_number = x_ci_sequence_number
150: FOR UPDATE NOWAIT;

Line 183: || and selected from igf_aw_fseog_match instead of igf_aw_fseog_match_all.bug:2222272

179: || Known limitations, enhancements or remarks :
180: || Change History :
181: || Who When What
182: || vvutukur 18-feb-2002 modified check of org_id in cur_rowid cursor using new local variable l_org_id
183: || and selected from igf_aw_fseog_match instead of igf_aw_fseog_match_all.bug:2222272
184: || (reverse chronological order - newest change first)
185: */
186:
187: l_org_id igf_aw_fseog_match_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

Line 187: l_org_id igf_aw_fseog_match_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;

183: || and selected from igf_aw_fseog_match instead of igf_aw_fseog_match_all.bug:2222272
184: || (reverse chronological order - newest change first)
185: */
186:
187: l_org_id igf_aw_fseog_match_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
188:
189: CURSOR cur_rowid IS
190: SELECT rowid
191: FROM igf_aw_fseog_match

Line 191: FROM igf_aw_fseog_match

187: l_org_id igf_aw_fseog_match_all.org_id%TYPE DEFAULT igf_aw_gen.get_org_id;
188:
189: CURSOR cur_rowid IS
190: SELECT rowid
191: FROM igf_aw_fseog_match
192: WHERE ci_cal_type = x_ci_cal_type
193: AND ci_sequence_number = x_ci_sequence_number
194: AND match_order = x_match_order
195: AND NVL(org_id,NVL(l_org_id,-99)) = NVL(l_org_id,-99) --BUG:2222272

Line 230: FROM igf_aw_fseog_match_all

226: || (reverse chronological order - newest change first)
227: */
228: CURSOR cur_rowid IS
229: SELECT rowid
230: FROM igf_aw_fseog_match_all
231: WHERE ((ci_cal_type = x_cal_type) AND
232: (ci_sequence_number = x_sequence_number));
233:
234: lv_rowid cur_rowid%RowType;

Line 348: FROM igf_aw_fseog_match_all

344: || (reverse chronological order - newest change first)
345: */
346: CURSOR c IS
347: SELECT rowid
348: FROM igf_aw_fseog_match_all
349: WHERE fund_id = x_fund_id
350: AND ci_cal_type = x_ci_cal_type
351: AND ci_sequence_number = x_ci_sequence_number;
352:

Line 394: INSERT INTO igf_aw_fseog_match_all (

390: x_last_updated_by => x_last_updated_by,
391: x_last_update_login => x_last_update_login
392: );
393:
394: INSERT INTO igf_aw_fseog_match_all (
395: fund_id,
396: match_order,
397: ci_cal_type,
398: ci_sequence_number,

Line 448: FROM igf_aw_fseog_match_all

444: */
445: CURSOR c1 IS
446: SELECT
447: match_order
448: FROM igf_aw_fseog_match_all
449: WHERE rowid = x_rowid
450: FOR UPDATE NOWAIT;
451:
452: tlinfo c1%ROWTYPE;

Line 538: UPDATE igf_aw_fseog_match_all

534: x_last_updated_by => x_last_updated_by,
535: x_last_update_login => x_last_update_login
536: );
537:
538: UPDATE igf_aw_fseog_match_all
539: SET
540: match_order = new_references.match_order,
541: last_update_date = x_last_update_date,
542: last_updated_by = x_last_updated_by,

Line 572: FROM igf_aw_fseog_match_all

568: || (reverse chronological order - newest change first)
569: */
570: CURSOR c1 IS
571: SELECT rowid
572: FROM igf_aw_fseog_match_all
573: WHERE fund_id = x_fund_id
574: AND ci_cal_type = x_ci_cal_type
575: AND ci_sequence_number = x_ci_sequence_number;
576:

Line 627: DELETE FROM igf_aw_fseog_match_all

623: p_action => 'DELETE',
624: x_rowid => x_rowid
625: );
626:
627: DELETE FROM igf_aw_fseog_match_all
628: WHERE rowid = x_rowid;
629:
630: IF (SQL%NOTFOUND) THEN
631: RAISE NO_DATA_FOUND;

Line 637: END igf_aw_fseog_match_pkg;

633:
634: END delete_row;
635:
636:
637: END igf_aw_fseog_match_pkg;