APPS.ICX_RELATED_TEMPLATES_PUB dependencies on PO_RELATED_TEMPLATES

Line 128: from po_related_templates

124:
125: -- check that top relationship does not already exist if needed
126: if p_relationship_type = 'TOP' then
127: select count(*) into l_count
128: from po_related_templates
129: where express_name = p_template
130: and related_express_name = p_related_template;
131:
132: if l_count > 0 then

Line 147: from po_related_templates

143:
144: -- check that relationship does not already exist
145: if p_template <> p_related_template then
146: select count(*) into l_count
147: from po_related_templates
148: where express_name = p_template
149: and related_express_name = p_related_template;
150:
151: if l_count > 0 then

Line 191: insert into po_related_templates

187:
188:
189: -- API body
190:
191: insert into po_related_templates
192: (express_name,
193: related_express_name,
194: relationship_type,
195: created_by,

Line 356: delete from po_related_templates

352:
353:
354: -- API body
355:
356: delete from po_related_templates
357: where express_name = p_template
358: and related_express_name = p_related_template;
359:
360: -- End of API body