DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on JTF_OBJECTS_VL

Line 1365: FROM JTF_OBJECTS_VL

1361:
1362: if l_destination_org_id is null or l_destination_sub_inv is null then
1363: SELECT NAME
1364: INTO l_resource_type_name
1365: FROM JTF_OBJECTS_VL
1366: WHERE OBJECT_CODE = p_options.resource_type;
1367: l_resource_name := csp_pick_utils.get_object_name(p_options.resource_type, p_options.resource_id);
1368: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
1369: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name, FALSE);

Line 3124: FROM JTF_OBJECTS_VL

3120: AND DEFAULT_CODE = 'IN' ;
3121:
3122: CURSOR csp_resource_type_name(l_resource_type varchar2) is
3123: SELECT NAME
3124: FROM JTF_OBJECTS_VL
3125: WHERE OBJECT_CODE = l_resource_type;
3126: l_organization NUMBER;
3127: l_sub_inventory VARCHAR2(10);
3128: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.GET_ORGANIZATION_SUBINV';

Line 8434: FROM JTF_OBJECTS_VL

8430: x_return_status := FND_API.G_RET_STS_ERROR;
8431: l_resource_name := csp_pick_utils.get_object_name(p_new_resource_type, p_new_resource_id);
8432: SELECT NAME
8433: into l_resource_type_name
8434: FROM JTF_OBJECTS_VL
8435: WHERE OBJECT_CODE = p_new_resource_type;
8436: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEFAULT_SUBINV');
8437: FND_MESSAGE.SET_TOKEN('RESOURCE_TYPE',l_resource_type_name,FALSE);
8438: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);