APPS.PA_PROJECT_SET_UTILS dependencies on PA_PROJECT_SETS_TL

Line 190: FROM pa_project_sets_tl

186: l_unique VARCHAR2(1);
187:
188: CURSOR check_name_unique IS
189: SELECT 'N'
190: FROM pa_project_sets_tl
191: WHERE name = p_project_set_name
192: AND language = userenv('lang')
193: AND ((project_set_id <> p_project_set_id AND p_project_set_id IS NOT NULL)
194: OR p_project_set_id IS NULL);

Line 218: l_project_set_name pa_project_sets_tl.name%type;

214:
215: FUNCTION get_proj_set_name (p_project_set_id IN NUMBER)
216: RETURN VARCHAR2
217: IS
218: l_project_set_name pa_project_sets_tl.name%type;
219:
220: BEGIN
221:
222: SELECT name

Line 224: FROM pa_project_sets_tl

220: BEGIN
221:
222: SELECT name
223: INTO l_project_set_name
224: FROM pa_project_sets_tl
225: WHERE project_set_id = p_project_set_id
226: AND userenv('lang') = language(+); --Bug 6208018
227:
228: return l_project_set_name;

Line 256: l_proj_set_name pa_project_sets_tl.name%TYPE;

252: l_project_id_tbl SYSTEM.pa_num_tbl_type := p_project_id_tbl;
253: l_msg_count NUMBER;
254: l_msg_data VARCHAR2(200);
255: l_exists VARCHAR2(4);
256: l_proj_set_name pa_project_sets_tl.name%TYPE;
257: l_project_list VARCHAR2(2000) := '';
258: l_project_name pa_projects_all.name%TYPE;
259: l_project_number pa_projects_all.segment1%TYPE;
260: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');