APPS.OKL_CREATE_KLE_PVT dependencies on OKX_PARTY_SITE_USES_V

Line 1726: FROM OKX_PARTY_SITE_USES_V

1722:
1723: CURSOR c_get_id1_id2(p_id1 OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE) IS
1724: SELECT id1
1725: ,id2
1726: FROM OKX_PARTY_SITE_USES_V
1727: WHERE id1 = p_id1
1728: AND id2 = G_ID2
1729: AND site_use_type = 'INSTALL_AT';
1730:

Line 1737: p_token1_value => 'OKX_PARTY_SITE_USES_V.ID1');

1733: p_object_id1_new = OKL_API.G_MISS_NUM) THEN
1734: OKL_API.set_message(p_app_name => G_APP_NAME,
1735: p_msg_name => G_REQUIRED_VALUE,
1736: p_token1 => G_COL_NAME_TOKEN,
1737: p_token1_value => 'OKX_PARTY_SITE_USES_V.ID1');
1738: RAISE G_EXCEPTION_HALT_VALIDATION;
1739: END IF;
1740: OPEN c_get_id1_id2(p_object_id1_new);
1741: FETCH c_get_id1_id2 INTO x_object_id1_new,

Line 1747: p_token1_value => 'OKX_PARTY_SITE_USES_V.ID1 and ID2');

1743: IF c_get_id1_id2%NOTFOUND THEN
1744: OKL_API.set_message(p_app_name => G_APP_NAME,
1745: p_msg_name => G_NO_MATCHING_RECORD,
1746: p_token1 => G_COL_NAME_TOKEN,
1747: p_token1_value => 'OKX_PARTY_SITE_USES_V.ID1 and ID2');
1748: RAISE G_EXCEPTION_HALT_VALIDATION;
1749: END IF;
1750: CLOSE c_get_id1_id2;
1751: IF (x_object_id1_new IS NULL OR

Line 1758: p_token1_value => 'OKX_PARTY_SITE_USES_V.ID1 and ID2');

1754: x_object_id2_new = OKL_API.G_MISS_CHAR) THEN
1755: OKL_API.set_message(p_app_name => G_APP_NAME,
1756: p_msg_name => G_NO_MATCHING_RECORD,
1757: p_token1 => G_COL_NAME_TOKEN,
1758: p_token1_value => 'OKX_PARTY_SITE_USES_V.ID1 and ID2');
1759: RAISE G_EXCEPTION_HALT_VALIDATION;
1760: ELSIF (x_object_id1_new IS NULL OR
1761: x_object_id1_new = OKL_API.G_MISS_CHAR) OR
1762: (x_object_id2_new IS NULL OR

Line 1767: p_token1_value => 'OKX_PARTY_SITE_USES_V.ID1 and ID2');

1763: x_object_id2_new = OKL_API.G_MISS_CHAR) THEN
1764: OKL_API.set_message(p_app_name => G_APP_NAME,
1765: p_msg_name => G_NO_MATCHING_RECORD,
1766: p_token1 => G_COL_NAME_TOKEN,
1767: p_token1_value => 'OKX_PARTY_SITE_USES_V.ID1 and ID2');
1768: RAISE G_EXCEPTION_HALT_VALIDATION;
1769: END IF;
1770: RETURN x_return_status;
1771: EXCEPTION