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.IRC_IAV_BUS dependencies on PO_VENDORS

Line 397: -- Validates if the agency id exists in the PO_VENDORS table

393: -- |---------------------------< chk_agency_id >-------------------------------|
394: -- ----------------------------------------------------------------------------
395: --
396: -- Description:
397: -- Validates if the agency id exists in the PO_VENDORS table
398: --
399: -- Prerequisites:
400: -- Must be called as the first step in insert_validate.
401: --

Line 406: -- If the agency_id is existing in PO_VENDORS (vendor_id)

402: -- In Arguments:
403: -- p_agency_id
404: --
405: -- Post Success:
406: -- If the agency_id is existing in PO_VENDORS (vendor_id)
407: -- then continue.
408: --
409: -- Post Failure:
410: -- If the agency_id is not present in PO_VENDORS (vendor_id)

Line 410: -- If the agency_id is not present in PO_VENDORS (vendor_id)

406: -- If the agency_id is existing in PO_VENDORS (vendor_id)
407: -- then continue.
408: --
409: -- Post Failure:
410: -- If the agency_id is not present in PO_VENDORS (vendor_id)
411: -- then throw an error indicating the same.
412: --
413: -- Access Status:
414: -- Internal Row Handler Use Only.

Line 426: from po_vendors

422: l_proc varchar2(72) := g_package||'chk_agency_id';
423: l_agency_id irc_agency_vacancies.agency_id%type;
424: cursor csr_agency_id is
425: select 1
426: from po_vendors
427: where vendor_id = p_agency_id
428: and vendor_type_lookup_code = 'IRC_JOB_AGENCY';
429: --
430: Begin