APPS.INV_ITEM_REVISION_PUB dependencies on MTL_ITEM_TEMPLATES

Line 580: FROM mtl_item_templates

576: IS
577:
578: CURSOR check_template_name (cp_template_name VARCHAR2) IS
579: SELECT template_id
580: FROM mtl_item_templates
581: WHERE template_name = cp_template_name;
582:
583: CURSOR check_template_id (cp_template_id NUMBER) IS
584: SELECT template_id

Line 585: FROM mtl_item_templates

581: WHERE template_name = cp_template_name;
582:
583: CURSOR check_template_id (cp_template_id NUMBER) IS
584: SELECT template_id
585: FROM mtl_item_templates
586: WHERE template_id = cp_template_id;
587:
588: l_api_name CONSTANT VARCHAR2(30) := 'Create_Item_Revision';
589: l_api_version CONSTANT NUMBER := 1.0;

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

594: l_revision_ascii_diff NUMBER; /*Added for bug 8679971*/
595: l_sysdate DATE;
596: l_revision_id NUMBER;
597: l_apply_template BOOLEAN := FALSE;
598: l_template_id mtl_item_templates.template_id%TYPE := NULL;
599: l_message_name VARCHAR2(200);
600: /*Added for bug 8679971 to ensure error message gets displayed*/
601: l_entity_index NUMBER;
602: l_entity_id VARCHAR2(100);

Line 1285: FROM mtl_item_templates

1281: )
1282: IS
1283: CURSOR check_template_name (cp_template_name VARCHAR2) IS
1284: SELECT template_id
1285: FROM mtl_item_templates
1286: WHERE template_name = cp_template_name;
1287:
1288: CURSOR check_template_id (cp_template_id NUMBER) IS
1289: SELECT template_id

Line 1290: FROM mtl_item_templates

1286: WHERE template_name = cp_template_name;
1287:
1288: CURSOR check_template_id (cp_template_id NUMBER) IS
1289: SELECT template_id
1290: FROM mtl_item_templates
1291: WHERE template_id = cp_template_id;
1292:
1293: CURSOR ItemRev_oldvalues_cur(p_inventory_item_id NUMBER
1294: ,p_organization_id NUMBER

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

1316: l_sysdate DATE;
1317: l_msg_count NUMBER;
1318: l_msg_text VARCHAR2(4000);
1319: l_apply_template BOOLEAN := FALSE;
1320: l_template_id mtl_item_templates.template_id%TYPE := NULL;
1321: l_message_name VARCHAR2(200);
1322:
1323: BEGIN
1324: