75: project_id
76: BULK COLLECT INTO
77: l_project_set_id_tbl,
78: l_project_id_tbl
79: FROM pa_project_set_lines
80: WHERE project_set_id = p_project_set_id;
81:
82: IF l_project_set_id_tbl.COUNT > 0 THEN
83:
101: l_lines_exist VARCHAR2(1);
102:
103: CURSOR do_lines_exist IS
104: SELECT 'Y'
105: FROM pa_project_set_lines
106: WHERE project_set_id = p_project_set_id;
107: BEGIN
108:
109: OPEN do_lines_exist;
130: l_exists VARCHAR2(1);
131: BEGIN
132:
133: SELECT 'Y' INTO l_exists
134: FROM pa_project_set_lines
135: WHERE project_set_id = p_project_set_id
136: AND project_id = p_project_id;
137:
138: RETURN l_exists;