APPS.PO_UDA_LOAD_TEMPLATES dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 37: FROM po_uda_ag_template_usages

33: l_new_template_id NUMBER;
34:
35: CURSOR c_get_seeded_usage_id(p_template_id NUMBER) IS
36: SELECT usage_id
37: FROM po_uda_ag_template_usages
38: WHERE template_id = p_template_id
39: AND last_updated_by =0 ;
40:
41:

Line 255: DELETE FROM po_uda_ag_template_usages WHERE usage_id = c_get_seeded_usage_id_rec.usage_id;

251: x_return_status => l_return_status,
252: x_msg_count => l_msg_count,
253: x_msg_data => l_msg_data);
254:
255: DELETE FROM po_uda_ag_template_usages WHERE usage_id = c_get_seeded_usage_id_rec.usage_id;
256:
257: END LOOP ;
258:
259: load_msg('After deleting the seeded usages ');

Line 409: FROM PO_UDA_AG_TEMPLATE_USAGES

405:
406: IF l_attr_grp_id IS NOT NULL THEN
407: SELECT COUNT(*)
408: INTO v_count
409: FROM PO_UDA_AG_TEMPLATE_USAGES
410: WHERE TEMPLATE_ID = g_pkg_template_id
411: AND ATTRIBUTE_GROUP_ID = l_attr_grp_id
412: AND (p_attribute_category IS NULL OR ATTRIBUTE_CATEGORY = p_attribute_category)
413: AND (p_attribute1 IS NULL OR NVL(ATTRIBUTE1, '') = p_attribute1)

Line 438: INSERT INTO PO_UDA_AG_TEMPLATE_USAGES

434: IF (v_count = 0) THEN
435:
436: PO_UDA_DATA_UTIL.CREATE_ASSOCIATION_ID(g_pkg_template_id, l_attr_grp_id, l_association_id);
437:
438: INSERT INTO PO_UDA_AG_TEMPLATE_USAGES
439: (
440: TEMPLATE_ID,
441: ATTRIBUTE_GROUP_ID,
442: ATTRIBUTE_CATEGORY,

Line 503: PO_UDA_AG_TEMPLATE_USAGES_S.nextval,

499: SYSDATE,
500: DECODE(p_owner, 'SEED', 1, 0),
501: 0,
502: l_association_id,
503: PO_UDA_AG_TEMPLATE_USAGES_S.nextval,
504: p_attribute_group_sequence
505: );
506:
507: ELSE

Line 509: UPDATE PO_UDA_AG_TEMPLATE_USAGES

505: );
506:
507: ELSE
508:
509: UPDATE PO_UDA_AG_TEMPLATE_USAGES
510: SET ATTRIBUTE_GROUP_SEQUENCE = p_attribute_group_sequence
511: WHERE TEMPLATE_ID = g_pkg_template_id
512: AND ATTRIBUTE_GROUP_ID = l_attr_grp_id
513: AND (p_attribute_category IS NULL OR ATTRIBUTE_CATEGORY = p_attribute_category)