eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ABC_ASSIGNMENTS_PVT dependencies on MTL_ABC_ASSIGNMENTS

Line 36: l_item_id mtl_abc_assignments.inventory_item_id%TYPE;

32:
33: l_abc_class_id NUMBER;
34: l_abc_classid_old NUMBER;
35: l_org_id mtl_abc_assignment_groups.organization_id%TYPE;
36: l_item_id mtl_abc_assignments.inventory_item_id%TYPE;
37: l_assignment_group_id mtl_abc_assignments.assignment_group_id%TYPE;
38: l_last_updated_by mtl_abc_assignments.last_updated_by%TYPE;
39: l_last_update_date mtl_abc_assignments.last_update_date%TYPE;
40: l_created_by mtl_abc_assignments.created_by%TYPE;

Line 37: l_assignment_group_id mtl_abc_assignments.assignment_group_id%TYPE;

33: l_abc_class_id NUMBER;
34: l_abc_classid_old NUMBER;
35: l_org_id mtl_abc_assignment_groups.organization_id%TYPE;
36: l_item_id mtl_abc_assignments.inventory_item_id%TYPE;
37: l_assignment_group_id mtl_abc_assignments.assignment_group_id%TYPE;
38: l_last_updated_by mtl_abc_assignments.last_updated_by%TYPE;
39: l_last_update_date mtl_abc_assignments.last_update_date%TYPE;
40: l_created_by mtl_abc_assignments.created_by%TYPE;
41: l_creation_date mtl_abc_assignments.creation_date%TYPE;

Line 38: l_last_updated_by mtl_abc_assignments.last_updated_by%TYPE;

34: l_abc_classid_old NUMBER;
35: l_org_id mtl_abc_assignment_groups.organization_id%TYPE;
36: l_item_id mtl_abc_assignments.inventory_item_id%TYPE;
37: l_assignment_group_id mtl_abc_assignments.assignment_group_id%TYPE;
38: l_last_updated_by mtl_abc_assignments.last_updated_by%TYPE;
39: l_last_update_date mtl_abc_assignments.last_update_date%TYPE;
40: l_created_by mtl_abc_assignments.created_by%TYPE;
41: l_creation_date mtl_abc_assignments.creation_date%TYPE;
42:

Line 39: l_last_update_date mtl_abc_assignments.last_update_date%TYPE;

35: l_org_id mtl_abc_assignment_groups.organization_id%TYPE;
36: l_item_id mtl_abc_assignments.inventory_item_id%TYPE;
37: l_assignment_group_id mtl_abc_assignments.assignment_group_id%TYPE;
38: l_last_updated_by mtl_abc_assignments.last_updated_by%TYPE;
39: l_last_update_date mtl_abc_assignments.last_update_date%TYPE;
40: l_created_by mtl_abc_assignments.created_by%TYPE;
41: l_creation_date mtl_abc_assignments.creation_date%TYPE;
42:
43: l_api_version_number CONSTANT NUMBER := 1.0;

Line 40: l_created_by mtl_abc_assignments.created_by%TYPE;

36: l_item_id mtl_abc_assignments.inventory_item_id%TYPE;
37: l_assignment_group_id mtl_abc_assignments.assignment_group_id%TYPE;
38: l_last_updated_by mtl_abc_assignments.last_updated_by%TYPE;
39: l_last_update_date mtl_abc_assignments.last_update_date%TYPE;
40: l_created_by mtl_abc_assignments.created_by%TYPE;
41: l_creation_date mtl_abc_assignments.creation_date%TYPE;
42:
43: l_api_version_number CONSTANT NUMBER := 1.0;
44: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ABC_ASSIGNMENTS';

Line 41: l_creation_date mtl_abc_assignments.creation_date%TYPE;

37: l_assignment_group_id mtl_abc_assignments.assignment_group_id%TYPE;
38: l_last_updated_by mtl_abc_assignments.last_updated_by%TYPE;
39: l_last_update_date mtl_abc_assignments.last_update_date%TYPE;
40: l_created_by mtl_abc_assignments.created_by%TYPE;
41: l_creation_date mtl_abc_assignments.creation_date%TYPE;
42:
43: l_api_version_number CONSTANT NUMBER := 1.0;
44: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ABC_ASSIGNMENTS';
45:

Line 75: FROM mtl_abc_assignments

71: CURSOR chk_abc_assignments (
72: p_item_id NUMBER,
73: p_assignment_group_id NUMBER) IS
74: SELECT abc_class_id
75: FROM mtl_abc_assignments
76: WHERE inventory_item_id = p_item_id
77: AND assignment_group_id = p_assignment_group_id;
78: BEGIN
79: IF ( l_debug = 1 ) THEN

Line 286: Mydebug(l_api_name ||' Inserting new record into MTL_ABC_ASSIGNMENTS ');

282: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_ABC_ASSIGNMENTS';
283: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'), 0);
284: BEGIN
285: IF ( l_debug = 1 ) THEN
286: Mydebug(l_api_name ||' Inserting new record into MTL_ABC_ASSIGNMENTS ');
287: Mydebug(l_api_name ||' p_inventory_item_id : ' || p_inventory_item_id);
288: Mydebug(l_api_name ||' P_assignment_group_id : ' || p_assignment_group_id);
289: Mydebug(l_api_name ||' p_abc_class_id : ' || p_abc_class_id);
290: END IF;

Line 292: INSERT INTO mtl_abc_assignments

288: Mydebug(l_api_name ||' P_assignment_group_id : ' || p_assignment_group_id);
289: Mydebug(l_api_name ||' p_abc_class_id : ' || p_abc_class_id);
290: END IF;
291:
292: INSERT INTO mtl_abc_assignments
293: ( inventory_item_id
294: , assignment_group_id
295: , abc_class_id
296: , last_update_date

Line 333: Mydebug(l_api_name || ' Updating MTL_ABC_ASSIGNMENTS ');

329: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ABC_ASSIGNMENTS';
330: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'), 0);
331: BEGIN
332: IF ( l_debug = 1 ) THEN
333: Mydebug(l_api_name || ' Updating MTL_ABC_ASSIGNMENTS ');
334: Mydebug(l_api_name || ' inventory_item_id : ' || p_inventory_item_id);
335: Mydebug(l_api_name || ' assignment_group_id : ' || p_assignment_group_id);
336: Mydebug(l_api_name || ' with p_abc_class_id_new : ' || p_abc_class_id);
337: END IF;

Line 339: UPDATE mtl_abc_assignments

335: Mydebug(l_api_name || ' assignment_group_id : ' || p_assignment_group_id);
336: Mydebug(l_api_name || ' with p_abc_class_id_new : ' || p_abc_class_id);
337: END IF;
338:
339: UPDATE mtl_abc_assignments
340: SET abc_class_id = p_abc_class_id,
341: last_updated_by = p_last_updated_by,
342: last_update_date = p_last_update_date
343: WHERE assignment_group_id = p_assignment_group_id