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

Line 385: -- Purpose: Function for returning formatted IGS_OR_UNIT names and addresses

381: RETURN FALSE;
382: END genp_get_per_addr;
383: -------------------------------------------------------------------------------
384: -- Module: genp_get_org_addr
385: -- Purpose: Function for returning formatted IGS_OR_UNIT names and addresses
386: -- based on variations of the parameters passed
387: -- Notes:
388: -- p_phone_no is used to toggle the display of the phone number
389: -- Y populates the p_phone_line parameter with the phone number

Line 417: -- cursor for selection of the IGS_OR_UNIT name

413: p_line_5 OUT NOCOPY VARCHAR2,
414: p_phone_line OUT NOCOPY VARCHAR2)
415: RETURN BOOLEAN
416: AS
417: -- cursor for selection of the IGS_OR_UNIT name
418: CURSOR c_org_name (
419: cp_org_unit_cd VARCHAR2)IS
420: SELECT ou.description ou_description
421: FROM IGS_OR_UNIT ou

Line 421: FROM IGS_OR_UNIT ou

417: -- cursor for selection of the IGS_OR_UNIT name
418: CURSOR c_org_name (
419: cp_org_unit_cd VARCHAR2)IS
420: SELECT ou.description ou_description
421: FROM IGS_OR_UNIT ou
422: WHERE ou.org_unit_cd = cp_org_unit_cd;
423: -- cursor for selection of the IGS_OR_UNIT address when
424: -- only the org_unit_cd is supplied
425: CURSOR c_ou(

Line 423: -- cursor for selection of the IGS_OR_UNIT address when

419: cp_org_unit_cd VARCHAR2)IS
420: SELECT ou.description ou_description
421: FROM IGS_OR_UNIT ou
422: WHERE ou.org_unit_cd = cp_org_unit_cd;
423: -- cursor for selection of the IGS_OR_UNIT address when
424: -- only the org_unit_cd is supplied
425: CURSOR c_ou(
426: cp_org_unit_cd VARCHAR2)IS
427: SELECT oadv.org_unit_cd oadv_org_unit_cd,

Line 438: -- cursor for selection of the IGS_OR_UNIT address when

434: FROM IGS_OR_ADDR oadv
435: WHERE oadv.org_unit_cd = cp_org_unit_cd AND
436: oadv.correspondence_ind = 'Y';
437:
438: -- cursor for selection of the IGS_OR_UNIT address when
439: -- only the org_unit_cd and IGS_CO_ADDR_TYPE is supplied
440: CURSOR c_out(
441: cp_org_unit_cd VARCHAR2,
442: cp_addr_type VARCHAR2) IS

Line 458: e_name_error EXCEPTION; -- IGS_OR_UNIT name exception handler

454: -- Local Variables
455: v_name VARCHAR2(256) := NULL;
456: v_line_1 VARCHAR2(256) := NULL;
457: -- Local IGS_GE_EXCEPTIONS
458: e_name_error EXCEPTION; -- IGS_OR_UNIT name exception handler
459: e_addr_error EXCEPTION; -- IGS_OR_UNIT address exception handler
460: BEGIN
461: -- test for open cursor, then loop and select the persons name
462: IF c_org_name%ISOPEN THEN

Line 459: e_addr_error EXCEPTION; -- IGS_OR_UNIT address exception handler

455: v_name VARCHAR2(256) := NULL;
456: v_line_1 VARCHAR2(256) := NULL;
457: -- Local IGS_GE_EXCEPTIONS
458: e_name_error EXCEPTION; -- IGS_OR_UNIT name exception handler
459: e_addr_error EXCEPTION; -- IGS_OR_UNIT address exception handler
460: BEGIN
461: -- test for open cursor, then loop and select the persons name
462: IF c_org_name%ISOPEN THEN
463: CLOSE c_org_name;