DBA Data[Home] [Help]

APPS.CSP_PICK_UTILS dependencies on CSP_PICKLIST_HEADERS

Line 631: SELECT csp_picklist_headers_s1.nextval

627: l_old_created_by := mo_line_rec.created_by;
628:
629: l_line_number := 0; -- Initialize the line number
630:
631: SELECT csp_picklist_headers_s1.nextval
632: INTO l_picklist_header_id
633: FROM dual;
634:
635: CSP_PC_FORM_PICKHEADERS.Validate_And_Write (

Line 1104: FROM csp_picklist_headers

1100: ELSE
1101: -- check whether the organizaton exists.
1102: BEGIN
1103: SELECT picklist_header_id INTO l_check_existence
1104: FROM csp_picklist_headers
1105: WHERE organization_id = p_organization_id
1106: AND picklist_header_id = p_picklist_header_id;
1107: EXCEPTION
1108: WHEN NO_DATA_FOUND THEN

Line 1117: fnd_message.set_token('TABLE', 'csp_picklist_headers', TRUE);

1113: WHEN OTHERS THEN
1114: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1115: fnd_message.set_token('ERR_FIELD', 'p_picklist_header_id', TRUE);
1116: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
1117: fnd_message.set_token('TABLE', 'csp_picklist_headers', TRUE);
1118: FND_MSG_PUB.ADD;
1119: RAISE EXCP_USER_DEFINED;
1120: END;
1121: END IF;