APPS.CSP_PC_FORM_PICKLINES dependencies on CSP_PICKLIST_HEADERS

Line 193: from csp_picklist_headers

189: ELSE
190: BEGIN
191: -- organization id will be used to validate the item id
192: select organization_id into l_organization_id
193: from csp_picklist_headers
194: where picklist_header_id = p_picklist_header_id;
195: EXCEPTION
196: WHEN NO_DATA_FOUND THEN
197: fnd_message.set_name ('CSP', 'CSP_INVALID_PICKLIST_HEADER');

Line 205: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);

201: WHEN OTHERS THEN
202: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
203: fnd_message.set_token('ERR_FIELD', 'p_picklist_header_id', FALSE);
204: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
205: fnd_message.set_token('TABLE', 'CSP_PICKLIST_HEADERS', FALSE);
206: FND_MSG_PUB.ADD;
207: RAISE EXCP_USER_DEFINED;
208: END;
209: END IF;

Line 357: -- csp_picklist_lines table. Instead, we need to make sure that it exists in the csp_picklist_headers

353: --validate the pick list header id.
354: BEGIN
355: -- for bug 1238607.
356: -- Since we are updating the picklist_header_id, we do not need to check whether it exists in the
357: -- csp_picklist_lines table. Instead, we need to make sure that it exists in the csp_picklist_headers
358: -- table.
359: select picklist_header_id into l_check_existence
360: from csp_picklist_headers
361: where picklist_header_id = p_picklist_header_id;

Line 360: from csp_picklist_headers

356: -- Since we are updating the picklist_header_id, we do not need to check whether it exists in the
357: -- csp_picklist_lines table. Instead, we need to make sure that it exists in the csp_picklist_headers
358: -- table.
359: select picklist_header_id into l_check_existence
360: from csp_picklist_headers
361: where picklist_header_id = p_picklist_header_id;
362:
363: -- find the organization_id based on the p_pick_line_id
364: select organization_id into l_organization_id

Line 365: from csp_picklist_headers

361: where picklist_header_id = p_picklist_header_id;
362:
363: -- find the organization_id based on the p_pick_line_id
364: select organization_id into l_organization_id
365: from csp_picklist_headers
366: where picklist_header_id = p_picklist_header_id;
367:
368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN

Line 386: from csp_picklist_headers

382:
383: ELSE -- if the header_id is null
384: -- find the organization_id based on the p_pick_line_id
385: select organization_id into l_organization_id
386: from csp_picklist_headers
387: where picklist_header_id = (select picklist_header_id
388: from csp_picklist_lines
389: where picklist_line_id = px_picklist_line_id);
390: END IF;