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_COA_LD_PKG dependencies on IGF_AW_COA_LD

Line 1: PACKAGE BODY igf_aw_coa_ld_pkg AS

1: PACKAGE BODY igf_aw_coa_ld_pkg AS
2: /* $Header: IGFWI33B.pls 115.9 2002/11/28 14:41:20 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_coa_ld_all%ROWTYPE;

Line 5: old_references igf_aw_coa_ld_all%ROWTYPE;

1: PACKAGE BODY igf_aw_coa_ld_pkg AS
2: /* $Header: IGFWI33B.pls 115.9 2002/11/28 14:41:20 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_coa_ld_all%ROWTYPE;
6: new_references igf_aw_coa_ld_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igf_aw_coa_ld_all%ROWTYPE;

2: /* $Header: IGFWI33B.pls 115.9 2002/11/28 14:41:20 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igf_aw_coa_ld_all%ROWTYPE;
6: new_references igf_aw_coa_ld_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 36: FROM IGF_AW_COA_LD_ALL

32: */
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM IGF_AW_COA_LD_ALL
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 170: FROM igf_aw_coa_ld_all

166: || (reverse chronological order - newest change first)
167: */
168: CURSOR cur_rowid IS
169: SELECT rowid
170: FROM igf_aw_coa_ld_all
171: WHERE coald_id = x_coald_id
172: FOR UPDATE NOWAIT;
173:
174: lv_rowid cur_rowid%RowType;

Line 206: || vvutukur 18-feb-2002 modified org_id check in cur_rowid cursor and selected from igf_aw_coa_ld

202: || Purpose : Validates the Unique Keys of the table.
203: || Known limitations, enhancements or remarks :
204: || Change History :
205: || Who When What
206: || vvutukur 18-feb-2002 modified org_id check in cur_rowid cursor and selected from igf_aw_coa_ld
207: || instead of igf_aw_coa_ld_all for bug :2222272
208: || (reverse chronological order - newest change first)
209: */
210:

Line 207: || instead of igf_aw_coa_ld_all for bug :2222272

203: || Known limitations, enhancements or remarks :
204: || Change History :
205: || Who When What
206: || vvutukur 18-feb-2002 modified org_id check in cur_rowid cursor and selected from igf_aw_coa_ld
207: || instead of igf_aw_coa_ld_all for bug :2222272
208: || (reverse chronological order - newest change first)
209: */
210:
211: l_org_id igf_aw_coa_ld_all.org_id%TYPE;

Line 211: l_org_id igf_aw_coa_ld_all.org_id%TYPE;

207: || instead of igf_aw_coa_ld_all for bug :2222272
208: || (reverse chronological order - newest change first)
209: */
210:
211: l_org_id igf_aw_coa_ld_all.org_id%TYPE;
212:
213: CURSOR cur_rowid IS
214: SELECT rowid
215: FROM igf_aw_coa_ld

Line 215: FROM igf_aw_coa_ld

211: l_org_id igf_aw_coa_ld_all.org_id%TYPE;
212:
213: CURSOR cur_rowid IS
214: SELECT rowid
215: FROM igf_aw_coa_ld
216: WHERE coa_code = x_coa_code
217: AND ci_cal_type = x_ci_cal_type
218: AND ci_sequence_number = x_ci_sequence_number
219: AND ld_cal_type = x_ld_cal_type

Line 258: FROM igf_aw_coa_ld_all

254: || (reverse chronological order - newest change first)
255: */
256: CURSOR cur_rowid IS
257: SELECT rowid
258: FROM igf_aw_coa_ld_all
259: WHERE ((ci_cal_type = x_ci_cal_type) AND
260: (ci_sequence_number = x_ci_sequence_number) AND
261: (coa_code = x_coa_code));
262:

Line 296: FROM igf_aw_coa_ld_all

292: || (reverse chronological order - newest change first)
293: */
294: CURSOR cur_rowid IS
295: SELECT rowid
296: FROM igf_aw_coa_ld_all
297: WHERE ((ld_cal_type = x_cal_type) AND
298: (ld_sequence_number = x_sequence_number));
299:
300: lv_rowid cur_rowid%RowType;

Line 419: FROM igf_aw_coa_ld_all

415: || (reverse chronological order - newest change first)
416: */
417: CURSOR c IS
418: SELECT rowid
419: FROM igf_aw_coa_ld_all
420: WHERE coald_id = x_coald_id;
421:
422: x_last_update_date DATE;
423: x_last_updated_by NUMBER;

Line 447: SELECT igf_aw_coa_ld_s.NEXTVAL

443: igs_ge_msg_stack.add;
444: app_exception.raise_exception;
445: END IF;
446:
447: SELECT igf_aw_coa_ld_s.NEXTVAL
448: INTO x_coald_id
449: FROM dual;
450:
451: new_references.org_id := igs_ge_gen_003.get_org_id;

Line 470: INSERT INTO igf_aw_coa_ld (

466: x_last_updated_by => x_last_updated_by,
467: x_last_update_login => x_last_update_login
468: );
469:
470: INSERT INTO igf_aw_coa_ld (
471: coald_id,
472: coa_code,
473: ci_cal_type,
474: ci_sequence_number,

Line 538: FROM igf_aw_coa_ld_all

534: ci_sequence_number,
535: ld_cal_type,
536: ld_sequence_number,
537: ld_perct
538: FROM igf_aw_coa_ld_all
539: WHERE rowid = x_rowid
540: FOR UPDATE NOWAIT;
541:
542: tlinfo c1%ROWTYPE;

Line 639: UPDATE igf_aw_coa_ld_all

635: x_last_updated_by => x_last_updated_by,
636: x_last_update_login => x_last_update_login
637: );
638:
639: UPDATE igf_aw_coa_ld_all
640: SET
641: coa_code = new_references.coa_code,
642: ci_cal_type = new_references.ci_cal_type,
643: ci_sequence_number = new_references.ci_sequence_number,

Line 681: FROM igf_aw_coa_ld_all

677: || (reverse chronological order - newest change first)
678: */
679: CURSOR c1 IS
680: SELECT rowid
681: FROM igf_aw_coa_ld_all
682: WHERE coald_id = x_coald_id;
683:
684: BEGIN
685:

Line 740: DELETE FROM igf_aw_coa_ld_all

736: p_action => 'DELETE',
737: x_rowid => x_rowid
738: );
739:
740: DELETE FROM igf_aw_coa_ld_all
741: WHERE rowid = x_rowid;
742:
743: IF (SQL%NOTFOUND) THEN
744: RAISE NO_DATA_FOUND;

Line 750: END igf_aw_coa_ld_pkg;

746:
747: END delete_row;
748:
749:
750: END igf_aw_coa_ld_pkg;