DBA Data[Home] [Help]

APPS.PER_PER_BUS dependencies on PO_VENDORS

Line 6785: -- Cursor to validate vendor_id in PO_VENDORS table.

6781: l_proc varchar2(72);
6782: l_api_updating boolean;
6783: l_exists varchar2(1);
6784: --
6785: -- Cursor to validate vendor_id in PO_VENDORS table.
6786: --
6787: cursor csr_chk_vendor is
6788: select null
6789: from po_vendors

Line 6789: from po_vendors

6785: -- Cursor to validate vendor_id in PO_VENDORS table.
6786: --
6787: cursor csr_chk_vendor is
6788: select null
6789: from po_vendors
6790: where vendor_id = p_vendor_id;
6791: --
6792: begin
6793: if g_debug then

Line 6823: -- in the PO_VENDORS table.

6819: if return_system_person_type(p_person_type_id,p_business_group_id)
6820: in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') then
6821: --
6822: -- Vendor id can be null, but if it is not null then it must exist
6823: -- in the PO_VENDORS table.
6824: --
6825: if p_vendor_id is not null then
6826: if g_debug then
6827: hr_utility.set_location(l_proc, 40);