APPS.IEX_REP_PVT dependencies on PO_VENDORS

Line 591: Cursor l_rna_csr(cp_rna_id IN PO_VENDORS.VENDOR_ID%TYPE) IS

587: x_return_status OUT NOCOPY VARCHAR2,
588: p_repv_rec IN repv_rec_type) AS
589: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
590:
591: Cursor l_rna_csr(cp_rna_id IN PO_VENDORS.VENDOR_ID%TYPE) IS
592: SELECT vendor_id
593: FROM po_vendors
594: WHERE vendor_id = cp_rna_id;
595:

Line 593: FROM po_vendors

589: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
590:
591: Cursor l_rna_csr(cp_rna_id IN PO_VENDORS.VENDOR_ID%TYPE) IS
592: SELECT vendor_id
593: FROM po_vendors
594: WHERE vendor_id = cp_rna_id;
595:
596: l_rna_id PO_VENDORS.VENDOR_ID%TYPE;
597: BEGIN

Line 596: l_rna_id PO_VENDORS.VENDOR_ID%TYPE;

592: SELECT vendor_id
593: FROM po_vendors
594: WHERE vendor_id = cp_rna_id;
595:
596: l_rna_id PO_VENDORS.VENDOR_ID%TYPE;
597: BEGIN
598: IF (p_repv_rec.rna_id = OKL_API.G_MISS_NUM OR
599: p_repv_rec.rna_id IS NULL)
600: THEN

Line 616: p_token3_value => 'PO_VENDORS');

612: p_token1_value => 'rna_id',
613: p_token2 => G_CHILD_TABLE_TOKEN,
614: p_token2_value => 'IEX_REPOS_OBJECTS_V',
615: p_token3 => G_PARENT_TABLE_TOKEN,
616: p_token3_value => 'PO_VENDORS');
617: l_return_status := OKL_API.G_RET_STS_ERROR;
618: END IF;
619: CLOSE l_rna_csr;
620: END IF;

Line 641: Cursor l_rna_site_csr(cp_rna_id IN PO_VENDORS.VENDOR_ID%TYPE

637: x_return_status OUT NOCOPY VARCHAR2,
638: p_repv_rec IN repv_rec_type) AS
639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
640:
641: Cursor l_rna_site_csr(cp_rna_id IN PO_VENDORS.VENDOR_ID%TYPE
642: ,cp_rna_site_id IN PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE) IS
643: SELECT vendor_site_id
644: FROM po_vendor_sites_all
645: WHERE vendor_id = cp_rna_id

Line 663: p_token3_value => 'PO_VENDORS');

659: p_token1_value => 'rna_site_id',
660: p_token2 => G_CHILD_TABLE_TOKEN,
661: p_token2_value => 'PO_VENDOR_SITES_ALL',
662: p_token3 => G_PARENT_TABLE_TOKEN,
663: p_token3_value => 'PO_VENDORS');
664: l_return_status := OKL_API.G_RET_STS_ERROR;
665: END IF;
666: CLOSE l_rna_site_csr;
667: END IF;