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_CHARGES_API_PVT dependencies on IGS_OR_UNIT

Line 387: FUNCTION validate_org_unit_cd(p_org_unit_cd IN igs_or_unit.org_unit_cd%TYPE) RETURN BOOLEAN AS

383: RETURN l_bool;
384:
385: END validate_uoo;
386:
387: FUNCTION validate_org_unit_cd(p_org_unit_cd IN igs_or_unit.org_unit_cd%TYPE) RETURN BOOLEAN AS
388:
389: /***********************************************************************************************
390:
391: Created By: Amit Gairola

Line 408: CURSOR cur_org_unit(cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE) IS

404: l_temp VARCHAR2(1);
405: l_bool BOOLEAN;
406:
407: -- Cursor for validating the Org_Unit_Code
408: CURSOR cur_org_unit(cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE) IS
409: SELECT 'x'
410: FROM igs_or_unit
411: WHERE org_unit_cd = cp_org_unit_cd;
412: BEGIN

Line 410: FROM igs_or_unit

406:
407: -- Cursor for validating the Org_Unit_Code
408: CURSOR cur_org_unit(cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE) IS
409: SELECT 'x'
410: FROM igs_or_unit
411: WHERE org_unit_cd = cp_org_unit_cd;
412: BEGIN
413: OPEN cur_org_unit(p_org_unit_cd);
414: FETCH cur_org_unit INTO l_temp;

Line 521: l_st_date igs_or_unit.start_dt%TYPE;

517: l_err_string igs_fi_invln_int_all.error_string%TYPE;
518: l_ret_status BOOLEAN;
519: l_err_type NUMBER;
520: l_version_number igs_en_stdnt_ps_att.version_number%TYPE;
521: l_st_date igs_or_unit.start_dt%TYPE;
522: l_v_transaction_type igs_fi_inv_int_all.transaction_type%TYPE;
523:
524: -- As part of the bug #1962286 the local variables l_unit_cd and l_unit_version_number were added
525:

Line 539: -- cursor to get the start date for org_unit_cd from igs_or_unit

535: WHERE course_cd = l_course_cd
536: AND person_id = l_person_id;
537:
538: --
539: -- cursor to get the start date for org_unit_cd from igs_or_unit
540: --
541: CURSOR cur_org_st_dt (l_org_unit_cd igs_or_unit.org_unit_cd%TYPE) IS
542: SELECT start_dt
543: FROM igs_or_unit

Line 541: CURSOR cur_org_st_dt (l_org_unit_cd igs_or_unit.org_unit_cd%TYPE) IS

537:
538: --
539: -- cursor to get the start date for org_unit_cd from igs_or_unit
540: --
541: CURSOR cur_org_st_dt (l_org_unit_cd igs_or_unit.org_unit_cd%TYPE) IS
542: SELECT start_dt
543: FROM igs_or_unit
544: WHERE org_unit_cd = l_org_unit_cd;
545:

Line 543: FROM igs_or_unit

539: -- cursor to get the start date for org_unit_cd from igs_or_unit
540: --
541: CURSOR cur_org_st_dt (l_org_unit_cd igs_or_unit.org_unit_cd%TYPE) IS
542: SELECT start_dt
543: FROM igs_or_unit
544: WHERE org_unit_cd = l_org_unit_cd;
545:
546:
547: -- As part of the bug #1962286 the cursor cur_unit_cd_ver was added