APPS.FV_CCR_UTIL_PVT dependencies on PO_ISPCODELEVEL_PVT

Line 2372: IF (PO_ISPCODELEVEL_PVT.get_curr_isp_supp_code_level

2368: --Bug9790495
2369: -- Logic to check if user is ISP UI is available or not.
2370: -- If ISP UI is not available then not include populate attributs
2371: -- in ap_supplier_sites_all table
2372: IF (PO_ISPCODELEVEL_PVT.get_curr_isp_supp_code_level
2373: >= PO_ISPCODELEVEL_PVT.G_ISP_SUP_CODE_LEVEL_CLM_BASE) THEN
2374:
2375:
2376: BEGIN

Line 2373: >= PO_ISPCODELEVEL_PVT.G_ISP_SUP_CODE_LEVEL_CLM_BASE) THEN

2369: -- Logic to check if user is ISP UI is available or not.
2370: -- If ISP UI is not available then not include populate attributs
2371: -- in ap_supplier_sites_all table
2372: IF (PO_ISPCODELEVEL_PVT.get_curr_isp_supp_code_level
2373: >= PO_ISPCODELEVEL_PVT.G_ISP_SUP_CODE_LEVEL_CLM_BASE) THEN
2374:
2375:
2376: BEGIN
2377: Select cage_code, legal_bus_name, dba_name, division_name

Line 2506: IF (PO_ISPCODELEVEL_PVT.get_curr_isp_supp_code_level

2502: l_division_name fv_ccr_vendors.division_name%type;
2503: BEGIN
2504:
2505: --Bug9790495
2506: IF (PO_ISPCODELEVEL_PVT.get_curr_isp_supp_code_level
2507: >= PO_ISPCODELEVEL_PVT.G_ISP_SUP_CODE_LEVEL_CLM_BASE) THEN
2508: BEGIN
2509: Select cage_code, legal_bus_name, dba_name, division_name
2510: into l_cage_code, l_legal_bus_name, l_dba_name, l_division_name

Line 2507: >= PO_ISPCODELEVEL_PVT.G_ISP_SUP_CODE_LEVEL_CLM_BASE) THEN

2503: BEGIN
2504:
2505: --Bug9790495
2506: IF (PO_ISPCODELEVEL_PVT.get_curr_isp_supp_code_level
2507: >= PO_ISPCODELEVEL_PVT.G_ISP_SUP_CODE_LEVEL_CLM_BASE) THEN
2508: BEGIN
2509: Select cage_code, legal_bus_name, dba_name, division_name
2510: into l_cage_code, l_legal_bus_name, l_dba_name, l_division_name
2511: from fv_ccr_vendors where duns = p_duns_number and rownum<=1;