APPS.INV_ITEM_REVISION_PUB dependencies on MTL_ITEM_TEMPLATES

Line 554: FROM mtl_item_templates

550: IS
551:
552: CURSOR check_template_name (cp_template_name VARCHAR2) IS
553: SELECT template_id
554: FROM mtl_item_templates
555: WHERE template_name = cp_template_name;
556:
557: CURSOR check_template_id (cp_template_id NUMBER) IS
558: SELECT template_id

Line 559: FROM mtl_item_templates

555: WHERE template_name = cp_template_name;
556:
557: CURSOR check_template_id (cp_template_id NUMBER) IS
558: SELECT template_id
559: FROM mtl_item_templates
560: WHERE template_id = cp_template_id;
561:
562: l_api_name CONSTANT VARCHAR2(30) := 'Create_Item_Revision';
563: l_api_version CONSTANT NUMBER := 1.0;

Line 571: l_template_id mtl_item_templates.template_id%TYPE := NULL;

567: c_object_version_number CONSTANT NUMBER := 1;
568: l_sysdate DATE;
569: l_revision_id NUMBER;
570: l_apply_template BOOLEAN := FALSE;
571: l_template_id mtl_item_templates.template_id%TYPE := NULL;
572: l_message_name VARCHAR2(200);
573:
574: BEGIN
575:

Line 1223: FROM mtl_item_templates

1219: )
1220: IS
1221: CURSOR check_template_name (cp_template_name VARCHAR2) IS
1222: SELECT template_id
1223: FROM mtl_item_templates
1224: WHERE template_name = cp_template_name;
1225:
1226: CURSOR check_template_id (cp_template_id NUMBER) IS
1227: SELECT template_id

Line 1228: FROM mtl_item_templates

1224: WHERE template_name = cp_template_name;
1225:
1226: CURSOR check_template_id (cp_template_id NUMBER) IS
1227: SELECT template_id
1228: FROM mtl_item_templates
1229: WHERE template_id = cp_template_id;
1230:
1231: CURSOR ItemRev_oldvalues_cur(p_inventory_item_id NUMBER
1232: ,p_organization_id NUMBER

Line 1258: l_template_id mtl_item_templates.template_id%TYPE := NULL;

1254: l_sysdate DATE;
1255: l_msg_count NUMBER;
1256: l_msg_text VARCHAR2(4000);
1257: l_apply_template BOOLEAN := FALSE;
1258: l_template_id mtl_item_templates.template_id%TYPE := NULL;
1259: l_message_name VARCHAR2(200);
1260:
1261: BEGIN
1262: