APPS.JTF_RESOURCE_UTL dependencies on JTF_RS_RESOURCE_PARAMS

Line 1861: l_resource_param_id JTF_RS_RESOURCE_PARAMS.resource_param_id%TYPE;

1857: x_return_status OUT NOCOPY VARCHAR2
1858: )
1859: IS
1860:
1861: l_resource_param_id JTF_RS_RESOURCE_PARAMS.resource_param_id%TYPE;
1862:
1863: CURSOR c_resource_param_id IS
1864: SELECT resource_param_id
1865: FROM jtf_rs_resource_params

Line 1865: FROM jtf_rs_resource_params

1861: l_resource_param_id JTF_RS_RESOURCE_PARAMS.resource_param_id%TYPE;
1862:
1863: CURSOR c_resource_param_id IS
1864: SELECT resource_param_id
1865: FROM jtf_rs_resource_params
1866: WHERE resource_param_id = p_resource_param_id;
1867:
1868: BEGIN
1869:

Line 1905: c_application_id JTF_RS_RESOURCE_PARAMS.APPLICATION_ID%TYPE;

1901: )
1902: IS
1903:
1904: l_value_type JTF_RS_RESOURCE_VALUES.VALUE_TYPE%TYPE;
1905: c_application_id JTF_RS_RESOURCE_PARAMS.APPLICATION_ID%TYPE;
1906:
1907: CURSOR c_value_type_m (l_application_id JTF_RS_RESOURCE_PARAMS.APPLICATION_ID%TYPE)
1908: IS
1909: SELECT value_type

Line 1907: CURSOR c_value_type_m (l_application_id JTF_RS_RESOURCE_PARAMS.APPLICATION_ID%TYPE)

1903:
1904: l_value_type JTF_RS_RESOURCE_VALUES.VALUE_TYPE%TYPE;
1905: c_application_id JTF_RS_RESOURCE_PARAMS.APPLICATION_ID%TYPE;
1906:
1907: CURSOR c_value_type_m (l_application_id JTF_RS_RESOURCE_PARAMS.APPLICATION_ID%TYPE)
1908: IS
1909: SELECT value_type
1910: FROM jtf_rs_cct_middlewares_v cctmv, jtf_rs_resource_params jrspm
1911: WHERE cctmv.value_type = p_value_type

Line 1910: FROM jtf_rs_cct_middlewares_v cctmv, jtf_rs_resource_params jrspm

1906:
1907: CURSOR c_value_type_m (l_application_id JTF_RS_RESOURCE_PARAMS.APPLICATION_ID%TYPE)
1908: IS
1909: SELECT value_type
1910: FROM jtf_rs_cct_middlewares_v cctmv, jtf_rs_resource_params jrspm
1911: WHERE cctmv.value_type = p_value_type
1912: AND jrspm.application_id = l_application_id;
1913:
1914: CURSOR c_value_type_e (l_application_id JTF_RS_RESOURCE_PARAMS.APPLICATION_ID%TYPE)

Line 1914: CURSOR c_value_type_e (l_application_id JTF_RS_RESOURCE_PARAMS.APPLICATION_ID%TYPE)

1910: FROM jtf_rs_cct_middlewares_v cctmv, jtf_rs_resource_params jrspm
1911: WHERE cctmv.value_type = p_value_type
1912: AND jrspm.application_id = l_application_id;
1913:
1914: CURSOR c_value_type_e (l_application_id JTF_RS_RESOURCE_PARAMS.APPLICATION_ID%TYPE)
1915: IS
1916: SELECT value_type
1917: FROM jtf_rs_email_accounts_v iemac, jtf_rs_resource_params jtrpm
1918: WHERE iemac.value_type = p_value_type

Line 1917: FROM jtf_rs_email_accounts_v iemac, jtf_rs_resource_params jtrpm

1913:
1914: CURSOR c_value_type_e (l_application_id JTF_RS_RESOURCE_PARAMS.APPLICATION_ID%TYPE)
1915: IS
1916: SELECT value_type
1917: FROM jtf_rs_email_accounts_v iemac, jtf_rs_resource_params jtrpm
1918: WHERE iemac.value_type = p_value_type
1919: AND jtrpm.application_id = l_application_id;
1920:
1921: CURSOR c_value_type_no_sg_check

Line 1937: FROM jtf_rs_resource_params

1933: fnd_profile.get('JTF_RS_SERVER_GROUP_CHECK',server_group_check);
1934:
1935: SELECT application_id
1936: INTO c_application_id
1937: FROM jtf_rs_resource_params
1938: WHERE resource_param_id = p_resource_param_id;
1939:
1940: x_return_status := fnd_api.g_ret_sts_success;
1941: IF p_value_type IS NOT NULL THEN

Line 2004: FROM fnd_lookups fnl, jtf_rs_resource_params jrp

2000: i NUMBER;
2001:
2002: CURSOR c_lookup_code IS
2003: SELECT lookup_code
2004: FROM fnd_lookups fnl, jtf_rs_resource_params jrp
2005: WHERE fnl.lookup_type = jrp.domain_lookup_type
2006: AND jrp.resource_param_id = p_resource_param_id
2007: AND lookup_code = p_value;
2008:

Line 2014: FROM jtf_rs_resource_params

2010:
2011: l_value := p_value;
2012:
2013: SELECT type , length into v_type ,v_length
2014: FROM jtf_rs_resource_params
2015: WHERE resource_param_id = p_resource_param_id;
2016:
2017: p_length:=LENGTH(p_value);
2018: x_return_status := fnd_api.g_ret_sts_success;