94: item_in_cat_set(
95: p_organization_id,
96: p_item_id,
97: p_spec_cat_set_id) THEN
98: RETURN fnd_api.g_true;
99: END IF;
100:
101: --
102: -- 2. p_spec_item_id is null and
108: p_organization_id,
109: p_item_id,
110: p_spec_cat_id,
111: p_spec_cat_set_id) THEN
112: RETURN fnd_api.g_true;
113: END IF;
114:
115: --
116: -- 1. p_item_id = p_spec_item_id
115: --
116: -- 1. p_item_id = p_spec_item_id
117: --
118: IF p_item_id = p_spec_item_id THEN
119: RETURN fnd_api.g_true;
120: END IF;
121:
122: RETURN fnd_api.g_false;
123: END spec_item_matched;
118: IF p_item_id = p_spec_item_id THEN
119: RETURN fnd_api.g_true;
120: END IF;
121:
122: RETURN fnd_api.g_false;
123: END spec_item_matched;
124:
125:
126: --
148: --
149: PROCEDURE copy_attachment(p_from_spec_id NUMBER, p_to_spec_id NUMBER) IS
150: BEGIN
151: --
152: -- Use standard FND API to copy attachment from master
153: -- spec to child spec.
154: --
155: fnd_attached_documents2_pkg.copy_attachments(
156: x_from_entity_name => 'QA_SPECS',