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.IGS_FI_CREDITS_PKG dependencies on IGS_FI_CREDITS_ALL

Line 5: old_references igs_fi_credits_all%ROWTYPE;

1: PACKAGE BODY igs_fi_credits_pkg AS
2: /* $Header: IGSSI86B.pls 120.2 2005/08/08 01:20:45 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_credits_all%ROWTYPE;
6: new_references igs_fi_credits_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_credits_all%ROWTYPE;

2: /* $Header: IGSSI86B.pls 120.2 2005/08/08 01:20:45 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_credits_all%ROWTYPE;
6: new_references igs_fi_credits_all%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 110: FROM IGS_FI_CREDITS_ALL

106: */
107:
108: CURSOR cur_old_ref_values IS
109: SELECT *
110: FROM IGS_FI_CREDITS_ALL
111: WHERE rowid = x_rowid;
112:
113: BEGIN
114:

Line 471: || Added call to igs_fi_person_holds_pkg.get_fk_igs_fi_credits_all

467: || Change History :
468: || Who When What
469: || (reverse chronological order - newest change first)
470: || pathipat 11-Aug-2003 Enh 3076768 - Auto Release of Holds
471: || Added call to igs_fi_person_holds_pkg.get_fk_igs_fi_credits_all
472: */
473: BEGIN
474:
475: igs_fi_applications_pkg.get_fk_igs_fi_credits_all (

Line 475: igs_fi_applications_pkg.get_fk_igs_fi_credits_all (

471: || Added call to igs_fi_person_holds_pkg.get_fk_igs_fi_credits_all
472: */
473: BEGIN
474:
475: igs_fi_applications_pkg.get_fk_igs_fi_credits_all (
476: old_references.credit_id
477: );
478:
479: igs_fi_cr_activities_pkg.get_fk_igs_fi_credits_all (

Line 479: igs_fi_cr_activities_pkg.get_fk_igs_fi_credits_all (

475: igs_fi_applications_pkg.get_fk_igs_fi_credits_all (
476: old_references.credit_id
477: );
478:
479: igs_fi_cr_activities_pkg.get_fk_igs_fi_credits_all (
480: old_references.credit_id
481: );
482:
483: igs_fi_otc_charges_pkg.get_fk_igs_fi_credits_all (

Line 483: igs_fi_otc_charges_pkg.get_fk_igs_fi_credits_all (

479: igs_fi_cr_activities_pkg.get_fk_igs_fi_credits_all (
480: old_references.credit_id
481: );
482:
483: igs_fi_otc_charges_pkg.get_fk_igs_fi_credits_all (
484: old_references.credit_id
485: );
486:
487: igs_fi_person_holds_pkg.get_fk_igs_fi_credits_all (

Line 487: igs_fi_person_holds_pkg.get_fk_igs_fi_credits_all (

483: igs_fi_otc_charges_pkg.get_fk_igs_fi_credits_all (
484: old_references.credit_id
485: );
486:
487: igs_fi_person_holds_pkg.get_fk_igs_fi_credits_all (
488: old_references.credit_id
489: );
490:
491: END check_child_existance;

Line 510: FROM igs_fi_credits_all

506: || (reverse chronological order - newest change first)
507: */
508: CURSOR cur_rowid IS
509: SELECT rowid
510: FROM igs_fi_credits_all
511: WHERE credit_id = x_credit_id;
512:
513: lv_rowid cur_rowid%RowType;
514:

Line 545: FROM igs_fi_credits_all

541: || (reverse chronological order - newest change first)
542: */
543: CURSOR cur_rowid IS
544: SELECT rowid
545: FROM igs_fi_credits_all
546: WHERE credit_number = x_credit_number
547: AND party_id = x_party_id
548: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
549:

Line 581: FROM igs_fi_credits_all

577: || (reverse chronological order - newest change first)
578: */
579: CURSOR cur_rowid IS
580: SELECT rowid
581: FROM igs_fi_credits_all
582: WHERE ((credit_type_id = x_credit_type_id));
583:
584: lv_rowid cur_rowid%RowType;
585:

Line 618: FROM igs_fi_credits_all

614: || (reverse chronological order - newest change first)
615: */
616: CURSOR cur_rowid IS
617: SELECT rowid
618: FROM igs_fi_credits_all
619: WHERE (( (awd_yr_cal_type = x_awd_yr_cal_type ) AND ( awd_yr_ci_sequence_number = x_awd_yr_ci_sequence_number) ));
620:
621: lv_rowid cur_rowid%RowType;
622:

Line 654: FROM igs_fi_credits_all

650: || (reverse chronological order - newest change first)
651: */
652: CURSOR cur_rowid IS
653: SELECT rowid
654: FROM igs_fi_credits_all
655: WHERE (( (fee_cal_type = x_fee_cal_type ) AND ( fee_ci_sequence_number = x_fee_ci_sequence_number) ));
656:
657: lv_rowid cur_rowid%RowType;
658:

Line 994: FROM igs_fi_credits_all

990: || (reverse chronological order - newest change first)
991: */
992: CURSOR c IS
993: SELECT rowid
994: FROM igs_fi_credits_all
995: WHERE credit_id = x_credit_id;
996:
997: x_last_update_date DATE;
998: x_last_updated_by NUMBER;

Line 1121: INSERT INTO igs_fi_credits_all (

1117: x_tax_year_code => x_tax_year_code,
1118: x_waiver_name => x_waiver_name
1119: );
1120:
1121: INSERT INTO igs_fi_credits_all (
1122: credit_id,
1123: credit_number,
1124: status,
1125: credit_source,

Line 1439: FROM igs_fi_credits_all

1435: deposit_date,
1436: source_invoice_id,
1437: tax_year_code,
1438: waiver_name
1439: FROM igs_fi_credits_all
1440: WHERE rowid = x_rowid
1441: FOR UPDATE NOWAIT;
1442:
1443: tlinfo c1%ROWTYPE;

Line 1745: UPDATE igs_fi_credits_all

1741: x_program_update_date := SYSDATE;
1742: END IF;
1743: END IF;
1744:
1745: UPDATE igs_fi_credits_all
1746: SET
1747: credit_number = new_references.credit_number,
1748: status = new_references.status,
1749: credit_source = new_references.credit_source,

Line 1924: FROM igs_fi_credits_all

1920: || (reverse chronological order - newest change first)
1921: */
1922: CURSOR c1 IS
1923: SELECT rowid
1924: FROM igs_fi_credits_all
1925: WHERE credit_id = x_credit_id;
1926:
1927: BEGIN
1928: